[SOLVED] CS Mission Beach

Mission Beach
2020A
2021E
2022E
2023E
sales growth k sales
0.075 PM g OI 0.02 NFE
CI
ATO NOA NFO
S/E
ReCI disc rate
sum PV begin S/E V
P
WaveJumper
sales growth k sales
0.06 PM g OI 0.03 NFE
CI
ATO NOA NFO
S/E ReOI disc rate
sum PV begin NOA Firm V begin NFO equity V
P
7,750 1,750 6,000
10,000 0.20 2000 175 1,825 1.25 8,000 1,750 6,250 1375 1.075
10,500 0.20 2100 175 1,925 1.25 8,400 1,750 6,650 1456.25 1.155625
11,000 0.20 2200 175 2,025 1.25 8,800 1,750 7,050 1526.25 1.242297 1228.571
2020A
200000
100,000 25,000 75,000
1608215 100,000 1708215 25000 1683215 8.416073
2022E
0.05 220,500 0.25 55125
2.00 110,250
48825 1.1236 43454.08
1760141 1.191016 1477849
1279.07 1260.141
28305 1.242297 22784.41
26552.19 6,000 32552.19 32.55219
2021E
0.05 210,000 0.25 52500
2.00 105,000
46500 1.06 43867.92
2023E
0.05 231,525 0.25 57881.25
2.00 115,763
51266.25 1.191016 43044.13