A company plans the construction of a winter-themed family amusement park in Alberta. The project details...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company plans the construction of a winter-themed family amusement park in Alberta. The project details are as follows: . $1,000,000 in year 1 and $1,500,000 in year 2 for construction. $500,000 in year 3, increasing at a rate of 4.5% per year in years 4 to 10 as operating and maintenance costs. e $20,000 in each of years 1 and 2, and $40,000 in each of years 3 to 10 for advertising. . 25,000 tourists will visit the park in each of years 3 and 4, after which the number of tourists is expected to increase at a rate of 5% per year. Initially the price of entrance will be $34 for year 3, increasing at a rate of 3.5% in years 4 to 10. . The opportunity cost is 10%. ● 2 I (a) Construct a table containing the outflows, the inflows, the net cash flow, and the discounted cash flows for years 1 to 10 for the Winter Park project. (b) Calculate the NPV and the IRR in year 10 and decide if the project is profitable. (c) What is the maximum discount rate for which this project should be undertaken? (d) Calculate the cash balances and the interest-based cash balances. For both columns, highlight the maximum amount tied in the project during the ten years. (e) What is the payback period? What is the interest-based payback period? What do they repre- sent? The investors want to know what changes could make the project profitable, other than financ- ing and want to use some sensitivity analysis to understand this. determine the NPV and the IRR for changes (f) in initial ticket price of -15%, -10%, -5%, 0%, 5%, 10 %, 15%, and 20%. Use a discount rate of 10%. Is the project profitable at any of these changes? (g) Using a Data Table command with actual values determine the NPV and the IRR for changes in initial number of tourists of -15%, -10%, -5%, 0%, 5%, 10%, 15%, and 20%. Use a discount rate of 10%. Is the project profitable at any of these changes? (h) An investor, who has studied economics, is concerned that if the price of a ticket increases then the number of tourists will decrease, so instead, maybe they should decrease the ticket price so the number of tourists will increase. Using a two-way Data Table command, determine the NPV for changes in both the initial ticket price and the number of tourists. Do this for the IRR as well (you need to do two, two-way tables). Use the changes of -15% to 20%, increasing by 5%, along with the discount rate of 10%. Use conditional formatting to represent the investor's concerns/idea (outside of scenarios where both ticket price and number of tourists are decreasing). What would your analysis of this project tell you about the demand curve that would be needed, the elasticity, for this to be profitable? A company plans the construction of a winter-themed family amusement park in Alberta. The project details are as follows: . $1,000,000 in year 1 and $1,500,000 in year 2 for construction. $500,000 in year 3, increasing at a rate of 4.5% per year in years 4 to 10 as operating and maintenance costs. e $20,000 in each of years 1 and 2, and $40,000 in each of years 3 to 10 for advertising. . 25,000 tourists will visit the park in each of years 3 and 4, after which the number of tourists is expected to increase at a rate of 5% per year. Initially the price of entrance will be $34 for year 3, increasing at a rate of 3.5% in years 4 to 10. . The opportunity cost is 10%. ● 2 I (a) Construct a table containing the outflows, the inflows, the net cash flow, and the discounted cash flows for years 1 to 10 for the Winter Park project. (b) Calculate the NPV and the IRR in year 10 and decide if the project is profitable. (c) What is the maximum discount rate for which this project should be undertaken? (d) Calculate the cash balances and the interest-based cash balances. For both columns, highlight the maximum amount tied in the project during the ten years. (e) What is the payback period? What is the interest-based payback period? What do they repre- sent? The investors want to know what changes could make the project profitable, other than financ- ing and want to use some sensitivity analysis to understand this. determine the NPV and the IRR for changes (f) in initial ticket price of -15%, -10%, -5%, 0%, 5%, 10 %, 15%, and 20%. Use a discount rate of 10%. Is the project profitable at any of these changes? (g) Using a Data Table command with actual values determine the NPV and the IRR for changes in initial number of tourists of -15%, -10%, -5%, 0%, 5%, 10%, 15%, and 20%. Use a discount rate of 10%. Is the project profitable at any of these changes? (h) An investor, who has studied economics, is concerned that if the price of a ticket increases then the number of tourists will decrease, so instead, maybe they should decrease the ticket price so the number of tourists will increase. Using a two-way Data Table command, determine the NPV for changes in both the initial ticket price and the number of tourists. Do this for the IRR as well (you need to do two, two-way tables). Use the changes of -15% to 20%, increasing by 5%, along with the discount rate of 10%. Use conditional formatting to represent the investor's concerns/idea (outside of scenarios where both ticket price and number of tourists are decreasing). What would your analysis of this project tell you about the demand curve that would be needed, the elasticity, for this to be profitable?
Expert Answer:
Answer rating: 100% (QA)
To analyze the Winter Park project we will calculate the outflows inflows net cash flow discounted cash flows NPV IRR maximum discount rate cash balances payback period and perform sensitivity analysi... View the full answer
Related Book For
Modern Advanced Accounting In Canada
ISBN: 9781259066481
7th Edition
Authors: Hilton Murray, Herauf Darrell
Posted Date:
Students also viewed these economics questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
On January 1, 2018, Rastall Co. signed a long-term finance lease for an office building. The terms of the lease required Rastall to pay $30,000 annually, beginning December 31, 2018, and continuing...
-
Determine the largest mass of cylinder A that can be supported from the drum if a force P is applied to the handle of the lever. The coefficient of static friction between the belt and the wheel is...
-
The Acme Super light bulb is known to have a useful life described by the density function f (t) = .01e.01t, Where time t is measured in hours (a) Find the failure rate of this bulb (see Exercise...
-
List the problems with life-cycle assessment. Explain which level of management is appropriate for addressing each of these problems.
-
Jerry Young is thinking about opening a bicycle shop in his hometown. Jerry loves to take his own bike on 50-mile trips with his friends, but he believes that any small business should be started...
-
Based on the following data, determine the total assets, total liabilities, net worth, total cash inflows, and total cash outflows. Balance Sheet and Cash Flow Items Rent for the month Cash in...
-
An army division in Iraq has five troop encampments in the desert, and the division leaders want to determine the best location for a supply depot to serve the camps. The (x, y) coordinates (in...
-
Company XXX is looking to raise long-term funding to expand its manufacturing facility. What are the advantages and disadvantages compared to XXX Corporation issuing common stock and borrowing money...
-
You are the beneficiary of a trust fund that will start paying you cash flows in five years. The cash flows will be $21,172 per year, and there will be a total of 43 yearly cash flows paid. If the...
-
Examine the relationship between economic inequality and social justice. How do different theoretical frameworks explain the persistence of income and wealth disparities across generations ?
-
Explore the applications of advanced water quality modeling tools, such as multi-species reactive transport models and coupled hydrodynamic-biogeochemical models, in assessing the fate and transport...
-
Pharoah Company sponsors a defined benefit pension plan for its employees. The following data relate to the operation of the plan for the years 2025 and 2026. 2025 2026 Projected benefit obligation,...
-
Microeconomics students must present a real-world company or other entity to analyze from a Microeconomics perspective. Grading Rubric : in three equal parts (too short Presentations will have...
-
In a December 1, 2013, interview on the American television program 60 Minutes, Amazon CEO Jeff Bezos announced that Amazon would soon change the future of online shopping by enabling customers to...
-
What are the typical record-at-a-time operations for accessing a file? Which of these depend on the current file record?
-
List the types of intercompany revenue and expenses that are eliminated in the preparation of a consolidated income statement , and indicate the effect that each-elimination has on the amount of net...
-
In what manner does the balance-sheet format used by companies in other countries differ from the format used by Canadian companies?
-
On January 1, Year 2, PAT Ltd. acquired 90% of SAT Inc. when SATs retained earnings were $900,000. There was no acquisition differential. PAT accounts for its investment under the cost method. SAT...
-
In the 2016 Olympic Games, Michael Phelps won five gold medals in swimming. Following are the events he won, along with his margin of victory, in seconds. a. What was the mean margin of victory? b....
-
The following table presents the number of monthly users for the 15 most popular mobile apps as of June 2015. a. Find the mean number of monthly users. b. Find the median number of monthly users. c....
-
The following table presents the number of monthly users for the 15 most popular Facebook applications as of November 2015. a. Find the mean number of monthly users. b. Find the median number of...
Study smarter with the SolutionInn App