LAST YEAR, STUMBLE -ON -INN INC. REPORTED ON roe OF 19% THE FIRM'S...

LAST YEAR, STUMBLE -ON -INN INC. REPORTED ON roe OF 19% THE FIRM'S DEBT RATIO WAS 60% PERCENT, SALES WERE 34 MILLION, AND THE CAPITAL INTENSITY WAS 1.30 TIMES.

CALCULATE THE NET INCOME FOR STUMBLE-ON -INN LAST YEAR. DO NOT ROUND INTERMEDIATE CALCULATIONS. ENTER YOUR ANSWER IN DOLLARS NOT IN MILLIONS.

EXCEL SPREADSHEET(THE LINE NUMBERS ON THE EXCEL SPREADSHEET CORRESPOND TO THE QUESTIONS)

PLEASE SHOW THE FORMULAS FROM THE EXCEL SPREADSHEET.

Line 7 ROE 19%

Line 8 DEBT RATIO 60%

Line 9 SALES $34,000,000

Line 10 CAPITAL INTENSITY RATIO 1.30

COMPLETE THE FOLLOWING ANALYSIS. DO NOT HARD CODE VALUES IN YOUR CALCULATIONS.

TOTAL ASSETS_____________

TOTAL DEBT________________

TOTAL EQUITY_____________

NET INCOME______________