whir

with Formal , please

N A B D E F G H I J K L 1 In the data presented below, Income Statement and Balance Sheet are actual for 2019 and 2020, and pro-forma for 2021. 2 The pro-formas are not completed, but started. MAKE SURE THAT YOU ENABLE ITERATIVE CALCULATIONS 3 4 1 18pts Fill in the blue cells USING FORMULAS. 5 2 30pts Fill in all the missing orange cells USING FORMULAS. Start with the discretionary financing needed (DFN). Then fill in the PLUGs. 6 Assume that the company will borrow short-term debt in case of deficit, and keep any leftover funds (extra cash) in case of surplus. 7 Finally, fill in the interest expense. Assume that the company will pay 15% interest on the short-term debt and 8% on the long term debt. 8 Set up iterative worksheet. Make the balance sheet balanced. 9 Note that the company had no short-term debt outstanding at the end of 2020. 10 3 7pts Is there an expected deficit or a surplus in 2021? How much? Answer in writing and create a formula that identifies whether there is a deficit or a surplus. 11 4 20pts In the scenario manager, create three scenarios for expected sales in 2021 as follows: 12 Best Case Sales growth rate is 20% 13 Base Case Sales growth rate is 17%