Answered step by step
Verified Expert Solution
Question
1 Approved Answer
you will use the complete Excel model of the ratios, trends, and financial statements you completed in Week 6 to analyze ABC company. You will
you will use the complete Excel model of the ratios, trends, and financial statements you completed in Week 6 to analyze ABC company. You will present your analysis in the form of an executive memo. maximum 2 pages mention profitability, liquidity, debt, activity, dupont analysis. use an example with a chart
ABC Company Income Statement (000 omitted) Yearending December 31 Net sales Increase (Decrease) YR1 932 YR2 Amount % Change 23.4% 1150 750 305 578 265 172 Cost of goods sold Operating expenses (salaries, rent, utilities) Depreciation Interest expense Income tax expense 29.8% 40 25.0% 0.0% 0.0% Total expenses Net income 1,088 $ 62$ 58 $ 874 4 6.9% ABC Company Balance Sheet (000 omitted) December 31 Cash Accounts receivable Inventory Increase (Decrease) Amount 102 10 YR2 YR1 %Change 463.6% 52.6% 42% 123.6% 29.1% 31.6% 66.7% 26.7% 65.2% $ 124 S 22 S 19 199 Total curent assets Investments Gross property, plant and equipment Accumulated Depreciation Total long term assets Total assets 16 125 30 135 36 $ 370 224 $ 146 LIABILITIES AND NETASSETS Accounts payable Interest payable $ 30 S 36 (6) -16.7% 315% -20.5% 194.1% 194.1% 92.3% 63.3% 748% 65.2% Total current liabilities Notes payable Total long-tem liabilities Common stock Retained 125 160 285 earnings 163 $ 370 224 $ Total stockholders' equi 122 Total liabilities and stockholders' equi 146Step 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