Question: PLEASE WORK QUESTIONS IN EXCEL, IN EXCEL , IN EXCEL!!!!!!!!!! 1. Bonus a. Sixteen years ago, your parents opened a saving account in your name

PLEASE WORK QUESTIONS IN EXCEL, IN EXCEL , IN EXCEL!!!!!!!!!!
PLEASE WORK QUESTIONS IN EXCEL, IN EXCEL , IN EXCEL!!!!!!!!!! 1. Bonus

1. Bonus a. Sixteen years ago, your parents opened a saving account in your name and made a lump sum deposit, today the balance of this account is $260,000. If the account has been earning 6% compounded annually, how much did your parents initially deposit? b. Sixteen years ago, your parents deposited an amount in your saving account earing 6% annually, today the balance of this account is $260,000. If the account is expected to continue earning 6% annually, what will the balance be in 5 years? c. Sixteen years ago, your parents deposited an amount in your saving account, today the balance of this account is $260,000. If the account has been earning 6% compounded monthly, how much did your parents initially deposit? d. Sixteen years ago, your parents deposited an amount in your saving account, today the balance of this account is $260,000. If the account has been earning 6% compounded continuously, how much did your parents initially deposit? Referring to (a), what was the balance in your saving account three years ago? (Assume annual compounding)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!