Financials
dherin
financeStatements1.xlsxIncome Statement
| Fruity Surprise | |||||
| Proforma Statement of Income | |||||
| Year 1 | Year 2 | Year 3 | |||
| Net revenues | $ 52,217.00 | $ 77,383.00 | $ 104,446.00 | ||
| Cost of Sales | $ (12,114.00) | $ (17,772.00) | $ (24,227.00) | ||
| Gross Profit | $ 40,103.00 | $ 59,611.00 | $ 80,219.00 | ||
| Expenses | |||||
| Payroll | $ 10,800.00 | $ 11,232.00 | $ 11,681.00 | ||
| Marketing and promotion | $ 1,410.00 | $ 1,466.00 | $ 1,525.00 | ||
| Depreciation | $ 400.00 | $ 400.00 | $ 400.00 | ||
| Utilities | $ 1,720.00 | $ 1,789.00 | $ 1,861.00 | ||
| Insurance | $ 1,200.00 | $ 1,248.00 | $ 1,298.00 | ||
| Total operating expenses | $ 15,530.00 | $ 16,135.00 | $ 16,765.00 | ||
| Earnings before Interest and Tax | $ 24,573.00 | $ 43,476.00 | $ 63,454.00 | ||
| Interest expense | $ 3,632.00 | $ 2,626.00 | $ 1,576.00 | ||
| Earnings before tax | $ 20,941.00 | $ 40,850.00 | $ 61,878.00 | ||
| Income Tax (30%) | $ 6,282.30 | $ 12,255.00 | $ 18,563.40 | ||
| Net Income | $ 14,658.70 | $ 28,595.00 | $ 43,314.60 |
Cash Flow
| Fruity Surprise | |||||
| Pro Forma Statement of Cash Flow | |||||
| Year 1 | Year 2 | Year 3 | |||
| Cash from Operations | |||||
| Cash Sales | $ 52,217.00 | $ 77,383.00 | $ 104,446.00 | ||
| Additional cash received | 0 | 0 | 0 | ||
| Sales tax received | 0 | 0 | 0 | ||
| New creditors | 0 | 0 | 0 | ||
| New long term liabilities | 0 | 0 | 0 | ||
| Sale of current assets | 0 | 0 | 0 | ||
| Sale of long term assets | 0 | 0 | 0 | ||
| New investment received | 0 | 0 | 0 | ||
| Total cash received | $ 52,217.00 | $ 77,383.00 | $ 104,446.00 | ||
| Expenditures | |||||
| Expenditures from operations | |||||
| Cash spending | $ 10,800.00 | $ 11,232.00 | $ 11,681.00 | ||
| Bill payments | $ 25,459.00 | $ 34,970.00 | $ 48,550.00 | ||
| Subtotal expenditure on operations | $ 36,259.00 | $ 46,202.00 | $ 60,231.00 | ||
| Additional cash spent | |||||
| Principal repayment of current debt | 10,500 | 10,500 | 10,500 | ||
| Other liabilities principal repayment | 0 | 0 | 0 | ||
| Sales tax | 0 | 0 | 0 | ||
| Long-term liabilities principal repayment | 0 | 0 | 0 | ||
| Purchase of long-term assets | 0 | 0 | 0 | ||
| Dividends | 0 | 0 | 0 | ||
| Total cash spent | $ 46,759.00 | $ 56,702.00 | $ 70,731.00 | ||
| Net cash flow | $ 5,458.00 | $ 20,681.00 | $ 33,715.00 | ||
| Paid in capital | $ 10,000.00 | $ - 0 | $ - 0 | ||
| Cash balance | $ 15,458.00 | $ 36,139.00 | $ 69,854.00 |
Balance Sheet
| Fruity Surprise | |||||
| Pro Forma Balance Sheet Statement | |||||
| Year 1 | Year 2 | Year 3 | |||
| Current Assets | |||||
| Cash | $ 15,458.00 | $ 36,139.00 | $ 69,854.00 | ||
| Inventory | $ 905.00 | $ 1,328.00 | $ 1,810.00 | ||
| Trade Receivables | $ 675.00 | $ 675.00 | $ 675.00 | ||
| Total Current Assets | $ 17,038.00 | $ 38,142.00 | $ 72,339.00 | ||
| Long Term Assets | |||||
| Machinery and Equipment | $ 4,000.00 | $ 4,000.00 | $ 4,000.00 | ||
| Accumulated Depreciation | $ 400.00 | $ 800.00 | $ 1,200.00 | ||
| Total Long Term Assets | $ 3,600.00 | $ 3,200.00 | $ 2,800.00 | ||
| Total Assets | $ 20,638.00 | $ 41,342.00 | $ 75,139.00 | ||
| Current Liabilities | |||||
| Accounts Payable | $ 480.00 | $ 3,089.00 | $ 4,071.00 | ||
| Total Current Liabilities | $ 480.00 | $ 3,089.00 | $ 4,071.00 | ||
| Long Term Liabilities | |||||
| Bank Loan | $ 31,510.00 | $ 21,010.00 | $ 10,510.00 | ||
| Total Liabilities | $ 31,990.00 | $ 24,099.00 | $ 14,581.00 | ||
| Paid in Capital | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 | ||
| Retained earnings | $ (36,010.00) | $ (21,351.00) | $ 7,244.00 | ||
| Net Income | $ 14,659.00 | $ 28,595.00 | $ 43,315.00 | ||
| Total Shareholders' Equity | $ (11,351.00) | $ 17,244.00 | $ 60,559.00 | ||
| Total Liabilities and Equity | $ 20,639.00 | $ 41,343.00 | $ 75,140.00 |
