Please show work using Excel. a. Sixteen years ago...

70.2K

Verified Solution

Question

Finance

Please show work using Excel.
image
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 parent:s 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-600 compounded continuously, how much did your parents initially deposit? e. Sixteen years ago your deposited $200,000 in your saving account, today the balance of this account is $260,000. Calculate the annual rate of return earned on this account

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students