Instructions Students must submit a document (MS Excel or Word file) that provides the detailed calculations for the following ratios for the most recent two fiscal years, one calculation for each year for Ford Motorvehicle. To provide the detail, include the figures used from the financial statements from Component 2. Attach the financial statements, if possible. 1. Current Ratio 2. Quick Ratio 3. Operating margin 4. Profit margin 5. Return on total assets (ROA) 6. Return on common equity (ROE) 7. Return on invested capital (ROIC) 8. Price/Earnings (P/E) 9. Market Capitalization 10. Shares outstanding 11. Dividend and Dividend yield 12. Required Rate of Return- Use CAPM model and the Beta posted on the stock quotes to calculate Use the general format: Show work. This information can be formatted using the table below in Word or using Excel or combination of both with Excel included in a word document. Be sure to include financial statements. This is one example of how information may be formatted. Feel free to use a format that makes logical sense to you.

Students must submit a document (MS Excel or Word file) that provides the detailed calculations for the ollowing ratios for the most recent two fiscal years, one calculation for each year. To provide the detail, include the figures used from the financial statements from Component 2. Attach the financial statements, if possible. 1. Current Ratio 2. Quick Ratio 3. Operating margin 4. Profit margin 5. Return on total assets (ROA) . 6. Return on common equity (ROE) 7. Return on invested capital (ROIC) 8. Price/Earnings (P/E) 9. Market Capitalization 10. Shares outstanding 11. Dividend and Dividend yield 12. Required Rate of Return-Use CAPM model and the Beta posted on the stock quotes to calculate Use the general format: Show work. This information can be formatted using the table below in Word or using Excel or combination of both with Excel included in a word document. Be sure to include financial statements. This is one example of how information may be formatted. Feel free to use a format that makes logical sense to you. Students must submit a document (MS Excel or Word file) that provides the detailed calculations for the ollowing ratios for the most recent two fiscal years, one calculation for each year. To provide the detail, include the figures used from the financial statements from Component 2. Attach the financial statements, if possible. 1. Current Ratio 2. Quick Ratio 3. Operating margin 4. Profit margin 5. Return on total assets (ROA) . 6. Return on common equity (ROE) 7. Return on invested capital (ROIC) 8. Price/Earnings (P/E) 9. Market Capitalization 10. Shares outstanding 11. Dividend and Dividend yield 12. Required Rate of Return-Use CAPM model and the Beta posted on the stock quotes to calculate Use the general format: Show work. This information can be formatted using the table below in Word or using Excel or combination of both with Excel included in a word document. Be sure to include financial statements. This is one example of how information may be formatted. Feel free to use a format that makes logical sense to you