Question

In: Finance

Louise receives a series of annual payments that start at $1,000 and decrease by $100 each...

Louise receives a series of annual payments that start at $1,000 and decrease by $100 each year

down to $100, then increase again by $100 each year back up to $1,000 and then the payments

stop. Assume that payments begin immediately and that the annual effective interest rate is

i

= 9%

.

Determine the present value of this series of payments.

Please help! I am really stuck. Thank you!

Solutions

Expert Solution

NPV Formula in excel= =NPV(rate, 900,800,700,....1000) +1000

Year0 Year1 Year2 Year3 Year4 Year5 Year6 Year7 Year8 Year9 Year10 Year11 Year12 Year13 Year14 Year15 Year16 Year17 Year18
          1,000            900            800            700            600            500            400            300            200            100            200            300            400            500            600            700            800            900         1,000
RATE 9%
npv     5,837.84

Related Solutions

A. In a series of semi-annual payments of P14465 each, the first payment is due at...
A. In a series of semi-annual payments of P14465 each, the first payment is due at the beginning of 5 years and the last at the end of 12 years and 6 months. If money is worth 11% compounded semi-annually, find the present value of the deferred annuity. B. The cost of equipment is P582277 and the cost of installation is P27253, if the salvage value is 10% of the cost of the equipment at the end of 8 years...
Consider the following scenario to determine the future value of the payments. Annual payments of 100...
Consider the following scenario to determine the future value of the payments. Annual payments of 100 are made for 5 years at an effective rate of r, followed by annual payments of 200 for the next 3 years at the same rate. Set up three different equation of values for this situation.
Karen has to make rental payments of $1,000 at the start of every month, throughout the...
Karen has to make rental payments of $1,000 at the start of every month, throughout the four year duration of her university course. Her University fees are $4,000 to be paid at the start of each year. She earns $1,500 per month (paid at the end of each month) from a part time job. Assume an interest rate of 8% p.a. and that she keeps the part time job for the next four years. How much money, in present value...
William has to make rental payments of $1,000 at the start of every month, throughout the...
William has to make rental payments of $1,000 at the start of every month, throughout the four-year duration of his university course. His university fees are $4,000 to be paid at the start of each year. He earns $1,500 per month (paid at the end of each month) from a part-time job. Assume an interest rate of 8% p.a. and that he keeps the part-time job for the next four years. How much money, in present value terms, can he...
A loan is to be repaid in end of quarter payments of $1,000 each, with there...
A loan is to be repaid in end of quarter payments of $1,000 each, with there being 20 end of quarter payments total. The interest rate for the first two years is 6% convertible quarterly, and the interest rate for the last three years is 8% convertible quarterly. Find the outstanding loan balance right after the 6th payment.
An investment promises to make $100 annual payments forever. If the annual interest rate is 7%,...
An investment promises to make $100 annual payments forever. If the annual interest rate is 7%, then what is the value of this investment today? Round your answer to 2 decimal places.
a 20-years annuity-immediate has annual payments . The first payment is 100 and subsequent payments are...
a 20-years annuity-immediate has annual payments . The first payment is 100 and subsequent payments are increased by 100 until they reach 1000. The remaining payment stay at 1000. the annual effective intersst rate 7.5% . What is the coast of this annuity?
A $1,000 bond with annual coupon payments at 9% of par has an expected return of...
A $1,000 bond with annual coupon payments at 9% of par has an expected return of 11% over the life of the bond, compute the value of the bond at these times to maturity 12, 8, 5, 2 years ( and how do i enter this information into an online bond yield to maturity calculator)
A bond that makes annual payments is initially selling at $1,000. It has a 6% coupon...
A bond that makes annual payments is initially selling at $1,000. It has a 6% coupon rate and 6% YTM. The maturity is 10 years and face value is $1,000. If the YTM falls to 5%, what is the percentage change in the price? Enter as a whole percentage to two decimals with no symbols (e.g if the change is 9.52% enter 9.52). Numeric Response
A loan is being repaid with 20 payments of $ 1,000 at the end of each...
A loan is being repaid with 20 payments of $ 1,000 at the end of each quarter. Given that the nominal rate of interest is 8% per year compounded quarterly, find the outstanding balance of the loan immediately after 10 payments have been made (a) by the prospective method, (b) by the retrospective method.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT