Net Present Value Synco_Solutions Only

copy_of_wildbill_1.xlsx

2007 Analysis

Documentation: The purpose of this model is to calculate the NPV of investing in Wild Bill's Adventure.
Inputs:
Upfront Investment	30,000,000
Annual Fixed Costs	5,000,000
Annual Inflation Fixed Costs	3%
Number of Vistors per Years
D 2009	1,000
D 2010	1,100
D 2011	1,200
D 2012	1,300
D 2013	1,400
D 2014	1,500
D 2015	1,525
D 2016	1,550
D 2017	1,575
D 2018	1,600
D 2019	1,625
Variable Cost	35,000
Price Per Vist	45,000
Discount Rate	15%
Formula/Output:		Year	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019
		Demand			1,000	1,100	1,200	1,300	1,400	1,500	1,525	1,550	1,575	1,600	1,625
		Revenue			45,000,000	49,500,000	54,000,000	58,500,000	63,000,000	67,500,000	68,625,000	69,750,000	70,875,000	72,000,000	73,125,000
		Initial Investment		30,000,000
		Fixed Costs			5,000,000	5,150,000	5,304,500	5,463,635	5,627,544	5,796,370	5,970,261	6,149,369	6,333,850	6,523,866	6,719,582
		Variable Costs			35,000,000	38,500,000	42,000,000	45,500,000	49,000,000	52,500,000	53,375,000	54,250,000	55,125,000	56,000,000	56,875,000
		Total Costs		30,000,000	40,000,000	43,650,000	47,304,500	50,963,635	54,627,544	58,296,370	59,345,261	60,399,369	61,458,850	62,523,866	63,594,582
		CashFlow		(30,000,000)	5,000,000	5,850,000	6,695,500	7,536,365	8,372,456	9,203,630	9,279,739	9,350,631	9,416,150	9,476,134	9,530,418
		NPV	$9,237,028

Documentation: The purpose of this model is to calculate the NPV of investing in Wild Bill's Adventure.
Inputs:
Upfront Investment	30,000,000
Annual Fixed Costs	5,000,000
Annual Inflation Fixed Costs	3%
Number of Vistors per Years
D 2009	625
D 2010	600
D 2011	610
D 2012	735
D 2013	895
D 2014	1,000
D 2015	1,025
D 2016	1,050
D 2017	1,075
D 2018	1,100
D 2019	1,125
Variable Cost	35,000
Price Per Vist	45,000
Discount Rate	15%
Formula/Output:		Year	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019
		Demand			625	600	610	735	895	1,000	1,025	1,050	1,075	1,100	1,125
		Revenue			28,125,000	27,000,000	27,450,000	33,075,000	40,275,000	45,000,000	46,125,000	47,250,000	48,375,000	49,500,000	50,625,000
		Initial Investment		30,000,000
		Fixed Costs			5,000,000	5,150,000	5,304,500	5,463,635	5,627,544	5,796,370	5,970,261	6,149,369	6,333,850	6,523,866	6,719,582
		Variable Costs			21,875,000	21,000,000	21,350,000	25,725,000	31,325,000	35,000,000	35,875,000	36,750,000	37,625,000	38,500,000	39,375,000
		Total Costs		30,000,000	26,875,000	26,150,000	26,654,500	31,188,635	36,952,544	40,796,370	41,845,261	42,899,369	43,958,850	45,023,866	46,094,582
		CashFlow		(30,000,000)	1,250,000	850,000	795,500	1,886,365	3,322,456	4,203,630	4,279,739	4,350,631	4,416,150	4,476,134	4,530,418
		NPV	($16,832,838)

Assignment: Update the 2008 model with 2013 information
Documentation: The purpose of this model is to calculate the NPV of investing in Wild Bill's Adventure.
Inputs:
Upfront Investment	30,000,000
Annual Fixed Costs	5,000,000
Annual Inflation Fixed Costs	3%
Number of Vistors per Years
D 2009	625
D 2010	600
D 2011	610
D 2012	735
D 2013	895
D 2014	1,000
D 2015	1,025
D 2016	1,050
D 2017	1,075
D 2018	1,100
D 2019	1,125
Variable Cost	35,000
Price Per Vist	45,000
Discount Rate	17%
Formula/Output:		Year	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019
		Demand			625	600	610	735	895	1,000	1,025	1,050	1,075	1,100	1,125
		Revenue			28,125,000	27,000,000	27,450,000	33,075,000	40,275,000	45,000,000	46,125,000	47,250,000	48,375,000	49,500,000	50,625,000
		Initial Investment		30,000,000
		Fixed Costs			5,000,000	5,150,000	5,304,500	5,463,635	5,627,544	5,796,370	5,970,261	6,149,369	6,333,850	6,523,866	6,719,582
		Variable Costs			21,875,000	21,000,000	21,350,000	25,725,000	31,325,000	35,000,000	35,875,000	36,750,000	37,625,000	38,500,000	39,375,000
		Total Costs		30,000,000	26,875,000	26,150,000	26,654,500	31,188,635	36,952,544	40,796,370	41,845,261	42,899,369	43,958,850	45,023,866	46,094,582
		CashFlow		(30,000,000)	1,250,000	850,000	795,500	1,886,365	3,322,456	4,203,630	4,279,739	4,350,631	4,416,150	4,476,134	4,530,418
		NPV	($18,176,561)