Complete Study Problem 4.10 on page 124 of the text andsubmit to instructor. In parts a and b clearly label thecalculation of the required ratios and solve using Excel. Useformulas to calculate the ratios and format the cells to insert acomma if there is more than three numbers. Round to the nearestwhole number. In part c clearly label the pre and postrenovation analysis using an Excel work sheet. Do a comparativeanalysis in a Word document not to exceed 200 words explainingwhether the renovation should occur