# Spreadsheet
#Car Loan
#Car Loan
# 
# Compute car loan balance after each payment given the interest rate (annual), Payment Amount,
# and Frequency (payments per year / compound period)
Car Loan
C2 C2 L R 
Year	Balance	C	D	
=0	=$D$1	Original Loan	9000	
=A1+1/$D$4	=B1*(1+$D$2/100/$D$4)-$D$3	Interest Rate	6%	
=A2+1/$D$4	=B2*(1+$D$2/100/$D$4)-$D$3	Payment Amt	250	
=A3+1/$D$4	=B3*(1+$D$2/100/$D$4)-$D$3	Freq (per year)	4	
=A4+1/$D$4	=B4*(1+$D$2/100/$D$4)-$D$3	.	.	
=A5+1/$D$4	=B5*(1+$D$2/100/$D$4)-$D$3	.	.	
=A6+1/$D$4	=B6*(1+$D$2/100/$D$4)-$D$3	.	.	
=A7+1/$D$4	=B7*(1+$D$2/100/$D$4)-$D$3	.	.	
=A8+1/$D$4	=B8*(1+$D$2/100/$D$4)-$D$3	.	.	
=A9+1/$D$4	=B9*(1+$D$2/100/$D$4)-$D$3	.	.	
=A10+1/$D$4	=B10*(1+$D$2/100/$D$4)-$D$3	.	.	
=A11+1/$D$4	=B11*(1+$D$2/100/$D$4)-$D$3	.	.	
=A12+1/$D$4	=B12*(1+$D$2/100/$D$4)-$D$3	.	.	
=A13+1/$D$4	=B13*(1+$D$2/100/$D$4)-$D$3	.	.	
=A14+1/$D$4	=B14*(1+$D$2/100/$D$4)-$D$3	.	.	
=A15+1/$D$4	=B15*(1+$D$2/100/$D$4)-$D$3	.	.	
=A16+1/$D$4	=B16*(1+$D$2/100/$D$4)-$D$3	.	.	
=A17+1/$D$4	=B17*(1+$D$2/100/$D$4)-$D$3	.	.	
=A18+1/$D$4	=B18*(1+$D$2/100/$D$4)-$D$3	.	.	
=A19+1/$D$4	=B19*(1+$D$2/100/$D$4)-$D$3	.	.	
=A20+1/$D$4	=B20*(1+$D$2/100/$D$4)-$D$3	.	.	
=A21+1/$D$4	=B21*(1+$D$2/100/$D$4)-$D$3	.	.	
=A22+1/$D$4	=B22*(1+$D$2/100/$D$4)-$D$3	.	.	
=A23+1/$D$4	=B23*(1+$D$2/100/$D$4)-$D$3	.	.	
=A24+1/$D$4	=B24*(1+$D$2/100/$D$4)-$D$3	.	.	
=A25+1/$D$4	=B25*(1+$D$2/100/$D$4)-$D$3	.	.	
=A26+1/$D$4	=B26*(1+$D$2/100/$D$4)-$D$3	.	.	
=A27+1/$D$4	=B27*(1+$D$2/100/$D$4)-$D$3	.	.	
=A28+1/$D$4	=B28*(1+$D$2/100/$D$4)-$D$3	.	.	
=A29+1/$D$4	=B29*(1+$D$2/100/$D$4)-$D$3	.	.	
=A30+1/$D$4	=B30*(1+$D$2/100/$D$4)-$D$3	.	.	
=A31+1/$D$4	=B31*(1+$D$2/100/$D$4)-$D$3	.	.	
=A32+1/$D$4	=B32*(1+$D$2/100/$D$4)-$D$3	.	.	
=A33+1/$D$4	=B33*(1+$D$2/100/$D$4)-$D$3	.	.	
=A34+1/$D$4	=B34*(1+$D$2/100/$D$4)-$D$3	.	.	
=A35+1/$D$4	=B35*(1+$D$2/100/$D$4)-$D$3	.	.	
=A36+1/$D$4	=B36*(1+$D$2/100/$D$4)-$D$3	.	.	
=A37+1/$D$4	=B37*(1+$D$2/100/$D$4)-$D$3	.	.	
=A38+1/$D$4	=B38*(1+$D$2/100/$D$4)-$D$3	.	.	
=A39+1/$D$4	=B39*(1+$D$2/100/$D$4)-$D$3	.	.	
=A40+1/$D$4	=B40*(1+$D$2/100/$D$4)-$D$3	.	.	
=A41+1/$D$4	=B41*(1+$D$2/100/$D$4)-$D$3	.	.	
=A42+1/$D$4	=B42*(1+$D$2/100/$D$4)-$D$3	.	.	
=A43+1/$D$4	=B43*(1+$D$2/100/$D$4)-$D$3	.	.	
=A44+1/$D$4	=B44*(1+$D$2/100/$D$4)-$D$3	.	.	
=A45+1/$D$4	=B45*(1+$D$2/100/$D$4)-$D$3	.	.	
=A46+1/$D$4	=B46*(1+$D$2/100/$D$4)-$D$3	.	.	
=A47+1/$D$4	=B47*(1+$D$2/100/$D$4)-$D$3	.	.	
=A48+1/$D$4	=B48*(1+$D$2/100/$D$4)-$D$3	.	.	
=A49+1/$D$4	=B49*(1+$D$2/100/$D$4)-$D$3	.	.	
=A50+1/$D$4	=B50*(1+$D$2/100/$D$4)-$D$3	.	.	
=A51+1/$D$4	=B51*(1+$D$2/100/$D$4)-$D$3	.	.	
=A52+1/$D$4	=B52*(1+$D$2/100/$D$4)-$D$3	.	.	
=A53+1/$D$4	=B53*(1+$D$2/100/$D$4)-$D$3	.	.	
=A54+1/$D$4	=B54*(1+$D$2/100/$D$4)-$D$3	.	.	
=A55+1/$D$4	=B55*(1+$D$2/100/$D$4)-$D$3	.	.	
=A56+1/$D$4	=B56*(1+$D$2/100/$D$4)-$D$3	.	.	
=A57+1/$D$4	=B57*(1+$D$2/100/$D$4)-$D$3	.	.	
=A58+1/$D$4	=B58*(1+$D$2/100/$D$4)-$D$3	.	.	
=A59+1/$D$4	=B59*(1+$D$2/100/$D$4)-$D$3	.	.	
=A60+1/$D$4	=B60*(1+$D$2/100/$D$4)-$D$3	.	.	
=A61+1/$D$4	=B61*(1+$D$2/100/$D$4)-$D$3	.	.	
=A62+1/$D$4	=B62*(1+$D$2/100/$D$4)-$D$3	.	.	
=A63+1/$D$4	=B63*(1+$D$2/100/$D$4)-$D$3	.	.	
=A64+1/$D$4	=B64*(1+$D$2/100/$D$4)-$D$3	.	.	
=A65+1/$D$4	=B65*(1+$D$2/100/$D$4)-$D$3	.	.	
=A66+1/$D$4	=B66*(1+$D$2/100/$D$4)-$D$3	.	.	
=A67+1/$D$4	=B67*(1+$D$2/100/$D$4)-$D$3	.	.	
=A68+1/$D$4	=B68*(1+$D$2/100/$D$4)-$D$3	.	.	
=A69+1/$D$4	=B69*(1+$D$2/100/$D$4)-$D$3	.	.	
=A70+1/$D$4	=B70*(1+$D$2/100/$D$4)-$D$3	.	.	
=A71+1/$D$4	=B71*(1+$D$2/100/$D$4)-$D$3	.	.	
=A72+1/$D$4	=B72*(1+$D$2/100/$D$4)-$D$3	.	.	
=A73+1/$D$4	=B73*(1+$D$2/100/$D$4)-$D$3	.	.	
=A74+1/$D$4	=B74*(1+$D$2/100/$D$4)-$D$3	.	.	
=A75+1/$D$4	=B75*(1+$D$2/100/$D$4)-$D$3	.	.	
=A76+1/$D$4	=B76*(1+$D$2/100/$D$4)-$D$3	.	.	
=A77+1/$D$4	=B77*(1+$D$2/100/$D$4)-$D$3	.	.	
=A78+1/$D$4	=B78*(1+$D$2/100/$D$4)-$D$3	.	.	
=A79+1/$D$4	=B79*(1+$D$2/100/$D$4)-$D$3	.	.	
=A80+1/$D$4	=B80*(1+$D$2/100/$D$4)-$D$3	.	.