Overview
	This workbook enables you to estimate the requirements of reaching medium-term (6-60 months) financial goals. Whether you’re building your bankroll for a big trip, down payment, grad school, or founding a business…this tool tells you exactly what it will take to get there.
	The model converts income and expenses into daily figures so that the impact of a multi-year goal, semi-monthly salary, monthly cell phone bill, etc. talk to each other in the common language of dollars / day. The resulting figure is more intuitive and actionable (i.e. What do I have to give up in my daily life? How many lattes / beers / nice dinners is that?).
	You’ll learn:
	*How much you have to save on a daily basis to reach your goal
	*How much money you have left over to do whatever you please
	*The $$ / day impact of making a goal bigger/smaller or closer/farther away
	Note: the model should not be relied upon for long-term planning. In many-year scenarios, ROI and compound interest become major considerations, and this model doesn’t touch that.
	Instructions
	1) Fill in all the boxes that look like this:	box	but don't touch the others!
	They are filled in with initial example data. Roll your mouse over the red triangles for explanatory commentary
	2) Paste the your starting value from C45 on the Accounts sheet into D5 of the goals sheet
	3) Tinker with the values and see what happens!
	Formatting standards
	Area to input a value
	Blue numbers are inputs
	Black numbers are calculations
	Green numbers are directly pulled from elsewhere (e.g. an =, VLOOKUP.)
	Total
	Column header labels
	Major workbook section
	Copyright Pete Mockaits 2009
	www.PeteMockaitis.com

	Goal parameters
	Parameter	Date	Dollars
	Starting line	10/1/2009	$2,000
	Goal	9/20/2010	$10,000
	Implied budget (Goal - Starting line)	354.0	$8,000
	Current state	10/7/2009	$6,520
	Progress (Current - Starting)	6.6	$4,520
	Remaining	347	$3,480
	Implication	Value
	Budgeted savings by today	$148
	Overall savings performance	3046%
	Surplus (Deficit)	$4,371
	Budgeted required savings / day	$22.60
	Remaining required savings / day	$10.02
	Daily play money (from below)	$32.84
	Recurring income
	Income source	Amount	Frequency	(Days)	Per day	Last occurrence	Implied accrual
	Take-home wages	$1,600	Semi-monthly	15.2	$105.13	10/1/2009	$690.27
	Other income 1			0.0	$-		0
	Other income 2			0.0	$-		0
	Other income 3			0.0	$-		0
	TOTAL				$105.13		$690.3
	Recurring expense
	Expense	Amount	Frequency	(Days)	Per day	Last occurrence	Implied accrual
	Rent	$900	Monthly	30.4	$29.57	10/1/2009	$194.14
	Cell phone	$128	Monthly	30.4	$4.21	9/25/2009	$52.84
	Internet	$50	Monthly	30.4	$1.64	10/5/2009	$4.21
	Gym	$35	Monthly	30.4	$1.15	10/1/2009	$7.55
	Giving	$100	Weekly	7.0	$14.29	10/5/2009	$36.65
	Groceries	$80	Weekly	7.0	$11.43	10/1/2009	$75.04
	Other 2			0.0	$-		0
	Other 3			0.0	$-		0
	Other 4			0.0	$-		0
	TOTAL				$62.28		$370.44
	Remaining daily dollars
	Remaining after recurring expenses	$42.85
	Required savings	$10.02
	Dollars per day for play	$32.84
	Copyright Pete Mockaits 2009
	www.PeteMockaitis.com

	Accounts
	Account	Category	Date updated	Value
	Checking 1	Liquid	10/6/2009	$500
	Checking 2	Liquid	10/6/2009	$500
	Checking 3	Liquid	10/6/2009	$500
	Checking 4	Liquid	10/6/2009	$500
	Cash on hand	Liquid	10/6/2009	$500
	Cash in Drawer	Liquid	10/6/2009	$500
	Savings 1	Liquid	10/6/2009	$500
	Savings 2	Liquid	10/6/2009	$500
	Credit Card balance	Liquid	10/6/2009	$(300)
	Mutual funds 1	Liquid	10/6/2009	$500
	Prosper.com	Liquid	10/6/2009	$500
	Edward Jones	Liquid	10/6/2009	$500
	401(K) - Vanguard	Retirement	10/6/2009	$10,000
	Roth IRA - Vanguard	Retirement	10/6/2009	$2,000
	IRA - Fidelity	Retirement	10/6/2009	$4,000
	Real estate	Longterm	10/6/2009	$8,000
	Other 1	Longterm	10/6/2009	$500
	Other 2	Longterm	10/6/2009	$500
	Other 3	Longterm	10/6/2009	$500
	Total	Liquid		$5,200
	Total	Retirement		$16,000
	Total	Longterm		$8,500
	Total	Net Worth		$29,700
	Adjusted totals
	One-off adjustments	Value
	Loan to Buddy 1	$100
	Loan owed to Buddy 2	$(200)
	Upcoming tax refund	$850
	Other 3	$50
	Other 4	$50
	Other 5	$50
	Other 6	$50
	Other 6	$50
	Total one-off adjustments	$1,000
	Total accrued income	$690
	Total accrued expenses	$(370)
	Total adjustments	$1,320
	Total adjusted liquid	$6,520
	Total adjusted net worth	$31,020
	Copyright Pete Mockaits 2009
	www.PeteMockaitis.com