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 = $7.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 = $37,750,000

First year net profits for:

Fun-rides = ($146,518)

Hotel = ($597,750)

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 11

Net present value of $ 18,613,704

Internal rate of return = 15.3%