Estimating Share Value Using the ROPI Model Following are forecasts of Target Corporation's sales, net operating...

Transcribed Image Text:

Estimating Share Value Using the ROPI 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 Terminal 2019 Sales NOPAT NOA millions 2018 2020 $76,656 $79,124 $84,380 $87,234 $92,896 3,269 4,702 3,572 5,051 3,939 24,320 25,497 26,707 27,977 29,311 2021 2022 Period $93,428 5,317 29,871 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) $13,023 million Estimate the value of a share of Target common stock using the residual operating income (ROPI) model as of February 2, 2019. ($ millions) Reported 2018 Forecast Horizon Terminal 2019 2020 2021 2022 Period $ $ 0 * $ 0 * $ 0 * $ 0 x 0 0 0 x 0 x ROPI (NOPAT -[NOABeg x rw]) Present value of horizon ROPI Cum present value of horizon ROPI $ Present value of terminal ROPI NOA Total firm value 0 x 0 0 0 Less NNO 13,023 Firm equity value $ 0 % Shares outstanding (millions) 517.8 Stock price per share $ 0 x Estimating Share Value Using the ROPI 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 Terminal 2019 Sales NOPAT NOA millions 2018 2020 $76,656 $79,124 $84,380 $87,234 $92,896 3,269 4,702 3,572 5,051 3,939 24,320 25,497 26,707 27,977 29,311 2021 2022 Period $93,428 5,317 29,871 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) $13,023 million Estimate the value of a share of Target common stock using the residual operating income (ROPI) model as of February 2, 2019. ($ millions) Reported 2018 Forecast Horizon Terminal 2019 2020 2021 2022 Period $ $ 0 * $ 0 * $ 0 * $ 0 x 0 0 0 x 0 x ROPI (NOPAT -[NOABeg x rw]) Present value of horizon ROPI Cum present value of horizon ROPI $ Present value of terminal ROPI NOA Total firm value 0 x 0 0 0 Less NNO 13,023 Firm equity value $ 0 % Shares outstanding (millions) 517.8 Stock price per share $ 0 x