Dear Visitor, I'd like to take this opportunity to say "Thanks very much!" for visiting It's Your Money! and for downloading this financial spreadsheet. (Feel free to try out all my others, too!) I truly hope that the spreadsheets and tools I've made available there can help you as much as they've helped me. I’m going to go out on a limb here. I'll guess that since you've downloaded and opened this spreadsheet, that little voice inside your head is urging you to take action (somehow!) to improve your financial situation. I know all about that voice. I spent a whole lot of years ignoring it! That said, I am being entirely honest when I say that the single most effective thing I ever did for my family's finances was to start planning our spending on a monthly basis. You can call it "budgeting" if you want, but "budgeting" doesn't sound the least bit fun. And if you play your cards right, and let spreadsheets help you, you can actually make your "budgeting" fun. That's where the "You Need A Budget" spreadsheet comes in. I've seen a lot of budgeting spreadsheets over the years, and this one beats 'em all. Handily. (Personally, I couldn't build anything nearly so cool.) I mention this only because I know the power of a good spending plan ("budget"), and "You Need a Budget" is about as good as it gets. If you'd like to know more, just click the YNAB icon below to read my review. Once more, thanks very much for stopping by!
Michael @ It's Your Money!
Gross Income (Pretax)
Category
Paycheck: Steve Paycheck: Martha Bonus: Martha Money Gifts Yard Sale Proceeds
Planned Total
$3,000.00 $3,200.00 $500.00 $75.00 $300.00
#1
$1,500.00 $1,600.00 $500.00 $35.00 $300.00
Gross Income Received #2 #3 #4
$1,500.00 $1,600.00 $40.00
#5
Current Total
$3,000.00 $3,200.00 $500.00 $75.00 $300.00
$7,075.00
$7,075.00
Taxes Paid
Category
Federal Social Security Medicare State
Planned Total
$230.00 $305.26 $71.39 $164.00
#1
$115.00 $253.59 $59.31 $158.00
#2
$115.00 $51.67 $12.08 $6.00
Paid Amounts #3
#4
#5
Current Total
$230.00 $305.26 $71.39 $164.00
$770.65
$770.65
Net Income
Planned Total Current Total $6,304.35 $6,304.35 Web Link: http://www.mdmproofing.com/iym/BMF.shtml
Goal %:
50.0% 39.6% 39.6%
Goal $: Planned $: Current $:
$3,152.18 $2,493.74 $2,493.74
Must-Haves
Description
auto child computer: web site fees: paypal fsa food: groceries mortgage
Planned %: Current %:
Planned Amount
$78.89 $50.00 $29.94 $1.57 $83.34 $350.00 $1,900.00
#1
$78.89 $50.00 $29.94 $1.57 $41.67 $350.00 $1,900.00
#2
#3
Spent Amounts #4
#5
#6
$41.67
$2,493.74
DFG: DFG:
$658.44 $658.44
Total
$78.89 $50.00 $29.94 $1.57 $83.34 $350.00 $1,900.00
Difference
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$2,493.74
Goal %:
30.0% 4.6% 4.6%
Goal $: Planned $: Current $:
$1,891.31 $290.85 $290.85
Wants
Description
adopt-a-platoon books cash charity child groceries
Planned %: Current %:
Planned Amount
$18.25 $62.02 $0.68 $12.00 $27.90 $170.00
#1
$18.25 $62.02 $0.68 $12.00 $27.90 $170.00
#2
#3
Spent Amounts #4
#5
#6
$290.85
DFG: DFG:
$1,600.46 $1,600.46
Total
$18.25 $62.02 $0.68 $12.00 $27.90 $170.00
Difference
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$290.85
Goal %:
20.0% 18.1% 18.1%
Goal $: Planned $: Current $:
$1,260.87 $1,144.21 $1,144.21
Savings
Description
401k freedom account Gift To ABFCU Savings
Planned %: Current %:
Planned Amount
$433.83 $590.38 $50.00 $70.00
#1
$347.19 $590.38 $50.00 $70.00
#2
$86.64
#3
Spent Amounts #4
#5
#6
$1,144.21
Total
$433.83 $590.38 $50.00 $70.00
Difference
$0.00 $0.00 $0.00 $0.00
$1,144.21
Balanced Money Formula: Target
Total Planned Net Income: Total Planned Allocations (MH, W, & S): Total Current Expenses (MH & W): Total Current Allocations (MH, W, & S): Net Income (minus) Planned Expenses: Net Income (minus) Current Expenses:
Savings 20%
Wants 30%
MustHaves 50%
Balanced Money Formula: Planned Outcome
Undetermined 38%
MustHaves 39%
Savings 18%
Wants 5%
ions (MH, W, & S): es (MH & W): ons (MH, W, & S): Planned Expenses: Current Expenses:
$ $ $ $ $ $
6,304.35 3,928.80 2,784.59 3,928.80 2,375.55 2,375.55
Must-Haves Wants Savings Must-Haves Wants Savings Undetermined $ $ $ $
50% 30% 20% 2,493.74 290.85 1,144.21 2,375.55 39.6% 4.6% 18.1% 37.7%