Please show all work along with how you came to your answers so I can ensure I'm doing this correctly please (: both excel files are the same, just wanted to ensure you could read the numbers.

This is all of the information provided to answer those two questions, are you sure that is needed?

Option #1: Corporate Finance Application Part A: Ratio Analysis (Week 3 Milestone) Attached are the financial statements for Smith Company, Inc. Use the financial statements to calculate the attached ratios. Write a couple sentences interpreting the ratio. Calculate and interpret the following debt ratios: debt ratio, debt-equity ratio, and times interest earned. Calculate and interpret the following profitability ratios Joperating profit margin, net profit margin, return on assets, and return on equity. Chart Alignment Data SmartArt Number General Formulas Format Edit Font Calibri (Body) 11 BI U de J22A8 Gfx Paste - % ) Align Conditional Formatting Styles 12/31/18 CANDLINE 12/31/17 12/31/16 12/31/15 5 6 7 8 Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets 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 9,095,000 6,966,000 2,912,000 6,693,000 6,436,000 2,722,000 2,719,000 31,000 730,000 25,569,000 21,892,000 1,949,000 2,310,000 16,590,000 16,316,000 14,429,000 14,176,000 13,432,000 13,080,000 635,000 749,000 72,604,000 68,523,000 10 Long Term Investments Property Plant and Equipment Goodwill Intangible Assets Other Assets Total Assets 15 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 Stockholders' Equity 28 Total Stockholder Equity 7,211,000 3,951,000 6,601,000 17,763,000 28,293,000 12,611,000 58,667,000 6,724,000 4,017,000 4,112,000 14,853,000 33,793,000 14,522,000 63,168,000 6,157,000 4,400,000 3,870,000 14,427,000 30,052,000 11,102,000 55,581,000 5,545,000 3,108,000 3,882,000 12,535,000 29,591,000 10,466.000 52,592,000 18,375,000 15,106,000 17,023,000 15,931,000 29 Income Statement Projects + Balance Sheet R eady Normal View A B 12/31/18 C 12/31/17 D 12/31/16 E 12/31/15 COVOUANLI Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets 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 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 12 10 Long Term Investments 11 Property Plant and Equipment 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 7,211,000 3,951,000 6,601,000 17,763,000 28,293,000 12,611,000 58,667,000 6,724,000 4,017,000 4,112,000 14,853,000 33,793,000 14,522,000 63,168,000 6,157,000 4,400,000 3,870,000 14,427,000 30,052,000 11,102,000 55,581,000 5,545,000 3,108,000 3,882,000 12,535,000 29,591,000 10,466,000 52,592,000 27 28 29 Stockholders' Equity Total Stockholder Equity 18,375,000 15,106,000 17,023,000 15,931,000 30 Option #1: Corporate Finance Application Part A: Ratio Analysis (Week 3 Milestone) Attached are the financial statements for Smith Company, Inc. Use the financial statements to calculate the attached ratios. Write a couple sentences interpreting the ratio. Calculate and interpret the following debt ratios: debt ratio, debt-equity ratio, and times interest earned. Calculate and interpret the following profitability ratios: operating profit margin. net profit margin, return on assets, and return on equity. Part B: Require Return for Capital Funding (Week 5 Milestone) Sunnnce that Smith Company is considering a new project. They are trying to Font 8 Alignment Number Format General Align Tea m Conditional Formatting Styles F Calibri (Body) BI U AA- Paste G23 88 O fx 1 B 12/31/18 Current Assets 3 Cash And Cash Equivalents 8,719,000 Short Term Investments 270,000 5 Net Receivables 7,140,000 6 Inventory 3,126,000 Other Current Assets 2,042,000 8 Total Current Assets 21,297,000 C 12/31/17 D 12/31/16 E 12/31/15 AWN 10,607,000 8,897,000 7,021,000 2,944,000 43,000 29,512,000 9,157,000 6,966,000 6,693,000 2,722,000 31,000 25,569,000 9,095,000 2,912,000 6,436,000 2,719,000 730,000 21,892,000 10 Long Term Investments 11 Property Plant and Equipment 12 Goodwill 13 Intangible Assets 14 Other Assets 15 Total Assets 2,407,000 2,039,000 17,587,000 17,237,000 14,806,000 14,741,000 15,823,000 13,835,000 5,122,000 910,000 77,042,000 78,274,000 1,949,000 2,310,000 16,590,000 16,316,000 14,429,000 14,176,000 13,432,000 13,080,000 635,000 749,000 72,604,000 68,523,000 17 Current Liabilities 18 Accounts Payable 19 Short/Current Long Term Debt 20 Other Current Liabilities 21 Total Current Liabilities Long Term Debt Other Liabilities 25 Total Liabilities 27 Stockholders' Equity 28 Total Stockholder Equity 7,211,000 3,951,000 6,601,000 17,763,000 28,293,000 12,611,000 58,667,000 6,724,000 4,017,000 4,112,000 14,853,000 33,793,000 14,522,000 63,168,000 6,157,000 4,400,000 3,870,000 14,427,000 30,052,000 11,102,000 55,581,000 5,545,000 3,108,000 3,882,000 12,535,000 29,591,000 10,466,000 52,592,000 18,375,000 15,106,000 17,023,000 15,931,000