The lon given below was paid off early. Find the unearned interest by (a) the actuarial method and (b) the rule of 78.

Amount financed: $3,300

Regular monthly payment: $196.66

Total number of payments scheduled: 18

Remaining number of scheduled payments after payoff: 6

(a) The unearned interest calculated using the actiarial method is $________.

(b) The unearned interest calculated using the rule of 78 is $________.

Note: I need easy to follow step by step explanation. also, is this solvable through Excel? if yes, can you please provide formulas?

Mode - Delay Number of Monthly Payments in 6 12 18 24 30 36 48 60 Annual Percentage Rate (APR) for Monthly Payment Loans Annual Percentage Rate (APR) 4.0% 4.5% 5.0% 5.5% 6.0% 0.5% 7.0% 7.5% 8.0% 8.5% 9.0% 9.5% 10.0% 10.5% 11.0% 11.5% 12.0% Finance Charge per $100 of Amount Financed (h) 1.171.32 146 161 1.76 190 205 220 2.35 249 2.64 2.79 2.94 3.08 323 3.38 3.53 2.18 2.45 2.73 3 00 3.28 3.56 3.83 439 4.66 494 5.22 5.50 5.78 606 6.34 6.62 3.20 3.60 4.00 4.41 4.82 5.22 5.63 6.04 6.45 6.86 7.28 7.69 8.10 8.52 8.93 935 9.77 4.22 4.75 529 5.83 6.37 6 91 7.45 8.00 8.55 9.09 9.64 10.19 10.75 11.30 11.86 12 42 12 98 5 25 5.92 6.59 7 29 7.94 8.61 930 9.98 10.66 11.35 12.04 12.74 13.43 14.13 14.83 15 54 16:24 6.29 7.09 7.90 8.71 9.52 10.34 11.16 1198 12.81 13.64 14.4815,32 16.16 17.01 17 86 18.71 1957 8.38 9.46 10.5411 63 12.73 13 83 14.94 16.06 17.18 18.31 1945 20.5921.74 2290 24.06 25.2326.40 10.50 11.86 13.23 14.61 16.00 17.40 18,81 20 23 2166 23.10 24 55 26.01 27.48 28.96 30.45 31,96