For the companies Lockheed-Martin (LMT) & Northrop-Grumman (NOC)•••[5 pts] Use Macrotrends data to calculate Return on Sales, Return on Assets, DebtRatio, Inventory Turnover, Lead Time for each company[4 pts] Use 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/noc[4 pts] Assuming 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%[2 pts] Find the current stock price for each company[5 pts) Based on the above calculations, which company's stock would you buy, andprovide your reasoning (If neither or both, explain reasoning)

Lockheed-Martin (LMT): Return on Sales (ROS):ROS = Net Income / RevenueYou can find these values…

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

Question content area top Part 1 (Solving a comprehensive problem) Use the end-of-year stock price data in the popup window, LOADING... , to answer the following questions for the Harris and Pinwheel companies. a. Compute the annual rates of return for each time period and for both firms. b. Calculate both the arithmetic and the geometric mean rates of return for the entire three-year period using your annual rates of return from part a. (Note: you may assume that neither firm pays any dividends.) c. Compute a three-year rate of return spanning the entire period (i.e., using the ending price for period 1 and ending price for period 4). d. Since the rate of return calculated in part c is a three-year rate of return, convert it to an annual rate of return by using the following equation: 1+ Three-Year Rate of Return =1+ 3 e. How is the annual rate of return calculated in part d related to the geometric rate of return? When you are…
See Table 2.5 LOADING... showing financial statement data and stock price data for Mydeco Corp. Suppose Mydeco's costs and expenses had been the same fraction of revenues in 2016-2019 as they were in 2015. What would Mydeco's EPS have been each year in this case? Calculate the new EPS for 2016-2019 below: (Round dollar amounts and number of shares to one decimal place. Round percentage amount and the EPS to two decimal places.)
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,…
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…
I need a and b answer
From the information attached below, calculate: a. the average stock return from 20x1- 20x3. b. The standard deviation over the same period.
Suppose the following model describes changes in Company ABC’s sales: ∆ ABCt = 0.078 - 0.095(∆ ABCt-1) The current change (first difference) in the company’s sales growth rate is 0.04. Use this information to answer the questions below. (NB: For all the questions below, give your final answers to 3 decimal places.) 1. Calculate the mean-reverting level for changes in the company’s sales growth rate. (Give your answer in decimals). 2. What is the best prediction of the next change? (Give your answer in decimals) 3. What is the prediction of the change following the next change? (Give your answer in decimals) 4. blanks. Suppose we want to compute the four-quarter moving average of Company ABC’s sales as of the beginning of the first quarter of 2022. ABCs sales in the previous four quarters were as follows: 1Q 2021, R 1,200,000; 2Q 2021, R 800,000; 3Q 2021, R 750,000; and 4Q 2021, R 1,600,000. Calculate the four-quarter moving average of sales as of the beginning of the first…
What is the comparison (analysis) of the Earnings Per Share (EPS) of Industry Average Ratio and the Company A Ratio? The EPS has decreased and increased. Why? Industry Average, Earnings Per Share 2015: RM10.38 2016: RM15.05 2017: RM11.53 2018: RM10.71 2019: RM6.37 Company A, Earnings Per Share 2015: RM5.70 2016: RM3.30 2017: RM6.21 2018: RM6.20 2019: RM4.91
As of 2022 Company (as of October 2022) Apple Microsoft Amazon McDonald's AT&T PE Ratio 23.12 25.46 57.12 23.75 4.87 Dividend Yield 0.55% 1.06% 0.00% 2.37% 9.13% According to the table, why do you think some of the p/e ratios are lower than the others?
Required: Conduct Equity Valuation and Analysis for the years 2018 using: · P/E Ratio· P/B Ratio· PEG Ratio Comment on the results of the year 2018. Give recommendations on how to improve the performance of the company in the coming years.
Compute Topp Company's price-earnings (PE) ratio if its common stock has a market value of $22.20 per share and its earnings per share (EPS) is $4.00. Topp's key competitor, Lower Deck, has a price-earnings (PE) ratio of 9.5. For which company does the market have higher expectations of future performance? Complete this question by entering your answers in the tabs below. Price Earnings Ratio Future Performance Compute Topp Company's price-earnings (PE) ratio if its common stock has a market value of $22.20 per share and its earnings per share (EPS) is $4.00. Choose Numerator: Price Earnings Ratio 1 Choose Denominator: 1 1 Price Earnings Ratio = Price Earnings Ratio

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