Question

1.) calculate the present value of annuity. Round answer to the nearest cent. $1800 monthly at 6.2% for 30 years. *NOTE: i keep getting 293,879.98 which is incorrect.

2.) since 2007, a particular fund returned 13.5% compounded monthly. How much would a $6000 investment in this phone have been worth after two years? Round your answer to the nearest cent.

3.) In the following ordinary annuity, the interest is compounded with each payment, and the payment is made at the end of the compounding.. Find the accumulated amount of the annuity. Round your answer to the nearest cent. $5500 annually at 5% for 10 years.

in the following ordinary annuity, the interest is compounded with each payment, and the payment is made at the end of the compounding. Period find the accumulated amount of the annuity. Round your answer to the nearest cent. $5500 annually at 5% for 10 years.

4.) in the following ordinary annuity, The interest is compounded with each payment, and the payment is made at the end of the compounding period. Find the required payment for the syncing phone. Round your answer to the nearest cent. Monthly deposits earning 6% to accumulate $2000 after 10 years.

5.) determine the payment to amortize The debt. Round your answer to the nearest cent. Quarterly payments on $18,500 at 3.5% for six years.

Answer 1

1. Calculate the Present value of annuity in excel as shown below -

Rate = Monthly Interest Rate, NPER = Total months, PMT = Monthly Payment, FV can be assumed as 0 in the excel formula used.

Formula used is shown below -

I hope above answer will help you in your task. As per policy, I have answered your first question, please upload remaining questions separately for answer.