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.
- Current Ratio
- Quick Ratio
- Operating margin
- Profit margin
- Return on total assets (ROA)
- Return on common equity (ROE)
- Return on invested capital (ROIC)
- Price/Earnings (P/E)
- Market Capitalization
- Shares outstanding
- Dividend and Dividend yield
- Required Rate of Return- Use CAPM model and the Beta posted on the stock quotes to calculate
\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
Get step-by-step solutions from verified subject matter experts
