Please show me how to solve this in Excel

? 1 x 3 . - BU5433_S2022_Exam1 - Excel ( ) ACROBAT Calibri -11 >> . - + = = = = = = $ - % = : : " " HUTU Desislava Stamora 2 * - + i F19 B D E F G 1 J K L M N P Q R R S T U V w 1 PROBLEM 2 7 points 2 Boeing, one of the largest aircraft manufacturers in the world, reported EBITDA of $1,290 million in 2018, prior to interest expenses of $215 million and depreciation charges of $400 million. Capital expenditures in 2018 amounted to $450 million, and working capital was 7% of revenues (which were $13,500 million). The firm had debt outstanding of $3.068 billion (in book value), trading at a market value of $3.2 billion and yielding a pretax interest rate of 8%. There were 62 million shares outstanding, trading at $64 per share. The tax rate for the firm was 21%, the Treasury bond rate was 7%, the risk premiuin was 5.5%, and beta was 1.10. The firm expects revenues, earnings, capital expenditures and depreciation to grow at 9.5% per year from 2019 to 2023, after which the growth rate is expected to drop to 4%. Capital spending will be 120% of depreciation in the steady (stable) state period. The company also plans to lower its debt/equity ratio to 50% for the steady state period, which will result in in the pretax interest rate dropping to 7.5%. a. Estimate the value of the firm and the value per share. 3 4 5 6 7 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 2B 29 30 INSTRUCTIONS Problem Problem2 Problem3 Problem + TUICU Ea 1 ! P3 a 13C Cloudy ENG 7:31 PM 3/25/2022 ? 1 x 3 . - BU5433_S2022_Exam1 - Excel ( ) ACROBAT Calibri -11 >> . - + = = = = = = $ - % = : : " " HUTU Desislava Stamora 2 * - + i F19 B D E F G 1 J K L M N P Q R R S T U V w 1 PROBLEM 2 7 points 2 Boeing, one of the largest aircraft manufacturers in the world, reported EBITDA of $1,290 million in 2018, prior to interest expenses of $215 million and depreciation charges of $400 million. Capital expenditures in 2018 amounted to $450 million, and working capital was 7% of revenues (which were $13,500 million). The firm had debt outstanding of $3.068 billion (in book value), trading at a market value of $3.2 billion and yielding a pretax interest rate of 8%. There were 62 million shares outstanding, trading at $64 per share. The tax rate for the firm was 21%, the Treasury bond rate was 7%, the risk premiuin was 5.5%, and beta was 1.10. The firm expects revenues, earnings, capital expenditures and depreciation to grow at 9.5% per year from 2019 to 2023, after which the growth rate is expected to drop to 4%. Capital spending will be 120% of depreciation in the steady (stable) state period. The company also plans to lower its debt/equity ratio to 50% for the steady state period, which will result in in the pretax interest rate dropping to 7.5%. a. Estimate the value of the firm and the value per share. 3 4 5 6 7 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 2B 29 30 INSTRUCTIONS Problem Problem2 Problem3 Problem + TUICU Ea 1 ! P3 a 13C Cloudy ENG 7:31 PM 3/25/2022