BUS 401AssignmentTo complete the following assignment, go to this week’s Assignment link in the left navigation.Ratio AnalysisReview the financial information pertaining to Salco Inc. in Study Problem 4-10 on pages 113 and 114 of you text. Answer the following questions in an Excel document. Solve using Excel formulas (preferred) or clearly write out the steps you took to calculate your answers. Round any dollar amounts to the nearest dollar ($1,500,074) and any percentages to two decimals (9.56%).*** Note that Chapter 8 is currently under editorial review for the equation of Common Stock Valuation. The formula that follows should be used in this assignment:Expected Rate of Return = (Dividend in Year / Market Price) + GrowthRate Investor’s Value = Dividend in Year / (Required Rate of Return – Growth Rate)4-10.(Financial ratios—investment analysis) The annual sales for Salco Inc. were $4.5 million last year. The firm’s end-of-year balance sheet was as follows:Current assets$ 500,000Liabilities$1,000,000Net fixed assets 1,500,000Owners’equity 1,000,000$2,000,000$2,000,000The firm’s income statement for the year was as follows:Sales$ 4,500,000Less cost of goods sold (3,500,000)ExamSales$ 4,500,000Less cost of goods sold (3,500,000)Gross profit$1,000,000Less operating expenses (500,000)Operating income$ 500,000Less interest expense (100,000)Earnings before taxes$ 400,000Less taxes (50%) (200,000)Net income$ 200,000a. Calculate Salco’s total asset turnover, operating profit margin, and operating return on assets.b. Salco plans to renovate one of its plants, which will require an added investment in plant and equipment of $1 million. The firm will maintain its present debt ratio of .5 when financing the new investment and expects sales to remain constant. The operating profit margin will rise to 13 percent. What will be the new operating return on assets for Salco after the plant’s renovation?c. Given that the plant renovation in part b occurs and Salco’s interest expense rises by $50,000 per year, what will be the return earned on the common stockholders’ investment? Compare this rate of return with that earned before the renovation. (Keown)Keown, Arthur J., John H. Martin, and John W. Petty.Foundations of Finance for Ashford University, 7th Edition.Pearson Learning Solutions.