This Portfolio Project has two parts: Calculations and a 4- to 6-page essay. While the calculation requirements of this assignment are important, equally important are your discussion and analysis of the quantitative results. You will submit two documents: 1) a spreadsheet containing your horizontal and vertical analysis (and perhaps your ratios) in Module 7 and 2) a word document containing your essay in Module 8.You will submit both parts separately. See the Portfolio Project Part One and Part Two grading rubrics, located in the Module 7 and Module 8 folders. In Module 7, you submitted your spreadsheet. For this module, you will take what you submitted in your spreadsheet, and use that information to write your paper.

Directions:

Your paper must:

• Be 4-6 pages in length.
• Include a proper introduction and conclusion.
• Include a reference page.
• Provide your reader with an overall understanding of the financial health of your chosen firm including the following:
• • Discussion of the ratio analysis results, including rationale for the ratios chosen.
  • Discussion of all horizontal and vertical analysis from above.
  • Discussion of four items from the management discussion of the firmthat support the conclusion formed in your discussion of the financial results.

Finally, read through the Portfolio Project Part Two Grading Rubric in the Module 8 folder that will be used to grade your assignment?you will get a feeling for expectations by doing so. Your instructor is here to help you through this project. If you have questions, please let your instructor know. He or she may be willing to take a quick look at your horizontal and vertical analysis to give you feedback in advance since you will not have had much experience on that calculation prior to the project. Always communicate right away with your instructor when you need assistance!

Can you please help me write a paper on the file attached ?

