Project model with ratios
Project Co
Break Even Month
13
14
EBITDA
Net Income
EBITDA % Margin to Net Revenue
30
27.9
Operational Cash Flow¹
12.4
Year 1
Year 2
27.2
Return on Investment
34.9
Year 3
Year 4
38.4
7.6%
Year 5
¹Cumulative
Gross Revenue / Net Income
Margin
28.5%
31.4%
²Monthly Average
³Million
Res. Value = Ending Net Worth
Disccount Rate = 5,375% pa
2 300
Receivables
Operational Payments
Fixed Assets
Operational Cash Flow
20.9%
183
7.6%
10 966
Gross Revenue
Services
Other
7 554
-29.5%
1 013
2 300
Year 1
Year 2
4 500
(150)
(471)
(93) (115) (171) (32) (236) (59)
(7)
(36)
Year 1
CoGS
Royalties
Depn&Amort
Marketing
Logistics&Delivery
Interest
Year 2
Year 3
Year 4
Personnel
Credit Cards
Taxes
Year 5
25 475
Year
Year 3
Selected Financial Ratios
Current Ratio
Quick Ratio
Year 4
Year 5
Year 1
Year 2
Year 3
Year 4
Year 5
Year 1
Year 2
Year 3
Year 4
Year 5
0.7
1.1
3.3
4.1
5.5
0.1
0.1
2.1
3.2
4.5
Gross Profit Margin to Net Revenue
59.6%
67.0%
67.2%
67.3%
67.5%
EBITA Profit Margin to Net Revenue
27.9%
12.4%
27.2%
34.9%
38.4%
O/Heads to Sales
87.5%
54.6%
40.0%
32.4%
29.1%
Net Profit Margin to Net Revenue
30.0%
7.7%
21.3%
28.9%
31.9%
Return on Assets
82.4%
49.4%
77.1%
73.4%
71.0%
Return on Equity
na
151.6%
109.0%
96.4%
86.7%
Days in Accounts Receivable
13.5
13.8
13.7
13.8
13.8
Inventory Turnover
9.2
9.1
9.2
9.2
9.2
$142.5
$251.7
$402.9
$572.4
$720.1
Revenue Per Employee - K
Net Present Value³
Cumulative Operational Cash Flow -$K
Profitability by Year $000
(748)
$10.1
Internal Return Rate²
14 810
7 480
6 371
3 159
3 009
938
741
(488)
(306)