Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Net Operating Working Capital (NOWC) 2) Total net operating Capital (TOC) 3) Investment in Total Net Operating Capital (Inv. In TOC) 4) Net Operating

1) Net Operating Working Capital (NOWC)

2) Total net operating Capital (TOC)

3) Investment in Total Net Operating Capital (Inv. In TOC)

4) Net Operating Profit after Taxes (NOPAT)

5) Free Cash Flow (FCF)

6) Economic Value Added (EVA)

You may assume a wacc=5% and estimate the tax rate (T) using the equation below:

taxes paid/taxable income. Both values are found in the income statement.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Calculate all (6) --1. NOWC, 2.TOC, 3.INV. In TOC, 4. NOPAT, 5. FCF and 6. EVA
Please
E148 B A 1 Home Depot Balance Sheet 2. Name 3 Total Assets 4 Total Current Assets 5 Cash, Cash Equivalents and Short Term Investments 6 Cash and Cash Equivalents 7 Inventories 8 Finished Goods and Merchandise 9 Trade and Other Receivables, Current 10 Trade/Accounts Receivable, Current 11 Other Receivables, Current 12 Other Current Assets 13 Total Non-Current Assets 14 Net Property, Plant and Equipment 15 Gross Property, Plant and Equipment 16 Properties 17 Land and Improvements 18 Buildings and Improvements 19 Leasehold and Improvements 20 Machinery, Furniture and Equipment 21 Furniture, Fixtures and Office Equipment 22 Construction in Progress and Advance Payments 23 Leased Property. Plant and Equipment Home Depot 2019 Sheet2 2019 44,003,000,000 18,529,000,000 1,778,000,000 1,778,000,000 13,925,000,000 13,925,000,000 1,936,000,000 1,640,000,000 296,000,000 890,000,000 25,474,000,000 22,375,000,000 42,939,000,000 28,267,000,000 8,363,000,000 18,199,000,000" 1,705,000,000 12,460,000,000 12,460,000,000 820.000.000 1,392,000,000 DECO -------- E148 B -20,564,000,000 -20,564,000,000 2.252,000,000 2,252,000,000 2,252,000,000 847,000,000 A 24 Accumulated Depreciation and Impairment 25 Accumulated Depreciation 26 Net Intangible Assets 27 Gross Goodwill and Other Intangible Assets 28 Goodwill 29 Intangibles other than Goodwill 30 Other Non-Current Assets 31 Trade and Other Receivables, Non-Current 32 Notes Receivable, Non-Current 33 Total Liabilities 34 Total Current Liabilities 35 Payables and Accrued Expenses, Current 36 Trade and Other Payables, Current 37 Trade/Accounts Payable, Current 38 Taxes Payable, Current 39 Accrued Expenses, Current 40 Financial Liabilities, Current 41 Current Debt and Capital Lease Obligation 42 Current Debt 43 Current Portion of Long Term Debt and Capital Lease 44 Deferred Liabilities, Current 45 Deferred Income/Customer Advances/Billings in Excess of Cost, Current 46 Total Non-Current Liabilities 45,881,000,000 16,716,000,000 12,539,000,000 8,422,000,000 7,755,000,000 667,000,000 4,117,000,000 2,395,000,000 2,395,000,000 1,339,000,000 1,056,000,000 1,782,000,000 1,782,000,000 29,165,000,000 Azan L. AL-- Home Depot 2019 Sheet2 + 46 Total Non-Current Liabilities 47 Financial Liabilities, Non-Current 48 Long Term Debt and Capital Lease Obligation 49 Long Term Debt 50 Tax Liabilities, Non-Current 51 Deferred Tax Liabilities, Non-Current 52 Other Non-Current Liabilities 53 Total Equity 54 Equity Attributable to Parent Stockholders 55 Paid in Capital 56 Capital Stock 57 Common Stock 58 Additional Paid in Capital/Share Premium 59 Treasury Stock 60 Retained Earnings/Accumulated Deficit 61 Reserves/Accumulated Comprehensive Income/Losses 62 Common Shares Issued 63 Common Shares Outstanding 64 Common Shares Treasury 65 Fiscal year ends in Jan 31 USD 66 B 29,165,000,000 26,807,000,000 26,807,000,000 26,807,000,000 491.000.000 491,000,000 1,867,000,000 -1,878,000,000 -1,878,000,000 -47,529,000,000 10,667,000,000 89,000,000 10,578,000,000 -58, 196,000,000 46,423,000,000 -772,000,000 1,105,000,000 1,105,000,000 677,000,000 E14 B 68 Home Depot income Statement 69 Name 70 Gross Profit 71 Total Revenue 72 Business Revenue 73 Cost of Revenue 74 Cost of Goods and Services 75 Operating Income/Expenses 76 Selling, General and Administrative Expenses 77 Depreciation, Amortization and Depletion 78 Depreciation and Amortization 79 Total Operating Profit/Loss 80 Non-Operating Income/Expenses, Total 81 Total Net Finance Income/Expense 82 Net Interest Income/Expense 83 Interest Expense Net of Capitalized Interest 84 Interest Income 85 Irregular Income/Expenses 86 Impairment/Write Off/Write Down of Capital Assets 87 Other Income/Expense, Non-Operating 88 Pretax Income 89 Provision for Income Tax 90 Net Income from Continuing Operations ----- Home Depot 2019 2019 37,160,000,000 108,203,000,000 108,203,000,000 -71,043,000,000 -71,043,000,000 -21,383,000,000 -19,513,000,000 -1,870,000,000 -1,870,000,000 15777000000 -1,221,000,000 -958,000,000 -958,000,000 -1,051,000,000 93,000,000 -247,000,000 -247,000,000 -16,000,000 14,556,000,000 -3,435,000,000 11.121,000,000 14. Annan 4 Sheet2 11,121,000,000 11,121,000,000 11,121,000,000 11,121,000,000 90 Net Income from Continuing Operations 91 Net Income after Extraordinary Items and Discontinued Operations 92 Net Income after Non-Controlling/Minority Interests 93 Net Income Available to Common Stockholders 94 Diluted Net Income Available to Common Stockholders 95 Discontinued Operations 96 Reported Total Revenue 97 Reported Operating Expense 98 Reported Total Operating Profit/Loss 99 Reported Effective Tax Rate 100 Fiscal year ends in Jan 31 USD 101 108,203,000,000 -21,630,000,000 15,530,000,000 0 Home Depot 2019 Sheet2 E148 B A 1 Home Depot Balance Sheet 2. Name 3 Total Assets 4 Total Current Assets 5 Cash, Cash Equivalents and Short Term Investments 6 Cash and Cash Equivalents 7 Inventories 8 Finished Goods and Merchandise 9 Trade and Other Receivables, Current 10 Trade/Accounts Receivable, Current 11 Other Receivables, Current 12 Other Current Assets 13 Total Non-Current Assets 14 Net Property, Plant and Equipment 15 Gross Property, Plant and Equipment 16 Properties 17 Land and Improvements 18 Buildings and Improvements 19 Leasehold and Improvements 20 Machinery, Furniture and Equipment 21 Furniture, Fixtures and Office Equipment 22 Construction in Progress and Advance Payments 23 Leased Property. Plant and Equipment Home Depot 2019 Sheet2 2019 44,003,000,000 18,529,000,000 1,778,000,000 1,778,000,000 13,925,000,000 13,925,000,000 1,936,000,000 1,640,000,000 296,000,000 890,000,000 25,474,000,000 22,375,000,000 42,939,000,000 28,267,000,000 8,363,000,000 18,199,000,000" 1,705,000,000 12,460,000,000 12,460,000,000 820.000.000 1,392,000,000 DECO -------- E148 B -20,564,000,000 -20,564,000,000 2.252,000,000 2,252,000,000 2,252,000,000 847,000,000 A 24 Accumulated Depreciation and Impairment 25 Accumulated Depreciation 26 Net Intangible Assets 27 Gross Goodwill and Other Intangible Assets 28 Goodwill 29 Intangibles other than Goodwill 30 Other Non-Current Assets 31 Trade and Other Receivables, Non-Current 32 Notes Receivable, Non-Current 33 Total Liabilities 34 Total Current Liabilities 35 Payables and Accrued Expenses, Current 36 Trade and Other Payables, Current 37 Trade/Accounts Payable, Current 38 Taxes Payable, Current 39 Accrued Expenses, Current 40 Financial Liabilities, Current 41 Current Debt and Capital Lease Obligation 42 Current Debt 43 Current Portion of Long Term Debt and Capital Lease 44 Deferred Liabilities, Current 45 Deferred Income/Customer Advances/Billings in Excess of Cost, Current 46 Total Non-Current Liabilities 45,881,000,000 16,716,000,000 12,539,000,000 8,422,000,000 7,755,000,000 667,000,000 4,117,000,000 2,395,000,000 2,395,000,000 1,339,000,000 1,056,000,000 1,782,000,000 1,782,000,000 29,165,000,000 Azan L. AL-- Home Depot 2019 Sheet2 + 46 Total Non-Current Liabilities 47 Financial Liabilities, Non-Current 48 Long Term Debt and Capital Lease Obligation 49 Long Term Debt 50 Tax Liabilities, Non-Current 51 Deferred Tax Liabilities, Non-Current 52 Other Non-Current Liabilities 53 Total Equity 54 Equity Attributable to Parent Stockholders 55 Paid in Capital 56 Capital Stock 57 Common Stock 58 Additional Paid in Capital/Share Premium 59 Treasury Stock 60 Retained Earnings/Accumulated Deficit 61 Reserves/Accumulated Comprehensive Income/Losses 62 Common Shares Issued 63 Common Shares Outstanding 64 Common Shares Treasury 65 Fiscal year ends in Jan 31 USD 66 B 29,165,000,000 26,807,000,000 26,807,000,000 26,807,000,000 491.000.000 491,000,000 1,867,000,000 -1,878,000,000 -1,878,000,000 -47,529,000,000 10,667,000,000 89,000,000 10,578,000,000 -58, 196,000,000 46,423,000,000 -772,000,000 1,105,000,000 1,105,000,000 677,000,000 E14 B 68 Home Depot income Statement 69 Name 70 Gross Profit 71 Total Revenue 72 Business Revenue 73 Cost of Revenue 74 Cost of Goods and Services 75 Operating Income/Expenses 76 Selling, General and Administrative Expenses 77 Depreciation, Amortization and Depletion 78 Depreciation and Amortization 79 Total Operating Profit/Loss 80 Non-Operating Income/Expenses, Total 81 Total Net Finance Income/Expense 82 Net Interest Income/Expense 83 Interest Expense Net of Capitalized Interest 84 Interest Income 85 Irregular Income/Expenses 86 Impairment/Write Off/Write Down of Capital Assets 87 Other Income/Expense, Non-Operating 88 Pretax Income 89 Provision for Income Tax 90 Net Income from Continuing Operations ----- Home Depot 2019 2019 37,160,000,000 108,203,000,000 108,203,000,000 -71,043,000,000 -71,043,000,000 -21,383,000,000 -19,513,000,000 -1,870,000,000 -1,870,000,000 15777000000 -1,221,000,000 -958,000,000 -958,000,000 -1,051,000,000 93,000,000 -247,000,000 -247,000,000 -16,000,000 14,556,000,000 -3,435,000,000 11.121,000,000 14. Annan 4 Sheet2 11,121,000,000 11,121,000,000 11,121,000,000 11,121,000,000 90 Net Income from Continuing Operations 91 Net Income after Extraordinary Items and Discontinued Operations 92 Net Income after Non-Controlling/Minority Interests 93 Net Income Available to Common Stockholders 94 Diluted Net Income Available to Common Stockholders 95 Discontinued Operations 96 Reported Total Revenue 97 Reported Operating Expense 98 Reported Total Operating Profit/Loss 99 Reported Effective Tax Rate 100 Fiscal year ends in Jan 31 USD 101 108,203,000,000 -21,630,000,000 15,530,000,000 0 Home Depot 2019 Sheet2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions