Question

In: Finance

Assume an investment costing $24,869 will earn $10,000 a year for ten years. If the discount...

Assume an investment costing $24,869 will earn $10,000 a year for ten years. If the discount rate is 15%, what is the NPV of this project?

Show this in excel with the formulas for excel shown. the formulas must be shown

Solutions

Expert Solution

Ans $ 25318.69

Year Project Cash Flows (i) DF@ 15% DF@ 15% (ii) PV of Project A ( (i) * (ii) )
0 -24869 1 1                    (24,869.00)
1 10000 1/((1+15%)^1) 0.870                       8,695.65
2 10000 1/((1+15%)^2) 0.756                       7,561.44
3 10000 1/((1+15%)^3) 0.658                       6,575.16
4 10000 1/((1+15%)^4) 0.572                       5,717.53
5 10000 1/((1+15%)^5) 0.497                       4,971.77
6 10000 1/((1+15%)^6) 0.432                       4,323.28
7 10000 1/((1+15%)^7) 0.376                       3,759.37
8 10000 1/((1+15%)^8) 0.327                       3,269.02
9 10000 1/((1+15%)^9) 0.284                       2,842.62
10 10000 1/((1+15%)^10) 0.247                       2,471.85
NPV                     25,318.69

Related Solutions

What is the lump sum value today for a financial instrument that would pay me $10,000 per year for ten years assuming a discount rate of:
What is the lump sum value today for a financial instrument that would pay me $10,000 per year for ten years assuming a discount rate of:a. 6 percentb. 12 percent
- Assume you are considering an investment costing $10,000, for which the future cash flows from...
- Assume you are considering an investment costing $10,000, for which the future cash flows from owning the security depend on the state of the economy as estimated in this table. In any given year the, the investment could produce any one of three possible cash flows, depending on the particular state of the economy. Given this information calculate: Expected Cash Flow Expected rate of return State of the economy Probability of the states Cash flow from the investment %...
Assume you are planning to invest $5,558 each year for six years and will earn 7...
Assume you are planning to invest $5,558 each year for six years and will earn 7 percent per year. Determine the future value of this annuity due problem if your first $5,558 is invested now. (Round answer to 2 decimal places, e.g., 1,220.25.)
An investment offers €10,000 per year for 15 years, with the first payment occurring one year...
An investment offers €10,000 per year for 15 years, with the first payment occurring one year from now. If the required return is 10 per cent, a) What is the value of the investment? b) What would the value be if the payments occurred for 50 years? c) For ever?
Investment A offers to pay you $10,000 per year for 10 years while Investment B offers...
Investment A offers to pay you $10,000 per year for 10 years while Investment B offers to pay you $15,000 per year for 6 years. a. If the annual interest rate (compounded annually) is 10%, which investment is more valuable? b. Does your answer change if the annual interest rate (compounded annually) is 5%? c. At what interest rate are the two investments equally attractive?
Johnston Corp has 10,000 bonds outstanding that were issued for 30 years ten years ago at...
Johnston Corp has 10,000 bonds outstanding that were issued for 30 years ten years ago at a par value of RM1,000.00 and a 12% coupon rate with interest being paid semiannually. Similar bonds are now selling to yield 9%. It issued 40,000 shares of 6% preferred stock with par value of RM100.00 eight years ago. These preferred stocks are now selling to yield 10%. There are currently 2,500,000 of common stocks outstanding, selling for RM11.60 per share. Johnston Corp expects...
Kiran is 22 today and his superannuation account contains exactly $10,000. Assume this balance will earn...
Kiran is 22 today and his superannuation account contains exactly $10,000. Assume this balance will earn an average return rate of 6% p.a. compounding semi-annually until his retirement at age 65. Calculate the investment returns (in dollars) this sum will earn in the final year before retirement.
An investment is expected to earn you $1,000 eachquarter for the next 13 years. If...
An investment is expected to earn you $1,000 each quarter for the next 13 years. If the appropriate discount rate is 8.0%, how much is this investment worth today? Round to the nearest cent.
Assume the free cash flows of an investment, with a 13% discount rate, are $100 in...
Assume the free cash flows of an investment, with a 13% discount rate, are $100 in year 1, $120 in year 2. $150 in year 3, and will grow 3% in perpetuity after year 3. (show work)
Assume that you pay $10,000 to receive $2,000 per year in years 1 through 5. $3,000...
Assume that you pay $10,000 to receive $2,000 per year in years 1 through 5. $3,000 per years in years 6 through 8, and $4,000 in year 9, with cash flows to be received at the end of the year. If you require a 14% rate of return, what is the NPV of these cash flows? PLEASE EXPLAIN HOW TO DO THIS WITH A FINANCIAL CALCULATOR NOT THE FORMULA Step by step. Please give small details that you may think...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT