Question

In: Finance

Using Excel. What is the present value of the following series of cash payments: $8,000 per...

Using Excel. What is the present value of the following series of cash payments: $8,000 per year for four consecutive years starting one year from today, followed by annual cash payments that increase by 2% per year in perpetuity (i.e. cash payment in year 5 is $8,000*1.02, cash payment in year 6 is $8,000*1.022, etc.)? Assume the appropriate discount rate is 5%/year.

Solutions

Expert Solution

Growing Perptuity is a series of payments that occurs periodically which continues to grow indefinitely at a specified rate.

Hence PV is a geometric series, PV = [D/(1+r)] + [D(1+g)/(1+r)^2] + ....

On simplifying the formula for PV, we get

PV = D / (1+r) - (1+g)

where, D is the dividend per year

r = discount rate

g = growth rate

PV = 8000 / (1+0.05) - (1+0.02)

= 8000/0.03

=266,666.666


Related Solutions

Determine the present value of the following series of payments: • $ 4,000 at the end...
Determine the present value of the following series of payments: • $ 4,000 at the end of each month for 8 years at 9% compounded monthly. Step # 1: Graph the situation Step # 2: Equation with Factor nomenclature. Step # 3: Replacement of factors and mathematical solution of the problem.
Question 1: What is the present value (PV) of the following series of cash flows at...
Question 1: What is the present value (PV) of the following series of cash flows at 10% and its IRR? Year 0: -2,000$ | Year 1: +800$ | Year 2: +600$ | Year 3: +700$ | Year 4: +500$ Question 2: Draw a present value (PV) profile of the following project and determine the IRR(s). Is the project acceptable at 10% cost of capital? Year 0: -4,000$ | Year 1: +10,200$ | Year 2: -6,300$ Observation: if you find cumbersome...
Time Value of Money Complete the following exercise using MS Excel. Using the Present Value and...
Time Value of Money Complete the following exercise using MS Excel. Using the Present Value and Future Value Equations 4. If you invested $200 at 5%, how much would it be worth in 30 years? 5. How many years does it take to double your money if it is invested at 6%? 6. If you invest $10,000 in a 20 year annuity paying 5%, what would be the annual payment made to you? 7. If you have a student loan...
Using excel, determine: The present value of a five (5) year project, with expected annual cash...
Using excel, determine: The present value of a five (5) year project, with expected annual cash flows given below, assuming the cost of capital of 12.5% p.a.                                                                (1 Mark) Year Cash flow 1 75,600.00 2 58,800.00 3 50,400.00 4 42,000.00 5 36,500.00 ii. The future value of $ 12,200 received annually over a period of four (4) years, interest paid quarterly at the rate of 14% p.a.                                    
What is the present value of the following cash flows if I can earn 5% per...
What is the present value of the following cash flows if I can earn 5% per year: T                      CF 0                      -5 million 1                      2 million 2                      2 million 3                      2 million 4                      2 million 5                      0 6                      0 7                      -3 million 8                      -3 million 9                      0 10                    10 million 11                    8 million *Please post any calculations done by calculator or any formulas used*
1. Find the present value of a series of quarterly payments of P950 each, the first...
1. Find the present value of a series of quarterly payments of P950 each, the first payment is due at the end of 2 years and 3 months and the last at the end of 5 years and 6 months. If the money is worth 15% compounded quarterly. 2. Find the monthly payment for 36 periods to discharge an obligation of P88000 if the money is worth 12%, m=12 and the first payment is due at the end of 1...
Find the net present value (NPV) for the following series of future cash flows, assuming the...
Find the net present value (NPV) for the following series of future cash flows, assuming the company’s cost of capital is 6.64 percent. The initial outlay is $339,858. Year 1: 163,676 Year 2: 147,656 Year 3: 123,800 Year 4: 178,407 Year 5: 149,077 Round the answer to two decimal places.
1) What is the Present Value using a discount rate of 8% given the following cash...
1) What is the Present Value using a discount rate of 8% given the following cash flows?             Year 1:            40,000             Year 2:            42,000             Year 3:            44,000             Year 4:            45,000             Year 5:            37,000             And, a sale occurs at the end of year 5 at a price of $425,000. 2) Same facts as #1. Would you pay the asking price of $502,000 ? Yes or no for NPV being positive or negative. 3) Same facts as...
What is the value of an annual equivalent series for this cash flow using an interest...
What is the value of an annual equivalent series for this cash flow using an interest rate of 7%?      Years; 1,2 = $325, years 3,4= $275, years 5, 6 = $185?
Consider the following two cash flow series of payments: Series A is a geometric series increasing...
Consider the following two cash flow series of payments: Series A is a geometric series increasing at a rate of 4% per year. The initial cash payment at the end of year 1 is $1,000. The payments occur annually for 5 years. Series B is a uniform series with payments of value X occurring annually at the end of years 1 through 5. You must make the payments in either Series A or Series B. Click here to access the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT