MVIDIA Corp. financial statements are presented below. Analysts forecast that its 2021 sales will be $8,260. The expected 2021 tax rate will be 17.35%. Assume the firm pays 5% interest on short- term debt and 7% on long term debt. Sales Cost of Goods Sold Gross Income Research & Development Other SG&A Depreciation Expense Other Operating Expense EBIT (Operating Income) Nonoperating Income - Net Interest Expense Unusual Expense - Net Pretax Income Income Taxes Net Income Dividends per Share Shares Outstanding Tax Rate MVIDIA Corporation Income Statement ($ in Millions) For the Years 2015 to 2020 Jan-20 Jan-19 Jan-18 6,910 2,648 4,262 1,463 641 187 2 1,969 50 58 56 1,905 239 1,666 5,010 4,682 4,130 2,002 1,862 1,623 3,008 2,820 1,331 532 197 0 948 43 47 201 743 129 614 0.49 0.40 649.00 569.00 12.55% 17.36% Jan-17 Jan-16 Jan-15 4,280 3,998 1,828 1,743 1,360 443 220 0 796 42 46 37 755 124 631 2,507 1,336 436 239 0 496 24 10 0 510 70 440 2,453 1,147 431 226 0 648 17 3 0 662 100 563 2,255 984 398 204 669 7 3 9 663 82 581 0.34 0.31 0.08 0.00 594.52 624.96 616.37 563.07 16.46% 13.77% 15.03% 12.41%

please help complete the excel yellow highlighted parts (excel formulas)

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 2021? Is this a surplus or deficit? Please complete the yellow highlighted parts. Please show the formulas if the number or figures are not provided in the problem. MVIDIA Corporation Balance Shect ( $ in Millions) For the Years 2015 to 2020 \begin{tabular}{l} \hline \\ Ascets \\ Cash \& Short-Term Investments \\ Short-Term Investments \\ Accounts Receivable \\ Inventories \\ Other Current Asets \end{tabular} Total Current Assets Gross Plant \& Equipment Accumulated Depreciation Net Plant \& Equipment Other Assets Total Assets Labilities \& Shareholders' Equity ST Debt \& Current Portion LT Debt Accounts Payable Other Curreat Liabilities Total Current Liabilities. Long-Term Debi Other Liabilities Total Labilities Common Equity Total Liabilities \& Shareholders' Equity Shares Outstanding 649 649 569 563,07 594.52 624.96 616.37 Discretionary Financing Needed Accumulated DFN Iteration Source: FactSet Fundamentals MVIDIA Corp. financial statements are presented below. Analysts forecast that its 2021 sales will be $8,260. The expected 2021 tax rate will be 17.35%. Assume the firm pays 5% interest on shortterm debt and 7% on long term debt. 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 2021 ? Is this a surplus or deficit? 1 Assume that the dividends per share will be $0.54 and the number of shares will be the same as in 2020 (Analysis \& Identify and Access Needed Information 8pts ). 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 (Analysis, Identify and Aceess Needed Information, \& Use Information Effectively to Accomplish a Snerific Pumnesty and 2 Please complete the vellow highlighted par parts. Pleases 3 MVIDIA Corporation 4 Income Statement ( S in Miltions) For the Years 2015 to 2020 5 6 Sales Cost or Goods Sold Gross Income Research \& Development Other SGEA Depreciation Expense Other Opcrating Expense FBIT (Operating Income) Nonoperating Income - Net Interest Expense Unusual Expense - Net Pretax Income Income Taxes Net Income \begin{tabular}{|l|r|r|r|r|r|r|r|} \hline Dividendsper Share & 0.54 & 0.49 & 0.40 & 0.34 & 0.31 & 0.08 & 0.00 \\ \hline Tax Rate & 17.35% & 12.55% & 17.36% & 16.46% & 13.77% & 15.03% & 12.41% \\ \hline \end{tabular} - Forecal Intercut Rate FactSet 2020 Revenue Forecas Factict 2020 Tax Rate Forecas FactSet 2018 RLD Forecus Sales Multiplaer for Soenarion DFN for Scenurias 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 2021? Is this a surplus or deficit? Please complete the yellow highlighted parts. Please show the formulas if the number or figures are not provided in the problem. MVIDIA Corporation Balance Shect ( $ in Millions) For the Years 2015 to 2020 \begin{tabular}{l} \hline \\ Ascets \\ Cash \& Short-Term Investments \\ Short-Term Investments \\ Accounts Receivable \\ Inventories \\ Other Current Asets \end{tabular} Total Current Assets Gross Plant \& Equipment Accumulated Depreciation Net Plant \& Equipment Other Assets Total Assets Labilities \& Shareholders' Equity ST Debt \& Current Portion LT Debt Accounts Payable Other Curreat Liabilities Total Current Liabilities. Long-Term Debi Other Liabilities Total Labilities Common Equity Total Liabilities \& Shareholders' Equity Shares Outstanding 649 649 569 563,07 594.52 624.96 616.37 Discretionary Financing Needed Accumulated DFN Iteration Source: FactSet Fundamentals MVIDIA Corp. financial statements are presented below. Analysts forecast that its 2021 sales will be $8,260. The expected 2021 tax rate will be 17.35%. Assume the firm pays 5% interest on shortterm debt and 7% on long term debt. 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 2021 ? Is this a surplus or deficit? 1 Assume that the dividends per share will be $0.54 and the number of shares will be the same as in 2020 (Analysis \& Identify and Access Needed Information 8pts ). 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 (Analysis, Identify and Aceess Needed Information, \& Use Information Effectively to Accomplish a Snerific Pumnesty and 2 Please complete the vellow highlighted par parts. Pleases 3 MVIDIA Corporation 4 Income Statement ( S in Miltions) For the Years 2015 to 2020 5 6 Sales Cost or Goods Sold Gross Income Research \& Development Other SGEA Depreciation Expense Other Opcrating Expense FBIT (Operating Income) Nonoperating Income - Net Interest Expense Unusual Expense - Net Pretax Income Income Taxes Net Income \begin{tabular}{|l|r|r|r|r|r|r|r|} \hline Dividendsper Share & 0.54 & 0.49 & 0.40 & 0.34 & 0.31 & 0.08 & 0.00 \\ \hline Tax Rate & 17.35% & 12.55% & 17.36% & 16.46% & 13.77% & 15.03% & 12.41% \\ \hline \end{tabular} - Forecal Intercut Rate FactSet 2020 Revenue Forecas Factict 2020 Tax Rate Forecas FactSet 2018 RLD Forecus Sales Multiplaer for Soenarion DFN for Scenurias