Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please use excel if you deposit $5,000 in a sa

Please use excel If you deposit $5,000 in a savings account that pays 8% annual interest compounded monthly, and...

80.2K

Verified Solution

Question

Finance

Please use excel

If you deposit $5,000 in a savings account that pays 8% annualinterest compounded
monthly,and make no other deposits to the account, how much will youhave
after 5years?
$7,449.23
In addition to the $5,000 as specified in the above problem, howmuch will you
have atthe end of 5 years if you also deposit an additional $200 at theend of
eachmonth for the entire 5 year period?
In addition to the $5,000 as specified in above problem #4, howmuch will you
have atthe end of 5 years if you also deposit an additional $200 at thebeginning
of eachmonth for the entire 5 year period?

Answer & Explanation Solved by verified expert
3.8 Ratings (399 Votes)
1Future value present value 1 rnwhere r interest rate per periodand n number of periodsHere the r monthly rater annual rate 12 8 12n total number of monthly periodsn number of years 12 5 12Future value 7449232The accumulated    See Answer
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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Please use excelIf you deposit $5,000 in a savings account that pays 8% annualinterest compoundedmonthly,and make no other deposits to the account, how much will youhaveafter 5years?$7,449.23In addition to the $5,000 as specified in the above problem, howmuch will youhave atthe end of 5 years if you also deposit an additional $200 at theend ofeachmonth for the entire 5 year period?In addition to the $5,000 as specified in above problem #4, howmuch will youhave atthe end of 5 years if you also deposit an additional $200 at thebeginningof eachmonth for the entire 5 year period?

Other questions asked by students

Q

A health psychologist conducted an experiment in which participants watched a film that either did or...

Basic Math
Q

On February 8, 2018, Holly purchased a residential apartment building. The cost basis assigned to the...

Accounting
Q

Jenna drives on average 46 miles per day with a standard deviation of 5.3 miles...

Basic Math
Q

Use implicit differentiation to find y' and then evaluate y' at the point (3,5).y -...

Basic Math
Q

If a Type II error is made what conclusion will be drawn regarding the mean...

Statistics
Q

please help Current Attempt in Progress On June 10, Sheridan...

Accounting
Q

\table[[Budgeted Costs,$EZ Print LTD. produces and sells printing products across Canada. Last...

Accounting
Q

How do you calculate: Sales budget, schedules of expected cash flows, Production budget, Materials budget,...

Accounting
Q

Kindly help me with those financial accounting and reporting homework questions..... Question one (35...

Accounting
Q

On March 15, Monroe Sales sells $9,525 on account to Garrison Brewer with terms of...

Accounting
Q

Amy transfers property with a tax basis of $1,155 and a fair market value of...

Accounting
Q

thank you CSU ACT 221 Fall 2022 Practice Set A COMPREHENSIVE ACCOUNTING CYCLE...

Accounting