F

Function: NPV; Formula: Add, Subtract; Cell Referencing usin Excel to Determine the Net Present Value PROBLEM Thunder Corporation, an amusement park, is considering a capital investment in a new exhibit. Amusement parks need to rotate exhibits to keep people interested. Additional information concerning the potential investment follows. Original cost ot investment Estimated sales value at end ot 5 years Expected increase In annual cash flows Estimated useful lite in years Borrowing rate Cost ot capital S136,ooo 60,000 25,000 5 10.0% years Student Work Area Required: Provide input into cells shaded in yellow in this template. Use the NPV function witn cell referencing to the Problem area in the input cell. Use a math formula in the field in which the cash flow tor the salvage value is expected to occur, and separately, to account tor the initial cash flow in the formula atter the function nas been in utted _l Calculate the net present value ot this project to the company using Excel's NPV function. Net present value