Pro Forma Statement Analysis

Satisfactory Essays
Analyzing Pro Forma Statements
Aaron Daniel Bernstein
FIN 571
December 15, 2014
Dr. McCarrolle
Analyzing Pro Forma Statements Upper management has propositioned the financial analysis team to develop Pro Forma financial statements covering the next five years for the new product line that increases revenue in a similar but slightly different market. (The make-believe company is a restaurant group, the make-believe new product is pizza). The financial statement helps assess the possible financial impacts of pizza. The Pro Forma statements are based on the current year’s (2014) Balance Sheet and Profit/Loss Statement and are projected for an 18% increase in sales each year for the next five years. Analysis for the Pro Forma statement
…show more content…
Currently COGS is $182,129, after year five the COGS will be $282,129. Therefore projected gross profit will grow to $1,025,048 from $414,250
Wages increase by 12.5% in the first year because of the new hires. Every year after the wage expense increases 2.5% because of merit based raises and bonuses. In 2014 our wage expense is $172,704, by 2019 it will grow to $214,462.
Credit Card Fees and Taxes are expected to grow 20% each year because of the additional sales from $14,852 and $17,800 to $37,325 and $44,292
…show more content…
Cash is projected to increase from the current amount of $200,000 to $457,552 by the end of 2019. Accounts Receivables will increase from the current amount of $371,379 to $$849,625. Inventory will increase from the current amount of $9,100 to $20,819 by the end of projected period, and Prepaid Assets will climb from $2,500 to $5,816. Total Fixed Assets are not projected to increase, the property and equipment assets associated with Total Fixed assets will depreciate stagnantly by $15,000 over the 5 year projected period. The Asset category, “Other” will increase from $988 to $2,107. Along with the increase of these asset accounts, the Liabilities Account of Account Payable will increase from $147,179 to $365,682 by the end of 2019. From the prepared Pro Forma projections, expanding the product line to pizza is good for the bottom line. Net Profit will increase by approximately 322% and Cash is projected to increase by 228%. The additional retained earnings over the five year period from the pizza line can be used to finance the project. In other words, by applying the retained earnings from the pizza line project back into the company we can finance the project

You May Also Find These Documents Helpful

  • Good Essays

    Analyzing Pro Forma Statements FIN 571 Kent Kelly February 2, 2015 Suzanne Elliot Financial statements that are prepared by a company to consider the effects of potential activity is considered a pro forma statements. A financial statement shows the projected or forecast of operating results and balance sheet, and statement of cash flows. The company XYZ Company Inc. is planning to expand their company in the next five years. This paper will review and discuss XYZ’s Company’s five year plan…

    • 558 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Analyzing Pro Forma 2

    • 465 Words
    • 2 Pages

    Analyzing Pro Forma Statements FIN/571 February 09, 2015 Analyzing Pro Forma Statements Introduction 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…

    • 465 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Analyzing Pro Forma Data

    • 467 Words
    • 2 Pages

    Analyzing Pro Forma Statements Bridget Harvey and Keva Paul FIN/571 February 09, 2015 Ms. Wendy Thomas Introduction 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…

    • 467 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Pro Forma

    • 1365 Words
    • 7 Pages

    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 1.1 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…

    • 1365 Words
    • 7 Pages
    Better Essays
  • Satisfactory Essays

    Analyzing Pro Forma Statements FIN/571 David Binder October 20, 2014 XYZ Inc. 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…

    • 575 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    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…

    • 527 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Pro Forma Case Summary

    • 236 Words
    • 1 Page

    Mbagu performed to see the influence of pro forma regulation toward firm’s reporting practice. The type of firms used in the examination are S&P 500 companies, specifically Enron and Trump Hotels and Casino, and it focuses on 2001 and 2003. The Changes in Reported Pro Forma Earnings and GAAP 77% of firms reported pro forma earnings in 2001. The percentage of firms was seen to be declined to 54% in 2003. There are 85% of firms that have greater pro forma than GAAP earnings in 2001. In 2003, this…

    • 236 Words
    • 1 Page
    Good Essays
  • Good Essays

    Pro Forma Chapter 4

    • 1294 Words
    • 6 Pages

    CHAPTER 3 TUTORIAL SOLUTIONS 21. Assuming costs vary with sales and a 20 percent increase in sales, the pro forma income statement will look like this: MOOSE TOURS INC. Pro Forma Income Statement Sales $ 1,114,800 Costs 867,600 Other expenses 22,800 EBIT $ 224,400 Interest 14,000 Taxable income $ 210,400 Taxes(35%) 73,640 Net income $ 136,760 The payout ratio is constant, so the dividends…

    • 1294 Words
    • 6 Pages
    Good Essays
  • Better Essays

    Selected Companies Pro Forma 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…

    • 1255 Words
    • 6 Pages
    Better Essays
  • Satisfactory Essays

    Pro Forma Case Study

    • 343 Words
    • 2 Pages

    Assumptions. We build pro-forma statement mostly based on the assumptions given in the case. Other assumptions are following. At first, we assume that the tax rate is an average of tax rates for the past three years which is 20.1%. We use this tax rate to calculate the provision for income taxes for following years. Next assumption is that we take Mr. Dadge’s approximation for the initial rate as the interest rate, 11%. Since Mr. Clarkson finished payment to Mr. Holtz in 1995, we assume that only…

    • 343 Words
    • 2 Pages
    Satisfactory Essays