BUS 401.Finance – Assignments

BUS 401.Finance – Assignments - BUS...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
BUS 401.Finance – Assignments Week 1 Ratio Analysis Complete Study Problem 4.10 on page 124 of the text and submit to instructor. In parts "a" and "b," clearly label the calculation of the required ratios and solve using Excel. Use formulas to calculate the ratios and format the cells to insert a comma if there is more than three numbers. Round to the nearest whole number. In part "c," clearly label the pre and post renovation analysis using an Excel work sheet. Do a comparative analysis in a Word document not to exceed 200 words explaining whether the renovation should occur. A) Total Asset Turnover: 4,500,000 / 2,000,000 = 2.25 Operating Profit Margin: 500,000 / 4,500,000 = .11 (11%) Operating Return on Assets: (500,000/4,500,000)*(4,500,000/2,000,000) =.11 * 2.25 = .2475 (24.75%) = 25% B) .13 * (4,500,000/3,000,000) = .13 * 1.5 = .195 = 19.5% C) The way I understood the text, the operating profit margin is used to calculate the operating return on assets BEFORE interest expenses or taxes are taken out of the operating income. If this
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/29/2011 for the course BUSINESS 101 taught by Professor All during the Spring '11 term at Ashford University.

Page1 / 3

BUS 401.Finance – Assignments - BUS...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online