Capital Formation Plan
James05
CapitalFormationPlan_TEMPLATE.xlsxFinancial Model
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Revenue Model | ||||||||||||
| Provide Details of Revenues | ||||||||||||
| Gross Revenue | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Cost of Goods | ||||||||||||
| Provide details | ||||||||||||
| Cost of Goods Sold | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Headcount | ||||||||||||
| Provide details | ||||||||||||
| Total Headcount | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| General & Administrative Expenses | ||||||||||||
| Provide details | ||||||||||||
| Total G&A Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Marketing Costs | ||||||||||||
| Provide details | ||||||||||||
| Marketing Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Gross Burn | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Net Burn | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Cummulative Net Burn | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Opening Cash Balance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Less: Monthly Net Burn | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Closing Cash Balance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Assignment Questions
| 1. How much funding do you need to operate during the first 12 months of operations? Please include your numeric answer and an explanation of several sentences. |
| Provide answers and calculations here as necessary |
| 2. What is your monthly cash burn rate - both gross and net burn? (Gross burn is the average of total expenses each month; net burn is gross burn offset by the average monthly cash generated from revenues). Please include your numeric answer and an explanation of several sentences. |
| Provide answers and calculations here as necessary |
| 3. How long will you be able to operate at the end of the 12 months forecast before you need additional funding? Please include your numeric answer and an explanation of several sentences. |
| Provide answers and calculations here as necessary |
