Finance
posted by Lacey .
Mary needs $9000 in 7 years. What amount can she deposit at the end of each quarter at 6% interest compounded quarterly so she will have her $9000?

Part I:
As a financial planner a client comes to you for investment advice. After meeting with him and understanding his needs, you offer him the following two investment options:
Option 1 (refer to section on Mathematics of Finance in your text.): Invest $23,000 in a savings account at 4.25% interest compounded quarterly.
Option 2 (refer to section on Mathematics of Finance in your text): Invest into an ordinary annuity where $5,000 is deposited each year into an account that earns 6.6% interest compounded annually.
SPREADSHEET:
Set up the formula for compound interest for Option 1 and the formula for Future Value of an Annuity for Option 2 in an Excel spreadsheet to calculate the amount earned at the end of 5 years. 
what is the future value of $500 in a bank account for 10 years at 10% percent compounded bimonthly
Respond to this Question
Similar Questions

Finance
You deposit a single amount of $50,000 in a savings account that pays 7.6% annual interest (compounded quarterly). How much will you have at the end of four and a half years? 
math
How much money must you deposit now at 6% interest compounded quarterly in order to be able to withdraw $5000 at the end of each quarter for five years? 
Math
How much must you deposit in an account that pays 6% semiannual interest, compounded annually, to have a balance of $9000 in 15 years? 
Math
How much must you deposit in an account that pays 6% semiannual interest, compounded annually, to have a balance of $9000 in 15 years? 
MATH HELP PLEASE
$9000 invested at an APR of 9% for five years. In interest is compounded annually, what Ia the amount of money after 5 years? 
Finance
Bob Bryan made deposits of $10,000 at the end of each quarter to Lion Bank, which pays 8% interest compounded quarterly. After 9 years, Bob made no more deposits. What will be the account's balance 4 years after the last deposit? 
Math
A person wants to establish an annuity for retirement purposes. He wants to make quarterly deposits for 20 years so that he can then make quarterly withdrawals of $5,000 for 10 years. The annuity earns 7.32% interest compounded quarterly. … 
Math
Young and Company owes bond holders $5,500 interest at the end of each quarter for the next five years. How much they deposit now at 8% interest compounded quarterly to yield an annuity payment of $5,500? 
Mathematics and investment
1. Angelo wants to renovate his house in 3 years. He estimates the cost 300,000. How much must Angelo invest now at 8% compounded quarterly in order to have 300,000 3 years from now. 2. Angelo Ancis want to save 500,000 in 5.5 years … 
finite math
Sam wants to invest the same amount at the end of every 3 months so that he will have 4000 in 3 years. The account will pay 6% compounded quarterly. How much should he deposit each quarter.