/biz/ - Business & Finance

>>53519384
If you MUST do it with Excel then here's what you do:

>Sheet 1: Table of percentages (how much to which account) by month. Enter the first one then fill/copy 'em, manually change if you wish. Add a row to verify each sums to 100% if you want some robustness.
>Sheet 2: Table of dollar amounts by month. Single formula with values filled from the percentage page, protip if you fill the cell number increments. Dollar amount in once again copy-pasta the first one, if you need manual entry then can do on a per-month basis
>Sheet 3: Sum the dollar amounts from sheet 2. You can even do it on an accumulating basis if you want to just be able to keep filling the same formula

All of this should take less than 5 minutes to implement and you should feel bad you didn't already do it this way. And it will take maybe at most 3 math operators in a given cell including +-/*.

>>53286082
Mega caps seem like safe choice but will let you down in the end
Large caps overrated and always pushing themselves on you (by being in 401k auto-buy funds)
Small caps look fun but are too unstable and will probably drain all your money before you know it

Mid caps are the balanced choice with the highest potential for stable gains