For the companies Lockheed-Martin (LMT) & Northrop-Grumman (NOC)Use Macrotrends data to calculate Return on Sales, Return on Assets, DebtRatio, Inventory Turnover, Lead Time for each companyUse Fintel to determine EPS forecasts for 2024-2027 for each company, and usethose to calculate an average earnings growth rate for each-https://fintel.io/sfo/us/Imthttps://fintel.io/sfo/us/nocAssuming MARR = WACC + 3%, calculate a fair market price for the stock ofeach company, assuming that earnings grow at the calculated rate for the next 50years, with the following WACCLMT:NOC:8.00%8.25%Find the current stock price for each companyBased on the above calculations, which company's stock would you buy, andprovide your reasoning (If neither or both, explain reasoning)

I find no data in attached link. Please give me the full data or just follow the steps provided to…

Answered: For the companies Lockheed-Martin (LMT)…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Forecasting with the Parsimonious Method and Estimating Share Value Using the DCF Model Following are income statements and balance sheets for Cisco Systems. Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places. Cisco Systems Consolidated Statements of Income Years Ended December ($ millions) July 27, 2019 July 28, 2018 Revenue Product $33,544 $31,570 Service 11,093 10,854 Total revenue 44,637 42,424 Cost of sales Product 12,782 12,407 Service 3,763 3,695 Total cost of sales 16,545 16,102 Gross margin 28,092 26,322 Operating expenses Research and development 5,656 5,446 Sales and marketing 8,231 7,948 General and administrative 1,571 1,844 Amortization of purchased intangible assets 129 190 Restructuring and other charges 277 308 Total operating expenses 15,864 15,736 Operating income 12,228 10,586 Interest income 1,125 1,297 Interest expense (739) (811) Other…
Suppose a company has had the historic sales figures shown below. What would be the forecast for next years sales using the average approach?
Following are forecasts of Illinois Tool Works Inc. sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018. Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places. Reported Forecast Horizon Period $ millions 2018 2019 2020 2021 2022 Sales $14,030 $14,871 $15,763 $16,710 $17,712 NOPAT NOA Terminal Period $18,066 2,711 2,880 3,053 3,236 3,430 8,989 9,527 10,099 10,705 11,347 3,499 11,574 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate Discount rate (WACC) 2% 7.35% Common shares outstanding 328.1 million Net nonoperating obligations (NNO) $5,894 million (a) Estimate the value of a share of ITW's common stock using the residual operating income model (ROPI) model as of December 31, 2018. Forecast Horizon ($ millions) Reported 2018 Terminal 2019 2020 2021 2022 Period ROPI…
please show excel formulas
Estimating Share Value Using the ROPI Model Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Terminal Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal place Reported Horizon period $ millions 2018 2019 2020 2021 2022 Period Sales $56,880 $57,734 $58,600 $59,480 $60,372 2,492 2,542 2,580 2.619 2,658 4,000 4,065 4,126 4,189 4,252 NOPAT NOA $60,976 2,684 4,295 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate Discount rate (WACC) 19 7.8% Common shares outstanding 135.6 million Net nonoperating obligations (NNO) S(6,161) million NNO is negative because Humana's nonoperating assets exceed its nonoperating liabilities. (a) Estimate the value of a share of common stock using the residual operating income (ROPI) model as of December 31,…
Suppose a firm has had the historical sales figures shown as follows. What would be the forecast for next year's sales using the average approach? Year 2017 2018 Sales $ 750,000 500,000 Multiple Choice O $695,000 $700,000 $750,000 $775.000 2019 $ 700,000 2020 $ 750,000 2021 $ 775,000
Calculate the projected price/earnings ratio and market/book ratio. Explain whether these ratios indicate that investors will be expected to have a high or low opinion of the company. Computron's Balance Sheets (Millions of Dollars) 2019 2020 Assets Cash and equivalents $ 60 $ 50 Short-term investments 100 10 Accounts receivable 400 520 Inventories 620 820 Total current assets $ 1,180 $ 1,400 Gross fixed assets $ 3,900 $ 4,820 Less: Accumulated depreciation 1,000 1,320 Net fixed assets $ 2,900 $ 3,500 Total assets $ 4,080 $ 4,900 Liabilities and equity Accounts payable $ 300 $ 400 Notes payable 50 250 Accruals 200 240 Total current liabilities $ 550 $ 890 Long-term bonds 800 1,100 Total liabilities $ 1,350 $ 1,990 Common stock 1,000 1,000 Retained earnings 1,730 1,910 Total equity $ 2,730 $ 2,910 Total liabilities and equity $ 4,080 $ 4,900…
Toby’s forecasted 2021 financial statements follow, along with some industry average ratios. Calculate Toby’s 2021 forecasted ratios and fill in the above table. Calculate the EPS and DPS. The company has a 40% payout ratio. Please provide the solutions for the EPS, DPS, Days Sales Outstanding, Fixed Asset Turnover, Total Asset Turnover, Return on Assets, Return on Equity, Total Debt Ratio, Profit Margin on Sales, P/E Ratio.
Perform a liquidity and profitability analysis on your company utilizing the ratios listed below. Quick Ratio, Receivable Turnover, Days sales uncollected, inventory turnover, Days inventory on hand, payable turnover, days payable, asset turnover, return on assets, and return on equity. statement of operations 12 Months Ended Jul. 31, 2020 Jul. 31, 2019 Revenues: Revenues $ 1,497,826,000 $ 1,684,392,000 Costs and expenses: Operating expense - personnel, vehicle, plant and other 493,055,000 468,868,000 Operating expense - equipment lease expense 33,017,000 Equipment lease expense, preadoption 33,073,000 Depreciation and amortization expense 80,481,000 78,846,000 General and administrative expense 45,752,000 59,994,000 Non-cash employee stock ownership plan compensation charge 2,871,000 5,693,000 Asset impairments 0 0 Loss on asset sales and disposals 7,924,000 10,968,000 Operating income 148,670,000 113,028,000 Interest expense…
Suppose a firm has had the following historic sales figures. What would be the forecast for next year's sales using the average approach? You must use the built-in Excel function to answer this question. Input area: Year Sales 2016 2017 2018 es es e $ 1,500,000 $ 1,750,000 $ 1,400,000 2019 $ 2,000,000 2020 $ 1,600,000 Output area: Next year's sales
How do i find the industry ratios for Walmart and Target 2022, comparing both retailers, Gross Margin Ratio, Profit Margin Ratio and Return on Asset to the industry.
Calculate ROI for 2017. Calculate ROE for 2017. Calculate working capital at July 30, 2017, and July 31, 2016. Calculate current ratio at July 30, 2017, and July 31, 2016. Calculate Acid-test ratio at July 30, 2017, and July 31, 2016.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS