How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask linda_us Your Own Question
linda_us, Master's Degree
Category: Multiple Problems
Satisfied Customers: 1402
Experience:  A tutor for Business, Finance, Accounts and other related topics.
Type Your Multiple Problems Question Here...
linda_us is online now
A new question is answered every 9 seconds

What's the answer page?

Customer Question

what's the answer for this page?
Submitted: 2 years ago.
Category: Multiple Problems
Customer: replied 2 years ago.
Corporate Finance
Analyze two companies: Caterpillar (CAT) and Microsoft (MSFT).
See Excel spreadsheet.
See Excel spreadsheet.
3. For each for the 4 years of statements, compute the following ratios for each firm:
􏰀 Valuation Ratios
􏰀 Profitability Ratios
􏰀 Financial Strength Ratios
1. Download the annual income statements, balance sheets, and cash flow statements for the last 4 fiscal years from Market Watch ( into Excel.
2. Find historical stock prices for each firm from Yahoo! Finance ( Use the closing stock prices (not the adjusted close) to calculate the firm's market capitalization at each date, multiply the number of shares outstanding by the firm's historic stock price.
o Price-earnings ratio (for EPS use diluted EPS total)
o Market-to-book ratio
o Enterprise value-to-EBITDA (for debt, include long-term and short-term debt; for cash, include marketable securities)
o Operating margin (use operating income after depreciation) o Net profit margin
o Return on equity
o Current ratio
o Book debt-equity ratio o Market debt-equity ratio
4. Obtain industry averages for each firm from ( and compare each firm's ratios to the available industry ratios for the most recent year. Analyze the performance of each firm versus the industry and comment on any trends in each individual firm's performance. Identify any strengths or weakness you find in each firm.
5. Compare the valuation ratios across the two firms. How do you interpret the difference between them?
Customer: replied 2 years ago. saw the same question from the link above so can you give me the answer now
Expert:  F. Naz replied 2 years ago.
What should be the length of written work and also mention your deadline, thanks.
Customer: replied 2 years ago.
by the end of today thank you
Customer: replied 2 years ago.
the length is not gonna be like 4-5 pages. For analyze part, 1-2 pages should be okay. However, the excel part has to copy from the company excel information.
Expert:  F. Naz replied 2 years ago.
I have sent the offer, please accept it so the answer may be provided in next 24 hours, thanks.
Customer: replied 2 years ago.
thank you for the offer. I think is too much. I thought by paying the first fee $48 dollar I can get the service that I wanted.Thank you
Expert:  F. Naz replied 2 years ago.
You are welcome, you can see that the amount of work involved is a lot, anyways, better luck next time, take care.

Related Multiple Problems Questions