Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me answer Part A. Thank you! Part A: Ratio Analysis (Week 3 Milestone) Attached are the financial statements for Smith Company, Inc. Use

Please help me answer Part A. Thank you!

Part A: Ratio Analysis (Week 3 Milestone)

Attached are the financial statements for Smith Company, Inc. Use the financial statements to answer the questions below

  • Calculate and interpret the return on assets using the Dupont Method for the four years of data.
  • Calculate and interpret the return on equity using the Modified Dupont Method all four years of data.

Information for calculating the ROA and ROE using the Dupont Method for three competitors to Smith Company, Inc. is also provided below. You will use this information in Part D.

Format Table

(2018)

Competitor 1

Competitor 2

Competitor 3

Net Profit Margin 0.082 0.11 0.03
Total Asset Turnover 0.88 0.9 0.55
ROA 0.07216 0.099 0.0165
FLM 3.3 2.5 5.5
ROE 0.238128 0.2475 0.09075

Part B: Stock Valuation (Week 5 Milestone)

  • Use the information provided to calculate the required rate of return on four stocks. Use both CAPM and the Dividend Discount Model. The market return is expected to be 8.5% and the risk-free rate is 2.0%.

Format Table

Smith Company, Inc. Competitor 1 Competitor 2 Competitor 3
Beta 1.4 1.7 1.2 0.9
Dividend $2.00 $3.25 $2.00 $1.25
Price $26.00 $33.00 $45.00 $20.00
Growth 3.5% 3.5% 5.5% 1.5%

Part C: Dividend Policy

  • Use the information provided to discuss the dividend policy of the four listed firms over the past four years.

Format Table

2018 2017 2016 2015
Smith Company, Inc.
Dividend $2.00 $2.00 $2.00 $2.00
Net Income $3,978,000 $4,931,000 $5,220,000 $5,652,000
Competitor 1
Dividend $3.25 $0.75 $1.20 $1.00
Net Income $6,111,000 $5,408,000 $5,576,000 $5,456,000
Competitor 2
Dividend $2.50 $2.50 $2.00 $1.00
Net Income $5,547,000 $5,160,000 $4,823,000 $4,637,000
Competitor 3
Dividend $1.25 $0.55 $0.55 $0.55
Net Income $4,543,000 $3,786,000 $3,711,000 $3,657,000

Part D: Analysis

  • You are working as a financial analyst. Your manager has asked you to prepare a presentation on whether Smith Company, Inc. is a good investment opportunity. Prepare a presentation, a minimum of one slide for each part, summarizing your results. You should submit either an Excel or Word document showing your work for each part

Given Financial Information for Smith Company Inc.

image text in transcribed

\begin{tabular}{l|c|c|c|c|} \hline & 12/31/2018 & 12/31/2017 & 12/31/2016 & 12/31/2015 \\ \hline Revenue & & & & \\ \hline Total Revenue & 51,728,000 & 57,902,000 & 56,519,100 & 56,488,000 \\ \hline Cost of Revenue & 23,502,000 & 25,340,000 & 25,399,800 & 25,283,000 \\ \hline Gross Profit & 28,226,000 & 32,562,000 & 31,119,300 & 31,205,000 \\ \hline & & & & \\ \hline Operating Expenses & & & & \\ \hline Selling General and & & & & \\ \hline Administrative & & & & \\ \hline Operating Income or Loss & 9,042,000 & 11,856,000 & 9,893,700 & 10,469,000 \\ \hline & & & & \\ \hline Income from Continuing & & & & \\ \hline & & & & \\ \hline Operations & & & & \\ \hline Other Income/Expenses Net & 1,148,000 & 1,507,000 & 1,508,400 & 2,256,000 \\ \hline Interest Expense & 1,220,000 & 1,288,000 & 1,207,800 & 853,000 \\ \hline Income Before Tax & 6,674,000 & 9,061,000 & 7,177,500 & 7,360,000 \\ \hline & & & & \\ \hline \end{tabular}

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

Accounting Principles

Authors: Jerry Weygandt, Paul Kimmel, Donald Kieso

11th Edition

111856667X, 978-1118566671

More Books

Students also viewed these Accounting questions