Homework Help is Here – Start Your Trial Now!
Business
Accounting
Estimating Share Value Using the DCF Model Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 2, 2019, which we label fiscal year 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 Terminal 2019 2020 2021 2022 $79,124 $83,830 $87,234 $92,346 Period $93,428 4,767 Sales $76,106 NOPAT 3,269 NOA 23,770 4,152 3,572 4,501 3,939 24,197 26,157 26,677 28,761 28,571 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate 2% Discount rate (WACC) 7.63% Common shares outstanding 517.80 million Net nonoperating obligations (NNO) $12,473 million Estimate the value of a share of Target common stock using the discounted cash flow (DCF) model as of February 2, 2019. ($ millions) Increase in NOA Reported 2018 $ LA Forecast Horizon Terminal 2019 2020 2021 2022 Period 427 $ FCFF (NOPAT - Increase in NOA) Present value of horizon FCFF 3725 1960 $ 1612 520 $ 3981 2084 $ 1855 3461.4 1402.92 3246.03 1420.39 Cum. present value of horizon FCFF $ 0 Present value of terminal FCFF 0 Total firm value NNO 0 12473 Firm equity value $ -12473 Shares outstanding (millions) Stock price per share LA 517.8 24.05

Estimating Share Value Using the DCF Model Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 2, 2019, which we label fiscal year 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 Terminal 2019 2020 2021 2022 $79,124 $83,830 $87,234 $92,346 Period $93,428 4,767 Sales $76,106 NOPAT 3,269 NOA 23,770 4,152 3,572 4,501 3,939 24,197 26,157 26,677 28,761 28,571 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate 2% Discount rate (WACC) 7.63% Common shares outstanding 517.80 million Net nonoperating obligations (NNO) $12,473 million Estimate the value of a share of Target common stock using the discounted cash flow (DCF) model as of February 2, 2019. ($ millions) Increase in NOA Reported 2018 $ LA Forecast Horizon Terminal 2019 2020 2021 2022 Period 427 $ FCFF (NOPAT - Increase in NOA) Present value of horizon FCFF 3725 1960 $ 1612 520 $ 3981 2084 $ 1855 3461.4 1402.92 3246.03 1420.39 Cum. present value of horizon FCFF $ 0 Present value of terminal FCFF 0 Total firm value NNO 0 12473 Firm equity value $ -12473 Shares outstanding (millions) Stock price per share LA 517.8 24.05

Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter10: Stockholder's Equity
Section: Chapter Questions
Problem 88PSA: Ratio Analysis Consider the following information taken from the stockholders equity section: How do...
See similar textbooks
icon
Related questions
Question
Estimating Share Value Using the DCF Model Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 2, 2019, which we label fiscal year 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 Terminal 2019 2020 2021 2022 $79,124 $83,830 $87,234 $92,346 Period $93,428 4,767 Sales $76,106 NOPAT 3,269 NOA 23,770 4,152 3,572 4,501 3,939 24,197 26,157 26,677 28,761 28,571 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate 2% Discount rate (WACC) 7.63% Common shares outstanding 517.80 million Net nonoperating obligations (NNO) $12,473 million Estimate the value of a share of Target common stock using the discounted cash flow (DCF) model as of February 2, 2019. ($ millions) Increase in NOA Reported 2018 $ LA Forecast Horizon Terminal 2019 2020 2021 2022 Period 427 $ FCFF (NOPAT - Increase in NOA) Present value of horizon FCFF 3725 1960 $ 1612 520 $ 3981 2084 $ 1855 3461.4 1402.92 3246.03 1420.39 Cum. present value of horizon FCFF $ 0 Present value of terminal FCFF 0 Total firm value NNO 0 12473 Firm equity value $ -12473 Shares outstanding (millions) Stock price per share LA 517.8 24.05
Transcribed Image Text:Estimating Share Value Using the DCF Model Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 2, 2019, which we label fiscal year 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 Terminal 2019 2020 2021 2022 $79,124 $83,830 $87,234 $92,346 Period $93,428 4,767 Sales $76,106 NOPAT 3,269 NOA 23,770 4,152 3,572 4,501 3,939 24,197 26,157 26,677 28,761 28,571 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate 2% Discount rate (WACC) 7.63% Common shares outstanding 517.80 million Net nonoperating obligations (NNO) $12,473 million Estimate the value of a share of Target common stock using the discounted cash flow (DCF) model as of February 2, 2019. ($ millions) Increase in NOA Reported 2018 $ LA Forecast Horizon Terminal 2019 2020 2021 2022 Period 427 $ FCFF (NOPAT - Increase in NOA) Present value of horizon FCFF 3725 1960 $ 1612 520 $ 3981 2084 $ 1855 3461.4 1402.92 3246.03 1420.39 Cum. present value of horizon FCFF $ 0 Present value of terminal FCFF 0 Total firm value NNO 0 12473 Firm equity value $ -12473 Shares outstanding (millions) Stock price per share LA 517.8 24.05
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
SEE MORE TEXTBOOKS