Please show the correct answer and the excel formula. Thanks!

Question 2 - Growth Rates (IGR and SGR) Answer all question parts below. Use blank spaces to perform any necessary calculations. CELL REFERENCE AND USE EXCEL FUNCTIONS APPROPRIATELY. Format appropriately. Daisy's Bulbs would like to increase sales next year by 10.5%. Daisy would like to see if this is possible using internal financing only. Sales growth % 10.5% Sales Profit Margin (PM) Dividend payout ratio Capital Intensity Ratio (CIR TD ratio $ 245,000 12.2% 0.55 0.50 0.27 New sales = 1) What will forecasted sales be at this 10.5% growth rate? 2) What is the maximum internal growth rate (IGR) that Daisy can support? IGR = 3) Is Daisy able to increase its sales by the projected sales growth of 10.5% using internal financing only? 4) Why or why not? 5) What are the maximum sales Daisy can generate based on the IGR you calculated above? Maximum sales = 6) If external financing was obtained, what growth rate could Daisy sustain while keeping the DE rat SGR = 7) What is Daisy's D ratio? DE ratio = 8) Very briefly, describe what the DE ratio tells you