Consider a $4-$year amortizing loan. You borrow $$323,000$ initially, and repay it in four equal annual year$-$end payments.

a$.$ If the interest rate is $5\mathrm{.}92\%,$ calculate the annual payment. $($Do not round intermediate calculations. Round your answer to $2$ decimal places.$)$

Annual payment

$

$q,$

$q,$

b$.$ Prepare an amortization schedule. $($Leave no cells blank $-$ be certain to enter $"0"$ wherever required. Do not round intermediate calculations. Round your answers to $2$ decimal places.$)$

$\backslash$table$[[$Time$,\backslash$table$[[$Loan$],[$Balance$]],\backslash$table$[[$Year$-$End Interest$],[$Due on Balance$]],\backslash$table$[[$Year$-$End$],[$Payment$]],$Amortization$],[0,$$$,$$$,,],[1,,,,],[2,,,,],[3,,,,],[4,,,,]]$

c$-1.$ What is the loan balance at the end of year $1?($Do not round intermediate calculations. Round your answer to $2$ decimal places.$)$

Loan balance

$

c$-2.$ What is the present value of the remaining loan payments?

$c-2.$ What is the present value of the remaining loan payments?

Consider a $4-$year amortizing loan. You borrow $$323,000$ initially, and repay it in four equal annual year$-$end payments.

a$.$ If the interest rate is $5\mathrm{.}92\%,$ calculate the annual payment. $($Do not round intermediate calculations. Round your answer to $2$ decimal places.$)$

Annual payment

$

$$

b$.$ Prepare an amortization schedule. $($Leave no cells blanky$-$ be certain to enter $"0"$ wherever required. Do not round intermediate calculations. Round your answers to $2$ decimal places.$)$

$\backslash$table$[[$Time$,\backslash$table$[[$Loan$],[$Balance$]],\backslash$table$[[$Year$-$E$],[$Due o$]],,\backslash$table$[[$Am$],[0]]],[0,$$$,$$$,$$$,$$