Question: Estimating Share Value Using the DCF Model Following are forecasts of Illinois Tool Works Inc. sales, net operating profit after tax (NOPAT), and net operating

Estimating Share Value Using the DCF Model 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 Terminal $ millions 2018 2019 2020 2021 2022 Period Sales $9,599 $10,175 $10,785 $11,433 $12,119 $12,361 NOPAT 1,762 1,872 1,984 2,103 2,230 2,274 NOA 6,150 6,518 6,910 7,324 7,764 7,919 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate 2% Discount rate (WACC) 7.35% Common shares outstanding 213.00 mil

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Estimating Share Value Using the DCF Model 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....

I just need the FIRM EQUITY VALUE for 2 0 1 8 . Given data and already filled in the rest: Estimating Share Value Using the DCF Model Following are forecasts of Illinois Tool Works Inc. sales, net...

Please fill out every blue box in an organized way, thank you! Estimating Share Value Using the DCF Model Following are forecasts of Illinois Tool Works Inc. sales, net operating profit after tax...

Estimating Share Value Using the DCF Model 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....

Estimating Share Value Using the DCF Model Following are forecasts of Illinois Tool Works Inc, sales, net operating profit after tax ( NOPAT ) , and net operating assets ( NOA ) as of December 3 1 ,...

Please provide all work for all questions. please also show work through EXCEL . Thank you for your help! 3-10. Estimating Share Value Using the DCF Model Following are forecasts of Illinois Tool...

pg. 13-27 LO2 E13-16. Estimating Share Value Using the DCF Model Following are forecasts of Illinois Tool Works Inc. sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as...

Estimating Share Value Using the DCF Model 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....

In a short video, 25 minutes, Nouman Ali Khan makes some comments about al-Fatihah https://www.youtube.com/watch?v=_8I6BZQED7E&t=595s This video fascinates me. I would like you to think about it and...

Doorway Diffraction Sound of frequency 1250Hz leaves a room through a 1.0 D-m-wide doorway (see Exercise 36.5). At which angles relative to the centerline perpendicular to the doorway will someone...

5 Multiple Choice 1 point Blood makes up approximately what percent of the body's total weight? 8 % 1 8 % 2 8 %

Today is 1 July 2021. You are looking to purchase an investment property today (after months of research and negotiations). You have spoken to Peter, the loan specialist at Harrison Bank, to...