TKI Manufacture Five-Year Pro Forma Financials
Account | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
---|---|---|---|---|---|
Revenue | $7,500,000 | $11,250,000 | $15,000,000 | $16,875,000 | $18,562,500 |
Nanocellulose Revenue | $250,000 | $1,000,000 | $4,000,000 | $7,000,000 | $12,000,000 |
Extractions Revenue | $7,000,000 | $8,500,000 | $9,500,000 | $10,500,000 | $11,000,000 |
Outsourcing Revenue | $250,000 | $1,750,000 | $1,500,000 | $2,375,000 | $3,000,000 |
Cost of Goods Sold (COGS) | $3,250,000 | $5,250,000 | $7,500,000 | $8,437,500 | $9,281,250 |
Gross Margin | $4,250,000 | $6,000,000 | $7,500,000 | $8,437,500 | $9,281,250 |
Operating Expenses | |||||
Research & Development (R&D) | $150,000 | $500,000 | $1,000,000 | $1,500,000 | $1,500,000 |
Sales & Marketing | $100,000 | $400,000 | $900,000 | $1,200,000 | $1,200,000 |
General & Administrative | $600,000 | $700,000 | $1,000,000 | $1,500,000 | $1,700,000 |
Total Operating Expenses | $850,000 | $1,600,000 | $2,900,000 | $4,200,000 | $4,400,000 |
EBIT (Earnings Before Interest & Taxes) | $3,400,000 | $4,400,000 | $4,600,000 | $4,237,500 | $3,281,250 |
Interest Income | $0 | $50,000 | $150,000 | $300,000 | $500,000 |
Interest Expense | $0 | $0 | $0 | $0 | $0 |
Profit Before Tax (PBT) | $3,400,000 | $4,450,000 | $4,750,000 | $4,537,500 | $3,781,250 |
Income Tax | $0 | $150,000 | $1,000,000 | $1,500,000 | $2,000,000 |
Net Profit (Loss) | $3,400,000 | $4,300,000 | $3,750,000 | $3,037,500 | $3,381,250 |