Not sure on how to do assignment or what specific numbers go inside the all of the yellow cells.

A B C D E F G H Component Maxwell Barston Notes 2 Net Income (M$) 27.00 34.00 Earnings per share (EPS) 2.50 3.50 # of shares (M) Net Income / EPS 5 Price per share 16.00 15.00 6 Market Value - Equity (M) # of shares x price per share 7 Market Value - Debt (M) 120 130 8 Market Value - Total (M) 245 279 10 - % Debt Debt as a per cent of Total MV 10 - % Equity Equity as a per cent of Total MV Beta (levered) 0.90 0.80 as reported in Value Line 12 Beta (unlevered) Beta (levered) x % Equity 13 Average Beta (unlevered) Average of the two Beta (unlevered) 14 15 Values for Wilson: 16 % Debt 50.0% 17 % Equity 18 Beta (relevered) 19 Risk free rate 4.0% 20 Market risk premium 6.1% 21 Expected equity return (CAPM) 22 Expected cost of debt 7.5% 23 Tax rate 21.0% 24 Weighed average cost of capital (WACC) 25A B C D E F G H I J K Actual Projected Income Statement (in '000 S) 2020 2021 2022 2023 2024 2025 Notes Salaries and benefits 1.098 5.6% Research and development 1,022 6.1% 579 Increase at a yearly Service expense 4.7% rate of Sales and Administrative 481 2.3% 14 Depreciation amortization 332 2.2% 15 Total Operating Expenses 3,512 6 17 Income before taxes 1,656 18 Income tax expense (benefit) 348 Net Income 1,308 Balance Sheet Cash and investments 1.866 6.0% Accounts receivable 1,391 Increase at a yearly 7.0% Inventory and supplies, net 1,144 rate of 4.5% 24 Other 188 5.1% 15 Current Assets 4,589 Other 6,120 Increase at 5.5% Total Assets 10,709 28 29 Bank Loan 4,215 Plug account 30 Payables 265 4.5% 31 CPLTD 48 Increase at a yearly 2.5% Other rate of 99 2.5% Current Liabilities 4,627 34 LTD 1,988 Equity 4.094 36 Total Liabilities & Equity 10,709 8 Working Capital 4,177 Exclude Bank LoanA B C D E F G H I Free Cash Flow Valuation N (in '000 $) 2021 2022 2023 2024 2025 TV 4 Income before taxes 5 + Interest 6 = Income before interest and taxes (EBIT) 7 8 EBIAT 9 - Change in Working Capital 10 - Change in Other assets Growth rate 11 Free Cash Flow (FCF) 3.5% 12 PV of FCF = EV 13 - Existing Debt 14 = Value of equity 15 16 17 18 19