Problem Mary and Joe Case (excel Solution)

               

                                                                                                                                                                                                                                                                                                                   

                

Mary just deposited $33,000 in an account paying 7% interest. She plans to leave the money in this account for eight years. How much will she have in the account at the end of the seventh year?

                

Mary and Joe would like to save up $10,000 by the end of three years from now to buy new furniture for their home. They currently have $1500 in a savings account set aside for the furniture. They would like to make equal year end deposits to this savings account to pay for the furniture when they purchase it three years from now. Assuming that this account pays 6% interest, how much should the year end payments be?