finance report very important to have a good knowledge in finance

profileffff2019
financeNPVgoodone.xlsx
Home>Business & Finance homework help>Accounting homework help>finance report very important to have a good knowledge in finance

Sheet1

1-
if 20pound visitors Probability Visi.*Prob. if 30 pound visitors Probability Visi.*Prob.
10,200 0.25 2550 9300 0.25 2325
6000 0.4 2400 5400 0.4 2160
12,900 0.35 4515 12600 0.35 4410
Total monthly visitors 9465 Total monthly visitors 8895
Total visitors in year *12 113580 Total visitors in year *12 106740
Revenue cost ( if cost is 20) 2271600 Revenue cost ( if cost is 30) 3202200
Operating cash Flow (O.C.F) 30 pound Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
Price for ticket 30 31.5 33.075 34.72875 36.4651875 38.288446875 40.2028692188 the price is increasig 5%
Refreshments and Souvenirs 5 5 5 5 5 5 5 fixed
Total price 35 36.5 38.075 39.72875 41.4651875 43.288446875 45.2028692188
Total visitors in year (fiixed) 106740 106740 106740 106740 106740 106740 106740 the visitors is fixed as mentioned in the main question
maintence cost 3000000 3060000 3121200 3183624 3247296.48 3312242.4096 3378487.257792 is increasing 2% every year
Total Revenue 3735900 3896010 4064125.5 4240646.775 4425994.11375 4620608.8194375 4824954.26040938
Operating Cash flow 735900 836010 942925.5 1057022.775 1178697.63375 1308366.4098375 1446467.00261738
Capital Allowance Written down Value 25% reducing balance Allowance
Year 0
Year 1
Year 2 1000000 0.25 250000 depreciation from Year 2
Year 3 750000 0.25 187500
Year 4 562500 0.25 140625
Year 5 421875 0.25 105468.75
Year 6 316406.25 0.25 79101.5625
Year 7
Total year 1-6 762695.3125
Initial outlay 1000000
Scap Value 100000
Value consumed over 7 years 900000
Sum of Corporate Allowance 762695.3125
Capital Allowance 137304.6875
Tax liabilities Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8
O.C.F 735900 836010 942925.5 1057022.775 1178697.63375 1308366.4098375 1446467.00261738
Capital allowance 250000 187500 140625 105468.75 79101.5625 137304.6875
Tax profit 735900 586010 755425.5 916397.775 1073228.88375 1229264.8473375 1309162.31511738
tax paid (30%) 220770 175803 226627.65 274919.3325 321968.665125 368779.45420125 392748.694535213
Calculate NPV Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8
Visitors 106740 106740 106740 106740 106740 106740 106740
Entry Fees 30 31.5 33.075 34.72875 36.4651875 38.288446875 40.2028692188
Refreshments and Souvenirs 5 5 5 5 5 5 5
profit from selling the project in year 8 8000000
total Revenue 3735900 3896010 4064125.5 4240646.775 4425994.11375 4620608.8194375 4824954.26040938
Maintance cost 3000000 3060000 3121200 3183624 3247296.48 3312242.4096 3378487.257792
Opportunity Cost -500000 Opportunity cost 2M-1.5M= 500000
scrap Value
O.C.F 735900 836010 942925.5 1057022.775 1178697.63375 1308366.4098375 1446467.00261738 8000000 I THOUGH THEY CAN get 8million as cash in year 8 by selling the project
Tax Liability -220770 -175803 -226627.65 -274919.3325 -321968.665125 -368779.45420125 -392748.694535213 I CHANGED IT -NEGATIVE VALUE AS ITS TAX AND WE PAY IT SO THAT’S WHY IS NEGATIVE
Initial Investment
constraction cost -4000000
Net cash flow -4500000 735900 615240 767122.5 830395.125 903778.30125 986397.744712501 1077687.54841613 7607251.30546479
Discount Factors 8% 1 0.926 0.857 0.794 0.735 0.681 0.63 0.583 0.54
present Value -4500000 681443.4 527260.68 609095.265 610340.416875 615473.02315125 621430.579168876 628291.840726601 4107915.70495099
Net Present value 3901250.90987271
positive NPV