0% found this document useful (0 votes)
6 views6 pages

2023-2027 Financial Projections Summary

Uploaded by

ishrutikumari30
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
6 views6 pages

2023-2027 Financial Projections Summary

Uploaded by

ishrutikumari30
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

2023 2024 2025 2026

Figures in USD Unit Year 1 Year 2 Year 3 Year 4


Income Statement
Revenue $ 69,900 139,800 244,650 366,975
Cost of Goods Sold
Manufacturing $ 16,000 32,000 56,000 84,000
Order Fulfillment $ 4,500 9,000 15,750 23,625
Total COGS $ 20,500 41,000 71,750 107,625

Gross Profit $ 49,400 98,800 172,900 259,350


Gross Profit Margin % 71% 71% 71% 71%

Operating Expenses
Warehouse Rent $ 20,000 20,000 30,000 30,000
Salaries & Payroll $ 50,000 50,000 100,000 100,000
Marketing $ 25,000 25,000 50,000 100,000
Other $ 5,000 5,000 5,000 5,000
Total Operating Expenses $ 100,000 100,000 185,000 235,000

Operating Profit $ (50,600) (1,200) (12,100) 24,350


Operating Profit Margin % -72% -1% -5% 7%

Tax $ NA NA NA 6,088
Profit / (Loss) $ (50,600) (1,200) (12,100) 18,263

Live case
Revenue
Number of Orders # 2,000 4,000 7,000 10,500
Order Growth Rate % 100% 75% 50%
Average Order Value $ 34.95 34.95 34.95 34.95

Cost of Goods Sold (per order)


Manufacturing $ 8.00 8.00 8.00 8.00
Order Fulfillment $ 2.25 2.25 2.25 2.25

Operating Expenses
Warehouse Rent $ 20,000 20,000 30,000 30,000
Salaries & Payroll $ 50,000 50,000 100,000 100,000
Marketing $ 25,000 25,000 50,000 100,000
Other $ 5,000 5,000 5,000 5,000

Corporate Tax Rate % 25% 25% 25% 25%

Upper case (Scenario 1)


Revenue
Number of Orders # 3,000 6,000 10,500 15,750
Order Growth Rate % 100% 75% 50%
Average Order Value $ 39.95 39.95 39.95 39.95

Cost of Goods Sold (per order)


Manufacturing $ 6.50 6.50 6.50 6.50
Order Fulfillment $ 2.25 2.25 2.25 2.25

Operating Expenses
Warehouse Rent $ 20,000 20,000 30,000 30,000
Salaries & Payroll $ 50,000 50,000 100,000 100,000
Marketing $ 25,000 25,000 50,000 100,000
Other $ 5,000 5,000 5,000 5,000

Corporate Tax Rate % 20% 20% 20% 20%


2027
Year 5
scenario 2
495,416

113,400
31,894
145,294

350,123
71%

30,000
100,000
100,000
5,000
235,000

115,123
23%

28,781
86,342

14,175
35%
34.95

8.00
2.25

30,000
100,000
100,000
5,000

25%

Lower case (Scenario 2)


Revenue
21,263 Number of Orders # 2,000 4,000 7,000 10,500
35% Order Growth Rate % 100% 75% 50%
39.95 Average Order Value $ 34.95 34.95 34.95 34.95

Cost of Goods Sold (per order)


6.50 Manufacturing $ 8.00 8.00 8.00 8.00
2.25 Order Fulfillment $ 2.25 2.25 2.25 2.25

Operating Expenses
30,000 Warehouse Rent $ 20,000 20,000 30,000 30,000
100,000 Salaries & Payroll $ 50,000 50,000 100,000 100,000
100,000 Marketing $ 25,000 25,000 50,000 100,000
5,000 Other $ 5,000 5,000 5,000 5,000

20% Corporate Tax Rate % 25% 25% 25% 25%


14,175
35%
34.95

8.00
2.25

30,000
100,000
100,000
5,000

25%

You might also like