Total Amount Of Interest - Financial Question

[BAH0003]

Hi,

Can someone help me get the answer fo this question, alongside the relevant financial solver entries needed.

Question:

"Indira borrowed $29,000 to buy a car and was charged interest at the rate of 12.5% per annum, compounding monthly.
For the first year of the loan, Indira made monthly repayments of $425.
For the second year of the loan, Indira made monthly repayments of $500.
The total amount of interest that Indira paid over this two-year period is closest to

Thanks

[S_R_K]

Year 1:
N = 12
I = 12.5
PV = 29000
Pmt = -425
PPY/CPY = 12

This gives a balance of 27437.4906523.

Year 2:
N = 12
I = 12.5
PV = 27437.4906523
Pmt = -500
PPY/CPY = 12

This gives a balance of 24714.6844601

Interest paid = Total paid - Principal reduction = ($425*12 + $500*12) – ($29000 – $24715) = $6815 (to nearest dollar).