1 Year 2 Year 3 Sales
Half 1: (in hundreds of thousands) 12 months 1 12 months 2 12 months Three Gross sales 34,734 39,304 42,680 Price of Items Offered 33,550 37,852 40,648 Web Revenue 1,184 1,452 2,032 Property 25,654 27,385 29,903 Whole Debt 11,695 10,498 13,926 Fairness 15,654 15,220 14,727 Working Money Stream 1,998 2,378 Three,186 Funding Money Stream -2,781 -Three,419 -Four,049 Financing Money Stream -692 -287 -244 Required: Given the data in the desk above, calculate the next: Revenue margin on gross sales Return on belongings Return on fairness Whole debt to whole belongings Whole asset turnover Clarify and consider your outcomes as they pertain to profitability, debt, and asset turnover for the corporate over a three-year interval. Have to be reported in excel and present all calculations. Half 2: Report in a MS Excel doc. Present all calculations and conclusions. Establish two gadgets or points that can't be derived from the monetary statements of Common Motors and Ford Motors. Clarify why this stuff or points can be of concern to buyers and different stakeholders. In your rationale, deal with the precise pursuits of the totally different customers of economic statements. Examine and distinction Common Motors and Ford Motors by way of how nicely or how poorly they're performing within the areas of revenue, debt, and asset turnover. Use acceptable ratios in your evaluation. Point out methods for doable enchancment in every space.