#### Leggo

• Posts: 11
• Location: Ohio
« on: May 25, 2015, 01:02:12 PM »
Loved the article on what you're teaching your son about money.  Thanks for including the example excel spreadsheet.  Any chance you'd be willing to share the formulas you used to populate the cells?  I'm not great with Excel, and apparently, not so great with math, either.  I can get the spreadsheet to calculate monthly interest, but can't figure out how to let it calculate interest based on number of days, as you show in your example.

Any help is appreciated!

#### SpeedofTim

• Posts: 3
##### Re: Growing your kiddo's MM
« Reply #1 on: May 25, 2015, 04:24:42 PM »
Yes please! I was just searching the forums for the same thing.  I know I can recreate a basic deposit entry spreadsheet, but I'm curious as to how the interest calculations are done.

Thanks!

#### StockBeard

• Pencil Stache
• Posts: 620
• Age: 36
##### Re: Growing your kiddo's MM
« Reply #2 on: May 27, 2015, 10:39:02 AM »
Also, I'd love to understand how you get a 10% rate for your kid. Doesn't that skew your kid's expectations for what return they'll get in the future?

#### CheapskateWife

• Handlebar Stache
• Posts: 1401
• Countdown to fire in 3-2-1
##### Re: Growing your kiddo's MM
« Reply #3 on: May 27, 2015, 11:29:40 AM »
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.

#### MDM

• Walrus Stache
• Posts: 7938
##### Re: Growing your kiddo's MM
« Reply #4 on: May 27, 2015, 11:50:32 AM »
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