Question

What is the future value of a 5-year annuity due with annual payments of $1,855, evaluated...

What is the future value of a 5-year annuity due with annual payments of $1,855, evaluated at a 5.69 percent interest rate?

Please include excel formulas.

Homework Answers

Answer #1

Ans:- In this question, we need to find the FV of an annuity due. we will use the FV function of excel to find the answer.

Rate = 5.69%, Nper = 5, Pmt = -$1855, PV = 0, TYPE = 1

Therefore FV of the annuity due in 5 years will be $10,983.60.

Note:- If we need to find the FV of ordinary annuity we put (TYPE = 0) and (TYPE = 1) in case of an annuity due.

Note:- If this answer helps you pls give thumbs up.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
What is the present value of a 8-year ordinary annuity with annual payments of $479, evaluated...
What is the present value of a 8-year ordinary annuity with annual payments of $479, evaluated at a 16 percent interest rate? Round it to two decimal places, i.e., 1234.45.
What is the present value of an annuity due consisting of 5 annual payments of $4,000...
What is the present value of an annuity due consisting of 5 annual payments of $4,000 with an interest rate of 9% p.a. $16,959 $16,006   $19,558 $18,765 None of the above
Future Value: Ordinary Annuity versus Annuity Due What is the future value of a 7%, 5-year...
Future Value: Ordinary Annuity versus Annuity Due What is the future value of a 7%, 5-year ordinary annuity that pays $650 each year? Do not round intermediate calculations. Round your answer to the nearest cent. $   If this were an annuity due, what would its future value be? Do not round intermediate calculations. Round your answer to the nearest cent. $  
Future value: annuity versus annuity due What's the future value of a 8%, 5-year ordinary annuity...
Future value: annuity versus annuity due What's the future value of a 8%, 5-year ordinary annuity that pays $600 each year? Round your answer to the nearest cent. If this was an annuity due, what would its future value be? Round your answer to the nearest cent.
3. What is the present value of a 5-year ordinary annuity with annual payments of $200,...
3. What is the present value of a 5-year ordinary annuity with annual payments of $200, evaluated at a 10%? a. $ 670.44 b. $ 758.16 c. $1,121.70 d. $1,470.21 e. $1,500.00
11. What is the present value of a 10-year annuity with annual payments of 50 and...
11. What is the present value of a 10-year annuity with annual payments of 50 and an interest rate of 5? a. Do this with your calculator, indicating what number you put in each button. b. Do this in Excel, using the annuity formula. 12. What is the present value of a cash flow of 1000 being paid in 10 years with an interest rate of 5%? 13. What is the sum of the calculations in (11) and (12)? What...
An annuity-immediate has 20 annual payments starting at 5 and increasing by 10 every year. The...
An annuity-immediate has 20 annual payments starting at 5 and increasing by 10 every year. The annual effective rate of interest is 7%. Calculate the present value of this annuity. not a excel solution
15.a Calculate the FV of (a) an ordinary annuity and (b) an annuity due with payments...
15.a Calculate the FV of (a) an ordinary annuity and (b) an annuity due with payments of $2,000 at the interest rate of 12% per year. (a) $(                     ); (b) $(                            ) 15.b Calculate the PV of (a) an ordinary annuity and (b) the annuity due with 5 payments of $2,000 at the interest rate of 12%. (a) $(                       ); (b) $(                      ) (Please hand write and show all steps of the solution no Excel no typing I need to...
Find the present value of a 20-year annuity with annual payments which pays $600 today and...
Find the present value of a 20-year annuity with annual payments which pays $600 today and each subsequent payment is 5% greater than the preceding payment. The annual effective rate of interest is 10.25%. Answer: 7851.19 Please show which equations you used and please do not use excel to answer this question.
For the following annuity​ due, determine the nominal annual rate of interest. Future Value Present Value...
For the following annuity​ due, determine the nominal annual rate of interest. Future Value Present Value Periodic Rent Payment Period Term Conversion Period ​$6,818 – ​$490 1 year 9 years monthly