Question

Please help me fill this out, and i need the March-December answer also, thank you.

Month to month cashflow

monthly cash flow
Instructions: you can just fill in the blanks and estimate what your salary and expenses will be
		example		february
Salary
Net pay monthy		$        3,000.0		$ 3,000.0
rent		900		0
utilities		200		0
student loans		300		0
credit card debt		100		0
food		200		0
entertainment		150		0
hair salon/barber		50		0
clothes		100		0
car		199		0
auto insurance		75		0
life insurance		50		0
				0
				0
total monthly expenses		$          2,324		0
				0
savings		$             676		0

Answer 1

Instructions were not clear. From the question i thought that just to make a cash flow like this with imaginary figures. Some of the figures are treated as fixed and others variable. Even some figures are fixed over a period of time like salary and rent was same for the first 6 months upto june. After July these item were changed.

	February	March	April	May	June	July	August	September	October	November	December
Salary
Net pay monthy	$3,000	$3,000	$3,000	$3,000	$3,000	$3,500	$3,500	$3,500	$3,500	$3,500	$3,500
rent	900	900	900	900	900	900	1000	1000	1000	1000	1000
utilities	250	300	300	350	350	350	400	400	300	350	450
student loans	300	300	300	300	300	300	300	300	300	300	300
credit card debt	150	120	130	110	120	130	140	90	60	120	130
food	210	220	210	220	200	240	230	190	150	210	250
entertainment	160	120	130	140	160	170	180	200	210	130	120
hair salon/barber	50	50	50	50	50	50	50	50	50	50	50
clothes	120	130	90	0	50	90	80	120	150	140	110
car	200	250	120	100	199	180	168	178	195	205	210
auto insurance	75	75	75	75	75	75	75	75	75	75	75
life insurance	50	50	50	50	50	50	50	50	50	50	50
Total monthly expenses	$2,465	$2,515	$2,355	$2,295	$2,454	$2,535	$2,673	$2,653	$2,540	$2,630	$2,745
Savings	$535	$485	$645	$705	$546	$965	$827	$847	$960	$870	$755
Opening balance		$535	$485	$645	$705	$546	$965	$827	$847	$960	$870
Closing balance	$535	$1,020	$1,130	$1,350	$1,251	$1,511	$1,792	$1,674	$1,807	$1,830	$1,625