To the request for an excel document, I put together this quick calculation, and when you plan to add on, you simply copy and paste the last filled line into the first empty line.Nice! One might want to use formulas in columns C, D, and E. E.g., see table below. Other bells & whistles no doubt possible.
Kid's Bank Account Statement | ||||||
Interest rate | 0.1 | |||||
Date | New Contribution | Number of days | Interest | Interest Earned | Total | Comment |
42144 | 30 | =E6+B6 | Imported contents of Piggy Bank | |||
42147 | 3 | =A6-A5 | =C6/365*$B$2 | =D6*F5 | =F5+E6+B6 | |
42154 | 3 | =A7-A6 | =C7/365*$B$2 | =D7*F6 | =F6+E7+B7 | |
=A7+7 | 3 | =A8-A7 | =C8/365*$B$2 | =D8*F7 | =F7+E8+B8 | |
42168 | 3 | =A9-A8 | =C9/365*$B$2 | =D9*F8 | =F8+E9+B9 | |
42175 | 0 | =A10-A9 | =C10/365*$B$2 | =D10*F9 | =F9+E10+B10 |