Excel Final

Documentation

Timov Family Budget
Author	Zaki Evans
Date	11/17/22
Purpose	To evaluate two mortgage proposals based on projected income and expenses and make a recommendation.

Family Budget

Timov Family Budget
Mortgage Plan (1 or 2)		1
Year-End Summary		Sum	Average	Maximum	Minimum		Mortage Plan 1	Annual Rate			Mortage Plan 2	Annual Rate
Pay	Sergei							Compounded				Compounded
	Ava							Monthly Rate				Monthly Rate
	Total							Years				Years
Expenses	Taxes							# of Payments				# of Payments
	Car Payments							Principal				Principal
	Health Insurance							Monthly Payment				Monthly Payment
	Other
	Mortgage
	Total
Net Cash Flow
Monthly Values		January	February	March	April	May	June	July	August	September	October	November	December
Pay	Sergei	4,200	4,200	4,200	4,200	4,200	4,200	4,200	4,200	4,200	4,200	4,200	4,200
	Ava	3,500	3,900	4,300	4,700	2,800	2,200	500	2,500	2,700	3,200	3,400	3,100
	Total	7,700	8,100	8,500	8,900	7,000	6,400	4,700	6,700	6,900	7,400	7,600	7,300
Expenses	Taxes	2,400	2,500	2,600	2,800	2,200	2,000	1,500	2,100	2,100	2,300	2,400	2,300
	Car Payments	215	215	215	215	215	215	215	215	215	215	215	215
	Health Insurance	495	495	495	495	495	495	495	495	495	495	495	495
	Other	4,700	750	750	600	700	700	1,500	5,600	600	700	1,000	1,200
	Mortgage
	Total	7,810	3,960	4,060	4,110	3,610	3,410	3,710	8,410	3,410	3,710	4,110	4,210
Net Cash Flow		(110)	4,140	4,440	4,790	3,390	2,990	990	(1,710)	3,490	3,690	3,490	3,090