Question: 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.

Please help me answer Part A. Thank you! Part A: Ratio Analysis

\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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!