please help resolve and show results and formulas in blank excel sheets provided and interpret results - was this a surplus - why or why not ?

MIVID1. Corp. finasciat statrments are presented bolew. Analyits foeccme that it 2 e 20 sales will be 58,269. The espected Jowo tas rate will be 17.35\%h. Assene ise firme pays 5% iatered an sherd. term debt and The os lesa ierm dele. MvibAcepank 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 2020 ? 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 2019 (Analysis \& Identify and Access Needed Information 8 pts). 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 Access Needed Information, \& Use Information Effectively to Accomplish a Specific Purpose 12 pts). c) Interpretation: please describe where you obtained information to develop analyses and interpret the results. Please include your written description in the "interpretation" tab. If you do not complete this section with your words or leave the interpretation tab as a blank, you receive 0 point in this HW. Please complete the yellow highlighted parts. Please show the formulas if the number or figures are not provided in the problem. MVIDIA Corporation Income Statement ( S in Millions) For the Years 2014 to 2019 Please complete the yellow highlighted parts. Please show the formulas if the number or figures are not provided in the problem. MVIDIA Corporation Balance Sheet ( 5 in Millions) For the Years 2014 to 2019 MIVID1. Corp. finasciat statrments are presented bolew. Analyits foeccme that it 2 e 20 sales will be 58,269. The espected Jowo tas rate will be 17.35\%h. Assene ise firme pays 5% iatered an sherd. term debt and The os lesa ierm dele. MvibAcepank 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 2020 ? 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 2019 (Analysis \& Identify and Access Needed Information 8 pts). 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 Access Needed Information, \& Use Information Effectively to Accomplish a Specific Purpose 12 pts). c) Interpretation: please describe where you obtained information to develop analyses and interpret the results. Please include your written description in the "interpretation" tab. If you do not complete this section with your words or leave the interpretation tab as a blank, you receive 0 point in this HW. Please complete the yellow highlighted parts. Please show the formulas if the number or figures are not provided in the problem. MVIDIA Corporation Income Statement ( S in Millions) For the Years 2014 to 2019 Please complete the yellow highlighted parts. Please show the formulas if the number or figures are not provided in the problem. MVIDIA Corporation Balance Sheet ( 5 in Millions) For the Years 2014 to 2019