I need help with the excel formula for B/(B+S) and WACC.. I thought I had it figured out but I DID NOT!! Any help would be amazing!!

FCF B/(B+S) RB RF MRP Beta (b) WACC 2015 2016 2017 2018 2019 CONSOLIDATED BALANCE SHEETS - $ in Millions Current assets: Cash and cash equivalents Marketable securities 5 Accounts receivable, net 5 Inventories - Other current assets 3 Total current assets Non-current assets: 0 Marketable securities 1 Property, plant and equipment, net 2 Other non-current assets 3 Total non-current assets 4 Total assets $ 21,120 20,481 16,849 2,349 28,579 89,378 $ 20,484 46,671 15,754 2,132 21,828 106,869 $ 20,289 53,892 17,874 4,855 31,735 128,645 $ 25,913 40,388 23,186 3,956 37,896 131,339 $ 48,844 51,713 22,926 4,106 35,230 162,819 164,065 22,471 14,431 200,967 290,345 170,430 27,010 16,772 214,212 321,686 194,714 33,783 18,177 246,674 375,319 170,799 41,304 22,283 234,386 365,725 105,341 37,378 32,978 175,697 338,516 35,490 34,121 10,999 80,610 37,294 30,107 11,605 79,006 49,049 33,292 18,473 100,814 55,888 39,293 20,748 115,929 46,236 43,242 * 16,240 105,718 6 Current liabilities: 7 Accounts payable 8 Other current liabilities 9 Short-term debt 0 Total current liabilities 1 Non-current liabilities: 2 Long-term debt 3 Other non-current liabilities 4 Total non-current liabilities 5 Total liabilities 6 Common stock 7 Retained earnings 8 Total shareholders' equity 9 Total liabilities and shareholders' equity 0 Assumed Cash on Hand 1 Shares outstanding (in millions) 53,329 37,051 90,380 170,990 27,416 91,939 119,355 $ 290,345 $ 35,490 5,579 75,427 43,345 118,772 197,778 31,251 96,998 128,249 $ 321,686 $ 37,294 5,336 97,207 43,251 140,458 241,272 35,867 98,180 134,047 $375,319 $ 49,049 5,126 93,735 48,914 142,649 258,578 40,201 66,946 107,147 $ 365,725 $ 55,888 4,755 91,807 50,503 142,310 248,028 45,174 45,314 90,488 $ 338,516 $ 46,236 4,443 TI 2015 $ 233,715 140,089 93,626 2016 $ 215,639 131,376 84,263 2017 $ 229,234 141,048 88,186 2018 $ 265,595 163,756 101,839 2019 $ 260,174 161,782 98,392 14,236 CONSOLIDATED STATEMENTS OF OPERATIONS - $ in Millions Net sales Cost of sales Gross margin Operating expenses: Research and development Selling, general and administrative Total operating expenses Operating income Other income/(expense), net Income before provision for income taxes Provision for income taxes Net income 16,705 8,067 14,329 22,396 71,230 10,045 14,194 24,239 60,024 1,348 61,372 15,685 $ 45,687 11,581 15,261 26,842 61,344 2,745 64,089 15,738 $ 48,351 16,217 18,245 34,462 63,930 1,807 65,737 10,481 $ 55,256 30,941 70,898 2,005 72,903 13,372 $ 59,531 1,285 72,515 19,121 $ 53,394 Seth Morgan Home Insert Page Layout Formulas Data Review View Add-ins Help Analytic Solver Data Mining Solver Home Tell me what you want to do X Cut Calibri .1AA == > Wrap Text Accounting HEX PL AutoSum - A - 47 - BIU - 39.A Merge & Center - $ -% 4848 Conditional Format as Format Painter Cell Insert Delete Format Sort & Find & Formatting - Table - Styles - Clear - Filter - Select - Clipboard Alignment UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to dose some apps Update now Ford Styles Editing A C D E F G NOC ANOC H 30 B (8 FCF U 63, $ 1,080,861.59 im sto B/(B+S) RB RF MRP Beta (b) WACC PV(FCF) Long-run growth assumption Terminal value fcf_valuation Beta Question #6 Question #6 (2) Question #6 (3) 2.53% 1.53% 7.00% 1.36 63,7 3.50% ... Question #7 fef valuation (2) O Type here to search FCF B/(B+S) RB RF MRP Beta (b) WACC 2015 2016 2017 2018 2019 CONSOLIDATED BALANCE SHEETS - $ in Millions Current assets: Cash and cash equivalents Marketable securities 5 Accounts receivable, net 5 Inventories - Other current assets 3 Total current assets Non-current assets: 0 Marketable securities 1 Property, plant and equipment, net 2 Other non-current assets 3 Total non-current assets 4 Total assets $ 21,120 20,481 16,849 2,349 28,579 89,378 $ 20,484 46,671 15,754 2,132 21,828 106,869 $ 20,289 53,892 17,874 4,855 31,735 128,645 $ 25,913 40,388 23,186 3,956 37,896 131,339 $ 48,844 51,713 22,926 4,106 35,230 162,819 164,065 22,471 14,431 200,967 290,345 170,430 27,010 16,772 214,212 321,686 194,714 33,783 18,177 246,674 375,319 170,799 41,304 22,283 234,386 365,725 105,341 37,378 32,978 175,697 338,516 35,490 34,121 10,999 80,610 37,294 30,107 11,605 79,006 49,049 33,292 18,473 100,814 55,888 39,293 20,748 115,929 46,236 43,242 * 16,240 105,718 6 Current liabilities: 7 Accounts payable 8 Other current liabilities 9 Short-term debt 0 Total current liabilities 1 Non-current liabilities: 2 Long-term debt 3 Other non-current liabilities 4 Total non-current liabilities 5 Total liabilities 6 Common stock 7 Retained earnings 8 Total shareholders' equity 9 Total liabilities and shareholders' equity 0 Assumed Cash on Hand 1 Shares outstanding (in millions) 53,329 37,051 90,380 170,990 27,416 91,939 119,355 $ 290,345 $ 35,490 5,579 75,427 43,345 118,772 197,778 31,251 96,998 128,249 $ 321,686 $ 37,294 5,336 97,207 43,251 140,458 241,272 35,867 98,180 134,047 $375,319 $ 49,049 5,126 93,735 48,914 142,649 258,578 40,201 66,946 107,147 $ 365,725 $ 55,888 4,755 91,807 50,503 142,310 248,028 45,174 45,314 90,488 $ 338,516 $ 46,236 4,443 TI 2015 $ 233,715 140,089 93,626 2016 $ 215,639 131,376 84,263 2017 $ 229,234 141,048 88,186 2018 $ 265,595 163,756 101,839 2019 $ 260,174 161,782 98,392 14,236 CONSOLIDATED STATEMENTS OF OPERATIONS - $ in Millions Net sales Cost of sales Gross margin Operating expenses: Research and development Selling, general and administrative Total operating expenses Operating income Other income/(expense), net Income before provision for income taxes Provision for income taxes Net income 16,705 8,067 14,329 22,396 71,230 10,045 14,194 24,239 60,024 1,348 61,372 15,685 $ 45,687 11,581 15,261 26,842 61,344 2,745 64,089 15,738 $ 48,351 16,217 18,245 34,462 63,930 1,807 65,737 10,481 $ 55,256 30,941 70,898 2,005 72,903 13,372 $ 59,531 1,285 72,515 19,121 $ 53,394 Seth Morgan Home Insert Page Layout Formulas Data Review View Add-ins Help Analytic Solver Data Mining Solver Home Tell me what you want to do X Cut Calibri .1AA == > Wrap Text Accounting HEX PL AutoSum - A - 47 - BIU - 39.A Merge & Center - $ -% 4848 Conditional Format as Format Painter Cell Insert Delete Format Sort & Find & Formatting - Table - Styles - Clear - Filter - Select - Clipboard Alignment UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to dose some apps Update now Ford Styles Editing A C D E F G NOC ANOC H 30 B (8 FCF U 63, $ 1,080,861.59 im sto B/(B+S) RB RF MRP Beta (b) WACC PV(FCF) Long-run growth assumption Terminal value fcf_valuation Beta Question #6 Question #6 (2) Question #6 (3) 2.53% 1.53% 7.00% 1.36 63,7 3.50% ... Question #7 fef valuation (2) O Type here to search