Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting An Introduction To Concepts Methods And Uses

Authors: Arnold I. Davidson

2nd Edition

0030597269, 978-0030597268

More Books

Students also viewed these Accounting questions