Question

In: Economics

1) You invest $50,000 now and receive $10,000 per year for 15 years starting at the...

1) You invest $50,000 now and receive $10,000 per year for 15 years starting at the end of the first year. What is the payback period in whole number years for this investment? In other words, in what year do you break even on this investment? Use i = 9% annual rate compounded annually, and use the discounted payback approach (not Simple Payback).

Solutions

Expert Solution

Req: Payback period:

Initial Investment: $ 50,000

Annual cash inflows: $ 10,000

Pay back period : Initial Investment / Annual cash inflows = $ 50,000 / $10,000 = 5 years

Req : Discounted Payback period = 6.94 years

The explanation is as follows

YEAR CASHFLOW PVF @ 9% PRESENT VALUE CUMULATIVE Present value
1 10,000.00 0.917 9174.31 9174.31
2 10,000.00 0.842 8416.80 17591.11
3 10,000.00 0.772 7721.83 25312.95
4 10,000.00 0.708 7084.25 32397.20
5 10,000.00 0.650 6499.31 38896.51
6 10,000.00 0.596 5962.67 44859.19
7 10,000.00 0.547 5470.34 50329.53
8 10,000.00 0.502 5018.66 55348.19
9 10,000.00 0.460 4604.28 59952.47
10 10,000.00 0.422 4224.11 64176.58
11 10,000.00 0.388 3875.33 68051.91
12 10,000.00 0.356 3555.35 71607.25
13 10,000.00 0.326 3261.79 74869.04
14 10,000.00 0.299 2992.46 77861.50
15 10,000.00 0.275 2745.38 80606.88
Discounted payback period : 6 years + (50,000 -44859.19) /5470.34
(6 years + 0.94 year) = 6.94 years

Related Solutions

You invest $50,000 now and receive $10,000 per year for 15 years starting at the end...
You invest $50,000 now and receive $10,000 per year for 15 years starting at the end of the first year. What is the discounted payback period? Use i = 9% annual rate compounded annually. Give the discounted payback period between two consecutive integers.
You are investing for retirement starting at age 25. You invest $10,000 per year. During years...
You are investing for retirement starting at age 25. You invest $10,000 per year. During years 1-30 your investments earn 15% per year.   During years 31-40 you move to more conservative estimates earning 5% per year. How much will you have saved when you retire at age 65?   Assume investments occur at the beginning of each year. What is the IRR of this investment stream? (answer is IRR=11.9%) In excel functions
32. You just won a contest! You will receive $50,000 a year for 30 years, starting...
32. You just won a contest! You will receive $50,000 a year for 30 years, starting today. If you can earn 10 percent on your investments, what are your winnings worth today? A. $150,000.00 B. $333,333.33 C. $436,510.50 D. $450,000.00 E. $518,480.30 33. A local magazine is offering a $10,000 grand prize to one lucky winner. The prize will be paid in five annual payments of $2,000 each, starting one year after the drawing. How much would this prize be...
You just won a contest! You will receive $50,000 a year for 30 years, starting today....
You just won a contest! You will receive $50,000 a year for 30 years, starting today. If you can earn 10 percent on your investments, what are your winnings worth today?    A.  $150,000.00 B.  $333,333.33 C.  $436,510.50 D.  $450,000.00 E.  $518,480.30
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...
question 1 "You invest $4,600 now and receive $2,000 at the end of year 1, $1,800...
question 1 "You invest $4,600 now and receive $2,000 at the end of year 1, $1,800 at the end of year 2, $1,600 at the end of year 3, and so on. In what year do you break even on your investment? Use the discounted payback approach and assume an annual interest rate of 4.2%, compounded annually. Enter your answer as an integer."
Suppose you are going to receive $10,000 per year for 6 years. The appropriate interest rate...
Suppose you are going to receive $10,000 per year for 6 years. The appropriate interest rate is 11 percent.    a. What is the present value of the payments if they are in the form of an ordinary annuity?       b. What is the present value if the payments are an annuity due?
1) You receive $10,000 now for an investment that will give you cash flows of $1000...
1) You receive $10,000 now for an investment that will give you cash flows of $1000 in one year, $2000 in two years, $3000 in three years, and $4000 in four years. If the discount rate is 5% then what is the PV of this investment? (Enter the answer in dollar format without $ sign or thousands comma -> 3519.23 and not $3,519.23 or 3,519.23)
How much money do you need to invest now, to have $50,000 in 10 years?  Assume an...
How much money do you need to invest now, to have $50,000 in 10 years?  Assume an APR of 4.5%.
You are promised $10,000 a year for six years after which you will receive $5,000 a...
You are promised $10,000 a year for six years after which you will receive $5,000 a year for six years. If you can earn 8 percent annually, what is the present value of this stream of payments? Show how to solve in Excel, Step-By-Step
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT