Question

You deposit $100 each month into an account earning 3% interest compounded monthly a) How much will you have in the account in 20 years? 1) b) How much total money will you put into the account? 1) arī T) c) How much total interest will you earn? an Get hetlp Video Video Points availiable on this attempe: 0.9 of original 1 Unlimized actempeS Score on last actempt 0.0.0), Score in gracebookc (0, Q.O1 Out of (0. 33 0.33,0.34) Submit
0 1
Add a comment Improve this question Transcribed image text
Answer #1

As question is silent whether deposit are made in beginning of month or end of month. Hence, calculation are made for both. Generally, deposit are made in beginning of month.

Please refer below spreadsheet for calculation and answer.C9 xFV(C5,C3,-C2,,1) Monthly deposit No. of month Interest rate Monthly Interest rate 100.00 240 3% 0.0025 4 Deposit in beginning of month Deposit at end of month Account Balance in 20 year $32,912.28 $32,830.20 10 11 b 12 13 c Monev put in Account 24,000.00 $ 24,000.00 Interest earned $8,912.28 $8,830.20

formula reference

C9 XFV(C5,C3,-C2,,1) Monthly deposit No. of month Interest rate Monthly Interest rate 100 -20 12 0.03 C4/12 4 Deposit in beginning of month Deposit at end of month Account Balance in 20 year FV(C5,C3,-C2,,1) FV(C5,C3,-C2,,0 11 b 12 13 C Monev put in Account -C2 C3 -C2 C3 Interest earned -C9-C11 D9-D11 15

Add a comment
Know the answer?
Add Answer to:
You deposit $100 each month into an account earning 3% interest compounded monthly a) How much...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT