Build a spreadsheet like below for capital budgeting based o…
Build a spreadsheet like below for capital budgeting based on the following project. Hotel Biscayne recently invested in a project with a 3-year life span. The initial investment was $15,060 and annual cash inflows were $7,000 for year 1; $8,000 for year 2; and $9,000 for year 3. When the hotel expects a 4.5% interest/discount rate, What are NPV and Discounted Payback Period? Year FV r n (1+r)n PV 0 -$15,060 1 $7,000 2 3
Read Details