The following sections will present the break-even analysis, profit and loss, cash flow, and the balance sheet.
The Break-even Analysis is laid out in the following table and chart.
| Break-even Analysis | |
| Monthly Revenue Break-even | £1,190 |
| Assumptions: | |
| Average Percent Variable Cost | 0% |
| Estimated Monthly Fixed Cost | £1,190 |
The following table will indicate projected profit and loss for three years.
| Pro Forma Profit and Loss | |||
| Year 1 | Year 2 | Year 3 | |
| Sales | £23,850 | £35,000 | £52,000 |
| Direct Cost of Sales | £0 | £0 | £0 |
| Other Production Expenses | £0 | £0 | £0 |
| Total Cost of Sales | £0 | £0 | £0 |
| Gross Margin | £23,850 | £35,000 | £52,000 |
| Gross Margin % | 100.00% | 100.00% | 100.00% |
| Expenses | |||
| Payroll | £12,000 | £24,000 | £35,000 |
| Sales and Marketing and Other Expenses | £0 | £500 | £500 |
| Depreciation | £0 | £0 | £0 |
| Cell Phone | £480 | £480 | £480 |
| Utilities | £0 | £0 | £0 |
| Insurance | £0 | £0 | £0 |
| Rent | £0 | £0 | £0 |
| Payroll Taxes | £1,800 | £3,600 | £5,250 |
| Other | £0 | £0 | £0 |
| Total Operating Expenses | £14,280 | £28,580 | £41,230 |
| Profit Before Interest and Taxes | £9,570 | £6,420 | £10,770 |
| EBITDA | £9,570 | £6,420 | £10,770 |
| Interest Expense | £0 | £0 | £0 |
| Taxes Incurred | £2,871 | £1,926 | £3,231 |
| Net Profit | £6,699 | £4,494 | £7,539 |
| Net Profit/Sales | 28.09% | 12.84% | 14.50% |
The following chart and table indicates projected cash flow.
| Pro Forma Cash Flow | |||
| Year 1 | Year 2 | Year 3 | |
| Cash Received | |||
| Cash from Operations | |||
| Cash Sales | £5,963 | £8,750 | £13,000 |
| Cash from Receivables | £14,643 | £24,733 | £36,687 |
| Subtotal Cash from Operations | £20,605 | £33,483 | £49,687 |
| Additional Cash Received | |||
| Sales Tax, VAT, HST/GST Received | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 |
| New Other Liabilities (interest-free) | £0 | £0 | £0 |
| New Long-term Liabilities | £0 | £0 | £0 |
| Sales of Other Current Assets | £0 | £0 | £0 |
| Sales of Long-term Assets | £0 | £0 | £0 |
| New Investment Received | £0 | £0 | £0 |
| Subtotal Cash Received | £20,605 | £33,483 | £49,687 |
| Expenditures | Year 1 | Year 2 | Year 3 |
| Expenditures from Operations | |||
| Cash Spending | £12,000 | £24,000 | £35,000 |
| Bill Payments | £4,863 | £6,259 | £9,218 |
| Subtotal Spent on Operations | £16,863 | £30,259 | £44,218 |
| Additional Cash Spent | |||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 |
| Other Liabilities Principal Repayment | £0 | £0 | £0 |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 |
| Purchase Other Current Assets | £0 | £0 | £0 |
| Purchase Long-term Assets | £0 | £0 | £0 |
| Dividends | £0 | £0 | £0 |
| Subtotal Cash Spent | £16,863 | £30,259 | £44,218 |
| Net Cash Flow | £3,742 | £3,224 | £5,469 |
| Cash Balance | £4,092 | £7,316 | £12,785 |
The following is the projected balance sheet for three years.
| Pro Forma Balance Sheet | |||
| Year 1 | Year 2 | Year 3 | |
| Assets | |||
| Current Assets | |||
| Cash | £4,092 | £7,316 | £12,785 |
| Accounts Receivable | £3,245 | £4,762 | £7,075 |
| Other Current Assets | £0 | £0 | £0 |
| Total Current Assets | £7,337 | £12,078 | £19,860 |
| Long-term Assets | |||
| Long-term Assets | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 |
| Total Assets | £7,337 | £12,078 | £19,860 |
| Liabilities and Capital | Year 1 | Year 2 | Year 3 |
| Current Liabilities | |||
| Accounts Payable | £288 | £535 | £778 |
| Current Borrowing | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 |
| Subtotal Current Liabilities | £288 | £535 | £778 |
| Long-term Liabilities | £0 | £0 | £0 |
| Total Liabilities | £288 | £535 | £778 |
| Paid-in Capital | £1,000 | £1,000 | £1,000 |
| Retained Earnings | (£650) | £6,049 | £10,543 |
| Earnings | £6,699 | £4,494 | £7,539 |
| Total Capital | £7,049 | £11,543 | £19,082 |
| Total Liabilities and Capital | £7,337 | £12,078 | £19,860 |
| Net Worth | £7,049 | £11,543 | £19,082 |
The following table provides important ratios for the real estate industry, as determined by the Standard Industry Classification (SIC) Index, 7319, Advertising, nec.
| Ratio Analysis | ||||
| Year 1 | Year 2 | Year 3 | Industry Profile | |
| Sales Growth | 0.00% | 46.75% | 48.57% | 8.50% |
| Percent of Total Assets | ||||
| Accounts Receivable | 44.23% | 39.43% | 35.63% | 36.10% |
| Other Current Assets | 0.00% | 0.00% | 0.00% | 42.70% |
| Total Current Assets | 100.00% | 100.00% | 100.00% | 80.20% |
| Long-term Assets | 0.00% | 0.00% | 0.00% | 19.80% |
| Total Assets | 100.00% | 100.00% | 100.00% | 100.00% |
| Current Liabilities | 3.93% | 4.43% | 3.92% | 46.70% |
| Long-term Liabilities | 0.00% | 0.00% | 0.00% | 9.80% |
| Total Liabilities | 3.93% | 4.43% | 3.92% | 56.50% |
| Net Worth | 96.07% | 95.57% | 96.08% | 43.50% |
| Percent of Sales | ||||
| Sales | 100.00% | 100.00% | 100.00% | 100.00% |
| Gross Margin | 100.00% | 100.00% | 100.00% | 0.00% |
| Selling, General & Administrative Expenses | 71.91% | 87.16% | 85.50% | 79.10% |
| Advertising Expenses | 0.00% | 1.43% | 0.96% | 4.20% |
| Profit Before Interest and Taxes | 40.13% | 18.34% | 20.71% | 1.60% |
| Main Ratios | ||||
| Current | 25.47 | 22.59 | 25.54 | 1.70 |
| Quick | 25.47 | 22.59 | 25.54 | 1.43 |
| Total Debt to Total Assets | 3.93% | 4.43% | 3.92% | 56.50% |
| Pre-tax Return on Net Worth | 135.76% | 55.62% | 56.44% | 4.60% |
| Pre-tax Return on Assets | 130.43% | 53.16% | 54.23% | 10.50% |
| Additional Ratios | Year 1 | Year 2 | Year 3 | |
| Net Profit Margin | 28.09% | 12.84% | 14.50% | n.a |
| Return on Equity | 95.03% | 38.93% | 39.51% | n.a |
| Activity Ratios | ||||
| Accounts Receivable Turnover | 5.51 | 5.51 | 5.51 | n.a |
| Collection Days | 57 | 56 | 55 | n.a |
| Accounts Payable Turnover | 17.88 | 12.17 | 12.17 | n.a |
| Payment Days | 27 | 23 | 25 | n.a |
| Total Asset Turnover | 3.25 | 2.90 | 2.62 | n.a |
| Debt Ratios | ||||
| Debt to Net Worth | 0.04 | 0.05 | 0.04 | n.a |
| Current Liab. to Liab. | 1.00 | 1.00 | 1.00 | n.a |
| Liquidity Ratios | ||||
| Net Working Capital | £7,049 | £11,543 | £19,082 | n.a |
| Interest Coverage | 0.00 | 0.00 | 0.00 | n.a |
| Additional Ratios | ||||
| Assets to Sales | 0.31 | 0.35 | 0.38 | n.a |
| Current Debt/Total Assets | 4% | 4% | 4% | n.a |
| Acid Test | 14.21 | 13.68 | 16.44 | n.a |
| Sales/Net Worth | 3.38 | 3.03 | 2.73 | n.a |
| Dividend Payout | 0.00 | 0.00 | 0.00 | n.a |
| Break-even Analysis | |
| Monthly Revenue Break-even | £1,190 |
| Assumptions: | |
| Average Percent Variable Cost | 0% |
| Estimated Monthly Fixed Cost | £1,190 |
| Pro Forma Profit and Loss | |||
| Year 1 | Year 2 | Year 3 | |
| Sales | £23,850 | £35,000 | £52,000 |
| Direct Cost of Sales | £0 | £0 | £0 |
| Other Production Expenses | £0 | £0 | £0 |
| Total Cost of Sales | £0 | £0 | £0 |
| Gross Margin | £23,850 | £35,000 | £52,000 |
| Gross Margin % | 100.00% | 100.00% | 100.00% |
| Expenses | |||
| Payroll | £12,000 | £24,000 | £35,000 |
| Sales and Marketing and Other Expenses | £0 | £500 | £500 |
| Depreciation | £0 | £0 | £0 |
| Cell Phone | £480 | £480 | £480 |
| Utilities | £0 | £0 | £0 |
| Insurance | £0 | £0 | £0 |
| Rent | £0 | £0 | £0 |
| Payroll Taxes | £1,800 | £3,600 | £5,250 |
| Other | £0 | £0 | £0 |
| Total Operating Expenses | £14,280 | £28,580 | £41,230 |
| Profit Before Interest and Taxes | £9,570 | £6,420 | £10,770 |
| EBITDA | £9,570 | £6,420 | £10,770 |
| Interest Expense | £0 | £0 | £0 |
| Taxes Incurred | £2,871 | £1,926 | £3,231 |
| Net Profit | £6,699 | £4,494 | £7,539 |
| Net Profit/Sales | 28.09% | 12.84% | 14.50% |
| Pro Forma Cash Flow | |||
| Year 1 | Year 2 | Year 3 | |
| Cash Received | |||
| Cash from Operations | |||
| Cash Sales | £5,963 | £8,750 | £13,000 |
| Cash from Receivables | £14,643 | £24,733 | £36,687 |
| Subtotal Cash from Operations | £20,605 | £33,483 | £49,687 |
| Additional Cash Received | |||
| Sales Tax, VAT, HST/GST Received | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 |
| New Other Liabilities (interest-free) | £0 | £0 | £0 |
| New Long-term Liabilities | £0 | £0 | £0 |
| Sales of Other Current Assets | £0 | £0 | £0 |
| Sales of Long-term Assets | £0 | £0 | £0 |
| New Investment Received | £0 | £0 | £0 |
| Subtotal Cash Received | £20,605 | £33,483 | £49,687 |
| Expenditures | Year 1 | Year 2 | Year 3 |
| Expenditures from Operations | |||
| Cash Spending | £12,000 | £24,000 | £35,000 |
| Bill Payments | £4,863 | £6,259 | £9,218 |
| Subtotal Spent on Operations | £16,863 | £30,259 | £44,218 |
| Additional Cash Spent | |||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 |
| Other Liabilities Principal Repayment | £0 | £0 | £0 |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 |
| Purchase Other Current Assets | £0 | £0 | £0 |
| Purchase Long-term Assets | £0 | £0 | £0 |
| Dividends | £0 | £0 | £0 |
| Subtotal Cash Spent | £16,863 | £30,259 | £44,218 |
| Net Cash Flow | £3,742 | £3,224 | £5,469 |
| Cash Balance | £4,092 | £7,316 | £12,785 |
| Pro Forma Balance Sheet | |||
| Year 1 | Year 2 | Year 3 | |
| Assets | |||
| Current Assets | |||
| Cash | £4,092 | £7,316 | £12,785 |
| Accounts Receivable | £3,245 | £4,762 | £7,075 |
| Other Current Assets | £0 | £0 | £0 |
| Total Current Assets | £7,337 | £12,078 | £19,860 |
| Long-term Assets | |||
| Long-term Assets | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 |
| Total Assets | £7,337 | £12,078 | £19,860 |
| Liabilities and Capital | Year 1 | Year 2 | Year 3 |
| Current Liabilities | |||
| Accounts Payable | £288 | £535 | £778 |
| Current Borrowing | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 |
| Subtotal Current Liabilities | £288 | £535 | £778 |
| Long-term Liabilities | £0 | £0 | £0 |
| Total Liabilities | £288 | £535 | £778 |
| Paid-in Capital | £1,000 | £1,000 | £1,000 |
| Retained Earnings | (£650) | £6,049 | £10,543 |
| Earnings | £6,699 | £4,494 | £7,539 |
| Total Capital | £7,049 | £11,543 | £19,082 |
| Total Liabilities and Capital | £7,337 | £12,078 | £19,860 |
| Net Worth | £7,049 | £11,543 | £19,082 |
| Ratio Analysis | ||||
| Year 1 | Year 2 | Year 3 | Industry Profile | |
| Sales Growth | 0.00% | 46.75% | 48.57% | 8.50% |
| Percent of Total Assets | ||||
| Accounts Receivable | 44.23% | 39.43% | 35.63% | 36.10% |
| Other Current Assets | 0.00% | 0.00% | 0.00% | 42.70% |
| Total Current Assets | 100.00% | 100.00% | 100.00% | 80.20% |
| Long-term Assets | 0.00% | 0.00% | 0.00% | 19.80% |
| Total Assets | 100.00% | 100.00% | 100.00% | 100.00% |
| Current Liabilities | 3.93% | 4.43% | 3.92% | 46.70% |
| Long-term Liabilities | 0.00% | 0.00% | 0.00% | 9.80% |
| Total Liabilities | 3.93% | 4.43% | 3.92% | 56.50% |
| Net Worth | 96.07% | 95.57% | 96.08% | 43.50% |
| Percent of Sales | ||||
| Sales | 100.00% | 100.00% | 100.00% | 100.00% |
| Gross Margin | 100.00% | 100.00% | 100.00% | 0.00% |
| Selling, General & Administrative Expenses | 71.91% | 87.16% | 85.50% | 79.10% |
| Advertising Expenses | 0.00% | 1.43% | 0.96% | 4.20% |
| Profit Before Interest and Taxes | 40.13% | 18.34% | 20.71% | 1.60% |
| Main Ratios | ||||
| Current | 25.47 | 22.59 | 25.54 | 1.70 |
| Quick | 25.47 | 22.59 | 25.54 | 1.43 |
| Total Debt to Total Assets | 3.93% | 4.43% | 3.92% | 56.50% |
| Pre-tax Return on Net Worth | 135.76% | 55.62% | 56.44% | 4.60% |
| Pre-tax Return on Assets | 130.43% | 53.16% | 54.23% | 10.50% |
| Additional Ratios | Year 1 | Year 2 | Year 3 | |
| Net Profit Margin | 28.09% | 12.84% | 14.50% | n.a |
| Return on Equity | 95.03% | 38.93% | 39.51% | n.a |
| Activity Ratios | ||||
| Accounts Receivable Turnover | 5.51 | 5.51 | 5.51 | n.a |
| Collection Days | 57 | 56 | 55 | n.a |
| Accounts Payable Turnover | 17.88 | 12.17 | 12.17 | n.a |
| Payment Days | 27 | 23 | 25 | n.a |
| Total Asset Turnover | 3.25 | 2.90 | 2.62 | n.a |
| Debt Ratios | ||||
| Debt to Net Worth | 0.04 | 0.05 | 0.04 | n.a |
| Current Liab. to Liab. | 1.00 | 1.00 | 1.00 | n.a |
| Liquidity Ratios | ||||
| Net Working Capital | £7,049 | £11,543 | £19,082 | n.a |
| Interest Coverage | 0.00 | 0.00 | 0.00 | n.a |
| Additional Ratios | ||||
| Assets to Sales | 0.31 | 0.35 | 0.38 | n.a |
| Current Debt/Total Assets | 4% | 4% | 4% | n.a |
| Acid Test | 14.21 | 13.68 | 16.44 | n.a |
| Sales/Net Worth | 3.38 | 3.03 | 2.73 | n.a |
| Dividend Payout | 0.00 | 0.00 | 0.00 | n.a |