Copy of FAMILY EXPENSES SPREADSHEET by  rajasbc  rajasbc 
  Log In  |  Create a FREE Account  |  Everyone's Spreadsheets  |  Tags  |  Help  
 Saving... 
  login to save   undo redo  |  bold italic font text underline more font formatting  |  align left align center align right  |  text color background text color  |  sum hide/show tools
  fx
Family Monthly Budget
Family Monthly Budget
Total Projected CostTotal Actual CostTotal DifferenceProjected Monthly Income
=SUM(B19,B30,B37,B43,B55,B63,B73,G37,G46,G53,G60,G66,G73)=SUM(C19,C30,C37,C43,C55,C63,C73,H37,H46,H53,H60,H66,H73)=SUM(D19,D30,D37,D43,D55,D63,D73,I37,I46,I53,I60,I66,I73)Income 14333
Income 2
Extra income
HousingProjected CostActual CostDifferenceTotal monthly income=SUM(G4:G6)
Mortgage or rent$1290$1290=B8-C8
Second mortgage or rent$0100=B9-C9Actual Monthly Income
Phone$0$0=B10-C10Income 1$4,333lt
Electricity$100$100=B11-C11Income 2
Gas$120$120=B12-C12Extra income
Water and sewer$50$50=B13-C13Total monthly income=SUM(G10:G12)
Cable$50$50=B14-C14
Waste removal$22$22=B15-C15Projected balance=G7-B4
Maintenance or repairs$0$0=B16-C16
Supplies$0$0=B17-C17Actual balance873
Other$75$75=B18-C18
Subtotals=SUM(B8:B18)=SUM(C8:C18)=SUM(D8:D18)Difference=G17-G15
Transportation
Vehicle 1 payment$460$460=B22-C22
Vehicle 2 payment$276$276=B23-C23
Bus/taxi fare=B24-C24
Insurance$107$107=B25-C25
Licensing=B26-C26
Fuel=B27-C27
Maintenance=B28-C28
Other=B29-C29EntertainmentProjected CostActual CostDifference
Subtotals=SUM(B22:B29)=SUM(C22:C29)=SUM(D22:D29)Video/DVD=G30-H30
CDs=G31-H31
InsuranceMovies=G32-H32
Home=B33-C33Concerts=G33-H33
Health=B34-C34Sporting events=G34-H34
Life=B35-C35Live theater=G35-H35
Other=B36-C36Other=G36-H36
Subtotals=SUM(B33:B36)=SUM(C33:C36)=SUM(D33:D36)Subtotals=SUM(G30:G36)=SUM(H30:H36)=SUM(I30:I36)
FoodLoans
Groceries$600$600=B40-C40Personal=G40-H40
Dining out=B41-C41Student=G41-H41
Other=B42-C42Credit card=G42-H42
Subtotals=SUM(B40:B42)=SUM(C40:C42)=SUM(D40:D42)Credit card=G43-H43
Credit card=G44-H44
ChildrenOther=G45-H45
Medical=B46-C46Subtotals=SUM(G40:G45)=SUM(H40:H45)=SUM(I40:I45)
Clothing$100$100=B47-C47
School tuition$60$60=B48-C48Taxes
School supplies=B49-C49Federal=G49-H49
Organization dues or fees=B50-C50State=G50-H50
Lunch money=B51-C51Local=G51-H51
Child care=B52-C52Other=G52-H52
Toys/games$50$50=B53-C53Subtotals=SUM(G49:G52)=SUM(H49:H52)=SUM(I49:I52)
Other$100$100=B54-C54
Subtotals=SUM(B46:B54)=SUM(C46:C54)=SUM(D46:D54)Savings or Investments
Retirement account=G56-H56
PetsInvestment account=G57-H57
Food=B58-C58College=G58-H58
Medical=B59-C59Other=G59-H59
Grooming=B60-C60Subtotals=SUM(G56:G59)=SUM(H56:H59)=SUM(I56:I59)
Toys=B61-C61
Other=B62-C62Gifts and Donations
Subtotals=SUM(B58:B62)=SUM(C58:C62)=SUM(D58:D62)Charity 1=G63-H63
Charity 2=G64-H64
Personal CareCharity 3=G65-H65
Medical=B66-C66Subtotals=SUM(G63:G65)=SUM(H63:H65)=SUM(I63:I65)
Hair/nails=B67-C67
Clothing=B68-C68Legal
Dry cleaning=B69-C69Attorney=G69-H69
Health club=B70-C70Alimony=G70-H70
Organization dues or fees=B71-C71Payments on lien or judgment=G71-H71
Other=B72-C72Other=G72-H72
Subtotals=SUM(B66:B72)=SUM(C66:C72)=SUM(D66:D72)Subtotals=SUM(G69:G72)=SUM(H69:H72)=SUM(I69:I72)
 
Average Rating:  Not rated (Not yet rated)
 
Name:  Copy of FAMILY EXPENSES SPREADSHEET by  rajasbc rajasbc 
Description:  (no description yet)
Tags:  Borges Budget  
[ default color ]
 
 recent: