Pro Forma Statements help
chales18
week_4_pro_forma.xlsxSheet1
| YYZ Company | % | 1 | 2 | 3 | ||||||||||||
| $ | % | $ | % | $ | % | |||||||||||
| Sales | $ 1,750,450.00 | |||||||||||||||
| Returns & Allowances | $ 2,752.00 | |||||||||||||||
| Net Sales | $ 1,747,698.00 | 100.00% | $ 2,009,852.70 | 100.00% | $ 2,311,330.61 | 100.00% | $ 2,542,463.67 | 100.00% | ||||||||
| Cost of Sales | ||||||||||||||||
| Beg Inv | $ 50,000.00 | |||||||||||||||
| Purchases | $ 610,162.00 | |||||||||||||||
| Production Labor | $ 420,108.00 | |||||||||||||||
| End Inv | $ 30,000.00 | |||||||||||||||
| Total Cost of Sales | $ 1,050,270.00 | 60.09% | $ 1,207,810.50 | 60.09% | $ 1,365,996.39 | 59.10% | $ 1,529,291.89 | 60.15% | ||||||||
| Gross Profit | $ 697,428.00 | 39.91% | $ 802,042.20 | 39.91% | $ 945,334.22 | 40.90% | $ 1,013,171.77 | 39.85% | ||||||||
| Selling Expense | ||||||||||||||||
| Wages | $ 75,000.00 | |||||||||||||||
| Commissions | $ 25,000.00 | |||||||||||||||
| Marketing | $ 25,000.00 | |||||||||||||||
| Total Selling Expenses | $ 125,000.00 | 7.15% | $ 183,901.52 | 9.15% | $ 188,373.44 | 8.15% | $ 181,786.15 | 7.15% | ||||||||
| Operating Expense | ||||||||||||||||
| Salaries | $ 225,000.00 | |||||||||||||||
| Payroll Taxes | $ 29,000.00 | |||||||||||||||
| Benefits | $ 27,000.00 | |||||||||||||||
| Office Supplies | $ 500.00 | |||||||||||||||
| Postage | $ 250.00 | |||||||||||||||
| Pro. Fees | $ 2,000.00 | |||||||||||||||
| Telephone | $ 850.00 | |||||||||||||||
| Utilities | $ 950.00 | |||||||||||||||
| Training & Edu | $ 250.00 | |||||||||||||||
| Misc | $ 50.00 | |||||||||||||||
| Total Operating Expense | $ 285,850.00 | 16.36% | $ 281,379.38 | 14.00% | $ 350,166.59 | 15.15% | $ 457,643.46 | 18.00% | ||||||||
| Operating Profit (EBITDA) | $ 286,578.00 | 16.40% | $ 336,761.30 | 16.76% | $ 406,794.19 | 17.60% | $ 373,742.16 | 14.70% | ||||||||
| Other Income(Expense) | ||||||||||||||||
| Interest | $ (9,650.00) | $ (9,650.00) | $ (9,650.00) | $ (9,650.00) | ||||||||||||
| Dep | $ (12,000.00) | $ (12,000.00) | $ (12,000.00) | $ (12,000.00) | ||||||||||||
| Ammort | $ (2,500.00) | $ (2,500.00) | $ (2,500.00) | $ (2,500.00) | ||||||||||||
| Total Other Income (Expense) | $ (24,150.00) | $ (24,150.00) | $ (24,150.00) | $ (24,150.00) | ||||||||||||
| Total Pretax Profit | $ 262,428.00 | 15.02% | $ 312,611.30 | 15.55% | $ 382,644.19 | 16.56% | $ 349,592.16 | 13.75% | ||||||||
| Income Tax Allowance | $ 118,093.00 | 6.76% | $ 140,675.08 | 7.00% | $ 172,189.88 | 7.45% | $ 157,316.47 | 6.19% | ||||||||
| Net Profit | $ 144,335.00 | 8.26% | $ 171,936.21 | 8.55% | $ 210,454.30 | 9.11% | $ 192,275.69 | 7.56% | ||||||||
Table 2
| XYZ Company, INC. | ||||||||||||
| Balance Sheet | 1 | 2 | 3 | |||||||||
| For Year Ending December 31, 20XX | $ | % | $ | % | $ | % | $ | % | ||||
| ASSETS | ||||||||||||
| Current Assets | ||||||||||||
| Cash | $ 10,525.00 | |||||||||||
| Accounts Receivable | $ 27,000.00 | |||||||||||
| Inventory | $ 30,000.00 | |||||||||||
| Prepaid Expenses | $ 2,000.00 | |||||||||||
| Total Current Assets | $ 69,525.00 | 18.81% | $ 141,461.21 | 28.49% | $ 142,183.10 | 20% | ||||||
| Fixed Assets | ||||||||||||
| Property—net of depreciation | $ 215,000.00 | $ 215,000.00 | ||||||||||
| Equipment—net of depreciation | $ 80,000.00 | $ 105,000.00 | ||||||||||
| Vehicles—net of depreciation | $ 5,000.00 | $ 35,000.00 | ||||||||||
| Total Fixed Assets | $ 300,000.00 | 81.19% | $ 355,000.00 | 71.51% | $ 568,732.41 | 80% | ||||||
| Total Assets | $ 369,525.00 | 100.00% | $ 496,461.21 | 100% | $ 710,915.52 | |||||||
| LIABILITIES | ||||||||||||
| Current Liabilities | ||||||||||||
| Revolving lines of credit | $ 20,000.00 | |||||||||||
| Accounts Payable | $ 5,000.00 | |||||||||||
| Current Portion of Long-term Debt | $ 15,000.00 | |||||||||||
| Total Current Liabilities | $ 40,000.00 | 10.82% | $ 30,500.00 | 6.14% | $ 50,000.00 | |||||||
| Long-term Liabilities | ||||||||||||
| Long-term debt and capital leases | $ 45,500.00 | $ 70,500.00 | $ 55,000.00 | |||||||||
| Loans payable to stockholders | $ 60,500.00 | 0 | ||||||||||
| Total Long-term Liabilities | $ 106,000.00 | 28.69% | $ 70,500.00 | 14.20% | $ 55,000.00 | |||||||
| Total Liabilities | $ 146,000.00 | 39.51% | $ 101,000.00 | $ 105,000.00 | ||||||||
| Stockholders Equity | ||||||||||||
| Common stock | $ 1,000.00 | $ 1,000.00 | $ 1,000.00 | $ 1,000.00 | ||||||||
| Additional Paid-in Capital | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | ||||||||
| Retained Earnings (Cum from prior years) | $ 53,190.00 | $ 197,525.00 | $ 369,461.21 | |||||||||
| Retained Earnings (From current P&L) | $ 144,335.00 | $ 171,936.21 | $ 210,454.30 | |||||||||
| Total Stockholders Equity | $ 223,525.00 | 60.49% | $ 395,461.21 | 79.66% | $ 605,915.52 | |||||||
| Total Liabilities and Stockholders Equity | $ 369,525.00 | 100.00% | $ 496,461.21 | 100.00% | $ 710,915.52 |
