Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the WACC for Honeywell (NYSE:HON). Please utilize the attached file for the cost of debt calculation and Yahoo Finance historical data for the other

Calculate the WACC for Honeywell (NYSE:HON). Please utilize the attached file for the cost of debt calculation and Yahoo Finance historical data for the other components of the WACC. 15% is the effective tax rate for Honeywell.

image text in transcribed

Screenshot your Cost of Debt sheet, Beta calculation sheet, market return calculation sheet.
K5 K L M N. o Q R S T U V 1 Issuer Nar Ticker 2 Honeywell HON 3 Honeywell HON 4 Honeywell HON 5 Honeywell HON 6 Honeywell HON 7 Honeywell HON 8 Honeywell HON 9 Honeywell HON 10 Honeywell HON 11 Honeywell HON 12 Honeywell HON 13 Honeywell HON 14 Honeywell HON 15 Honeywell HON 16 Honeywell HON 17 Honeywell HON 18 Honeywell HON 19 Honeywell HON 20 Honeywell HON 21 Honeywell HON 22 Honeywell HON 23 Honeywell HON 24 Honeywell HON 25 Honeywell HON 26 Honeywell HON 27 C D E . Cpn Maturity Yld to Mty Amount Issued Series BBG Comp Maturity 1 Curr 0.483 8/19/2022 0.37527 2500000000 #N/A Field A CALLABLE USD 0.49775 8/19/2022 0.41507 500000000 #N/A Field A CALLABLE USD 1.95 6/1/2030 1.33703 1000000000 #N/A Field A CALLABLE USD 1.35 6/1/2025 0.6829 1250000000 #N/A Field A CALLABLE USD 2.15 8/8/2022 0.27353 600000000 #N/A Field A CALLABLE USD 2.8 6/1/2050 2.38166 750000000 #N/A Field A CALLABLE USD 1.85 11/1/2021 0.39412 1500000000 #N/A Field A CALLABLE USD 2.3 8/15/2024 0.54818 750000000 #N/A Field A CALLABLE USD 0.61325 8/8/2022 0.42133 600000000 #N/A Field A AT MATUR USD 4.25 3/1/2021 0.18174 800000000 #N/A Field A AT MATUR USD 2.5 11/1/2026 0.79988 1500000000 #N/A Field A CALLABLE USD 03/10/2024 0.03317 565820000 #N/A Field A CALLABLE EUR 1.3 2/22/2023 -0.03089 1378512500 #N/A Field A AT MATUF EUR 0.75 3/10/2032 0.72385 565820000 #N/A Field A CALLABLE EUR 2.7 8/15/2029 1.29104 750000000 #N/A Field A CALLABLE USD 3.35 12/1/2023 0.43971 300000000 #N/A Field A AT MATUR USD 6.625 6/15/2028 2.42592 250000000 #N/A Field A AT MATUR USD 5.7 3/15/2036 2.35559 550000000 #N/A Field A AT MATUR USD 3.812 11/21/2047 2.44327 442373000 #N/A Field A CALLABLE USD 5.375 3/1/2041 2.48377 600000000 #N/A Field A AT MATUR USD 2.25 2/22/2028 0.27211 827107500 #N/A Field A AT MATUF EUR 5.7 3/15/2037 2.42209 600000000 #N/A Field A AT MATUR USD 9.065 6/1/2033 2.64299 51207000 #N/A Field A AT MATUR USD 3.812 11/21/2047 3.51889 444859000 REGS A CALLABLE USD 3.812 11/21/2047 3.51889 444859000 144A A CALLABLE USD Sheet1 E + 86% K5 K L M N. o Q R S T U V 1 Issuer Nar Ticker 2 Honeywell HON 3 Honeywell HON 4 Honeywell HON 5 Honeywell HON 6 Honeywell HON 7 Honeywell HON 8 Honeywell HON 9 Honeywell HON 10 Honeywell HON 11 Honeywell HON 12 Honeywell HON 13 Honeywell HON 14 Honeywell HON 15 Honeywell HON 16 Honeywell HON 17 Honeywell HON 18 Honeywell HON 19 Honeywell HON 20 Honeywell HON 21 Honeywell HON 22 Honeywell HON 23 Honeywell HON 24 Honeywell HON 25 Honeywell HON 26 Honeywell HON 27 C D E . Cpn Maturity Yld to Mty Amount Issued Series BBG Comp Maturity 1 Curr 0.483 8/19/2022 0.37527 2500000000 #N/A Field A CALLABLE USD 0.49775 8/19/2022 0.41507 500000000 #N/A Field A CALLABLE USD 1.95 6/1/2030 1.33703 1000000000 #N/A Field A CALLABLE USD 1.35 6/1/2025 0.6829 1250000000 #N/A Field A CALLABLE USD 2.15 8/8/2022 0.27353 600000000 #N/A Field A CALLABLE USD 2.8 6/1/2050 2.38166 750000000 #N/A Field A CALLABLE USD 1.85 11/1/2021 0.39412 1500000000 #N/A Field A CALLABLE USD 2.3 8/15/2024 0.54818 750000000 #N/A Field A CALLABLE USD 0.61325 8/8/2022 0.42133 600000000 #N/A Field A AT MATUR USD 4.25 3/1/2021 0.18174 800000000 #N/A Field A AT MATUR USD 2.5 11/1/2026 0.79988 1500000000 #N/A Field A CALLABLE USD 03/10/2024 0.03317 565820000 #N/A Field A CALLABLE EUR 1.3 2/22/2023 -0.03089 1378512500 #N/A Field A AT MATUF EUR 0.75 3/10/2032 0.72385 565820000 #N/A Field A CALLABLE EUR 2.7 8/15/2029 1.29104 750000000 #N/A Field A CALLABLE USD 3.35 12/1/2023 0.43971 300000000 #N/A Field A AT MATUR USD 6.625 6/15/2028 2.42592 250000000 #N/A Field A AT MATUR USD 5.7 3/15/2036 2.35559 550000000 #N/A Field A AT MATUR USD 3.812 11/21/2047 2.44327 442373000 #N/A Field A CALLABLE USD 5.375 3/1/2041 2.48377 600000000 #N/A Field A AT MATUR USD 2.25 2/22/2028 0.27211 827107500 #N/A Field A AT MATUF EUR 5.7 3/15/2037 2.42209 600000000 #N/A Field A AT MATUR USD 9.065 6/1/2033 2.64299 51207000 #N/A Field A AT MATUR USD 3.812 11/21/2047 3.51889 444859000 REGS A CALLABLE USD 3.812 11/21/2047 3.51889 444859000 144A A CALLABLE USD Sheet1 E + 86%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Elizabeth A. Gordon, Jana S. Raedy, Alexander J. Sannella

1st edition

978-0133251579, 133251578, 013216230X, 978-0134102313, 134102312, 978-0132162302

Students also viewed these Finance questions