Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need step by step solution in excel. Can you answer this today Chapter 9 Problem 16 Harley-Davidson Inc. produces motorcycles, motorcycle parts and related

image text in transcribed

i need step by step solution in excel. Can you answer this today

image text in transcribed Chapter 9 Problem 16 Harley-Davidson Inc. produces motorcycles, motorcycle parts and related accessories and merchandise in the United States and internationally. It is headquartered in Milwaukee, Wisconsin. Use the following information on Harley-Davidson and five other similar companies to value Harley-Davidson as of December 31, 2004. Harley-Davidson Inc. 2004 ($ millions) Net income $ 889.77 Number of common shares, millions 294.31 Earnings before interest and tax $1,506.16 Tax rate 35.0% Book value of equity $3,218.47 Book value interest-bearing debt $1,295.44 Total Sales $5,320.45 Total Assets $5,483.29 5-year growth rate in sales (%) 5-year growth rate in eps (%) Interest coverage ratio (x) Total liabilities to assets (%) Total assets ($ millions) Price/earnings (x) MV firm/EBIT(1-tax rate) (x) MV equity/BV equity (x) MV firm/BV firm (x) Price/sales (x) MV firm/sales (x) HarleyArctic Polaris Marine Winnebago Davidson Cat Brunswick Industries Products Industries Comparison of Timberland with Comparable Companies: Growth Rates, Financial Risks, Size, Returns 15.5 6.2 4.1 6.1 15.5 10.8 28.1 11.1 47.1 15.9 25.1 17.2 60.9 * 8.9 85.1 * * 0.4 0.3 0.6 0.5 0.2 0.5 5,483 286 4,346 793 110 395 Indicators of Value 16.9 17.8 17.3 19.4 2.8 2.8 2.8 2.3 0.8 0.9 0.8 1.1 27.8 24.3 8.0 7.7 1.6 1.7 28.6 29.0 7.7 7.7 2.7 2.7 * These companies have little or no interest-bearing debt outstanding. 18.6 17.6 6.5 6.5 1.2 1.2

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

Financial Management for Public, Health and Not-for-Profit Organizations

Authors: Steven A. Finkler, Daniel L. Smith, Thad D. Calabrese, Robert M. Purtell

5th edition

1506326846, 9781506326863, 1506326862, 978-1506326849

More Books

Students also viewed these Finance questions

Question

If the job involves a client load or caseload, what is it?

Answered: 1 week ago