### Author Topic: Growing your kiddo's MM  (Read 1832 times)

#### Leggo

• 5 O'Clock Shadow
• Posts: 11
• Location: Ohio
##### Growing your kiddo's MM
« 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

• 5 O'Clock Shadow
• 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: 501
• Age: 35
##### 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

• Pencil Stache
• Posts: 920
• Location: On my bike...again
• Risking bike-vag to cure MS
##### 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.
I'm riding from Houston to Austin TX to beat MS...find out how you can get involved too!

http://main.nationalmssociety.org/goto/JennythPeterson

#### MDM

• Walrus Stache
• Posts: 6003
##### 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

#### Leggo

• 5 O'Clock Shadow
• Posts: 11
• Location: Ohio
##### Re: Growing your kiddo's MM
« Reply #5 on: May 31, 2015, 08:34:25 PM »
Thank you!  Can't wait to have a sit down with the kiddos once school lets out (next week!)