12. The couple currently has $7350 in their savings account. Each month the couple will either take money out of their savings account or deposit money. In row 41, calculate the end of month balance in their savings account by adding the value in cell E5 to the running total values of the net cash flow in row 39. Use an absolute cell reference for cell E5.

13.In cell E6, enter a formula to display the value of the savings balance at the end of December.

14. Juan and Olivia would like to have $15,000 in their savings account by the end of the year. Olivia is planning to ask for a raise at her job. Use Goal Seek to determine the value of cell B6 that will achieve a final savings balance of $15,000.

Please help!

Hernandez Family Budget
			Calculated Value
Monthly Income Statement
Income			Savings
Juan's Salary	$ 2,350		Initial	$ 7,350
Olivia's Salary	3,150		Final
Total	$ 5,500
Expenses
Rent	$ 922
Food	870
Utilities	191
Phone	140
Car Payments	210
Insurance	460
Tuition	1,124
Books & Supplies	462
Travel	421
Miscellaneous	208
Total	$ 5,007
Income & Expenses		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Income	Juan	2,350	2,350	2,350	2,350	2,350	2,350	2,350	2,350	2,350	2,350	2,350	2,350
	Olivia	3,150	3,150	3,150	3,150	3,150	3,150	3,150	3,150	3,150	3,150	3,150	3,150
	Total	5,500	5,500	5,500	5,500	5,500	5,500	5,500	5,500	5,500	5,500	5,500	5,500
Expenses	Rent	895	895	895	895	895	895	895	895	975	975	975	975
	Food	875	730	795	825	855	815	885	920	942	875	975	945
	Utilities	255	230	200	195	150	165	175	165	160	160	200	235
	Phone	120	131	125	138	120	145	140	135	145	135	165	175
	Car Payments	210	210	210	210	210	210	210	210	210	210	210	210
	Insurance	375	375	375	425	425	425	520	520	520	520	520	520
	Tuition	5,192	0	0	0	0	2,419	0	5,881	0	0	0	0
	Books & Supplies	2,115	0	0	0	0	975	0	2,450	0	0	0	0
	Travel	320	150	210	720	175	350	1,200	625	185	215	420	480
	Miscellaneous	200	250	120	150	250	120	150	175	210	250	270	350
	Total	10,557	2,971	2,930	3,558	3,080	6,519	4,175	11,976	3,347	3,340	3,735	3,890
	Net Cash Flow	-5,057	2,529	2,570	1,942	2,420	-1,019	1,325	-6,476	2,153	2,160	1,765	1,610
	Running Total	-5,057	-2,528	42	1,984	4,404	3,385	4,710	-1,766	387	2,547	4,312	5,922
	Savings