Preview

Pro forma statement analysis

Satisfactory Essays
Open Document
Open Document
527 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Pro forma statement analysis
Pro forma statement analysis
The outputs from the financial planning model are projected financial statements called pro forma financial statements. In finance and accounting, the term pro forma means forecasted or projected (Parrino, 2012). These statements are prepared on the basis of the inputs and assumptions that are fed into the financial model. This paper presents an analysis of the pro forma income statement and pro forma balance sheet of a fictitious company called XYZ Company inc.
Appendix A provides a sample of Profit and Loss statement and the Balance sheet of XYZ Company, INC., provided by the UOP. It also provides a five year projected sales and cost of sales.
XYZ Company assumes a 10% increase in sales for the upcoming five years. We also assume that there is a 10% increase in the cost of sales. Other operating and selling expenses are also assumed to raise 10%. It also assumes that the interest, depreciation and amortization rates will be 5 percent increase for the next five years. This can be calculated by analyzing the past balance sheets and income statements.
With a 10% increase in sales the company has an initiative to expand its facility at the end of five years. Using the pro forma statements managers and investors can have a clear view of the company’s cash flows. The company is planning to use debt to cover the expense of opening a new facility. This will raise the fixed costs, but it expects to increase sales by 15% after the new facility is constructed. The company’s short term and long term obligations such payroll, marketing expenses, Inventory purchases and interest rates are all provided in the pro forma statement.
With that as an input, the company’s projected sales and cost can be calculated as,
Projected sales at the end of five years = $2,814,685.106
Projected costs at the end of five years = $1,691,470.338
Projected net income after all expenses at the end of five years = $240,525
From the balance sheet at the end of five

You May Also Find These Documents Helpful

  • Satisfactory Essays

    The reason type of companies such as brand new companies, family-owned companies, and long-standing companies would need a financial forecast is to develop projected financial statements; a series of pro forma. The information developed by a series of pro forma provide a sort of estimate on inventory, payables, receivables as well as what would be required for profit and borrowing. A projected financial statement provides a kind of advantage in any of the companies listed above as it gives the firm an insight on operations. A pro forma would help guide companies in deciding how to best operate and succeed.…

    • 315 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    In order to create an initiative for growth, an analysis of the company 's short term and long term financing needs are assessed to determine strategies for the company to manage working capital. The suggested initiative to increase XYZ Company, Inc. revenue over the next five years is by acquiring assets through a merger with UVW Company to produce more of product X. Companies must be able to manage growth either through the acquisition of assets or through the capital budgeting process. Through the acquisition of assets, external financing will be required. Growing quickly will allow XYZ Company to gain a larger market share and reinforce its viable position in the marketplace. Expanding too rapidly can have consequences. If the company has too much debt-financing and cash flows are reduced the company will risk being unable to repay its debts. Management must ensure the business can grow, what funding may be needed, and determine the sustainable growth rate.…

    • 575 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Fina310 Unit 2

    • 410 Words
    • 2 Pages

    The second part of the Individual Project is to consider the Micro Chip’s Consolidated Statement of Operations for the year ended September 25, 2008. With this information the percentage sales method and a 25% increase in sales is to be used to forecast Micro Chip’s Consolidated Statement of Operations for the period of September 26, 2008 through September 25, 2009. For this we are to assume a 15% tax rate and a restructuring cost of 5% of the new sales figure. After doing all of the calculations I have the results for the forecast of the Micro Chip’s company. The assumption I have made is that everything is going to go up and the net income is going to be higher than the year before. By looking at the information I do not think that any of my assumptions are unreasonable.…

    • 410 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Xacc 280 Week 3

    • 898 Words
    • 4 Pages

    As you can see in the Linden percentage columns they are significantly less profitable than the Industry. With the EBIT we can see that Linden is less profitable than the industry standard. Linden has a very good interest rate, because its borrowing less, in the end that could hurt them in terms of leveraging the return on equity. Look for excessive executive salaries and bonuses, lavish travel and entertainment expenses, money spent on acquiring other companies, and any other expenditures that aren’t strictly necessary to run the business.…

    • 898 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    Ab209 Unit 6 Business Plan

    • 2986 Words
    • 12 Pages

    A key part of your Business Plan is the Pro Forma Financial Statements! This sub-section will provide the following documentation: An estimated 12-month profit and loss projection; a pro forma balance sheet; and a pro forma income statement. In order to accurately make these critical estimates, it is necessary to conduct primary and secondary research into the particular market and venture. The goodness of the business plan rests upon the accuracy of these financial estimates.…

    • 2986 Words
    • 12 Pages
    Powerful Essays
  • Satisfactory Essays

    Case 2 analysis

    • 264 Words
    • 2 Pages

    You will have to estimate the financials of the company using the excel file. Consider the following scenarios:…

    • 264 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    A pro forma income statement is a projection of future business profits and losses. It allows the business to make operational changes that could affect the actual outcome before the projections are reality.…

    • 639 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Analyzing Pro Forma Data

    • 467 Words
    • 2 Pages

    The Home Depot is the world’s largest home improvement retailer. The tagline for The Home Depot is “More savings more doing that’s the power of The Home Depot.” The catchy and recognizable tagline can be heard on nearly every TV and radio station in the United States. The Home Depot realizes that in order to maintain its title as the world’s largest home improvement retailer the company will need more than its catchy tagline. Therefore, The Home Depot has decided to extend the time in which small household appliances are available to its customers.…

    • 467 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    2. Based on Mr. Martin’s prediction for 1996 sales of $28,206,000, and for 1997 sales of $33,847,000 and relying on the other assumptions provided in the case, prepare complete pro forma forecasts of TCI’s 1996 and 1997 income statements and year-end balance sheets. As a preliminary assumption, assume any new financing required will be in the form of bank debt. Assume all debt (existing and any new debt) bears interest at the same rate of 10%.…

    • 2385 Words
    • 10 Pages
    Good Essays
  • Satisfactory Essays

    Accounting

    • 748 Words
    • 3 Pages

    5. If unit sales are $12, variable costs are $7.20 per unit and fixed costs are $24,000 what…

    • 748 Words
    • 3 Pages
    Satisfactory Essays
  • Better Essays

    Apple has become very successful in the technology industry. The company has increased its net sales from 2006 to 2007, which proves they are making good capital budgeting decisions. A pro forma income statement and balance sheet showing the future planning and growth of a company. The pro forma income statement and balance sheet will explain a cash budget, underlying assumptions of calculations, calculations of different ratio analysis, and make recommendations to management. “The most comprehensive means of financial forecasting is to develop a series of pro forma, or projected, financial statements” (2005, Block & Hirt, p. 88, chap. 4).…

    • 1255 Words
    • 6 Pages
    Better Essays
  • Good Essays

    Decision Making

    • 496 Words
    • 2 Pages

    (a) Calculate the estimated break-even point in annual unit sales of the new product if Martinez…

    • 496 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Oscar Mayer

    • 1765 Words
    • 8 Pages

    • Preparing an estimate of the future earnings from both the brands by applying the solution…

    • 1765 Words
    • 8 Pages
    Good Essays
  • Powerful Essays

    - Current assets, current liabilities and fixed assets will increase proportionally with the increase in sales (a rate of 40%)…

    • 1175 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    me and you

    • 1606 Words
    • 7 Pages

    “A Process for determining and assuring that the organization willhave an adequate numbering qualified persons, available at the propertime, performing jobs which meet the needs of the enterprise andprovides satisfaction for individual for individuals involved.”(Dales S. Beach)…

    • 1606 Words
    • 7 Pages
    Good Essays