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.
\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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started