Question: My question is: How do I do this on excel? WHat is the function and how do I set it up? Jessica has an insurance
My question is: How do I do this on excel? WHat is the function and how do I set it up?
Jessica has an insurance policy that will pay her an annual annuity of $450 at the end of each year for a total of 10 consecutive years. However, the terms of the policy are such that the annuity's first payment will not be made until the end of year 3. Determine the present value of Jessica's policy if the interest rate is 3%. Answer is 3618.24 Place your answer in dollars and cents. DO NOT USE A DOLLAR SIGN OR A COMMA IN YOUR ANSWER. Work your analysis using at least four decimal places of accuracy. Feedback: While many annuities begin at the end of the first period, others begin at some point in time beyond the first period. In situations such as these, the number of time periods that the annuity makes zero payment must be taken into account. There are many ways to take this into account. Break the problem into two steps: find the PV of the annuity as if it started at the end of year 1, and then make the starting period adjustment. The starting period adjustment is to divide that answer by (1+r) taken to the power equal to the number of years that the annuity pays nothing. For example, suppose a ten-year $100 annuity makes its first payment at the end of year 4. If the interest rate is 5.75%, then the present value of the annuity will be: PVA = $100 (PVIFA 5.75%, 10 years) / (1.0575) to the power of 3 PVA = 744.81 / 1.1826 PVA = $629.80
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
