9) (10 points) Assume for this question that NCC could borrow $20 million from a commercial bank to help pay for the acquisition. The loan would be for 10 years at an interest rate of 4.5% and require quarterly Principal and Interest payments. Use Excel functions (not an amortization schedule) to get your answers to parts A and B. (Show all work/calculations.) A. What would be the quarterly Principal and Interest payment? B. What would be the interest portion of the 20th payment? C. What would be the tax benefit (in dollars) of the 20th payment? pertinent financial data is included in the tables below. The applicable corporate tax rate is 21%. \begin{tabular}{|l|c|l|r|} \hline \multicolumn{4}{|c|}{ Table 3: Portable Coffee Express Balance Sheet (December 31, 2020) } \\ \hline Assets & \multicolumn{2}{|l|}{ Liabilities \& Equity } \\ \hline Cash & $3,000,000 & Current liabilities & $3,600,000 \\ \hline Accounts Receivable & 2,000,000 & Mortgages payable & 5,900,000 \\ \hline Inventory & 7,000,000 & Common stock & 14,800,000 \\ \hline Land & 7,250,000 & Retained Earnings & 9,700,000 \\ \hline Fixed assets (net) & 14,750,000 & Total Liabilities \& Equity & $34,000,000 \\ \hline Total Assets & $34,000,000 & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline \multicolumn{3}{|l|}{ Table 4: NCC and Portable additional data (December 31, 2020) } \\ \hline Item & NCC & Portable \\ \hline \begin{tabular}{l} Earnings available for \\ common stock \end{tabular} & $29,000,000 & $12,580,000 \\ \hline \begin{tabular}{l} Number of shares of \\ Common stock \end{tabular} & 7,000,000 & 3,400,000 \\ \hline \begin{tabular}{l} Market price per share \\ ( Estimated by NCC) \end{tabular} & $43.30 & $19 \\ \hline \end{tabular} Loan amount 20,000,000 Interest rate 4.50% Term in years 10 Tax rate 21% Use a function for parts A and B. Do not construct an amortization table as it is not needed. Part A Quarterly P\&I payment Part B 20th interest payment Part C Tax savings