Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show all calculations along with an explanation to ensure I'm doing this correctly(: Thanks for the help! hjkhkmghj Part A: Ratio Analysis (Week 3
Please show all calculations along with an explanation to ensure I'm doing this correctly(: Thanks for the help!
hjkhkmghj
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 0.082 0.11 0.03 Net Profit Margin 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 011 fx D 12/31/18 12/31/17 12/31/16 12/31/15 2 3 4 5 Revenue Total Revenue Cost of Revenue Gross Profit 51,728,000 23,502,000 28,226,000 57,902,000 25,340,000 32,562,000 56,519,100 25,399,800 31,119,300 56,488,000 25,283,000 31,205,000 19,184,000 ,042,000 20,706,000 11,856,000 21,225,600 9,893,700 9 20,736,000 10,469,000 7 Operating Expenses 8 Selling General and Administrative 9 Operating Income or loss 10 11 Income from Continuing Operations 12 Other Income/Expenses Net Y 13 Interest Expense 14 Income Before Tax 1,148,000 1,220,000 6,674,000 -1,507,000 1,288,000 9,061,000 -1,508,400 1,207,800 7,177,500 2,256,000 853,000 7,360,000 15 516 Income Tax Expense 17 Net Income 2,696,000 3,978,000 4,130,000 4,931,000 1,956,600 5,220,900 1,708,000 5,652,000 18 19 20 F17 8 fx 12/31/18 12/31/17 12/31/16 12/31/15 2 Revenue 3 Total Revenue 4 Cost of Revenue 5 Gross Profit 51,728,000 57,902,000 56,519,100 56,488,000 23,502,000 25,340,000 25,399,800 25,283,000 28,226,000 32,562,000 31,119,300 31,205,000 19,184,000 20,706,000 21,225,600 20,736,000 9,042,000 9,042,000 11,856,000 11,856,000 9,895,700 40, 9,893,700 10,469,000 7 Operating Expenses Selling General and Administrative 9 Operating Income or Loss 10 Income from Continuing 11 Operations - 12 Other Income/Expenses Net 13 Interest Expense 14 Income Before Tax -1,148,000 1,220,000 6,674,000 -1,507,000 1,288,000 9,061,000 -1,508,400 1,207,800 7,177,500 -2,256,000 853,000 7,360,000 Income Tax Expense Net Income 2,696,000 3,978,000 4,130,000 4,931,000 1,956,600 5,220,900 1,708,000 5,652,000 D11A 8Gfx 12/31/18 12/31/17 12/31/16 12/31/15 2 3 Revenue Total Revenue Cost of Revenue Gross Profit 51,728,000 23,502,000 28,226,000 57,902,000 25,340,000 32,562,000 56,519,100 25,399,800 31,119,300 56,488,000 25,283,000 31,205,000 5 8 19,184,000 9,042,000 20,706,000 11,856,000 21,225,600 9,893,700 20,736,000 10,469,000 Operating Expenses Selling General and Administrative 9 Operating Income or Loss 10 11 Income from Continuing Operations 12 Other Income/Expenses Net 13 Interest Expense 14 Income Before Ta> 15 116 Income Tax Expense 17 Net Income 18 -1,148,000 1,220,000 6,674,000 1,507,000 1,288,000 9,061,000 1,508,400 1,207,800 7,177,500 2,256,000 853,000 7,360,000 2,696,000 3,978,000 4,130,000 4,931,000 1,956,600 5,220,900 1,708,000 5,652,000 19 J22 X ( fx 12/31/18 | 12/31/17 12/31/16 || 12/31/15 2 3 4 5 6 Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets 8 8,719,000 270,000 7,140,000 3,126,000 2,042,000 21,297,000 2,407,000 17,587,000 14,806,000 15,823,000 5,122,000 77,042,000 10,607,000 8,897,000 7,021,000 2,944,000 43,000 29,512,000 2,039,000 17,237,000 14,741,000 13,835,000 910,000 78,274,000 9,157,000 6,966,000 6,693,000 2,722,000 31,000 25,569,000 1,949,000 16,590,000 14,429,000 13,432,000 635,000 72,604,000 9,095,000 2,912,000 6,436,000 2,719,000 730,000 21,892,000 2,310,000 16,316,000 14,176,000 13,080,000 749,000 68,523,000 11 10 Long Term Investments Property Plant and Equipment 12 Goodwill 13 Intangible Assets 14 Other Assets 15 Total Assets 17 Current Liabilities 18 Accounts Payable 19 Short/Current Long Term Debt 20 Other Current Liabilities 21 Total Current Liabilities 23 Long Term Debt 24 Other Liabilities 25 Total Liabilities 27 Stockholders' Equity 28 Total Stockholder Equity 29 7,211,000 3,951,000 6,601,000 17,763,000 28,293,000 12,611,000 58,667,000 6,724,000 6,157,000 5,545,000 4,017,000 4,400,000 3,108,000 4,112,000 3,870,000 11 3,882,000 14,853,000 14,427,000 12,535,000 33,793,000 30,052,000 29,591,000 14,522,000 11,102,000 10,466,000 63,168,000 55,581,000 52,592,000 18,375,000 15,106,000 17,023,000 15,931,000 011 Cfx 12/31/18 12/31/17 | 12/31/16 12/31/15 51,728,000 23,502,000 28,226,000 57,902,000 25,340,000 32,562,000 56,519,100 25,399,800 31,119,300 56,488,000 25,283,000 31,205,000 19,184,000 9,042,000 20,706,000 11,856,000 21,225,600 9,893,700 20,736,000 10,469,000 2 Revenue 3 Total Revenue 4 Cost of Revenue 5 Gross Profit 6 7 Operating Expenses 8 Selling General and Administrative 9 Operating Income or Loss 10 11 Income from Continuing Operations Other Income/Expenses Net 13 Interest Expense 14 Income Before Tax 15 16 Income Tax Expense 17 Net Income 18 12 -1,148,000 1,220,000 6,674,000 1,507,000 1,288,000 9,061,000 1,508,400 1,207,800 7,177,500 2,256,000 853,000 7,360,000 2,696,000 3,978,000 4,130,000 4,931,000 1,956,600 5,220,900 1,708,000 5,652,000
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