Start-up Funding | |
Start-up Expenses to Fund | $0 |
Start-up Assets to Fund | $20,100,000 |
Total Funding Required | $20,100,000 |
Assets | |
Non-cash Assets from Start-up | $0 |
Cash Requirements from Start-up | $20,100,000 |
Additional Cash Raised | $0 |
Cash Balance on Starting Date | $20,100,000 |
Total Assets | $20,100,000 |
Liabilities and Capital | |
Liabilities | |
Current Borrowing | $0 |
Long-term Liabilities | $0 |
Accounts Payable (Outstanding Bills) | $0 |
Other Current Liabilities (interest-free) | $0 |
Total Liabilities | $0 |
Capital | |
Planned Investment | |
Investor 1 | $20,000,000 |
Investor 2 | $100,000 |
Other | $0 |
Additional Investment Requirement | $0 |
Total Planned Investment | $20,100,000 |
Loss at Start-up (Start-up Expenses) | $0 |
Total Capital | $20,100,000 |
Total Capital and Liabilities | $20,100,000 |
Total Funding | $20,100,000 |
Strategy and implementation summary, sales forecast forecast sales .">.
Sales Forecast | |||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Sales | |||||
Management Fees | $400,000 | $400,000 | $400,000 | $400,000 | $400,000 |
Equity appreciation | $0 | $0 | $0 | $0 | $45,000,000 |
Total Sales | $400,000 | $400,000 | $400,000 | $400,000 | $45,400,000 |
Direct Cost of Sales | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
Management Fees | $0 | $0 | $0 | $0 | $0 |
Equity appreciation | $0 | $0 | $0 | $0 | $0 |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 |
7.1 personnel plan.
This hypothetical company pays salaries to its partners and other employees, and office expenses, from the management fee of two percent (2%).
Personnel Plan | |||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Partners | $240,000 | $252,000 | $265,000 | $278,000 | $292,000 |
Other | $60,000 | $63,000 | $66,000 | $69,000 | $72,000 |
Total People | 4 | 4 | 4 | 4 | 4 |
Total Payroll | $300,000 | $315,000 | $331,000 | $347,000 | $364,000 |
8.1 projected profit and loss.
Please note that in the third year one investment is written off as a failure, producing a $5 million cost which ends up showing a loss for the year of nearly $5 million. The sale of equity at the end of the period enters the sales forecast and the profit and loss statement as a $45 million gain.
Pro Forma Profit and Loss | |||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Sales | $400,000 | $400,000 | $400,000 | $400,000 | $45,400,000 |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 |
Investment write-off | $0 | $0 | $5,000,000 | $0 | $0 |
Total Cost of Sales | $0 | $0 | $5,000,000 | $0 | $0 |
Gross Margin | $400,000 | $400,000 | ($4,600,000) | $400,000 | $45,400,000 |
Gross Margin % | 100.00% | 100.00% | -1150.00% | 100.00% | 100.00% |
Expenses | |||||
Payroll | $300,000 | $315,000 | $331,000 | $347,000 | $364,000 |
Sales and Marketing and Other Expenses | $13,200 | $13,900 | $14,600 | $15,300 | $16,000 |
Depreciation | $0 | $0 | $0 | $0 | $0 |
Leased Equipment | $2,400 | $2,500 | $2,600 | $2,700 | $2,800 |
Utilities | $1,200 | $1,300 | $1,400 | $1,500 | $1,600 |
Insurance | $2,400 | $2,500 | $2,600 | $2,700 | $2,800 |
Rent | $36,000 | $37,800 | $39,700 | $41,700 | $43,800 |
Payroll Taxes | $45,000 | $47,250 | $49,650 | $52,050 | $54,600 |
Other | $0 | $0 | $0 | $0 | $0 |
Total Operating Expenses | $400,200 | $420,250 | $441,550 | $462,950 | $485,600 |
Profit Before Interest and Taxes | ($200) | ($20,250) | ($5,041,550) | ($62,950) | $44,914,400 |
EBITDA | ($200) | ($20,250) | ($5,041,550) | ($62,950) | $44,914,400 |
Interest Expense | $0 | $0 | $0 | $0 | $0 |
Taxes Incurred | $0 | $0 | $0 | $0 | $8,982,880 |
Net Profit | ($200) | ($20,250) | ($5,041,550) | ($62,950) | $35,931,520 |
Net Profit/Sales | -0.05% | -5.06% | -1260.39% | -15.74% | 79.14% |
The Cash Flow shows four $5 million investments made in the first few months of the plan.
In the third year, one of the target companies fails, so $5 million is written off as failure. You’ll see that shows as a $5 million sale of long-term assets in the cash flow, and a balancing entry of $5 million in costs of sales in the profit and loss, making for a loss and write-off that year. The result is a tax loss, and the balance of investments goes to $15 Million.
In the fifth year, another investment is transacted at $50 million. This shows up as a $5 million equity appreciation in the Sales Forecast, plus a $5 million sale of long-term assets in the Cash Flow. At that point there’s been a $45 million profit and the balance of long-term assets goes down to $10 million.
The partners invest an additional $100,000 in the fourth year as additional working capital to balance the cash flow of the company.
Pro Forma Cash Flow | |||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Cash Received | |||||
Cash from Operations | |||||
Cash Sales | $400,000 | $400,000 | $400,000 | $400,000 | $45,400,000 |
Subtotal Cash from Operations | $400,000 | $400,000 | $400,000 | $400,000 | $45,400,000 |
Additional Cash Received | |||||
Sales Tax, VAT, HST/GST Received | $0 | $0 | $0 | $0 | $0 |
New Current Borrowing | $0 | $0 | $0 | $0 | $0 |
New Other Liabilities (interest-free) | $0 | $0 | $0 | $0 | $0 |
New Long-term Liabilities | $0 | $0 | $0 | $0 | $0 |
Sales of Other Current Assets | $0 | $0 | $0 | $0 | $0 |
Sales of Long-term Assets | $0 | $0 | $5,000,000 | $0 | $5,000,000 |
New Investment Received | $0 | $0 | $0 | $100,000 | $0 |
Subtotal Cash Received | $400,000 | $400,000 | $5,400,000 | $500,000 | $50,400,000 |
Expenditures | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
Expenditures from Operations | |||||
Cash Spending | $300,000 | $315,000 | $331,000 | $347,000 | $364,000 |
Bill Payments | $92,128 | $104,671 | $4,699,155 | $526,465 | $8,365,697 |
Subtotal Spent on Operations | $392,128 | $419,671 | $5,030,155 | $873,465 | $8,729,697 |
Additional Cash Spent | |||||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 | $0 | $0 |
Principal Repayment of Current Borrowing | $0 | $0 | $0 | $0 | $0 |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 |
Long-term Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 |
Purchase Other Current Assets | $0 | $0 | $0 | $0 | $0 |
Purchase Long-term Assets | $20,000,000 | $0 | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 | $0 | $0 |
Subtotal Cash Spent | $20,392,128 | $419,671 | $5,030,155 | $873,465 | $8,729,697 |
Net Cash Flow | ($19,992,128) | ($19,671) | $369,845 | ($373,465) | $41,670,303 |
Cash Balance | $107,872 | $88,201 | $458,045 | $84,580 | $41,754,883 |
You can see in the balance sheet how the ending balances for long-term assets were not re-valued. They remain at the original purchase price until they are sold, or written off as a complete loss. There is a $5 million write-off in the third year, and a sale of $5 million worth of assets in the last year. That sale of $5 million in assets produces the $5 million sale at book value plus the $45 million gain in the sales forecast and profit and loss table.
Pro Forma Balance Sheet | |||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Assets | |||||
Current Assets | |||||
Cash | $107,872 | $88,201 | $458,045 | $84,580 | $41,754,883 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $107,872 | $88,201 | $458,045 | $84,580 | $41,754,883 |
Long-term Assets | |||||
Long-term Assets | $20,000,000 | $20,000,000 | $15,000,000 | $15,000,000 | $10,000,000 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $20,000,000 | $20,000,000 | $15,000,000 | $15,000,000 | $10,000,000 |
Total Assets | $20,107,872 | $20,088,201 | $15,458,045 | $15,084,580 | $51,754,883 |
Liabilities and Capital | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
Current Liabilities | |||||
Accounts Payable | $8,072 | $8,651 | $420,045 | $9,530 | $748,313 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $8,072 | $8,651 | $420,045 | $9,530 | $748,313 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $8,072 | $8,651 | $420,045 | $9,530 | $748,313 |
Paid-in Capital | $20,100,000 | $20,100,000 | $20,100,000 | $20,200,000 | $20,200,000 |
Retained Earnings | $0 | ($200) | ($20,450) | ($5,062,000) | ($5,124,950) |
Earnings | ($200) | ($20,250) | ($5,041,550) | ($62,950) | $35,931,520 |
Total Capital | $20,099,800 | $20,079,550 | $15,038,000 | $15,075,050 | $51,006,570 |
Total Liabilities and Capital | $20,107,872 | $20,088,201 | $15,458,045 | $15,084,580 | $51,754,883 |
Net Worth | $20,099,800 | $20,079,550 | $15,038,000 | $15,075,050 | $51,006,570 |
The Standard Industry Code (SIC) for this type of business is 7389, Business Services. The Industry Data is provided in the final column of the Ratios table.
Ratio Analysis | ||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Industry Profile | |
Sales Growth | 0.00% | 0.00% | 0.00% | 0.00% | 11250.00% | 8.20% |
Percent of Total Assets | ||||||
Other Current Assets | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 44.20% |
Total Current Assets | 0.54% | 0.44% | 2.96% | 0.56% | 80.68% | 74.30% |
Long-term Assets | 99.46% | 99.56% | 97.04% | 99.44% | 19.32% | 25.70% |
Total Assets | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% |
Current Liabilities | 0.04% | 0.04% | 2.72% | 0.06% | 1.45% | 49.00% |
Long-term Liabilities | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 13.80% |
Total Liabilities | 0.04% | 0.04% | 2.72% | 0.06% | 1.45% | 62.80% |
Net Worth | 99.96% | 99.96% | 97.28% | 99.94% | 98.55% | 37.20% |
Percent of Sales | ||||||
Sales | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% |
Gross Margin | 100.00% | 100.00% | -1150.00% | 100.00% | 100.00% | 0.00% |
Selling, General & Administrative Expenses | 100.05% | 105.06% | 110.39% | 115.74% | 20.86% | 81.40% |
Advertising Expenses | 0.30% | 0.33% | 0.35% | 0.38% | 0.00% | 1.70% |
Profit Before Interest and Taxes | -0.05% | -5.06% | -1260.39% | -15.74% | 98.93% | 2.10% |
Main Ratios | ||||||
Current | 13.36 | 10.20 | 1.09 | 8.88 | 55.80 | 1.49 |
Quick | 13.36 | 10.20 | 1.09 | 8.88 | 55.80 | 1.17 |
Total Debt to Total Assets | 0.04% | 0.04% | 2.72% | 0.06% | 1.45% | 62.80% |
Pre-tax Return on Net Worth | 0.00% | -0.10% | -33.53% | -0.42% | 88.06% | 4.20% |
Pre-tax Return on Assets | 0.00% | -0.10% | -32.61% | -0.42% | 86.78% | 11.30% |
Additional Ratios | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Net Profit Margin | -0.05% | -5.06% | -1260.39% | -15.74% | 79.14% | n.a |
Return on Equity | 0.00% | -0.10% | -33.53% | -0.42% | 70.44% | n.a |
Activity Ratios | ||||||
Accounts Payable Turnover | 12.41 | 12.17 | 12.17 | 12.17 | 12.17 | n.a |
Payment Days | 27 | 29 | 15 | 676 | 15 | n.a |
Total Asset Turnover | 0.02 | 0.02 | 0.03 | 0.03 | 0.88 | n.a |
Debt Ratios | ||||||
Debt to Net Worth | 0.00 | 0.00 | 0.03 | 0.00 | 0.01 | n.a |
Current Liab. to Liab. | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | n.a |
Liquidity Ratios | ||||||
Net Working Capital | $99,800 | $79,550 | $38,000 | $75,050 | $41,006,570 | n.a |
Interest Coverage | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | n.a |
Additional Ratios | ||||||
Assets to Sales | 50.27 | 50.22 | 38.65 | 37.71 | 1.14 | n.a |
Current Debt/Total Assets | 0% | 0% | 3% | 0% | 1% | n.a |
Acid Test | 13.36 | 10.20 | 1.09 | 8.88 | 55.80 | n.a |
Sales/Net Worth | 0.02 | 0.02 | 0.03 | 0.03 | 0.89 | n.a |
Dividend Payout | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | n.a |
Sales Forecast | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Sales | |||||||||||||
Management Fees | 2% | $0 | $0 | $100,000 | $0 | $0 | $100,000 | $0 | $0 | $100,000 | $0 | $0 | $100,000 |
Equity appreciation | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $0 | $0 | $100,000 | $0 | $0 | $100,000 | $0 | $0 | $100,000 | $0 | $0 | $100,000 | |
Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Management Fees | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Equity appreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Personnel Plan | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Partners | 0% | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 |
Other | 0% | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
Total Payroll | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 |
General Assumptions | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Tax Rate | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Pro Forma Profit and Loss | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Sales | $0 | $0 | $100,000 | $0 | $0 | $100,000 | $0 | $0 | $100,000 | $0 | $0 | $100,000 | |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Investment write-off | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Gross Margin | $0 | $0 | $100,000 | $0 | $0 | $100,000 | $0 | $0 | $100,000 | $0 | $0 | $100,000 | |
Gross Margin % | 0.00% | 0.00% | 100.00% | 0.00% | 0.00% | 100.00% | 0.00% | 0.00% | 100.00% | 0.00% | 0.00% | 100.00% | |
Expenses | |||||||||||||
Payroll | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | |
Sales and Marketing and Other Expenses | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Leased Equipment | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Utilities | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Insurance | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Rent | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Payroll Taxes | 15% | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | |
Profit Before Interest and Taxes | ($33,350) | ($33,350) | $66,650 | ($33,350) | ($33,350) | $66,650 | ($33,350) | ($33,350) | $66,650 | ($33,350) | ($33,350) | $66,650 | |
EBITDA | ($33,350) | ($33,350) | $66,650 | ($33,350) | ($33,350) | $66,650 | ($33,350) | ($33,350) | $66,650 | ($33,350) | ($33,350) | $66,650 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($33,350) | ($33,350) | $66,650 | ($33,350) | ($33,350) | $66,650 | ($33,350) | ($33,350) | $66,650 | ($33,350) | ($33,350) | $66,650 | |
Net Profit/Sales | 0.00% | 0.00% | 66.65% | 0.00% | 0.00% | 66.65% | 0.00% | 0.00% | 66.65% | 0.00% | 0.00% | 66.65% |
Pro Forma Cash Flow | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $0 | $0 | $100,000 | $0 | $0 | $100,000 | $0 | $0 | $100,000 | $0 | $0 | $100,000 | |
Subtotal Cash from Operations | $0 | $0 | $100,000 | $0 | $0 | $100,000 | $0 | $0 | $100,000 | $0 | $0 | $100,000 | |
Additional Cash Received | |||||||||||||
Sales Tax, VAT, HST/GST Received | 0.00% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
New Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Other Liabilities (interest-free) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Investment Received | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $0 | $0 | $100,000 | $0 | $0 | $100,000 | $0 | $0 | $100,000 | $0 | $0 | $100,000 | |
Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Expenditures from Operations | |||||||||||||
Cash Spending | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | |
Bill Payments | $278 | $8,350 | $8,350 | $8,350 | $8,350 | $8,350 | $8,350 | $8,350 | $8,350 | $8,350 | $8,350 | $8,350 | |
Subtotal Spent on Operations | $25,278 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | |
Additional Cash Spent | |||||||||||||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Principal Repayment of Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Long-term Assets | $5,000,000 | $5,000,000 | $5,000,000 | $5,000,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $5,025,278 | $5,033,350 | $5,033,350 | $5,033,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | $33,350 | |
Net Cash Flow | ($5,025,278) | ($5,033,350) | ($4,933,350) | ($5,033,350) | ($33,350) | $66,650 | ($33,350) | ($33,350) | $66,650 | ($33,350) | ($33,350) | $66,650 | |
Cash Balance | $15,074,722 | $10,041,372 | $5,108,022 | $74,672 | $41,322 | $107,972 | $74,622 | $41,272 | $107,922 | $74,572 | $41,222 | $107,872 |
Pro Forma Balance Sheet | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $20,100,000 | $15,074,722 | $10,041,372 | $5,108,022 | $74,672 | $41,322 | $107,972 | $74,622 | $41,272 | $107,922 | $74,572 | $41,222 | $107,872 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $20,100,000 | $15,074,722 | $10,041,372 | $5,108,022 | $74,672 | $41,322 | $107,972 | $74,622 | $41,272 | $107,922 | $74,572 | $41,222 | $107,872 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $5,000,000 | $10,000,000 | $15,000,000 | $20,000,000 | $20,000,000 | $20,000,000 | $20,000,000 | $20,000,000 | $20,000,000 | $20,000,000 | $20,000,000 | $20,000,000 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $0 | $5,000,000 | $10,000,000 | $15,000,000 | $20,000,000 | $20,000,000 | $20,000,000 | $20,000,000 | $20,000,000 | $20,000,000 | $20,000,000 | $20,000,000 | $20,000,000 |
Total Assets | $20,100,000 | $20,074,722 | $20,041,372 | $20,108,022 | $20,074,672 | $20,041,322 | $20,107,972 | $20,074,622 | $20,041,272 | $20,107,922 | $20,074,572 | $20,041,222 | $20,107,872 |
Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Current Liabilities | |||||||||||||
Accounts Payable | $0 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $0 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 | $8,072 |
Paid-in Capital | $20,100,000 | $20,100,000 | $20,100,000 | $20,100,000 | $20,100,000 | $20,100,000 | $20,100,000 | $20,100,000 | $20,100,000 | $20,100,000 | $20,100,000 | $20,100,000 | $20,100,000 |
Retained Earnings | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Earnings | $0 | ($33,350) | ($66,700) | ($50) | ($33,400) | ($66,750) | ($100) | ($33,450) | ($66,800) | ($150) | ($33,500) | ($66,850) | ($200) |
Total Capital | $20,100,000 | $20,066,650 | $20,033,300 | $20,099,950 | $20,066,600 | $20,033,250 | $20,099,900 | $20,066,550 | $20,033,200 | $20,099,850 | $20,066,500 | $20,033,150 | $20,099,800 |
Total Liabilities and Capital | $20,100,000 | $20,074,722 | $20,041,372 | $20,108,022 | $20,074,672 | $20,041,322 | $20,107,972 | $20,074,622 | $20,041,272 | $20,107,922 | $20,074,572 | $20,041,222 | $20,107,872 |
Net Worth | $20,100,000 | $20,066,650 | $20,033,300 | $20,099,950 | $20,066,600 | $20,033,250 | $20,099,900 | $20,066,550 | $20,033,200 | $20,099,850 | $20,066,500 | $20,033,150 | $20,099,800 |
Fill-in-the-blanks and automatic financials make it easy.
No thanks, I prefer writing 40-page documents.
Discover the world’s #1 plan building software
How to balance business and personal investments as an entrepreneur.
Dr. Clemen Chiang is the CEO of Spiking .
When you launch a startup, you pour your time, energy and money into growing the business, sometimes at the expense of your personal financial health. Scaling a startup is an intense and arduous process, involving long hours, steadfast commitment and considerable risk.
You can easily become overextended in both directions when trying to balance the financial demands of your business and your home life. On the one hand, you need to build a substantial runway for your startup, ensuring that you have enough cash on hand to survive in the market until you establish a customer base. On the other hand, you still need to pay for your living expenses and support yourself and your family while you prepare for takeoff.
Many entrepreneurs fall into the common trap of caring for the needs of their shareholders, employees and customers but neglecting their own. In my own experience as an entrepreneur, I’ve always known that I must take care of my own finances first, before I can take care of my startup, and I encourage you to do the same. Invest in yourself in parallel with investing in your business—and you are likely to see positive returns in both areas of your life.
Investing hones your skills, much like a sparring partner in a boxing match. It challenges you, informs you and forces you to think critically about your financial decisions. If you’re like most entrepreneurs, you dream of ringing the New York Stock Exchange's opening bell to celebrate your company’s IPO. And what better way to understand what makes a strong publicly listed company than to become an investor in a portfolio of these companies?
Floyd mayweather jr. vs. john gotti iii results: winner and reaction, apple iphone 16 release date: new report hones in on precise date.
By thoroughly researching where to make your personal investments, you will be exposed to the best of the best companies in different sectors. You can learn from their products, marketing ideas and business strategies, knowing that they have already gone through the validation of the public markets. While you build a personal investment portfolio to give yourself a financial safety net, you will also be building knowledge that will help inform your own business decisions.
I recommend the following best practices to make investment decisions that are beneficial for you and your business.
Start by allocating a portion of your monthly income to an investment budget. Designate a time every month, such as when you do payroll for employees or pay your personal bills, to update your investment portfolio. Research market news and updates on sectors that interest you, and aim to sharpen your mind as an investor and make proactive decisions on what stocks to buy.
Ask questions that contribute to your ongoing learning and development; for example: What does it take to be a good publicly traded company? What qualities am I looking for in a stock to invest in? How can I apply these lessons to my own business?
Once you've established a monthly routine, experiment with making it a weekly or even daily habit. Start your morning with a cup of coffee and the financial news. Tune into CNBC or Bloomberg and listen to the latest stock market news. If an opportunity interests you, take out your phone and place the order.
For my father's and grandfather's generations, saving money was the main approach to preparing for the future. But for younger generations in the current climate, having a savings plan is not enough. Inflation is increasing, geopolitical conflicts are causing instability and the price of goods and services will continue to rise. You can't count on the interest rates of your savings account; you need to invest and start early to safeguard your financial future.
Anyone can save money in a bank account, but developing an investment strategy requires more financial and business savvy. Focus on extracting wisdom from every conscious investment decision you make. Why are you investing in one company over another? Are they solving a big pain point in the marketplace? How is my startup meeting customers' needs? Are we solving pain points in a similar way?
For new investors, I advocate for what I call “the COSY start,” which stands for cryptos, options, stocks and saying “yes” to investing. I’ve found that these investment instruments offer high liquidity, meaning they are easy to buy and sell, unlike illiquid assets, such as real estate, or complex investments, such as forex trading.
Once you’ve built a solid foundation for investing, you can foster ongoing growth as an investor by embarking on “the SALT journey”:
Your ultimate goal in investing should be to achieve lasting financial success, which I dub “the MONEY finish”:
As you grow your business and make strides toward realizing your dream of taking it public one day, think like an investor. Make sure that you are investing in your personal financial future as much as your company’s. Your future self—and your business—will thank you.
Forbes Business Council is the foremost growth and networking organization for business owners and leaders. Do I qualify?
IMAGES
COMMENTS
Learn what a business plan is, why it's important, and how to write one that appeals to potential lenders and investors. Find out the common elements of a standard business plan, such as executive summary, market analysis, financial projections, and more.
Financial forecasts. Investors will inevitably want to see your financial forecasts. You'll need a sales forecast, expense budget, cash flow forecast, profit and loss, and balance sheet. If you have historical results, you should plan on sharing those too as well as any other key metrics about your business.
Learn how to write a business plan that persuades investors to fund your company. Follow the 14-section guide with tips, examples, and resources from Bizplan.
9. Denim Business Plan Template. Create your Business Plan with this easy-to-edit template Edit and Download. Dress your business plan in the fabric of your trade with this denim business plan template. The classic denim texture and patterns capture the true essence of your brand and draw your audience's attention.
Learn how to create a business plan that attracts investors with eight essential sections, including executive summary, market research, product description, and financials. Find out what investors want to see and how to showcase your company's potential, competence, and competitive advantage.
Here are five compelling reasons to write a business plan: Attract Investors and Secure Funding: A well-written business plan demonstrates your venture's potential and profitability, making it easier to attract investors and secure the necessary funding for growth and development. It provides a detailed overview of your business model, target ...
You will essentially create two plans. The first is known as the internal or initial start-up business plan. This plan includes your company's mission statement, product/service description, marketing strategy plan and initial start-up goals. Most importantly, the initial plan will also include a market analysis.
1. Create Your Executive Summary. The executive summary is a snapshot of your business or a high-level overview of your business purposes and plans. Although the executive summary is the first section in your business plan, most people write it last. The length of the executive summary is not more than two pages.
Step 3: Customers. Olivia has done her research, which is the fundamentals upon which any business plan should be based. People love statistics. Olivia found statistics describing the growth in plant-based eating in the past decade, as well as the growth of flexitarian dietary choices.
Step 1: Research your industry. When it comes to writing a business plan, research is key. You need to have a clear understanding of your industry, your target market, and your competition. Entrepreneurs tend to focus on the "right format" for writing a business plan. However, there is no such thing as a right or wrong business plan format.
A good business plan guides you through each stage of starting and managing your business. You'll use your business plan as a roadmap for how to structure, run, and grow your new business. It's a way to think through the key elements of your business. Business plans can help you get funding or bring on new business partners.
A strong financial plan is critical to attracting investors. You'll need to provide financial projections, including: Profit and Loss statements (for at least three years) Cash flow projections (for at least three years) Balance sheets (for at least three years) Breakeven analysis. A list of assumptions and explanations for your financial ...
Step 3: Develop a Marketing and Sales Strategy. Outline your marketing and sales strategies, including how you plan to attract and retain customers. Detail the channels you will use, your sales ...
A business plan is an important document in the process of attracting potential investors. The company description section of a business plan should include information that is specific to the business so that investors can understand the business' purpose and gain insight into the direction it plans to take.
The primary purpose of a business plan is to convince banks and/or investors to loan you money, but there are several other benefits. Business plans help create accountability within an organization, offer a holistic view of the company, and can repeatedly be used as a frame of reference. Ultimately, a business plan mitigates risk.
The investor business plan sample is intended for businesses seeking to attract investment from angel investors, venture capitalists, or other private equity firms. This plan includes a pitch deck, financial projections, and a detailed analysis of the market opportunity. We like this sample plan because it emphasizes the potential return on ...
A business plan should outline the specifics of the company, state the company's competitive advantages, define short and long term goals, discuss any potential financial risks, provide a realistic description of the potential returns for investors, and outline an exit strategy. Creating a persuasive business plan is no easy feat.
2. Overestimating your valuation, future revenue or profit. As we alluded to earlier, investors will quickly know when a business is overvalued or your future revenue or profit projections seem too high. Don't exaggerate. Be honest about where you are now and how much your business could grow with an investor's help. 3.
Tips to help you win funding. Keep these tips in mind to help you win the funding you are searching for: 1. Spend extra time working on the executive summary. Because bankers and professional ...
11. Utilize Your Network. The best way to attract a potential investor's interest is to find someone to help make a warm introduction. Once you find that person, then provide them with an email ...
This sample plan was created for a hypothetical investment company that buys other companies as investments. In this sample, the hypothetical Venture Capital firm starts with $20 million as an initial investment fund. In its early months of existence, it invests $5 million each in four companies. It receives a management fee of two percent (2% ...
4. Proof you've polished your business idea until it shines. Compared to a one-page business plan, a 100-page business plan may be impressive. But that doesn't mean it's automatically better—or more likely to attract VC funding. Prime example: Dropbox founder Drew Houston's application to Y Combinator.
The first meeting is a dot. And a few months later, when he checks in on the progress of those entrepreneurs, that is another dot. By connecting those dots, he makes a line. If the line shows growth and momentum, that is attractive for him in the entrepreneur. But if the line connects dots that are similar to each other which means that there ...
In the new book "Write Your Own Business Plan," business expert Eric Butow takes the anxiety and confusion out of planning and offers an easy-to-follow roadmap to success. ... 500+ sample plans ...
As you grow your business and make strides toward realizing your dream of taking it public one day, think like an investor. Make sure that you are investing in your personal financial future as ...