Prepare an amortization schedule for a five$-$year loan of $$59,000.$ Assume the loan agreement calls for a principal reduction of $$11,800$ every year. The interest rate is $7$ percent per year. $($Do not round intermediate calculations and round your answers to $2$ decimal places, e$.$g$.,32\mathrm{.}16.$ Leave no cells blank $-$ be certain to enter $"0"$ wherever required.$)$

$\backslash$table$[[$Year$,,\backslash$table$[[$Beginning$],[$Balance$]],$Total Payment,$\backslash$table$[[$Interest$],[$Payment$]],\backslash$table$[[$Principal$],[$Payment$]],\backslash$table$[[$Ending$],[$Balance$]]],[1,$$$,59,000,,$$$,4,130,,711],[2,,,,,1,],[3,,\stackrel{}{x},cos,,,10$