Question: 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

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. 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 Students must submit a document (MS Excel or Word file) that provides

\begin{tabular}{|c|c|c|c|} \hline Annual Data | Millions of US $ except per share data & & 20221231 & 20211231 \\ \hline Revenue & Lll & $8,399 & $5,992 \\ \hline Cost Of Goods Sold & l & $1,499 & $1,156 \\ \hline Gross Profit & Lll & $6,900 & $4,836 \\ \hline Research And Development Expenses & Lll & $1,502 & $1,425 \\ \hline SG\&A Expenses & Lll & $3,507 & $2,869 \\ \hline Other Operating Income Or Expenses & & - & - \\ \hline Operating Expenses & Lll & $5,098 & $4,407 \\ \hline Operating Income & Lll & $1,802 & $429 \\ \hline Total Non-Operating Income/Expense & Lll & $187 & $729 \\ \hline Pre-Tax Income & Lll & $1,989 & S-300 \\ \hline Income Taxes & Lll & $96 & $52 \\ \hline Income After Taxes & Lll & $1,893 & S-352 \\ \hline Other Income & & - & - \\ \hline Income From Continuous Operations & Lll & $1,893 & S-352 \\ \hline \multicolumn{4}{|l|}{ Income From Discontinued Operations } \\ \hline Net Income & Lll & $1,893 & S-352 \\ \hline EBITDA & Lll & $1,883 & $567 \\ \hline EBIT & Lll & $1,802 & $429 \\ \hline Basic Shares Outstanding & Lll & 637 & 616 \\ \hline Shares Outstanding & Lll & 680 & 616 \\ \hline Basic EPS & Lll & $2.97 & $0.57 \\ \hline EPS - Earnings Per Share & & $2.79 & $0.57 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!