In: Accounting
Brief Exercise A-5 Andrew and Emma Garfield invested $6,000 in a savings account paying 4% annual interest when their daughter, Angela, was born. They also deposited $1,000 on each of her birthdays until she was 18 (including her 18th birthday). Click here to view the factor table. (For calculation purposes, use 5 decimal places as displayed in the factor table provided.) How much was in the savings account on her 18th birthday (after the last deposit)? (Round answer to 2 decimal places, e.g. 25.25.) Amount on 18th birthday $
Birthday | Beginning Balance | Interest Earned | Additional Deposit | Ending Balance | |||||
a | b=a*4% | c | d=a+b+c | ||||||
0 | 0 | 0 | $ 6,000.00 | $ 6,000.00 | |||||
1 | $ 6,000.00 | 240.00 | 1,000.00 | 7,240.00 | |||||
2 | $ 7,240.00 | 289.60 | 1,000.00 | 8,529.60 | |||||
3 | $ 8,529.60 | 341.18 | 1,000.00 | 9,870.78 | |||||
4 | $ 9,870.78 | 394.83 | 1,000.00 | 11,265.62 | |||||
5 | $ 11,265.62 | 450.62 | 1,000.00 | 12,716.24 | |||||
6 | $ 12,716.24 | 508.65 | 1,000.00 | 14,224.89 | |||||
7 | $ 14,224.89 | 569.00 | 1,000.00 | 15,793.89 | |||||
8 | $ 15,793.89 | 631.76 | 1,000.00 | 17,425.64 | |||||
9 | $ 17,425.64 | 697.03 | 1,000.00 | 19,122.67 | |||||
10 | $ 19,122.67 | 764.91 | 1,000.00 | 20,887.57 | |||||
11 | $ 20,887.57 | 835.50 | 1,000.00 | 22,723.08 | |||||
12 | $ 22,723.08 | 908.92 | 1,000.00 | 24,632.00 | |||||
13 | $ 24,632.00 | 985.28 | 1,000.00 | 26,617.28 | |||||
14 | $ 26,617.28 | 1,064.69 | 1,000.00 | 28,681.97 | |||||
15 | $ 28,681.97 | 1,147.28 | 1,000.00 | 30,829.25 | |||||
16 | $ 30,829.25 | 1,233.17 | 1,000.00 | 33,062.42 | |||||
17 | $ 33,062.42 | 1,322.50 | 1,000.00 | 35,384.92 | |||||
18 | $ 35,384.92 | 1,415.40 | 1,000.00 | 37,800.31 | |||||
Thus, | |||||||||
Amount on 18th birthday is | $ 37,800.31 | ||||||||