Answer has to be on excel

45. FINANCIAL RATIOS DuBois Furniture, Inc., reported these figures for 20x7 and 20x6: Income statement: 20x7 20x6 Interest expense . Balance sheet: Total assets . Preferred stock, $1.30, no-par, 100,000 shares issued and outstanding 2,500,000 2,500,000 164,000,000 151,000,000 166,500,000 153,500,000