Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Research Methods In Accounting

Authors: Malcolm Smith

6th Edition

1529779774, 978-1529779776

More Books

Students also viewed these Accounting questions