Premium Essay

Analyzing Pro Forma Sttement

In: Business and Management

Submitted By Brad5001
Words 542
Pages 3
-------------------------------------------------
Fiscal year is February-January. All values USD millions. | -------------------------------------------------
2011 | -------------------------------------------------
2012 | -------------------------------------------------
2013 | -------------------------------------------------
2014 | ------------------------------------------------- | ------------------------------------------------- | -------------------------------------------------
Sales/Revenue | -------------------------------------------------
2.98B | -------------------------------------------------
2.88B | -------------------------------------------------
2.92B | -------------------------------------------------
2.83B | ------------------------------------------------- | ------------------------------------------------- | -------------------------------------------------
Sales Growth | -------------------------------------------------
- | -------------------------------------------------
-3.21% | -------------------------------------------------
1.20% | -------------------------------------------------
-2.92% | ------------------------------------------------- | ------------------------------------------------- | -------------------------------------------------
Cost of Goods Sold (COGS) incl. D&A | -------------------------------------------------
1.97B | -------------------------------------------------
1.95B | -------------------------------------------------
1.97B | -------------------------------------------------
1.86B | ------------------------------------------------- | ------------------------------------------------- | -------------------------------------------------
COGS excluding D&A | -------------------------------------------------
1.86B |…...

Similar Documents

Premium Essay

Week+3-Assignment-Pro+Forma+Statements

...Save Cancel Bottom of Form ------------------------------------------------- Top of Form * ------------------------------------------------- Word Count: words * ------------------------------------------------- Percentage: % or Cancel Bottom of Form * preferences Document Viewer Turnitin Originality Report * Processed on: 22-Dec-2012 10:11 AM CST * ID: 294959697 * Word Count: 227 * Submitted: 1 Week+3-Assignment-Pro+Forma+Statements[1] By Robert Oxendine   Similarity Index 41% What's this? Similarity by Source Internet Sources: 41% Publications: 0% Student Papers: N/A include quoted include bibliography exclude small matches download refresh print mode: 18% match (Internet from 8/2/10) http://www.jiskha.com 9% match (Internet from 4/3/10) http://sprott.carleton.ca 8% match (Internet from 2/18/12) http://www.coursehero.com 6% match (Internet from 9/30/10) http://studentoffortune.com ------------------------------------------------- Week 3-Assignment-Pro Forma Statements The Landis Corporation A.) ( ) Spontaneous Assets = 5% + 15% + 25% + 40% = 85% Spontaneous Liabilities = 15% + 10% = 25% RNF = ( ) ( ) = .85 ($15 million) - .25 ($15 million) - .06 ($115) (1 -.5) = $12.75 million - $3.75 million - $3.45 million = $5.55 million B.) An increase in Landis Corporation’s payout ratio will reduce the company’s retained earnings and profit margin, and therefore will increase its need for external funding. A......

Words: 630 - Pages: 3

Premium Essay

Pro Forma Statements

...Quinniece Garrett Individual: Pro Forma Statements Comprehensive Problem: Landis Corporation The Landis Corporation had 2008 sales of $100 million. The balance sheet items that vary directly with sales and the profit margin are as follows: Percent Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5% Accounts receivable. . . . . . . . . . . . . . . . . . . . . . 15 Inventory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Net fixed assets . . . . . . . . . . . . . . . . . . . . . . . . . 40 Accounts payable . . . . . . . . . . . . . . . . . . . . . . . 15 Accruals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Profit margin after taxes . . . . . . . . . . . . . . . . . . 6% The dividend payout rate is 50 percent of earnings, and the balance in retained earnings at the end of 2008 was $33 million. Common stock and the company’s long-term bonds are constant at $10 million and $5 million, respectively. Notes payable are currently $12 million. A- How much additional external capital will be required for next year if sales increase 15 percent? (Assume that the company is already operating at full capacity.) B- What will happen to external fund requirements if Landis Corporation reduces the payout ratio, grows at a slower rate, or suffers a decline in its profit margin? Discuss each of these separately. C- Prepare a pro forma balance sheet for 2009 assuming that any external funds......

Words: 396 - Pages: 2

Premium Essay

Analyzing Pro Forma Statements

...Analyzing Pro Forma Statements FIN/571 Kalena Armstrong-Henry November 4, 2013 Analyzing Pro Forma Statements General and financial managers can both benefit from forecasting financial statements. Proforma statements assist financial managers to plan accordingly, in terms of the company’s financial needs. How much financing is needed and when it is needed can be determined by acquiring an estimate of the company’s future balance sheet accounts and income statement. Hence, the purpose of the Proforma analysis is to forecast the company’s financial statements under a particular condition (Parrino et al., 2012). Subsequently, total assets must equate the sum of total liabilities and owner’s equity; otherwise the manager must consider corrective action (Parrino et al., 2012). The Proforma analysis has been proven to be instrumental for general managers in the planning of inventory and employment intensities; particularly problems solving issues. During the developing stages of the forecasting a manager is permitted to analyze the results; thus, identifying potential “hot spots” and handling the issues accordingly. Dealing with “hot spots” with ample time to spare during the forecasting stage is vital to any financial manager. When performing a Proforma Analysis the financial manager can handle forthcoming issues weeks or months in advance; thus, providing the manager ample time to avoid a potential real-time calamity. Subsequently, the manager will gain the ability......

Words: 1327 - Pages: 6

Premium Essay

Pro Forma Homework Handout S13

...Pro-forma Homework Handout Spring 2013 Allen Products, Inc. wants to project their earnings and income for 2012. Allen’s income statement for the most recent year follows: Allen Products Inc. Income Statement | For the Year Ended December 31, 2011 | Sales Revenue | $97,500 | Less: Cost of Goods Sold | 41,875 | Gross Profits (Margin) | $55,625 | Less: Operating Expenses | 24,375 | Operating Profits (Margin) (EBIT) | $31,250 | Less: Interest Expense | 3,000 | Net profits before tax (EBT) | $28,250 | Less: Taxes (rate = 35%) | 9,888 | Net Profits after taxes (EAT, net income, net margin) | $18,362 | Use the percent of sales method, the income statement for December 31, 2011, and the sales revenue estimate of $107,250 to develop a pro forma income statement for the coming year. Allen Products plans to pay a 50% dividend in 2012. Allen Products Inc. Income Statement | 2012 | Sales Revenue | $107,250 | Less: Cost of Goods Sold | 46,062.5 | Gross Profits (Margin) | 61,187.5 | Less: Operating Expenses | 26,812.5 | Operating Profits (Margin) (EBIT) | 34,375 | Less: Interest Expense | 3000 | Net profits before tax (EBT) | 31,375 | Less: Taxes (rate = 35%) | 10,981.25 | Net Profits after taxes (EAT, net income, net margin) | 20,393.75 | Dividends | 10,196.875 | To Retained Earnings | 10,196.875 | * Allen Products has the following balance sheet for December 31, 2011: Current assets |......

Words: 353 - Pages: 2

Premium Essay

Analyzing Pro Forma Statements

...XYZ Company, Inc: Analyzing Pro Forma Statements Karen E. Estremera Pizarro University of Phoenix FIN/571 - Foundations of Corporate Finance June 23, 2014 Prof. Victor Mojica – Rivera Analyzing Pro Forma Statements Pro Forma Statements are financial statements that a company prepares to consider the effects of potential activity (Pro Forma Statement, 2013). It is a financial statement showing the forecast or projected operating results and balance sheet, as in pro forma income statements, balance sheets, and statements of cash flows ((Parrino, Kidwell, and Bates, 2012). The XYZ Company, Inc. is looking to increase the sales in the next five years with the introduction of a new product in their organization. The following paper will review XYZ Company’s five-year financial plan to grow the organization. To achieve the company growth the strategy is introduce a new product and maximize capacity. Through increased sale, we will be getting fixed assets with the excess cash and will be taking loan if is necessary to cover any additional costs arise or are not sufficiently measured. Below in Figure 1-1, the pro forma income statement shows a 12% increase in gross sales for the year 2014 and 11 % in the next five-years. Therefore, in same proportion have been estimated the increase in the cost of sales, then other operating expenses and selling expenses will increase in the same ratio of sales. The increase in cost of sales are the purchases of raw...

Words: 789 - Pages: 4

Premium Essay

Analyzing Proforma

...Analyzing Pro Forma Statements FIN 571 September 11, 2014 Introduction This paper is the analysis of pro forma financial statements. Pro forma statements are forecasted or projected financial statements as a result of financial planning. The financial statements are based on the inputs and assumptions such as percent of sales model in which most of the entries vary directly with the level of sales. The attached excel spreadsheet includes pro forma statements for the next five years. This company decided to invest in the purchase of new equipment to help increase sales. The resulting projections are the focus of this paper. Analysis of pro forma statements will determine if the company requires any external financing to support its planned initiatives. Assumptions supporting each line for forecasted statements This paper covers a five year plan with the basic assumptions for the pro forma statements that the equipment purchase initiative will increase sales by 12% for the first two years, and then 5% for the next three years. The cost of sales including purchases, production and labor, and ending inventory will vary with sales, while beginning inventory comes from prior year ending inventory. Depreciation will increase by $40K for the additional equipment in year one. Fixed assets will not vary from year to year, except for $200K increase in equipment expected in the first year to support sales growth. Retained earnings for the prior year comes from previous year, and...

Words: 696 - Pages: 3

Premium Essay

Pro Forma

...FINANCIAL STATEMENT OVERVIEW ASSIGNMENT # 3 Members: Zhishuang Liu Siyi Shang Qihui Wu Anqi Li Context 1. Assumptions 2 2. I/S Pro Forma 2 1.1 Interest Income 2 1.2 Net Interest Income Margin 2 1.3 Provision for Loan Losses 5 1.4 Net Income Margin 6 1.5 Tax Rate 6 1.6 Non-interest income and Non-interest expense 7 3. B/S Pro Forma 8 3.1 ROA and ROE 8 3.2 The Accounts change according to the Interest Income and Interest Expense 9 3.3 The Other Asset and Liability Accounts 11 3.4 Shareholders’ Equity Forecast 12 3.5 Retained earnings 13 4. Cash Flow Statement Pro Forma 15 1. Assumptions (1) Interest Income grows at a certain rate every year. (2) There is no issue of new shares (3) There are tendencies of the ratios, such as net interest income margin, net income margin, return on asset, return on equity, etc., that could be used for forecasting. (4) Simplify the accounts of Balance Sheet, Income Statement and Cash Flow Statement. * 2. I/S Pro Forma Interest Income Graph 2-1 Interest Income Graph 2-1 shows the total interest income of Orrstown from year 2006-2013. As it takes a longer time for small financial institutions to react on the financial crisis, the negative interest income of orrstown showed in year 2012 and 2013. Because there would be little chance of any big financial crisis in the following five years, it is reasonable to take outliers. Take the average of the annual......

Words: 1472 - Pages: 6

Premium Essay

Pro Forma Analysis Cash Flow Forecasting

...Pro forma analysis cash flow forecasting Apartment Investment Case Study Scenario An investor is considering buying an apartment building with 140 units offered for sale at $16,500,000. The subject apartment building has the following unit mix: Additionally, the following assumptions are also being made by the investor in order to construct a 5-year cash flow pro forma: Vacancy and Credit Loss In the current market, vacancy and credit losses are running at 9%. Due to the improving market conditions as well as the investor’s prior experience leasing and operating multifamily buildings, it’s expected that vacancy will steadily decline over the next 5 years to 5%. Potential Rental Income Potential rental income is based on the above unit mix. The 1-bedroom and studio rental rates are expected to increase at 1% annually. The 2-bedroom units are expected to increase at 2% annually. Financing After a preliminary discussion with a relationship manager at a local bank it’s determined that a loan can be extended based on the lesser of a 1.25x debt service coverage ratio or 80% loan to value. Additionally, assuming the underwriting process doesn’t reveal any red flags, it’s expected that the loan will be based on a 20 year amortization and a 6% interest rate. Operating Expenses The following table breaks out historical operating expenses for the property as well as projected increases over the holding period. Reserves for Replacement In addition to the above operating......

Words: 1486 - Pages: 6

Premium Essay

What Is a Pro Forma Income Statement

...What is the purpose of a Pro Forma income statement? How would you use the information from the Pro Forma income statement? Provide an example. According to businesstown.com, Pro Forma income statements are “an important tool for planning future business operations. If the projections predict a downturn in profitability, you can make operational changes such as increasing prices or decreasing costs before these projections become reality.” Pro Forma income statements are used to let investors know a company’s operating results, conforming to investopedia.com, “Pro Forma financial statements take out one-time charges to smooth earnings.” In addition, “Pro-forma earnings describe a financial statement that has hypothetical amounts, or estimates, built into the data to give a "picture" of a company's profits if certain nonrecurring items were excluded.” (investopedia.com) The information from a Pro Forma income statement can be used through: * To give investors a clearer view of company operations - This applies to the nature of a business. investopedia.com explains that “Companies in certain industries tend to use pro-forma reporting more than others, as the impetus to report pro-forma numbers is usually a result of industry characteristics. For example, some cable and telephone companies almost never make a net operating profit because they are constantly writing down big depreciation costs.” (businesstown.com) But; * For companies that do not include cash......

Words: 382 - Pages: 2

Premium Essay

Analyzing Pro Forma Statements Paper

... Analyzing Pro Forma Statements Paper Gregory Curry FIN/571 April 22, 2015 CRISTINA MARINE Analyzing Pro Forma Statements Analyzing Pro Forma Statements can be used internally or externally to determine how financially stable a company is whether International or within the USA, ratios play a key role in determining how a company is doing financially either for the good or the bad or indifferent. I we will use three common ratios to determine how financially stable from how Shimizu International and Lexmark US based company balance sheets with their business information is doing these last three years. Balance sheets from Shimizu International and Lexmark, companies no matter the industry no company wants a current ratio less than one because this suggests that the company has more liabilities than assets meaning that in the short run they will be more likely not able to pay their debts. This is why “the current ratio is a popular financial ratio used to test a company's liquidity also referred to as its current or working capital position by deriving the proportion of current assets available to cover current liabilities” (Richard Loth, 2015). The figures for both Shimizu International and Lexmark companies will display their current ratios from 2012, 2013 and 2014. It's takes time to convert a company's...

Words: 851 - Pages: 4

Premium Essay

Analyzing Pro Forma Statement

... Pro forma income statement is similar to historical income statement, the difference is that the pro forma income statement projects the future. Pro forma income statements provide an important benchmark for operating a business throughout the year ( BusinessTown 2001 ). It provides the information that they need to help them make the right choices for their business. The XYZ Company are looking to increase their sales in the next five years. The company will introduce a new product and they will also maximize capacity in order to achieve company’s growth. Through the increase sale, the company will be able to get fixed assets with the use of their excess cash and in necessary they will take some loans to cover the additional cost that will arise. The pro forma income statement show a 12% increase in their gross sales and in the next five years there will be an 11% increase. There will be an increase in the cost of sales and those for the supplies, raw materials and product ion labor of the company that will happen when they start to add the new product. The increase will be tied to the expense of selling and under that are the new products commission sale, marketing the new product and hiring new workers. The total cost of sale represent 60.1 % and the gross profit is 39.9% of increase on sales. The total operating expenses will be 16.4 % of the sales and under that are payroll taxes, major expenses wages and benefits. Under the wages is hiring new worker, if needed,...

Words: 628 - Pages: 3

Premium Essay

Analyzing Pro Forma Statement

...Analyzing Pro Forma Statements Kaleah S. Daniels FIN/571 Analyzing Pro Forma Statements Pro forma statements are prepared to forecast financial results that are based on anticipated future projects or events. It is design to show projection of revenues, cash flows deducting the estimated expenses or costs for a particular business plan. Pro forma statements assist financial managers to plan accordingly, in terms of the company’s financial needs. How much financing is needed and when it is needed can be determined by acquiring an estimate of the company’s future balance sheet accounts and income statement. Hence, the purpose of the Pro forma analysis is to forecast the company’s financial statements under a particular condition (Parrino et al., 2012). XYZ Company, INC. is planning for business expansion in the coming years. This paper will discuss and analyze pro forma statements of five year projections created. The company’s income statement displays that the break in the current year occurred when; “Net sales equals $1,747,698, Gross profit equals $697,428 and Total operating expenses equals $285,850” (UOP, 2014). XYZ’s “management expects sales to increase by 10 percent for the coming year. Assuming that the financial statement accounts vary directly with changes in sales and that management has no financing plan at this time” (Parrino, 2012, pg. 613). Using the data from the current statement (income & balance sheet) we are able to calculate, 1)......

