PLEASE PROVIDE EXCEL FORMULAS :) THANK YOU!!

Project 3 Part Four Problem (20 points) Dependable Networks is a data storage business operating in select cities in Texas. Select financial data is presented below to provide you with the necessary content for perfromance evaluation purposes. Dallas Division 3,185,000 995,000 2,190,000 1,680,000 510,000 Austin Division 1,400,000 375,000 1,025,000 725,000 300,000 San Antonio Division 1,200,000 310,000 890,000 650,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 2020: Current assets Long-term assets Total assets Current liabilities Long-term debt Stockholders' equity Total liabilities and stockholders' equity Total 5,785,000 1,680,000 4,105,000 3.055.000 1,050,000 450,000 600,000 180,000 420,000 850,000 2,700,000 3,550,000 300,000 700,000 1,800,000 2,500,000 150,000 300,000 800,000 1,100,000 50,000 1,850,000 5.300.000 7,150,000 500,000 4,500,000 2.150.000 7,150,000 Requirement One: Calculate ROI for each of the three restaurants 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 assets increase by 400,000 for each one. Sales and costs remain the same as presented. Requirement Four: Calculate ROI for each of the three again, but assume sales increase by 5% for each one. Assets and fixed costs remain the same as presented. Requirement Five: 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