Please Provide the formulas needed to satisfy each empty yellow box not just the answers , Thank You !

. D1 X fx B E F G H 1 J Name Due 1 Build a Model 2 Chapter: 3 Problem: 9/20/21 5:30PM 6 21 4 5 a. Using the financial statements shown below, calculate net operating working capital, total net operating capital, net operating profit after taxes, free cash flow, and return on invested capital for the most recent 6 year. The federal-plus-state tax rate is 25%. 7 8 Lan & Chen Technologies: Income Statements for Year Ending December 31 9 (Millions of Dollars) 2022 2021 10 Sales $945,000 $900,000 11 Expenses excluding depreciation and amortization 812,700 774,000 12 EBITDA $132,300 $126,000 13 Depreciation and amortization 33,100 31.500 14 EBIT $99,200 $94,500 15 Interest Expense 10,400 8.900 16 EBT $88,800 $85,600 17 Taxes (25%) 22,200 21,400 18 Net income $66,600 $64,200 19 20 Common dividends $43,300 $41,230 21 Addition to retained earnings $23,300 $22,970 22 23 Lan & Chen Technologies: December 31 Balance Sheets 24 (Millions of Dollars) 25 Assets 2022 2021 26 Cash and cash equivalents $47,250 $45,000 27 Short-term investments 3,800 3,600 28 Accounts Receivable 283,500 270,000 29 Inventories 141,750 135,000 30 Total current assets $476,300 $453,600 31 Net fixed assets 330,750 315,000 32 Total assets $807,050 $768,600 29 VI K > A B D E F G H 1 J TULLI UJJU VOTVO UTVU, Vuu $94,500 47,250 17.400 $159,150 90,000 $249,150 $444,600 113,300 $557.900 $807,050 $90,000 45,000 9,000 $144,000 90,000 $234,000 $444,600 90,000 $534,600 $768,600 33 34 Liabilities and equity 35 Accounts payable 36 Accruals 37 Notes payable 38 Total current liabilities 39 Long-term debt 40 Total liabilities 41 Common stock 42 Retained Earnings 43 Total common equity 44 Total liabilities and equity 45 46 Key Input Data 47 Tax rate 48 49 Net operating working capital (NOWC) Operating 50 2022 NOWC = current assets 51 2022 NOWC = 52 2022 NOWC = 53 Operating 54 2021 NOWC = current assets 55 2021 NOWC = 56 2021 NOWC = 57 58 Total net operating capital (TNOC) 59 2022 TNOC = NOWC 60 2022 TNOC = 61 2022 TNOC = 62 25% Operating current liabilities points 2 Operating current liabilities 2 + Fixed assets + 2 D1 X fx I + + X A B D E F G 62 63 2021 TNOC = NOWC Fixed assets 64 2021 TNOC = 65 2021 TNOC = 2 66 67 Investment in total net operating capital 68 2022 2021 69 2022 Inv. In TOC = TNOC TNOC 70 2022 Inv. In TOC = 71 2022 Inv. In TOC = 2 72 73 Net operating profit after taxes 74 2022 NOPAT = EBIT (1-T) 75 2022 NOPAT = 76 2022 NOPAT = 2 77 78 Free cash flow 79 2022 FCF = NOPAT Investment in total net operating capital 80 2022 FCF = 81 2022 FCF = 2 82 83 Return on invested capital 84 2022 ROIC = NOPAT / Total net operating capital 85 2022 ROIC = / 86 2022 ROIC = 2 87 88 b. Assume that there were 15 million shares outstanding at the end of the year, the year-end closing stock 89 price was $65 per share, and the after-tax cost capital was 10% CE late EVA and MVA for the most 90 recent year. 91 92 Additional Input Data 93 Stock price per share $65.00 94 # of shares (in thousands) 15,000 95 After-tax cost of capital 10.0% 96 D1 A x V fx B D E F G H $65.00 15,000 10.0% X # of shares Total common equity 2 91 92 Additional Input Data 93 Stock price per share 94 # of shares (in thousands) 95 After-tax cost of capital 96 97 Market Value Added 98 MVA = Stock price 99 MVA = 100 MVA = 101 MVA = 102 103 Economic Value Added 104 EVA = NOPAT 105 EVA = 106 EVA = 107 EVA = 108 109 110 111 112 (Operating Capital After-tax cost of capital) X N