50.1K

Verified Solution

Link Copied!

I am working on an excel document that includes historical and competitor ratios. I am having some difficulty figuring out how to come up with Return on Total Assets (ROA) Return on Stockholders' Equity (ROE) Earnings Per Share (EPS) Price Earnings Ratio. I am attaching screen shots of my excel document. This includes my historical ratio sheet (one showing answers and the other showing formulas) along with the income statements, balance sheets, and statements of cash flow from each company. (These numbers are all based on SEC (10-K) filings from the individual companies.) Northrop Grumman Historical Statement of Cash Flows As of December 31,2022, December 31, 2021, and December 31, 2020 USD ( $ s in Millions OPERATING ACTIVITIES 31-Dec-22 Dec. 31, 2021 Dec. 31, 2020 Net earnings Adjestments to reconcile net earnings to net cash provided by operating 10 Depreciation and amortization 11 Mark-to-market pension and OPB (benefit) expense 12 Stock-based compensation 13 Deferred income taxes 14 Cain on sale of business 15 Net periodic pension and OPB income 16 Pension and OPB contributions Changes in assests and liabilities 18 Accounts reccivables, nct 19 Unbilled receivables, net 20 Inventoried costs, net 21 Prepaid expenses and other assets 22 Accounts payable and other liabilities 23 Income taxes payable, net 24 Other, net Net cash provided by operating activities INVESTING ACTIVITIES Divestiture of IT services business Capital expenditures Proceeds from sale of equipment to a customer Other, net Net cash used for investing activities FINANCING ACTTVTTES Net procceds from issuance of long-term debt Payments of long-term debt Payments to credit facilities Common stock repurchases Cash dividends paid Payments of employee taxes withbeld from share-based awards Other, net Net cash used for financing activities Net change in cash and cash equivalents Cash and cash cquivalents at beginning of year Casb and cash equivalents at end of year As of December 31,2022, December 31, 2021, and Deceember 31,2020 Function Library Current Liabilities Short-term debt and current portion of long-term Accounts payable Customer advances and deposits Other current liabilities Total current liabilities Noncurrent Liabilities Long-term debt, net Other libailities Total noncurrent liabilities Total libilities Stockholders' equity \begin{tabular}{|r|r|r|} \hline 1,253 & 1,005 & 3,003 \\ \hline 3,398 & 3,167 & 2,952 \\ \hline 7,436 & 6,266 & 6,276 \\ \hline 3,254 & 3,540 & 3,733 \\ \hline 15,341 & 13,978 & 15,964 \\ \hline 9,243 & & \\ \hline 8,433 & 10,490 & 9,995 \\ \hline 17,676 & 18,454 & 19,683 \\ \hline 33,017 & 32,432 & 35,647 \\ \hline \hline \end{tabular} Common stock Surplus Retained earnings Treasury stock Accumulated other comprehensive loss Total stockholders' equity Total liabilities and equity General Dynamics Income Statements As of December 31, 2022, December 31, 2021, and December 31, 2020 USD (\$) \$ in Millions \begin{tabular}{|l|l|l|} \hline 31Dec22 & Dec. 31,2021 & Dec. 31,2020 \\ \hline \end{tabular} Revenue Total Revenue Operating costs and expenses General and administrative Operating costs and expenses, Total Operating earnings Other, net Interest,net Earnings before income taxe Provision for income tax,net Net earnings \begin{tabular}{|rrr|} \hline(2,411) & (2,245) & (2,192) \\ (35,196) & (34,306) & (33,792) \\ \hline 4,211 & 4,163 & 4,133 \\ 189 & 134 & 82 \\ (364) & (424) & (477) \\ \hline 4,036 & 3,873 & 3,738 \\ (646) & (616) & (571) \\ \hline $3,390 & $3,257 & $3,167 \\ \hline \hline \end{tabular} \begin{tabular}{|c|cc} \hline & A & B \\ \hline 1 & Lockhead Martin Corp \\ 2 & Historical Statement of Cash Flows \\ 3 & As of December 31, 2022, December 31, 2021, and December 31, 2020 \end{tabular} USD (\$) $ in Millions \begin{tabular}{|l|l|l|} \hline 31-Dec-22 & Dec. 31,2021 & Dec. 31,2020 \\ \hline \end{tabular} OPERATING ACTIVITIES 1 Lockheed Martin Historical Balance Sheets As of December 31, 2022, December 31, 2021, and December 31, 2020 USD (\$) \$ in Millions ASSETS \begin{tabular}{|r|r|r|} \hline Dec. 31, 2022 & Dec. 31,2021 & Dec. 31, 2020 \\ \hline & & \\ \hline$2,547 & $3,604 & $3,160 \\ \hline 2,505 & 1,963 & 1,978 \\ \hline 12,318 & 10,579 & 9,545 \\ \hline 3,088 & 2,981 & 3,545 \\ \hline 533 & 688 & 1,150 \\ \hline 20,991 & 19,815 & 19,378 \\ \hline 7,975 & 7,597 & 7,213 \\ \hline 10,780 & 10,813 & 10,806 \\ \hline 2,459 & 2,706 & 3,012 \\ \hline 3,744 & 2,290 & 3,475 \\ \hline 6,931 & 7,652 & 6,826 \\ \hline 52,880 & 50,873 & 50,710 \\ \hline \hline \end{tabular} LIABILITIES Current Liabilities I am working on an excel document that includes historical and competitor ratios. I am having some difficulty figuring out how to come up with Return on Total Assets (ROA) Return on Stockholders' Equity (ROE) Earnings Per Share (EPS) Price Earnings Ratio. I am attaching screen shots of my excel document. This includes my historical ratio sheet (one showing answers and the other showing formulas) along with the income statements, balance sheets, and statements of cash flow from each company. (These numbers are all based on SEC (10-K) filings from the individual companies.) Northrop Grumman Historical Statement of Cash Flows As of December 31,2022, December 31, 2021, and December 31, 2020 USD ( $ s in Millions OPERATING ACTIVITIES 31-Dec-22 Dec. 31, 2021 Dec. 31, 2020 Net earnings Adjestments to reconcile net earnings to net cash provided by operating 10 Depreciation and amortization 11 Mark-to-market pension and OPB (benefit) expense 12 Stock-based compensation 13 Deferred income taxes 14 Cain on sale of business 15 Net periodic pension and OPB income 16 Pension and OPB contributions Changes in assests and liabilities 18 Accounts reccivables, nct 19 Unbilled receivables, net 20 Inventoried costs, net 21 Prepaid expenses and other assets 22 Accounts payable and other liabilities 23 Income taxes payable, net 24 Other, net Net cash provided by operating activities INVESTING ACTIVITIES Divestiture of IT services business Capital expenditures Proceeds from sale of equipment to a customer Other, net Net cash used for investing activities FINANCING ACTTVTTES Net procceds from issuance of long-term debt Payments of long-term debt Payments to credit facilities Common stock repurchases Cash dividends paid Payments of employee taxes withbeld from share-based awards Other, net Net cash used for financing activities Net change in cash and cash equivalents Cash and cash cquivalents at beginning of year Casb and cash equivalents at end of year As of December 31,2022, December 31, 2021, and Deceember 31,2020 Function Library Current Liabilities Short-term debt and current portion of long-term Accounts payable Customer advances and deposits Other current liabilities Total current liabilities Noncurrent Liabilities Long-term debt, net Other libailities Total noncurrent liabilities Total libilities Stockholders' equity \begin{tabular}{|r|r|r|} \hline 1,253 & 1,005 & 3,003 \\ \hline 3,398 & 3,167 & 2,952 \\ \hline 7,436 & 6,266 & 6,276 \\ \hline 3,254 & 3,540 & 3,733 \\ \hline 15,341 & 13,978 & 15,964 \\ \hline 9,243 & & \\ \hline 8,433 & 10,490 & 9,995 \\ \hline 17,676 & 18,454 & 19,683 \\ \hline 33,017 & 32,432 & 35,647 \\ \hline \hline \end{tabular} Common stock Surplus Retained earnings Treasury stock Accumulated other comprehensive loss Total stockholders' equity Total liabilities and equity General Dynamics Income Statements As of December 31, 2022, December 31, 2021, and December 31, 2020 USD (\$) \$ in Millions \begin{tabular}{|l|l|l|} \hline 31Dec22 & Dec. 31,2021 & Dec. 31,2020 \\ \hline \end{tabular} Revenue Total Revenue Operating costs and expenses General and administrative Operating costs and expenses, Total Operating earnings Other, net Interest,net Earnings before income taxe Provision for income tax,net Net earnings \begin{tabular}{|rrr|} \hline(2,411) & (2,245) & (2,192) \\ (35,196) & (34,306) & (33,792) \\ \hline 4,211 & 4,163 & 4,133 \\ 189 & 134 & 82 \\ (364) & (424) & (477) \\ \hline 4,036 & 3,873 & 3,738 \\ (646) & (616) & (571) \\ \hline $3,390 & $3,257 & $3,167 \\ \hline \hline \end{tabular} \begin{tabular}{|c|cc} \hline & A & B \\ \hline 1 & Lockhead Martin Corp \\ 2 & Historical Statement of Cash Flows \\ 3 & As of December 31, 2022, December 31, 2021, and December 31, 2020 \end{tabular} USD (\$) $ in Millions \begin{tabular}{|l|l|l|} \hline 31-Dec-22 & Dec. 31,2021 & Dec. 31,2020 \\ \hline \end{tabular} OPERATING ACTIVITIES 1 Lockheed Martin Historical Balance Sheets As of December 31, 2022, December 31, 2021, and December 31, 2020 USD (\$) \$ in Millions ASSETS \begin{tabular}{|r|r|r|} \hline Dec. 31, 2022 & Dec. 31,2021 & Dec. 31, 2020 \\ \hline & & \\ \hline$2,547 & $3,604 & $3,160 \\ \hline 2,505 & 1,963 & 1,978 \\ \hline 12,318 & 10,579 & 9,545 \\ \hline 3,088 & 2,981 & 3,545 \\ \hline 533 & 688 & 1,150 \\ \hline 20,991 & 19,815 & 19,378 \\ \hline 7,975 & 7,597 & 7,213 \\ \hline 10,780 & 10,813 & 10,806 \\ \hline 2,459 & 2,706 & 3,012 \\ \hline 3,744 & 2,290 & 3,475 \\ \hline 6,931 & 7,652 & 6,826 \\ \hline 52,880 & 50,873 & 50,710 \\ \hline \hline \end{tabular} LIABILITIES Current Liabilities

Answer & Explanation Solved by verified expert

See Answer