The following is a chart above corresponds to the questions below

A) create a worksheet that calculates the required annual payment for an $850,000.00, 7-year loan at 5 percent and includes a loan amortization schedule.

B) Use the Scenario Manager to create a scenario using rates of 10%, 9% ,7%, and 6% percent to calculate alternative payments.

C) Use Excels goal seek feature to calculate the amount the company could borrow if it could afford a payment of $120,000 per year assuming the original loan assumptions.

What SUP, Inc. Loan Amortization Schedule \begin{tabular}{l|r} \hline Amount & $850,000.00 \\ \hline Rate & 5% \\ \hline Term & 7 \\ \hline Payment & $146,896.85 \\ \hline \end{tabular} What SUP, Inc. Loan Amortization Schedule \begin{tabular}{l|r} \hline Amount & $850,000.00 \\ \hline Rate & 5% \\ \hline Term & 7 \\ \hline Payment & $146,896.85 \\ \hline \end{tabular}