Liberation Sans 12 A A 2 Wrap Text Custom Paste BIU + A Merge & Center $ % 90000 Clipboard 12 Alignment Number 10 A E Font Xfx 136000 B C 17 Conditional Format as Cell Formatting Insert Delete Format Table Styles Styles Cells D E F G H J K M N 0 P Q Function: NPV; Formula: Add, Subtract; Cell Referencing Using Excel to Determine the Net Present Value PROBLEM 5 Thunder Corporation, an amusement park, is considering a 5 capital investment in a new exhibit. Amusement parks need to 7 rotate exhibits to keep people interested. Additional information 8 concerning the potential investment follows. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use the NPV function with mathematical formulas and cell referencing to the Problem area in the input cells. 6 10 Original cost of investment $136.000 11 Estimated sales value at end of 5 years 60.000 12 Expected increase in annual cash flows 25.000 13 Estimated useful life in years 5 years 14 Borrowing rate 15 Cost of capital 8.0% 10.0% 16 17 18 19 20 21 22 24 Enter Answer + Calculate the net present value of this project to the company using Excel's NPV function. Net present value Fel Ready Accessibility: Investigate B ms of how far the signal will travel (thus requiring investing in more towers) and what it will travel through. By contrast, if a company chooses the low-band spectrum, its signal will trave uch at stake, these decisions have huge implications. pig question that nobody has answered yet is why will customers be willing to pay more for 5G than for 4G? Use of 5G will require consumers to purchase new phones-not a trivial perse mpanies might not get the payback they need for their huge investments. In the meantime, 6G technology, which will be 10 times faster than 5G, is already being designed. This additional s fely. Sources:Sarah Krouse, "U.S. Telecom Giants Take Different Paths to 5G," Wall Street Journal (April 12, 2020); and RiverDavis, "Forget 5G for a Moment. Instead, Imagine 6G," Wall Street Journal (April 12, 2020). Why is the capital investment in 5G technology particularly risky for telecom carriers? Answer sing a Discount Rate