FINANCES 1840																														

This spreadsheet is set up to help you figure your family's budget in 1840.																																

Fill in the required information and Excel will calculate your financial situation.							INCOME				INFORMATION ON THE RESIDENCE				HOUSEHOLD COSTS PER WEEK			NET FINANCES PER WEEK			NET FINANCES PER YEAR (1840)			TEN YEAR PROJECTION 1840-1849								
																								1841	1842	1843	1844	1845	1846	1847	1848	1849
FAMILY RECORDS	Please Fill In 			Please Fill In 																												
					Live at Home?	Daily	Daily	Days Work	Weekly Net		Location:				Weekly Rent:	$0.00 		Net Income Per Week	$0.00 		Net Income Per Year	$0.00 	Net Income Per Year	$0.00 	$0.00 	$0.00 	$0.00 	$0.00 	$0.00 	$0.00 	$0.00 	$0.00 
Family Name:			First Name	Age	" 1=""yes""; 0 = ""no"""	Income	Commute	Per Week	Income		Description:				Cost of Food (from Market Basket 1840)			Total Weekly Expenses	$0.00 		Total Yearly Expenses	$0.00 	Total Yearly Expenses	$0.00 	$0.00 	$0.00 	$0.00 	$0.00 	$0.00 	$0.00 	$0.00 	$0.00 
Cash on hand when landing		1)							$0.00 		# of Rooms:				Cost of Dry Goods & Clothing (from Market Basket 1840)			Miscellaneous	$0.80 		Miscellaneous	($41.60)	Miscellaneous	($42.02)	($42.44)	($42.86)	($43.29)	($43.72)	($44.16)	($44.60)	($45.05)	($45.50)
		2)							$0.00 		# of bathrooms:				Taxes	$0.00 		Weekly Gain or (Loss)	($0.80)		Cash at Hand When Landing	$0.00 	Cash at Hand at Present	($41.60)	($83.62)	($126.05)	($168.91)	($212.20)	($255.92)	($300.08)	($344.68)	($389.73)
		3)							$0.00 		Weekly Rent:				TOTAL WEEKLY EXPENSES	$0.00 					Yearly Gain or (Loss)	($41.60)	Yearly Gain or (Loss)	($83.62)	($126.05)	($168.91)	($212.20)	($255.92)	($300.08)	($344.68)	($389.73)	($435.23)
		4)							$0.00 																							
		5)							$0.00 																							
		6)							$0.00 																							
		7)							$0.00 																							
		8)							$0.00 
		9)							$0.00 
		10)							$0.00 
		11)							$0.00 
		12)							$0.00 
		13)							$0.00 
		14)							$0.00 
		15)							$0.00 
						Net Income Per Week For Family			$0.00