Words: 670 - Pages: 3

Free Essay

Pro Forma

...Analyzing Pro Forma Statements Christopher Radko has been in business for thirty years making blown glass Christmas ornaments. They have expanded their line to include snow globes and cookie jars and even a line of jewelry. I propose that Christopher Radko market a new product to their collectors; a home décor line that showcases their style. This line would include throw pillows, rugs, paintings and tabletop accent pieces. Pro Forma statements are hypothetical assumptions of a company for a time span, in this case five years. Taking an already successful company and adding to the line can be both a good idea and tricky because the customer base can split two ways. They can either decide that they love the addition and buy it or become upset at the perception that the company is changing its product line. A pro forma statement can include and exclude whatever the company feels is relevant or irrelevant; onetime expenses are usually not used in pro forma statements either. The pro forma guidelines are not as strict as generally accepted accounting principles. The calculations that were arrived to for Christopher Radko show how the line would be beneficial if it included a new home décor line. It is worth mentioning that the net income does not reflect one time buys therefore the pro forma statement does not reflect that information. While it was not shown in the attached pro forma statement there are companies that write off merchandise to in attempt to manipulate their......

Words: 297 - Pages: 2

Premium Essay

Pro Forma Financial Statements for Walt Disney Co.

...#14- Walt Disney Company: Pro Forma financial statements: income statement, balance sheet, cash flow statement, and applicable financial ratios with a baseline year and three years into the future. Income Statement 12/31/2014 12/31/2015 Percent Change Revenues $48,813,000 $52,465,000 1 7.48% Cost of Goods Sold 26,420,000 28,364,000 1 7.36% Gross Profit 22,393,000 24,101,000 1 7.63% Operating Expenses 37,378,000 39,294,000 1 5.13% EBIT (14,985,000) (15,193,000) 1 1.39% Interest Expense - - ####### #VALUE! EBT 12,246,000 13,868,000 1 13.25% Tax 4,242,000 5,016,000 1 18.25% Non-Recurring Events 140,000 53,000 -1 -62.14% Net Income 8,144,000 8,905,000 1 9.34% Balance Sheet 12/31/2014 12/31/2015 Percent Change Assets Cash and Equivalents $3,421,000 $4,269,000 1 25% Accounts Receivable 8,319,000 8,786,000 1 6% Inventory 1,574,000 1,571,000 -1 0% Other Current Assets 1,855,000 2,132,000 1 15% Total Current Assets 15,169,000 16,758,000 1 10% Property Plant & Equipment 47,054,000 50,023,000 1 6% Goodwill 27,881,000 27,826,000 -1 0% Intangibles 12,759,000 13,355,000 1 5% Other Long-Term Assets 857,000 832,000 -1 -3% Total Assets 84,186,000 88,182,000 1 5% Liabilities Accounts Payable 5,371,000 5,504,000 1 2% Other Current Liabilities 3,988,000 4,470,000 1 12% Total Current Liabilities 13,292,000 16,334,000 1 23% Long-Term Debt 12...

Words: 870 - Pages: 4

Premium Essay

Pro Forma Cash Flow Budget

...firm’s stockholders. If IRR exceeds its cost of capital, it increases shareholders’ wealth. But, if the internal rate of return is less than the cost of capital, then taking on the project will impose a cost on current stockholders. Valuation based on project’s IRR values estimates the Hi-Tech alternative as the best option where IRR value of 64.7% far exceeds the WACC of 6.38% but in the case of current and broker alternatives IRR is only 6.9% and 11.0% respectively. Relative Valuation Technique is another approach where current price of asset is compared with market value of same kind of assets. It assists in securities investment where price anomalies can be rectified and investors can take better decision in asset allocation after analyzing the price of different companies in business of similar nature. Contingent Claim Valuation technique decides the stock value depending on the comparison between current value of the asset and present value of asset using DCF where cash flow is independent of occurrence of non-occurrence of certain plans of project. The DCF does not provide precise value of asset. So comparison can be misleading sometimes. A Break-even Analysis on the Current Situation | |Mid grade |High end |Total | |Sales |$1,288,788.00 |$444,774.00 |$1,733,562.00 ......

Words: 1462 - Pages: 6