Financing Workbook Issues

[broncojared]

Hi All,

Hoping I can find some help. I've been having issues getting to the right answer when compared to the financing paperwork I have. The paperwork I received is off from my excel computations by about $176 bucks. I was thinking it would have to do with the daily rate and the 45 day grace period between note date and payment date, however, that figure is is around $510. Any thoughts on what I am missing?

Calculations Sheet DRAFT For Test.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N
4	MY CALCS
5
6
7
8	Note Date	9/2/2022								FROM BANK
9	Payment Start	10/17/2022
10		45	0.0185%	$ 510.76
11
12	APR	Finance Charge	Amount Financed	Total of Payments	Total Sale Price					APR	Finance Charge	Amount Financed	Total of Payments
13	6.9900%	$52,682.78	$ 61,310.58	$113,993.36	Down Pmt	$ 13,000.00				6.9900%	$52,859.64	$ 61,310.58	$114,170.22
14					Total	$ 126,993.36
15		FALSE
16
17
18	# Pmts	Amount of Payments	Payments Due							# Pmts	Amount of Payments	Payments Due
19	240		$474.97							240		$474.97
20
21
22
23
24	a	Total vehicle price	$ 64,995.00		l	Insurance premiums paid
25		Rigging
26		Accessories			m	TO: Doc Fee	$ 499.00
27		Tax 1	$ 3,275.69
28		Tax 2	$ 1,195.89		n	TO:
29		Tax Total	$ 4,471.58
30		Sale Total	$ 69,466.58		o	TO:
31
32					p	TO:
33	b	Public Officals (Title Fee)	$ 350.00
34					q	TO:
35	c	Service Contract	$ 3,995.00
36					r	TO:
37	d	Trade-in allowance
38					s	TO:
39	e	Less: Amount owing	$ 13,000.00
40					t	TO:
41	f	Net Trade-in (d-e)	$ 13,000.00
42					u	Other charges	$ 499.00
43	g	Cash Down Payment
44					v	Prepaid finance charges
45	h	Manufacture Rebate
46					w	Amount financed (k+u-v)	$ 61,310.58
47	i	Other down payment
48
49	j	Down payment total	$ 13,000.00
50
51	k	Balance of price due	$ 60,811.58
52
Sheet1

Cell Formulas
Range	Formula
C10	C10	=C9-C8
D10	D10	=(1+B13)^(1/365)-1
E10	E10	=C10*D10*D13
C13	C13	=-CUMIPMT(B13/12,B19,D13,1,B19,0)
D13	D13	=H46
E13	E13	=SUM(C13:D13)
K13	K13	=B13
G13	G13	=D49
G14	G14	=G13+E13
C15	C15	=C13=L13
D19,M19	D19	=-PMT(B13/12,B19,D13,,0)
D29	D29	=SUM(D27:D28)
D30	D30	=D24+D25+D26+D29
D41	D41	=SUM(D37:D39)
H42	H42	=SUM(H26:H41)
H46	H46	=D51+H42-H44
D49	D49	=D41+D43+D45+D47
D51	D51	=D30+D33+D35-D49