PLEASE PROVIDE EXCEL FORMULAS!!!

Project 3 Part Four Problem (15 points) Southeastern Selections is a small electronics business operating in select cities in the Southeast. Select financial data is presented below to provide you with the necessary content for perfromance evaluation purposes. Atlanta Division 3,000,000 775,000 2,225,000 1,680,000 545,000 Birmingham Division 1,600,000 475,000 1,125,000 725,000 400,000 Columbia Division 2,000,000 760,000 1,240,000 1,000,000 240,000 Sales revenue Variable costs Contribution margin Fixed costs Operating income Interest costs on long-term debt at 10% Income before income taxes Income taxes at 30% Net income Net book values at the end of 2018: Current assets Long-term assets Total assets Current liabilities Long-term debt Stockholders' equity Total liabilities and stockholders' equity Total 6,600,000 2,010,000 4,590,000 3.405,000 1,185,000 450,000 735,000 220,500 514,500 850,000 2,350,000 3,200,000 500,000 700,000 1,800,000 2,500,000 250,000 300,000 1,400,000 1,700,000 150,000 1,850,000 5,550,000 7,400,000 900,000 4,500,000 2.000.000 7,400,000 Requirement One: Calculate ROI for each of the three divisions by using the condensed ROI formula Requirement Two: Calculate Profit Margin (Return on Sales) for each Calculate Asset Turnover for each Requirement Three: Calculate ROI for each of the three again, but assume sales increase by 15% for each one. Assets and fixed costs remain the same as presented. Requirement Four: Calculate ROI for each of the three again, but assume fixed costs decrease by 10% for each one. Assets and costs remain the same as presented