please help me to do in excel with correct formula and give me good solution

NVIDIA Corp. financial statements are presented below. Analysts forecast that its 2018 sales will be $8,260. The expected 2018 tax rate will be 17.35%. Assume the firm pays 5% interest on short-term debt and 7% on long term debt. NVIDIA Corporation Income Statement ($ in Millions) For the Years 2012 to 2017 Jan-17 Jan-16 Jan-15 Jan-14 Jan-13 Jan-12 Sales 6,910 5,010 4,682 4,130 4,280 3,998 Cost of Goods Sold 2,648 2,002 1,862 1,828 1,743 Gross Income 4,262 3,008 2,820 2,507 2,453 2,255 1,623 Research & Development 1,463 1,331 1,360 1,336 1,147 984 Other SG&A 641 532 443 436 431 398 187 197 220 239 226 204 2 0 0 0 0 0 1,969 948 796 496 648 669 Depreciation Expense Other Operating Expense EBIT (Operating Income) Nonoperating income-Net Interest Expense Unusual Expense - Net Pretax Income 50 43 42 24 17 7 58 47 46 10 3 3 56 201 37 0 0 9 1,905 743 755 510 662 663 Income Taxes 239 129 124 70 100 82 Net Income 1,666 614 631 440 563 581 Dividends per Share 0.49 0.40 0.34 0.31 0.08 0.00 Shares Outstanding 649.00 569.00 563.07 594.52 624.96 616.37 Tax Rate 12.55% 17.36% 16.46% 13.77% 15.03% 12.41% NVIDIA Corporation Balance Sheet (s in Millions) For the Years 2012 to 2017 Jan-17 Jan 16 Jan-15 Jan-14 Jan 13 Jan 12 Assets Cash 1,766 596 497 1,151 431 253 5,032 4,441 4,127 3,521 3,297 2,876 826 505 474 426 454 336 794 418 483 388 420 340 118 93 133 139 173 99 8,536 6,053 5,713 5,625 4,775 3,905 1,191 1,100 1,179 1,283 1,289 1,157 670 634 622 700 713 596 521 466 557 583 576 560 784 851 931 1,043 1,061 1,087 9,841 7,370 7,201 7,251 6,412 5,553 Short-Term Investments Accounts Receivable Inventories Other Current Assets Total Current Assets Grass Plant & Equipment Accumulated Depreciation Net Plant & Equipment Other Assets Total Assets Liabilities & Shareholders' Equity ST Debt & Current Portion LT Debt Accounts Payable Other Current Liabilities Total Current Liabilities Long-Term Debt Other Liabilities Total Liabilities Common Equity Total Liabilities & Shareholders' Equity 800.0 1,413.0 0.0 2.9 0.0 0.0 485.0 296.0 293.2 324.4 356.4 335.1 503.0 642.0 602.8 621.1 619.8 594.9 1,788.0 2,351.0 896.0 948.4 976.2 930.0 2,020 97 1,398 1,371 19 21 271 453 489 475 589 456 4,079 2,901 2,783 2,794 1,585 1,407 5,762 4,469 4,418 4,456 4,828 4,146 9,841 7,370 7,201 7,251 6,412 5,553 a) Use your judgement to forecast the items on the income statement and balance sheet with the percent of sales method. What is the discretionary financing needed in 2018? Is this a surplus or deficit? Assume that the dividends per share will be $0.54 and the number of shares will be the same as in 2017. b) Assume that DFN will be absorbed by long-term debt and that the interest rate is 2.5% of the sum of LTD and short-term debt. Set up an iterative worksheet to eliminate it NVIDIA Corp. financial statements are presented below. Analysts forecast that its 2018 sales will be $8,260. The expected 2018 tax rate will be 17.35%. Assume the firm pays 5% interest on short-term debt and 7% on long term debt. NVIDIA Corporation Income Statement ($ in Millions) For the Years 2012 to 2017 Jan-17 Jan-16 Jan-15 Jan-14 Jan-13 Jan-12 Sales 6,910 5,010 4,682 4,130 4,280 3,998 Cost of Goods Sold 2,648 2,002 1,862 1,828 1,743 Gross Income 4,262 3,008 2,820 2,507 2,453 2,255 1,623 Research & Development 1,463 1,331 1,360 1,336 1,147 984 Other SG&A 641 532 443 436 431 398 187 197 220 239 226 204 2 0 0 0 0 0 1,969 948 796 496 648 669 Depreciation Expense Other Operating Expense EBIT (Operating Income) Nonoperating income-Net Interest Expense Unusual Expense - Net Pretax Income 50 43 42 24 17 7 58 47 46 10 3 3 56 201 37 0 0 9 1,905 743 755 510 662 663 Income Taxes 239 129 124 70 100 82 Net Income 1,666 614 631 440 563 581 Dividends per Share 0.49 0.40 0.34 0.31 0.08 0.00 Shares Outstanding 649.00 569.00 563.07 594.52 624.96 616.37 Tax Rate 12.55% 17.36% 16.46% 13.77% 15.03% 12.41% NVIDIA Corporation Balance Sheet (s in Millions) For the Years 2012 to 2017 Jan-17 Jan 16 Jan-15 Jan-14 Jan 13 Jan 12 Assets Cash 1,766 596 497 1,151 431 253 5,032 4,441 4,127 3,521 3,297 2,876 826 505 474 426 454 336 794 418 483 388 420 340 118 93 133 139 173 99 8,536 6,053 5,713 5,625 4,775 3,905 1,191 1,100 1,179 1,283 1,289 1,157 670 634 622 700 713 596 521 466 557 583 576 560 784 851 931 1,043 1,061 1,087 9,841 7,370 7,201 7,251 6,412 5,553 Short-Term Investments Accounts Receivable Inventories Other Current Assets Total Current Assets Grass Plant & Equipment Accumulated Depreciation Net Plant & Equipment Other Assets Total Assets Liabilities & Shareholders' Equity ST Debt & Current Portion LT Debt Accounts Payable Other Current Liabilities Total Current Liabilities Long-Term Debt Other Liabilities Total Liabilities Common Equity Total Liabilities & Shareholders' Equity 800.0 1,413.0 0.0 2.9 0.0 0.0 485.0 296.0 293.2 324.4 356.4 335.1 503.0 642.0 602.8 621.1 619.8 594.9 1,788.0 2,351.0 896.0 948.4 976.2 930.0 2,020 97 1,398 1,371 19 21 271 453 489 475 589 456 4,079 2,901 2,783 2,794 1,585 1,407 5,762 4,469 4,418 4,456 4,828 4,146 9,841 7,370 7,201 7,251 6,412 5,553 a) Use your judgement to forecast the items on the income statement and balance sheet with the percent of sales method. What is the discretionary financing needed in 2018? Is this a surplus or deficit? Assume that the dividends per share will be $0.54 and the number of shares will be the same as in 2017. b) Assume that DFN will be absorbed by long-term debt and that the interest rate is 2.5% of the sum of LTD and short-term debt. Set up an iterative worksheet to eliminate it