I need help creating the Pro Forma and turning the Balance Sheet and Income Statement and turn them into a percent of Sales and Total assets respectively. Only need help on part 1. Instructions are also on the Excel Part Tab part.

THE HOME DEPOT INC (HD) INCOME STATEMENT Fiscal year ends in January. U 2013-01 2014-01 2015-01 2016-01 2017-01 Revenue 74754 78812 83176 88519 94595 Cost of revenue 48912 51422 54222 58254 62282 Gross profit 25842 27390 28954 30265 32313 Operating expenses Sales, General and administra 16508 16597 16834 16801 17132 Other operating expenses 1568 1627 1651 1690 1754 Total operating expenses 18076 18224 18485 18491 18886 Operating income 7766 9166 10469 11774 13427 Interest Expense 632 711 830 919 972 Other income (expense) 87 12 337 166 36 Income before income taxes 7221 8467 9976 11021 12491 Provision for income taxes 2686 3082 3631 4012 4534 Net income from continuing o 4535 5385 6345 7009 7957 Net income 4535 5385 6345 7009 7957 Earnings per share Basic 3.03 3.78 4.74 5.49 6.47 Diluted 3 3.76 4.71 5.46 6.45 Weighted average shares outstanding Basic 1499 1425 1338 1277 1229 Diluted 1511 1434 1346 1283 1234 EBITDA 9537 10935 12592 13803 15436 2013 2014 201 2016 2017 2018E 2018E 5% 66% 18.50% 1.85% 1% same 4.60% 1229 same 1234 same THE HOME DEPOT INC (HD) CashFlowFlag BALANCE SHEET Fiscal year ends in January. USD i2013-01 2014-01 2015-01 2016-01 2017-01 Assets Current assets Cash Cash and cash equivalents 2494 1929 1723 2216 2538 Receivables 1395 1398 1484 1890 2029 Inventories 10710 11057 11079 11809 12549 Other current assets 773 895 1016 1078 608 Total current assets 15372 15279 15302 16993 17724 Non-current assets Property, plant and equipment Land 8485 8375 8243 8149 8207 Fixtures and equipment 9338 10107 9602 10279 11020 Other properties 20668 20582 20668 20838 21199 Property and equipment, at cost 38491 39064 38513 39266 40426 Accumulated Depreciation -14422 -15716 -15793 -17075 -18512 Property, plant and equipment, 24069 23348 22720 22191 21914 Goodwill 1170 1289 1353 2102 2093 Other long-term assets 473 602 571 1263 1235 Total non-current assets 25712 25239 24644 25556 25242 Total assets 41084 40518 39946 42549 42966 Liabilities and stockholders' equity Liabilities Current liabilities Short-term debt 1321 33 328 427 1252 Accounts payable 5376 5797 5807 6565 7000 Taxes payable 494 408 469 510 533 Accrued liabilities 3001 3174 3197 3458 3679 Deferred revenues 1270 1337 1468 1566 1669 Total current liabilities 11462 10749 11269 12526 14133 Non-current liabilities Long-term debt 9475 14691 16869 20888 22349 Deferred taxes liabilities 319 514 642 854 296 Other long-term liabilities 2051 2042 1844 1965 1855 Total non-current liabilities 11845 17247 19355 23707 24500 Total liabilities 23307 27996 30624 36233 38633 Stockholders' equity Common stock 88 88 88 88 88 Additional paid-in capital 7948 8402 8885 9347 9787 Retained earnings 20038 23180 26995 30973 35519 Treasury stock -10694 -19194 -26194 -33194 -40194 Accumulated other comprehensi 397 46 -452 -898 -867 Total stockholders' equity 17777 12522 9322 6316 4333 Total liabilities and stockholders' 41084 40518 39946 42549 42966 2013 2014 2015 2016 2017 2018E Ratios 2013 Sales % 7.5 days 72 days Sales % same same same same same same same same Sales % 41 days Sales % Sales % Sales % Sales % Sales % Sales % Sales % same Sales % fill in same plug Current Ratio Quick Ratio Times Int Earned Total Debt/Equity Days Inventory Days Receivable Days Payble 2014 2015 2016 2017 2018E Excel Part 1 When you submit both Part 1 & Part 2, do it on Canvas and name it: Last name_first name_par Turn the Income Statement and Balance Sheet and turn them into a precent of Sales and percent of Total Assets respective Take the Income Statement and Balance sheet and create a proforma for 2018 Based on the growth rates I have given you Be sure to use equations, NOT just typing in the numbers. This includes subtracting and addition. I will be grading the exercise BASED ON your equations. The idea is to be able to change one number and have it flow throughout the entire spreadsheet. Calculate the seven ratios, both for the previous five years AND for your proforma numbers 2018E Excel Part 2 Take the Income Statement and Balance sheet and create a proforma for 2018, based on the growth rates I have given you BE SURE TO COMMENT ON THE PLUG FIGURE! Is it positive or negative? Is it a number you think the firm can "handle". Would you consider doing something different on the Balance Sheet given the plug figure? The valuation page is NOT due with the original submission. Be sure to set up the valuation page with equations so you can change some of the assumptions and see how the numbers change. Once you have the valuation from the original numbers you were given, copy and past the VALUES into cells D3. You must use the special paste command to have this work out for you. You're doing this because of the further calculations you are doing below. After calculating the original valuation, change the numbers as follows to get subsequent valuations. Change COGS by 1% (higher cost) and see how the valuation changes. Copy and paste into cell D7 Change the SG&A by 1% (higher) and see how the valuation changes. Copy and paste into Cell D12 Drop the P/E to 20 times, the P/B to 38 times and P/S to 1.8 times and see how valuation changes. Put these results into Cell D18 Starting in Cell A24, comment on the results you have found above. Be sure to give your thoughts, not just read back the n Have a great day!! ame_first name_part 1(2) of Total Assets respectively. wth rates I have given you I will be grading t flow throughout the wth rates I have given you. n the plug figure? with equations so valuation from the al paste command s, not just read back the numbers. Current Price $147.31 Price P/E multiple P/B multiple P/S multiple 22 times 40 times 1.9 times