answer with excel functions please

A. (4 points) Based on the estimated future incremental cash flows, what is the most (total amount, not per share) NCC should offer Portable for a cash acquisition? Assume a cost of capital of 11% and use a time value of money function in Excel to find the answer. B. (4 points) If NCC paid the price from part A to acquire Portable, how much per share would Portable shareholders receive? (Hint: Review Portable's Balance Sheet liabilities.) ( 5 points) If after further analysis Portable ended up having much higher financial leverage than first indicated, what adjustment would be needed in determining your answer to Question 1a and how would it impact the highest price NCC would offer? Briefly explain. pertinent financial data is included in the tables below. The applicable corporate tax rate is 21%. \begin{tabular}{|l|c|l|c|} \hline \multicolumn{4}{|c|}{ Table 3: Portable Coffee Express Balance Sheet (December 31, 2020) } \\ \hline Assets & $3,000,000 & Liabilities \& Equity \\ \hline Cash & 2,000,000 & Mortgages payable & $3,600,000 \\ \hline Accounts Receivable & 7,000,000 & Common stock & 14,800,000 \\ \hline Inventory & 7,250,000 & Retained Earnings & 9,700,000 \\ \hline Land & 14,750,000 & Total Liabilities \& Equity & $34,000,000 \\ \hline Fixed assets (net) & $34,000,000 & & \\ \hline Total Assets & & & \\ \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} \begin{tabular}{|c|c|c|c|c|c|} \hline & A & B & C & D & E \\ \hline 1 & Part A & \multicolumn{2}{|c|}{ Cost of Capital } & 11% & \\ \hline 2 & & Year & Cash Flow & & \\ \hline 3 & & 1 & 19,400,000 & & \\ \hline 4 & & 2 & 19,100,000 & & \\ \hline 5 & & 3 & 20,100,000 & & \\ \hline 6 & & 4 & 22,550,000 & & \\ \hline 7 & & 5 & 17,100,000 & & \\ \hline 8 & & & & & \\ \hline 9 & & & & & \\ \hline 10 & & & & & \\ \hline 11 & & & & & \\ \hline 12 & & & & & \\ \hline 13 & & & & & \\ \hline 14 & Part B & & & & \\ \hline 15 & & & & & \\ \hline 16 & & & & & \\ \hline 17 & & & & & \\ \hline 18 & & & & & \\ \hline 19 & & & & & \\ \hline 20 & & & & & \\ \hline 21 & & & & & \\ \hline \end{tabular}