Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions