View the step-by-step solution to: 28. Trend analysis (LO4) Quantum Moving Company has the

This question was answered on Sep 06, 2012. View the Answer
Trend analysis (LO4) Quantum Moving Company has the following data. Industry information also is shown. Question information attached. Will need the response in Excel format.
Module 2-28 Assignment.docx

28.

Trend analysis (LO4) Quantum Moving Company has the following data. Industry
information also is shown.
Industry Data on
Net Income/Total Assets

Year
2008
2009
2010

Company Data
Net Income
$350,000
375,000
375,000

Total Assets
$2,800,000
3,200,000
3,750,000

Year
2008
2009
2010

Debt
$1,624,000
1,730,000
1,900,000

Total Assets
$2,800,000
3,200,000
3,750,000

11.5%
8.4
5.5
Industry Data on
Debt/Total Assets
54.1%
42.0
33.4

As an industry analyst comparing the firm to the industry, are you likely to praise or
criticize the firm in terms of:
a.
Net income/Total assets.
b.
Debt/Total assets.

Sign up to view the entire interaction

Dear Student Please find... View the full answer

Finance-8349564.doc

Answer
a) Net Income / Total Assets
Year
Quantum
2008
$350000/ $2800000 *100= 12.5%
2009
375000 / 3200000 *100 =11.7%
2010
375000/3750000 *100 =10%

Industry
11.5%
8.4%
5.5%

Companys Net Income /...

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • 890,990,898

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • 890,990,898

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards