Car Loan Formula Excel 46585 | Adv Budget Spreadsheet

Partial file snippet.

Sheet 1: BlankSheet

	
	
	
	
	
	
	
	
	
	
	
	
		Cash Flow Out
		Paid
		

		Cash Flow In
		

		Debt
		

		

		

	
	
		Category
		Expense
		Amount
		ACCT
		Date
		
 
		
		

		Resource
		Amount
		ACCT
		

		Debt
		Current Amount
		

		

		

	
	
		

		[blank]
		0
		

		

		

		Job 1
		0
		

		

		Credit Card
		0
		

		

		

	
	
		

		[blank]
		0
		

		

		

		Job 2
		0
		

		

		[Blank]
		0
		

		

		

	
	
		

		[blank]
		0
		

		

		

		FinAid
		0
		

		

		[Blank]
		0
		

		

		

	
	
		

		[blank]
		0
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		Total
		0
		

		Total
		0
		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		Remaining Cash Flow
		

		

		

		Annual One Time Payments
		

		

		

		Paid
	
	
		

		

		

		

		

		

		

		Total
		[insert formula]
		[insert formula for %]
		

		[Blank]
		0
		Date
		Account
		
 
	
	
	
		

		

		

		

		

		

		

		

		

		

		

		[Blank]
		0
		Date
		Account
		
	
		
 
		
		

		

		

		

		

		

		[Blank]
		0
		Date
		Account
		
	
		

		

		Acct. Balances
		

		

		[Blank]
		0
		Date
		Account
		
	
		

		

		ACCT
		Amount
		

		

		[Blank]
		0
		Date
		Account
		
	
		

		

		Savings
		0
		

		

		

		

		

		

		
	
		

		

		Checking
		0
		

		

		Total
		0
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		Total
		0
		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		For more information, please visit: https://www.redwoods.edu/financialaid/Financial-Aid-Home/Workshops    
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

 
 
 
 
 
 
 
 


Sheet 2: Example Sheet

	
	
	
	
	
	
	
	
	
	
		Cash Flow Out
		

		Cash Flow In
		

		Debt
		

		

		

	
	
		Entertainment
		Expense
		Amount
		ACCT
		Date
		Paid
		

		Resource
		Amount
		ACCT
		

		Debt
		Amount
		

		

		

	
	
		

		Spotify
		9.99
		Credit
		15th
		
 
		
		

		Wages
		1040
		chk acct.
		

		Credit Card
		2000
		

		

		

	
	
		

		Amazon Prime
		9.91
		Save
		12th
		

		FinAid
		815.75
		chk acct.
		

		[Blank]
		0
		

		

		

	
	
		

		Zip Car
		1.25
		Save
		21st
		

		Total
		1855.75
		

		

		[Blank]
		0
		

		

		

	
	
		

		Hulu
		9.99
		Credit
		15th
		

		

		

		

		

		Fedloan
		10500
		

		

		

	
	
		

		[blank]
		0
		

		

		

		

		

		

		

		
		Orig: 23850.83
		Car Loan
		0
		

		

		

	
	
		

		

		

		Total
		31.14
		

		Remaining Cash Flow
		

		[Blank]
		0
		

		

		

	
	
		

		

		

		

		

		

		

		Total
		206
		11.1%
		

		

		

		

		

		

	
	
		Health
		gym
		10
		chk acct.
		17th
		
 
		
		

		

		

		

		

		Total Debt
		12500
		

		

		

	
	
		

		Quip
		
		Every 3 months, new toothbrush head and battery. $5.
		1.66
		Save
		7th 
		

		

		

		

		

		

		

		

		

		

	
	
		

		Gym Fee
		3.25
		Save
		1st
		

		Acct. Balances
		

		

		Annual One Time Payments
		
	
		

		

		

		Total
		14.91
		

		ACCT
		Amount
		

		

		Expense
		Amount
		ACCT
		Date
		Paid
	
	
		

		

		

		

		

		

		

		Savings
		500
		

		

		Amazon Prime
		119
		12-Feb
		Credit
		
 
	
	
	
		Utilities/Housing
		Electric/Gas
		20
		chk acct.
		

		
 
		
		

		Checking
		2000
		

		

		Zip Car
		15
		21-Feb
		Credit
		
	
		

		Internet
		20
		Credit
		

		

		Total
		2500
		

		

		Gym Fee
		39
		1-Jun
		chk acct.
		
	
		

		Rent
		300
		Check
		

		

		

		

		

		

		Car Registration
		246
		18-Nov
		Credit
		
	
		

		Cell Phone
		30
		Credit
		

		

		

		

		

		

		Renters Insurance
		108
		14-May
		Credit
		
	
		

		Renters Ins.
		9
		Save
		

		

		

		

		

		

		

		

		

		

		
	
		

		Household Item
		15
		Credit
		

		

		

		

		

		

		Total
		527
		

		

		

	
	
		

		

		

		Total
		394
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Personal/Food
		Personal
		15
		Credit
		

		
 
		
		

		

		

		

		

		

		

		

		

		

	
	
		

		Clothing
		50
		Credit
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		School Expenses
		15
		Credit
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Grocery
		200
		Credit
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Eating Out
		125
		Credit
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		Total
		405
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Student Loans
		Fed Loan
		102.82
		chk acct.
		22nd
		
 
		
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		Total
		102.82
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Card Payments
		Visa Credit
		50
		chk acct.
		16th
		
 
		
		

		

		

		

		

		

		

		

		

		

	
	
		

		[Blank]
		0
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		[Blank]
		0
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		Total
		50
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Car
		Gas
		225
		Credit
		---
		
 
		
		

		

		

		

		

		

		

		

		

		

	
	
		

		Car Payment
		0
		chk acct.
		---
		

		

		

		

		

		

		

		

		

		

	
	
		

		Car Insurance
		100
		Debit
		29th
		

		

		

		

		

		

		

		

		

		

	
	
		

		Car Reg.
		20.5
		Save
		18th
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		Total
		345.5
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Financial Goals
		Goal 1
		35.29
		Save
		29th
		
 
		
		

		

		

		

		

		

		

		

		

		

	
	
		

		Goal 2
		187.5
		Save
		29th
		

		

		

		

		

		

		

		

		

		

	
	
		

		Goal 3
		83.34
		save
		29th
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		Total
		306.13
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Total
		

		1649.5
		88.9%
		

		

		

		

		

		

		

		

		

		

		

		

	

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


Sheet 3: AveragingSheet

	
	
	
	
		Dates
		Gas
		Grocery 
		eating out
		total
		Change in Spending
		
 
		
		
	
		12/27-1/25
		202.94
		94.06
		126.87
		423.87
		

		
	
		01/28-2/26
		236.4
		35.15
		405.36
		676.91
		#NAME?
		
	
		02/28-3/25
		147.64
		0
		392.47
		540.11
		#NAME?
		
	
		03/26-4/23
		114.95
		78.03
		251.59
		444.57
		#NAME?
		
	
		05/25-6/25
		200.61
		98.35
		119.97
		418.93
		#NAME?
		
	
		06/27-07/24
		259.3
		153
		95.09
		507.39
		#NAME?
		
	
		07/26-8/23
		295.57
		121
		192.57
		609.14
		#NAME?
		
	
		08/26-9/25
		236.01
		184.78
		217.6
		638.39
		#NAME?
		
	
		09/27-10/24
		340.26
		49.9
		236.26
		626.42
		#NAME?
		
	
		10/25-11/26
		347.71
		269.28
		280.6
		897.59
		#NAME?
		
	
		11/27-12/24
		208.1
		101.94
		136.53
		446.57
		#NAME?
		
	
		12/26-01/27
		290
		244.8
		82.56
		617.36
		38.24%
		
	
		

		

		

		

		

		

		
	
		Average
		239.96
		119.19
		211.46
		566.35

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet blanksheet cash flow out paid in debt category expense amount acct date resource current job credit card finaid total remaining annual one time payments account balances savings checking for more information please visit httpswwwredwoodsedufinancialaidfinancialaidhomeworkshops example entertainment spotify th wages chk amazon prime save zip car st hulu fedloan orig loan health gym quip every months new toothbrush head and battery fee feb utilitieshousing electricgas internet jun rent check registration nov cell phone renters insurance may ins household item personalfood personal clothing school expenses grocery eating student loans fed nd visa gas payment debit reg financial goals goal averagingsheet dates change spending name average...

Related files

Share

Help

Dates	Gas	Grocery	eating out	total	Change in Spending
12/27-1/25	202.94	94.06	126.87	423.87
01/28-2/26	236.4	35.15	405.36	676.91	#NAME?
02/28-3/25	147.64	0	392.47	540.11	#NAME?
03/26-4/23	114.95	78.03	251.59	444.57	#NAME?
05/25-6/25	200.61	98.35	119.97	418.93	#NAME?
06/27-07/24	259.3	153	95.09	507.39	#NAME?
07/26-8/23	295.57	121	192.57	609.14	#NAME?
08/26-9/25	236.01	184.78	217.6	638.39	#NAME?
09/27-10/24	340.26	49.9	236.26	626.42	#NAME?
10/25-11/26	347.71	269.28	280.6	897.59	#NAME?
11/27-12/24	208.1	101.94	136.53	446.57	#NAME?
12/26-01/27	290	244.8	82.56	617.36	38.24%

Average	239.96	119.19	211.46	566.35

Related files

Share

Share to social media

Help

Login Area