Multiple Problems

For Help with Multiple Homework Problems, Ask an Expert

Ask an Expert,
Get an Answer ASAP!

This is your second interview with a prestigious brokerage…

Customer Question
This is your second...

This is your second interview with a prestigious brokerage firm for a job as an equity analyst. You survived the morning interviews with the department manager and the vice president of equity. Everything has gone so well that they want to test your ability as an analyst. You are seated in a room with a computer and a list with the names of two companies – Caterpillar (CAT) and Microsoft (MSFT). Complete the following tasks:Download the annual income statements, balance sheets, and cash flow statements for the last three fiscal years from MarketWatch (www.marketwatch.com). Enter each company’s stock symbol and then go to “financials.” Copy and paste the financial statements into Excel.Find historical stock prices for each firm from Yahoo! Finance (finance.yahoo.com). Enter the stock symbol, click “Historical Prices” in the left column, and enter the proper date range to cover the last day of the month corresponding to the date of each financial statement. Using the closing stock prices (not the adjusted close). To calculate the firm’s market capitalization at each date, multiply the number of shares outstanding (see “Basic Weighted Shares Outstanding” on the income statement) by the firm’s historic stock price.For each of the three years of statements, compute the following ratios for each firm:
Profitability RatiosOperating margin (use operating income after depreciation)Net profit marginReturn on equityFinancial Strength RatiosCurrent ratioBook debt-equity ratioMarket debt-equity ratioInterest coverage ratio (EBIT ÷ interest expense)Compare the ratios across the two firms. How do you interpret the difference between them?

Tutor's Assistant: The Tutor can help you get an A on your homework or ace your next test. Is there anything else important you think the Tutor should know?

Its fiscal year of 2016, 2015, 2014

Submitted: 7 months ago.Category: Multiple Problems
Show More
Show Less
Ask Your Own Multiple Problems Question
Customer reply replied 7 months ago
it have to be in excel and i nee it before 8am
Answered in 3 hours by:
12/19/2017
Business Tutor: F. Naz, B.Com replied 7 months ago
F. Naz
F. Naz, B.Com
Category: Multiple Problems
Satisfied Customers: 5,481
Experience: have completed B.Com and CA Finalist
Verified

Hi, I can do this in next 18 to 24 hours, thanks.

Ask Your Own Multiple Problems Question
Customer reply replied 7 months ago
sure but it due tomorrow
Customer reply replied 7 months ago
im at work
Business Tutor: F. Naz, B.Com replied 7 months ago

Please accept the offer so answer may be provided in next 24 hours, take care.

Ask Your Own Multiple Problems Question
Customer reply replied 7 months ago
no i ready pay for it any why would i pay again
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a business tutorLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask linda_us Your Own Question
linda_us
linda_us
linda_us, Master's Degree
Category: Multiple Problems
Satisfied Customers: 1,402
1,402 Satisfied Customers
Experience: A tutor for Business, Finance, Accounts and other related topics.

linda_us is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

Meet the Experts:

linda_us

linda_us

Master's Degree

1,402 satisfied customers

A tutor for Business, Finance, Accounts and other related topics.

F. Naz

F. Naz

B.Com

5,481 satisfied customers

have completed B.Com and CA Finalist

Manal Elkhoshkhany

Manal Elkhoshkhany

Bachelor's Degree

936 satisfied customers

Completed by BA degree in 1988 and graduated with a GPA of 4.0

Mr. Gregory White

Mr. Gregory White

Master's Degree

874 satisfied customers

M.A., M.S. Education / Educational Administration

Bizhelp

Bizhelp

CPA

539 satisfied customers

BA degree and Certified Public Accountant

MyVirtualCPA

MyVirtualCPA

Master's Degree

155 satisfied customers

Master's degree holder who loves to help you understand your MC homework problems

Dimitry K., Esq.

Dimitry K., Esq.

Doctoral Degree

39 satisfied customers

JD/MBA, Business Attorney

< Previous | Next >

Related Multiple Problems Questions
ASSIGNMENT 2: FINANCIAL STATEMENT ANALYSIS Weighting: 7%
ASSIGNMENT 2: FINANCIAL STATEMENT ANALYSIS Weighting: 7% Marks: __/35 Purpose: Using spreadsheets to solve complex problems is a key competence – in fact a requirement – for many middle management positions in the workplace. Corporate finance provides many opportunities to use MS Excel to solve problems that cannot easily be solved manually. In this assignment, you will use MS Excel to prepare pro forma financial statements and also calculate free cash flow for a multi-year business opportunity. While you will not need to use any special functions for this assignment, you will need to consider how you can structure your spreadsheet to be flexible enough to handle sensitivity analysis. Instructions: 1. Use the scenario below to answer the questions. (Note: the websites are just recommendation, and you can freely to use other reliable resources, as long as you are able to find the accurate information required. For example, you can directly go to Caterpillar and Microsoft corporate website and find the information under “Investor” section…) 2. Use Excel for all calculations. 3. Submit your report in Word format. Attach any supporting Excel documents. 4. See the rubric below for the marking criteria. Scenario: This is your second interview with a prestigious brokerage firm for a job as an equity analyst.You survived the morning interviews with the department manager and the vice president of equity. Everything has gone so well that they want to test your ability as an analyst. You are seated in a room with a computer and a list with the names of two companies— Caterpillar (CAT) and Microsoft (MSFT). You need to complete the following tasks:1. Download the annual income statements, balance sheets, and cash flow statements for the last four fiscal years from MarketWatch (www.marketwatch.com). Enter each company's stock symbol and then go to “financials.” Copy and paste the financial statements into Excel.2. Find historical stock prices for each firm from Yahoo! Finance (finance.yahoo.com). Enter the stock symbol, click on “Historical Prices” in the left column, and enter the proper date range to cover the last day of the month corresponding to the date of each financial statement. 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 (see “Basic Weighted Shares Outstanding” on the income statement) by the firm's historic stock price.3. For each of the four years of statements, compute the following ratios for each firm: Valuation Ratios Price-earnings ratio (for EPS use diluted EPS total) Market-to-book ratio Enterprise value-to-EBITDA (For debt, include long-term and short-term debt; for cash, include marketable securities.)Profitability Ratios Operating margin (use operating income after depreciation) Net profit margin Return on equityFinancial Strength Ratios Current ratio Book debt–equity ratio Market debt–equity ratio Interest coverage ratio (EBIT / interest expense)4. Obtain industry averages for each firm from Reuters.com (www.reuters.com/ finance/stocks). Enter the stock symbol at the top of the page in the “Symbol lookup” and then click on the “Financials” button, and then click on “Search”. a. Scroll down to “Valuation Ratios,” and compare each firm's ratios to the available industry ratios for the most recent year. (Ignore the “Company” column as your calculations will be different.) b. Analyze the performance of each firm versus the industry and comment on any trends in each individual firm's performance. Identify any strengths or weaknesses you find in each firm. 5. Examine the market-to-book ratios you calculated for each firm. Which, if either, of the two firms can be considered “growth firms” and which, if either, can be considered “value firms”? 6. Compare the valuation ratios across the two firms. How do you interpret the difference between them? 7. Consider the enterprise value of both firms … read more
F. Naz
F. Naz
B.Com
5,481 satisfied customers
I did it but I am not sure if It is right. I am not looking
I did it but I am not sure if It is right. I am not looking for straight answers, but rather to how did you come up with answers to compare … read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Bachelor's Degree
936 satisfied customers
I need assistance with some corporate accounting homework
I need assistance with some corporate accounting homework questions, given outside of the text book. Could I send these to you for assistance? text is: Graham, J.R. & Smart, S.B. (2012). Introduction … read more
F. Naz
F. Naz
B.Com
5,481 satisfied customers
1. The officer of a corporation responsible for the firms
1. The officer of a corporation responsible for the firm's published financial statements would be most concerned about pronouncements of the: A. FASB. B. AICPA. C. GASB. D. SEC. E. IRS. 2. Which of t… read more
linda_us
linda_us
Master's Degree
Master's Degree
1,402 satisfied customers
It is more expensive to form a proprietorship than a corporation
Question 3.3. Which of the following statements is CORRECT? (Points : 4) It is generally more expensive to form a proprietorship than a corporation because, with a proprietorship, extensive legal docu… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Bachelor's Degree
936 satisfied customers
linda do you still have the answers to the box shared 1 month
linda do you still have the answers to the box shared 1 month ago for finance questions such as agency relationships balance sheet , rate of return for serox company.....?… read more
linda_us
linda_us
Master's Degree
Master's Degree
1,402 satisfied customers
Can I get some help with these questions. This is an emergency. Which
Can I get some help with these questions. This is an emergency. Which of the following is considered a hybrid organizational form? sole proprietorship partnership limited liability partnership corpora… read more
linda_us
linda_us
Master's Degree
Master's Degree
1,402 satisfied customers
1. The Obama Corporation has 120,000 shares outstanding with
1. The Obama Corporation has 120,000 shares outstanding with a current market price of $8.10 per share. The company needs to raise additional $36,000 to finance new expenditures, and has decided on a … read more
F. Naz
F. Naz
B.Com
5,481 satisfied customers
20. A firms capital structure is the mix of financial securities
20. A firm's capital structure is the mix of financial securities used to finance its activities and can include all of the following except stock. bonds. equity options. preferred stock. 21.M&M Propo… read more
linda_us
linda_us
Master's Degree
Master's Degree
1,402 satisfied customers
2. Which of the following statements is CORRECT? a. A firm
2. Which of the following statements is CORRECT? a. A firm that makes 90% of its sales on credit and 10% for cash is growing at a constant rate of 10% annually. Such a firm will be able to keep its ac… read more
linda_us
linda_us
Master's Degree
Master's Degree
1,402 satisfied customers
2. Which of the following statements is CORRECT? a. A firm
2. Which of the following statements is CORRECT? a. A firm can use retained earnings without paying a flotation cost. Therefore, while the cost of retained earnings is not zero, its cost is generally … read more
Mr. Gregory White
Mr. Gregory White
Master's Degree
Master's Degree
874 satisfied customers
1.Most Important Ratio Journal Reflect for a moment on the
1.Most Important Ratio Journal Reflect for a moment on the ratios (working capital, current ratio, quick ratio, debt to asset, debt to equity, times interest earned, gross margin and net margin) prese… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Bachelor's Degree
936 satisfied customers
Which of the following is a sensible reason to pay (or increase)
Which of the following is a sensible reason to pay (or increase) cash dividends to shareholders? a. Since a share price is the present value of expected future dividends, higher dividends payout incre… read more
linda_us
linda_us
Master's Degree
Master's Degree
1,402 satisfied customers
1. Common stocks of the Threes Company which currently has
1. Common stocks of the Threes Company which currently has no debt in its capital structure are trading for $50 a share. Threes has 2 million shares outstanding now. Threes Co. uses the CAPM in estima… read more
F. Naz
F. Naz
B.Com
5,481 satisfied customers
Thanks so much again for your wonderful help. 100% work once
Thanks so much again for your wonderful help. 100% work once again. I wanted to know if you can help me with my next finance quiz as well. I will be able to access it right now and that one is also 30… read more
Bizhelp
Bizhelp
CPA
Bachelor's Degree
539 satisfied customers
The common set of standards and procedures by which audited financial
"FOR LINDA" The common set of standards and procedures by which audited financial statements are prepared is known as the: matching principle. cash flow identity. Generally Accepted Accounting Princip… read more
linda_us
linda_us
Master's Degree
Master's Degree
1,402 satisfied customers
All these are TRUE OR FALSE, except 8 & 9: [1] An option is
All these are TRUE OR FALSE, except 8 & 9: [1] An option is a contract that gives its holder the right to buy or sell an asset at a predetermined price within a specified period of time. [2] The exerc… read more
Bizhelp
Bizhelp
CPA
Bachelor's Degree
539 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x