Questions Complete the questions below using the Excel file provided in MvCourses. Show all calculations and formulas for quantitative solutions. For questions that require textbased responses, create a text box in Excel for each (lnsertTextText Bax). 1) A. {4 points) Based on the estimated future incrementolcosh 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 w0uld Portable shareholders receive? (Hint: Review Portoble's Balance Sheet.) Table 3: Portable Coffee Express Balance Sheet [December 31, 2020] Assets Liabilities 8: Equity Cash 5 3,000,000 Current liabilities 5 3,600,000 Accounts Receivable 2,000,000 Mortgages payable 5,900,000 Inventory 7,000,000 Common stock 14,800,000 Land 7,250,000 Retained Earnings 9,700,000 Fixed assets [net] 14,750,000 Total Liabilities 8: Equity S 34,000,000 Total Assets $ 34,000,000 \f