Answered step by step
Verified Expert Solution
Question
1 Approved Answer
$1,000.00 $ 50.00 BS 4 S 50,00 50.00 9 10 11 12 13 14 15 16 17 18 19 20 Years 10 Initial Deposit Monthly
$1,000.00 $ 50.00 BS 4 S 50,00 50.00 9 10 11 12 13 14 15 16 17 18 19 20 Years 10 Initial Deposit Monthly Deposit Total $50.00 $1,000.00 Enter all of the deposits ($1000 and a whole bunch of $50s) made to Tommy and Gina's account over 10 years in column A. Then add all of those values using SUM. Hint: You should not have to type 50 a bunch of times. Use copy and paste or auto-fill. Think carefully about how many times $50 should be listed. Write the formula in F2 that will allow you to enter the years and monthly deposit and calculate the total deposits made to the account. (This does not take interest into account. We will Iconsider that later.) Here's a big hint: If you type 10, 1000, or 50 into your formula, it won't work correctly
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started