Aaron Daniel Bernstein
December 15, 2014
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