1.fill in the missing answers

2. show the work of how u got the answer w/ excel functions

3. make ammoritization table

Imagine that your company has docided to upgrade hardware and software in your department. You have been given the loan information in the table above, but notice that cach one is missing a hey plece of data that will allow you to select the most sutable loan. The loan objective is to minimize interest even if it means a slightly higher periodic payment. Complete the table above to include the missing values using financial functions and formulas. Critera to select the best loan: Loan 4 should reflect a balloon payment of $10,000 The periodic payment should not be in excess of $5500 The loan should be paid off in 55 monthis or less Total interest expense should not be greater than $8,000 Select the most suitable loan and create an amortization schedule in the next worksheet, Part 1 Data. \begin{tabular}{|c|c|c|c|} \hline & Amortization T & able C & D \\ \hline Original Loan & & & \\ \hline Annual Interest Rate & & & \% \\ \hline Loan Duration in Years & & & \\ \hline Number of Periods per Year & & & \\ \hline Ending Value of Loan & & & \\ \hline & & & \\ \hline Periodic Payment & & & \\ \hline Period & Remaining Principal & Interest Payment & Principal Payment \\ \hline & & & \\ \hline & & & \\ \hline & & & 4 \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & 8 & \\ \hline & & & \\ \hline & & & 1 \\ \hline & & 1 & \\ \hline . & . & & 0 \\ \hline. & & & - \\ \hline & & & \\ \hline & & & \\ \hline ang & & & \\ \hline 2 & & & \\ \hline & & & = \\ \hline & & & \\ \hline & & & 41 \\ \hline & & & +2 \\ \hline Ending Balance Due & & & \\ \hline \end{tabular}