Home Depot [HD], Inc. Consolidated Balance Sheets - USD ($) $ in Millions Current Assets: Cash and Cash Equivalents Receivables, net Merchandise Inventories Other Current Assets Total Current Assets Property and Equipment, at cost Less Accumulated Depreciation and Amortization Net Property and Equipment Goodwill Other Assets Total Assets Current Liabilities: Short-Term Debt Accounts Payable Accrued Salaries and Related Expenses Sales Taxes Payable Deferred Revenue Income Taxes Payable Current Installments of Long-Term Debt Other Accrued Expenses Total Current Liabilities Long-Term Debt, excluding current installments Other Long-Term Liabilities Deferred Income Taxes Total Liabilities STOCKHOLDERS' EQUITY Common Stock, par value $0.05; authorized: 10 billion shares; issued: 1.772 billion shares at January 31, 2016 and 1.768 billion shares at February 1, 2015; outstanding: 1.252 billion shares at January 31, 2016 and 1.307 billion shares at February 1, 2015 Paid-In Capital Retained Earnings Accumulated Other Comprehensive Loss Treasury Stock, at cost, 520 million shares at January 31, 2016 and 461 million shares at February 1, 2015 Total Stockholders' Equity Total Liabilities and Stockholders' Equity Vertical Analysis As % of total assets Consolidated Balance Sheets - USD ($) $ in Millions Current Assets: Cash and Cash Equivalents Receivables, net Merchandise Inventories Other Current Assets Total Current Assets Property and Equipment, at cost Less Accumulated Depreciation and Amortization Net Property and Equipment Goodwill Other Assets Total Assets Current Liabilities: Short-Term Debt Accounts Payable Accrued Salaries and Related Expenses Sales Taxes Payable Deferred Revenue Income Taxes Payable Current Installments of Long-Term Debt Other Accrued Expenses Total Current Liabilities Long-Term Debt, excluding current installments Other Long-Term Liabilities Deferred Income Taxes Total Liabilities STOCKHOLDERS' EQUITY Common Stock, par value $0.05; authorized: 10 billion shares; issued: 1.772 billion shares at January 31, 2016 and 1.768 billion shares at February 1, 2015; outstanding: 1.252 billion shares at January 31, 2016 and 1.307 billion shares at February 1, 2015 Paid-In Capital Retained Earnings Accumulated Other Comprehensive Loss Treasury Stock, at cost, 520 million shares at January 31, 2016 and 461 million shares at February 1, 2015 Total Stockholders' Equity Total Liabilities and Stockholders' Equity Horizontal Analysis Trend analysis 2014 as the base year Consolidated Balance Sheets - USD ($) $ in Millions Current Assets: Cash and Cash Equivalents Receivables, net Merchandise Inventories Other Current Assets Total Current Assets Property and Equipment, at cost Less Accumulated Depreciation and Amortization Net Property and Equipment Goodwill Other Assets Total Assets Current Liabilities: Short-Term Debt Accounts Payable Accrued Salaries and Related Expenses Sales Taxes Payable Deferred Revenue Income Taxes Payable Current Installments of Long-Term Debt Other Accrued Expenses Total Current Liabilities Long-Term Debt, excluding current installments Other Long-Term Liabilities Deferred Income Taxes Total Liabilities STOCKHOLDERS' EQUITY Common Stock, par value $0.05; authorized: 10 billion shares; issued: 1.772 billion shares at January 31, 2016 and 1.768 billion shares at February 1, 2015; outstanding: 1.252 billion shares at January 31, 2016 and 1.307 billion shares at February 1, 2015 Paid-In Capital Retained Earnings Accumulated Other Comprehensive Loss Treasury Stock, at cost, 520 million shares at January 31, 2016 and 461 million shares at February 1, 2015 Total Stockholders' Equity Total Liabilities and Stockholders' Equity RATIO ANALYSIS Ratio DuPont Equation Ratios 1 Net profit margin 2 Asset Turnover Ratio 3 Financial Leverage 4 Return on equity Liquidity Ratio 5 Current Ratios TurnOver Ratio 6 Receivable Turnover Profitability Ratio 7 Gross Profit Margin Financial Risk Ratio 8 Debt to equity Ratio Altman's Z-score Retail [Working Capital/ Total assets ] *1.2 Add [Retained earning / Total assets]*1.4 Add[Earnings Before interest and tax/ Total assets]*3.3 Add[Market value of equity/ Total Liabilities]*0.6 Add[ Sales / Total assets] *1.0 Total score Probability of illiquidity and bankruptcy Consolidated Balance Sheets - USD ($) $ in Millions Current Assets: Cash and Cash Equivalents Receivables, net Merchandise Inventories Other Current Assets Total Current Assets Property and Equipment, at cost Less Accumulated Depreciation and Amortization Net Property and Equipment Goodwill Other Assets Total Assets Current Liabilities: Short-Term Debt Accounts Payable Accrued Salaries and Related Expenses Sales Taxes Payable Deferred Revenue Income Taxes Payable Current Installments of Long-Term Debt Other Accrued Expenses Total Current Liabilities Long-Term Debt, excluding current installments Other Long-Term Liabilities Deferred Income Taxes Total Liabilities STOCKHOLDERS' EQUITY Common Stock, par value $0.05; authorized: 10 billion shares; issued: 1.772 billion shares at January 31, 2016 and 1.768 billion shares at February 1, 2015; outstanding: 1.252 billion shares at January 31, 2016 and 1.307 billion shares at February 1, 2015 Paid-In Capital Retained Earnings Accumulated Other Comprehensive Loss Treasury Stock, at cost, 520 million shares at January 31, 2016 and 461 million shares at February 1, 2015 Total Stockholders' Equity Total Liabilities and Stockholders' Equity Feb. 02, 2014 Feb. 01, 2015 2014 ' Jan. 31, 2016 $1,929 1,398 11,057 895 15279 2015 $ 1,723 1,484 11,079 1,016 15,302 2016 $ 2,216 1,890 11,809 1,078 16,993 39,064 15,716 23,348 1,289 602 40518 38,513 15,793 22,720 1,353 571 39,946 39,266 17,075 22,191 2,102 1,263 42,549 33 5,797 1,428 396 1,337 12 33 1,746 10,749 290 5,807 1,391 434 1,468 35 38 1,806 11,269 350 6,565 1,515 476 1,566 34 77 1,943 12,526 14,691 2,042 514 27,996 16,869 1,844 642 30,624 20,888 1,965 854 36,233 88 88 88 8,402 23,180 46 -19,194 8,885 26,995 (452) (26,194) 9,347 30,973 (898) (33,194) 12,522 $40,518 9,322 $ 39,946 6,316 $ 42,549 Feb. 02, 2014 Feb. 01, 2015 Jan. 31, 2016 4.76% 3.45% 27.29% 2.21% 37.71% 4.31% 3.72% 27.73% 2.54% 38.31% 5.21% 4.44% 27.75% 2.53% 39.94% 96.41% 38.79% 57.62% 3.18% 1.49% 100.00% 96.41% 39.54% 56.88% 3.39% 1.43% 100.00% 92.28% 40.13% 52.15% 4.94% 2.97% 100.00% 0.08% 14.31% 3.52% 0.98% 3.30% 0.03% 0.08% 4.31% 26.53% 0.73% 14.54% 3.48% 1.09% 3.67% 0.09% 0.10% 4.52% 28.21% 0.82% 15.43% 3.56% 1.12% 3.68% 0.08% 0.18% 4.57% 29.44% 36.26% 5.04% 1.27% 69.10% 42.23% 4.62% 1.61% 76.66% 49.09% 4.62% 2.01% 85.16% 0.22% 0.22% 0.21% 20.74% 57.21% 0.11% -47.37% 22.24% 67.58% -1.13% -65.57% 21.97% 72.79% -2.11% -78.01% 30.90% 100.00% Feb. 02, 2014 23.34% 100.00% Feb. 01, 2015 2014 14.84% 100.00% Jan. 31, 2016 Feb. 01, 2015 $1,929 1,398 11,057 895 15279 2015 $ 1,723 1,484 11,079 1,016 15,302 2016 $ 2,216 1,890 11,809 1,078 16,993 Increase / Decrease -10.68% 6.15% 0.20% 13.52% 0.15% 39,064 15,716 23,348 1,289 602 40518 38,513 15,793 22,720 1,353 571 39,946 39,266 17,075 22,191 2,102 1,263 42,549 -1.41% 0.49% -2.69% 4.97% -5.15% -1.41% 33 5,797 1,428 396 1,337 12 33 1,746 10,749 290 5,807 1,391 434 1,468 35 38 1,806 11,269 350 6,565 1,515 476 1,566 34 77 1,943 12,526 778.79% 0.17% -2.59% 9.60% 9.80% 191.67% 15.15% 3.44% 4.84% 14,691 2,042 514 27,996 16,869 1,844 642 30,624 20,888 1,965 854 36,233 14.83% -9.70% 24.90% 9.39% 88 8,402 88 8,885 88 9,347 0.00% 5.75% ' 23,180 46 26,995 (452) 30,973 (898) 16.46% -1082.61% -19,194 12,522 $40,518 (26,194) 9,322 $ 39,946 (33,194) 6,316 $ 42,549 36.47% -25.56% -1.41% Feb-14 Feb-15 Jan-16 Net Income Net sales 6.83% 8.43% 7.92% Sales Total assets 1.95 2.08 2.08 Total assets Total Equity 3.24 4.29 6.74 NM*AT* FL 43% 75% 111% Current assets Current Liabilities 1.42 1.36 1.36 56.37 56.05 46.84 34.15% 34.13% 34.19% 2.24 3.29 5.74 Feb-14 Feb-15 Jan-16 Net liquid asset to capitalization 0.13 0.12 0.13 Cumulative profit relatuve to size 0.80 0.95 1.02 Earning power of the company's assets 0.75 0.86 0.91 Formula Sales Net Receivable Gross profit Net sales Debt Equity Ratio Measures Insolvency: extent assets can decline in value before book value become negative 0.27 0.18 0.10 sales generating capacity of the assets 1.95 2.08 2.08 3.90 4.20 4.24 Not likely Not likely Not likely Feb. 01, 2015 Jan. 31, 2016 Feb. 02, 2014 ' $1,929 1,398 11,057 895 15279 2015 $ 1,723 1,484 11,079 1,016 15,302 2016 $ 2,216 1,890 11,809 1,078 16,993 39,064 15,716 23,348 1,289 602 40518 38,513 15,793 22,720 1,353 571 39,946 39,266 17,075 22,191 2,102 1,263 42,549 33 5,797 1,428 396 1,337 12 33 1,746 10,749 290 5,807 1,391 434 1,468 35 38 1,806 11,269 350 6,565 1,515 476 1,566 34 77 1,943 12,526 14,691 2,042 514 27,996 16,869 1,844 642 30,624 20,888 1,965 854 36,233 88 88 88 8,402 23,180 46 -19,194 8,885 26,995 (452) (26,194) 9,347 30,973 (898) (33,194) 12,522 $40,518 9,322 $ 39,946 6,316 $ 42,549 Jan. 31, 2016 Increase/ Decrease 15% 35% 7% 20% 11% 1% 9% -5% 63% 110% 5% 961% 13% 6% 20% 17% 183% 133% 11% 17% 42% -4% 66% 29% 0% 11% 34% -2052% 73% -50% 5% Target Corp. Current year Competitor Ratios Comment 4.56% Good 1.80 Good 3.11 Bad 26% Good 1.12 Good 160.40 Bad 30% Good 0.92 Bad Consolidated Income Statements $ in Millions Income Statement [Abstract] NET SALES Cost of Sales GROSS PROFIT Operating Expenses: Selling, General and Administrative Depreciation and Amortization Total Operating Expenses OPERATING INCOME Interest and Other (Income) Expense: Interest and Investment Income Interest Expense Interest and Other, net EARNINGS BEFORE PROVISION FOR INCOME TAXES Provision for Income Taxes NET EARNINGS Feb. 02, 2014 $ 78,812 51,897 26,915 Feb. 01, 2015 Jan. 31, 2016 $ 83,176 $ 88,519 54,787 58,254 28,389 30,265 16,122 1,627 17,749 9,166 16,280 1,640 17,920 10,469 16,801 1,690 18,491 11,774 (12) 711 699 8,467 3,082 $ 5,385 (337) 830 493 9,976 3,631 $ 6,345 (166) 919 753 11,021 4,012 $ 7,009 As a % of Sales Consolidated Income Statements $ in Millions Income Statement NET SALES Cost of Sales GROSS PROFIT Operating Expenses: Selling, General and Administrative Depreciation and Amortization Total Operating Expenses OPERATING INCOME Interest and Other (Income) Expense: Interest and Investment Income Interest Expense Interest and Other, net EARNINGS BEFORE PROVISION FOR INCOME TAXES Provision for Income Taxes NET EARNINGS Feb. 02, 2014 Feb. 01, 2015 Jan. 31, 2016 100% 66% 34% 100% 66% 34% 100% 66% 34% 20% 2% 23% 12% 20% 2% 22% 13% 19% 2% 21% 13% 1% 1% 11% 4% 7% 1% 1% 12% 4% 8% 1% 1% 12% 5% 8% 2014 as the base year Horizontal Analysis - Trend analysis Consolidated Income Statements $ in Millions Income Statement [Abstract] NET SALES Cost of Sales GROSS PROFIT Operating Expenses: Selling, General and Administrative Depreciation and Amortization Total Operating Expenses OPERATING INCOME Interest and Other (Income) Expense: Interest and Investment Income Interest Expense Interest and Other, net EARNINGS BEFORE PROVISION FOR INCOME TAXES Provision for Income Taxes NET EARNINGS Feb. 02, 2014 $ 78,812 51,897 26,915 Feb. 01, 2015 Jan. 31, 2016 $ 83,176 $ 88,519 54,787 58,254 28,389 30,265 16,122 1,627 17,749 9,166 16,280 1,640 17,920 10,469 16,801 1,690 18,491 11,774 (12) 711 699 8,467 3,082 $ 5,385 (337) 830 493 9,976 3,631 $ 6,345 (166) 919 753 11,021 4,012 $ 7,009 Consolidated Income Statements $ in Millions Income Statement [Abstract] NET SALES Cost of Sales GROSS PROFIT Operating Expenses: Selling, General and Administrative Depreciation and Amortization Total Operating Expenses OPERATING INCOME Interest and Other (Income) Expense: Interest and Investment Income Interest Expense Interest and Other, net EARNINGS BEFORE PROVISION FOR INCOME TAXES Provision for Income Taxes NET EARNINGS Feb. 02, 2014 $ 78,812 51,897 26,915 Feb. 01, 2015 Jan. 31, 2016 $ 83,176 $ 88,519 54,787 58,254 28,389 30,265 16,122 1,627 17,749 9,166 16,280 1,640 17,920 10,469 16,801 1,690 18,491 11,774 (12) 711 699 8,467 3,082 $ 5,385 (337) 830 493 9,976 3,631 $ 6,345 (166) 919 753 11,021 4,012 $ 7,009 2015 VS 2014 2016 VS 2014 Decrease/ Increase Decrease/ Increase 5.54% 5.57% 5.48% 12% 12% 12% 0.98% 0.80% 0.96% 14.22% 4% 4% 4% 28% 2708.33% 16.74% -29.47% 17.82% 17.81% 17.83% 1283% 29% 8% 30% 30% 30% Consolidated Income Statements $ in Millions Income Statement [Abstract] NET SALES Cost of Sales GROSS PROFIT Operating Expenses: Selling, General and Administrative Depreciation and Amortization Total Operating Expenses OPERATING INCOME Interest and Other (Income) Expense: Interest and Investment Income Interest Expense Interest and Other, net EARNINGS BEFORE PROVISION FOR INCOME TAXES Provision for Income Taxes NET EARNINGS Feb. 02, 2014 $ 78,812 51,897 26,915 Feb. 01, 2015 Jan. 31, 2016 $ 83,176 $ 88,519 54,787 58,254 28,389 30,265 16,122 1,627 17,749 9,166 16,280 1,640 17,920 10,469 16,801 1,690 18,491 11,774 (12) 711 699 8,467 3,082 $ 5,385 (337) 830 493 9,976 3,631 $ 6,345 (166) 919 753 11,021 4,012 $ 7,009