You purchased land 3 years ago for $84000 and believe its market value is now $93000. You are considering building a hotel on this land instead of selling it. To build the hotel, it will initially cost you $128000, an expense that you plan to depreciate straight line over the next three years. Wells Fargo offered you a loan for $60,000 at an 8% interest rate to be repaid over the next 4 years. You anticipate that the hotel will earn revenues of $240000 each year, while expenses will be a mere $163405 each year. The initial working capital requirement will be $23000 which will be recovered in the last year. The tax rate is 32%. Your estimated cost of capital is 9%. What is the net present value of this project?

Cost 84,000
Market value 93,000
Hotel investment 128,000
Depreciation 3 years
Loan 60,000
Interest rate 8%
Payment 4 years
revenues 240,000
Expenses 163,405
Working capital 23,000
Tax rate 32%
Cost of capital 9%

1. Estimate yearly payment for the loan
Use the present value approach - that is the $60,000 should be equal
to the present value fo 4 payments at 8%
You can compute using trial and error OR Goal ...

Solution Summary

The following posting helps calculate net present value. The answers are given in an Excel spreadsheet.

Calculating Net Value Present and IRR. ... Use the formula and the financial calculator or Excel... payback period and project acceptance are calculated and discussed. ...

... use Excel function IRR to calculate IRR. ... it takes into account book values Therefore, it ... capital budgeting problem and calculates Net present value, payback, IRR ...

... The easiest way to calculate NPV is to use the ...value today (Year 0). The formula in excel calculates the NPV ... How to calculate the value of an item with a known ...

... 2. Using mathmatical formula and calculating present value and net... (6) Income tax is calculated at 40%. 7) You can calculate Present values of different cash ...

... Solution describes the steps in calculating NPV of ... We will calculate Present Value of Each Cash flow for ... the help of above formula Net present Value is sum of ...

Calculate payback period, discount rate, NPV, IRR for 3 ... projects is 10.5%, What is the Net Present Value for each ... Please see the attached file in Excel 97-2003 ...

... in Chapter 10, except for the following questions.) a. Calculate the store's net present value, using an ... d. Calculate the store's profitability index ...

... You can solve problems manually, use Excel or a financial calculator. ... a step-by-step solution to how to calculate NPV (net present value), IRR (internal ...