Check Figures for the Decision Support Homework

In addition to the figures given in the assignment, set the other input data cells to include:

Number of fun-rides = 4

Hourly pay rate = $5.25

Number of hotel rooms = 100

Number of carts = 10

Number of restaurants = 6

Number of clubs = 4

Number of days open (Hotel) = 365

(Restaurants) = 365

(Clubs) = 310

Your Excel spreadsheet should then produce the following results:

Total construction costs = $34,150,000

First year net profits for:

Fun-rides = ($131,338)

Hotel = ($1,090,500)

Shops = $217,123

Restaurants = $2,874,375

Clubs = $2,046,000

When you have completed the “Financial Analysis” sheet (sheet 3) you should produce the following additional results if you use a discounting factor of 10%:

Payback in year 9

Net present value of $31,663,409

Internal rate of return = 20.0%