On January $1,2024$ the Victoria Mireles Company borrows $$260,000$ cash by signing a $5-$year, $9\%,$ installment note, with semiannual interest payments. $1)$ Calculate the amount of each payment using the PMT function. $2)$ Prepare the amortization schedule for the loan. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cell address$($es$).$ Entering a value will be marked as incorrect.

Loan amount

Term $($years$)$

Annual interest $\%$

Payments per year

$\backslash$table$[[$$$260,000$