Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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. $ millions Net operating assets (NOA) Net nonoperating obligations (NNO) Total stockholders' equity Net nonoperating expenses (NNE) Net operating profit after tax (NOPAT) Net income Revenue 2019 2018 2017 560 $21,714 $25,036 $24,275 15,238 15.897 14,675 4,191 6.754 7,399 568 578 2,801 3.941 3,596 2,661 3,964 3,557 71,309 68.619 65,017 Below are the adjustments that analysts would use to account for Lowe's operating leases as if they were capitalized. Adjustments are based on the present value of Lowe's operating leases for fiscal years 2017-2019. Balance Sheet Adjustments ($ millions) 2019 2018 2017 Net operating assets (NOA) $4,356 $4,693 $4,658 Net nonoperating obligations (NNO) Equity 5,009 5,397 5,357 0 0 0 Income Statement Adjustments ($ millions) 2019 2018 2017 Interest expense Net nonoperating expense, NNE $174 $188 $186 136 146 145 Net operating profit after tax, NOPAT 136 146 145 Net income D 0 a. Compute the following ratios using the unadjusted and the adjusted numbers for each year. For simplicity only, use year-end balances for NOA, NNO, and equity. 2019 2018 2017 Unadjusted Adjusted Unadjusted Adjusted Unadjusted Adjusted ROE 0% x 0% x DX 0% X 0% * 0% RNDA 0% * 0% * D 60 0% * 0% x NOPM 0% x 0% x 0% x 0% x 0% x 0% * NOAT 0 x 0 x 0 x 0 x 0 x FLEV 0 x 0 x 0 x 0 x 0 % 0 % 0x
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started