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)
ANSWER To solve this problem well go through each part step by step a Constructing the table for cash flows Year Outflows Inflows Net Cash Flow Discou... 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...
-
On February 15, 2012, Rooker, Madras & Associates compiled the following information concerning inventory for five years. They used the dollar-value LIFO retail inventory method. Compute the...
-
Coca-Cola is an extremely popular soft drink consumed all over the world. Therefore, probably someone, somewhere, is drinking a Coke right this minute. The following arguments are inductive....
-
Kronenberger Burgoyne, LLP, was a law firm with two equity partners who agreed to equal ownership as of 2009. Before 2009, Kronenberger had owned a majority interest in the firm, and when, in 2011,...
-
Perdue Company purchased equipment on April 1, 2012, for $270,000. The equipment was expected to have a useful life of three years, or 18,000 operating hours, and a residual value of $9,000. The...
-
Complete the table for the point (2, 2). f(x) (2, 2) f(2x) 6f(2x) 6f(2(x+1))- -3
-
The Ploughman family owns and operates a 640-acre farm that has been in the family for several generations. The Ploughmans always have had to work hard to make a decent living from the farm and have...
-
Which of the following systems are invertible? If invertible, find the inverse system. Otherwise, explain why you think a system is not invertible: a) y(t) = r(t 2), b) y(t) = . z(7)dr, c) yln] =...
-
Stock A's stock has a beta of 1.30, and its required return is 16.00%. Stock B's beta is 0.80. If the risk-free rate is 4.75%, what is the required rate of return on B's stock? ( Hint: First find the...
-
A new insurance company in your market has approached your practice with a contract. They are offering to pay your providers a percentage of charges. What other information would you want to know...
-
Company A is a Heating company and company B is an Air Conditioning Company. explain why it makes sense to merge both the companies?
-
Katherine's explanation about why company executives are getting bonuses could be considered?
-
Question: in essay format: Companies use numerous efforts and techniques to market products. As a sales manager, you are asked to create pressure using an artificial urgent timeframe to boost company...
-
The Social Security Administration documented the marriage year of various couples, along with the number of children they had. Use the table given below to answer the following. One (1) Two (2)...
-
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...
-
Portugal has a progressive personal income tax system. In 2016, tax rates on taxable income were \(14.5 \%\) on the first \( 7,035,21 \%\) on the next \( 13,065,37 \%\) on the next \( 20,100,45 \%\)...
-
In its 2016 International Tax Competitiveness Index report, the U.S.-based Tax Foundation ranked Estonia as having the most competitive tax system in the OECD, based in part on its \(20 \%\) flat tax...
-
A lump-sum tax is a fixed amount of tax per person. If a lump-sum tax, \(T\), raises the same amount of revenue for the government as a tax on earnings at the rate, \(t\), then \(t w H=T\), where...
Study smarter with the SolutionInn App