ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Great Scooter Company
2
Interest Rate8%
3
Margin Rate49.6%
4
5
Project Phase
YearCostUnit Sales
Net Revenue
Free Cash Flow
Net Cash Flow
Cash Flow
Discount Factor
PVs
6
Pre Launch1 $ (35,000.00)0 $ - $ (35,000.00) $ - $ (35,000.00)0.9259259259 $ (32,407.41)
7
Pre Launch2 $ (40,000.00)0 $ - $ (40,000.00) $ - $ (40,000.00)0.8573388203 $ (34,293.55)
8
Post Launch3 $ (10,290.00)50 $ 29,400.00 $ 19,110.00 $ 14,582.40 $ 4,292.40 0.793832241 $ 3,407.45
9
Post Launch4 $ (26,460.00)150 $ 88,200.00 $ 61,740.00 $ 43,747.20 $ 17,287.20 0.7350298528 $ 12,706.61
10
Post Launch5 $ (35,280.00)200 $ 117,600.00 $ 82,320.00 $ 58,329.60 $ 23,049.60 0.680583197 $ 15,687.17
11
Post Launch6 $ (44,100.00)250 $ 147,000.00 $ 102,900.00 $ 72,912.00 $ 28,812.00 0.6301696269 $ 18,156.45
12
Post Launch7 $ (44,100.00)250 $ 147,000.00 $ 102,900.00 $ 72,912.00 $ 28,812.00 0.5834903953 $ 16,811.53
13
 $ 262,483.20 $ 27,253.20 $ 68.24
14
NPV $174,761.14
15
16
17
18
Net Price $ 588.0 Total Cash Flow $ 27,253.20
19
Net Margin $ 291.6
Total Ne Revenue
 $ 529,200.00
20
COGS $ 296.4 Net Profit5.15%
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100