Multiple Problems

For Help with Multiple Homework Problems, Ask an Expert

Ask an Expert,
Get an Answer ASAP!

ASSIGNMENT 2: FINANCIAL STATEMENT ANALYSIS Weighting: 7%

Customer Question
ASSIGNMENT 2: FINANCIAL STATEMENT...

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

Submitted: 3 months ago.Category: Multiple Problems
Show More
Show Less
Ask Your Own Multiple Problems Question
Answered in 43 minutes by:
3/22/2018
Business Tutor: F. Naz, B.Com replied 3 months ago
F. Naz
F. Naz, B.Com
Category: Multiple Problems
Satisfied Customers: 5,480
Experience: have completed B.Com and CA Finalist
Verified

If you tell what is your deadline and also tell will you be able to cite my work in your assignment, thanks.

Ask Your Own Multiple Problems Question
Customer reply replied 3 months ago
I would need it by March 22nd 9pm (MDT) atleast. What do you mean cite your work?
Customer reply replied 3 months ago
would you be able to complete it on time?
Business Tutor: F. Naz, B.Com replied 3 months ago

In your final submission you will have to give reference of my work done, and how many hours are remaining from now, as I live in different time zone, thanks.

Ask Your Own Multiple Problems Question
Customer reply replied 3 months ago
Unfortunately it's individual work so I cannot mention someone else completed it
Customer reply replied 3 months ago
About 11h
Business Tutor: F. Naz, B.Com replied 3 months ago

Sorry I am unable to do this and the time is too short.

Ask Your Own Multiple Problems Question
Customer reply replied 3 months ago
Can u do it in 13h?
Customer reply replied 3 months ago
I dont get it my account was already charged 75$
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,480 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
This is your second interview with a prestigious brokerage
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. Everyt… read more
F. Naz
F. Naz
B.Com
5,480 satisfied customers
For Linda, 1. (Weighted average cost of capital) The target
For Linda, 1. (Weighted average cost of capital) The target capital structure for QM Industries is 45% common stock, 7% preferred stock, and 48% debt. If the cost of common equity for the firm is 17.8… read more
linda_us
linda_us
Master's Degree
1,402 satisfied customers
4. (Weighted average cost of capital) As a member of the
4. (Weighted average cost of capital) As a member of the Financial Department of Ranch Manufacturing, your supervisor has asked you to compute the appropriate discount rate to use when evaluating the … read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Bachelor's Degree
936 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,480 satisfied customers
Caledonia Products Calculating Free Cash Flow and Project
Caledonia Products Calculating Free Cash Flow and Project Valuation It's been two months since you took a position as an assistant financial analyst at Caledonia Products. Although your boss has been … read more
linda_us
linda_us
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
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
I have an exam that has 30 questions that I need help with. 1)
I have an exam that has 30 questions that I need help with. 1) The goal of the firm should be A. maximization of profits B. maximization of shareholder wealth C. maximization of consumer satisfaction … read more
linda_us
linda_us
Master's Degree
1,402 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
001. The target capital structure for QM industries is 41%
001. The target capital structure for QM industries is 41% common stock, 8% preferred stock, and 51% debt. If the cost of common equity for the firm is 17.7%, the cost of preferred stock is 9.7%, the … read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Bachelor's Degree
936 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,480 satisfied customers
1) QMs weighted average cost capital , the target capital structure f
1) QM's weighted average cost capital , the target capital structure for QM industries is 38% common stock 6% preferred stock , and 56% debt. if the cost of common equity for the firm is 18% the cost … read more
linda_us
linda_us
Master's Degree
1,402 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
Balance Sheet Year 20X1 Assets Current assets Cash 16,550 Accounts
Balance Sheet Year 20X1 Assets Current assets Cash 16,550 Accounts Receivable 9,600 Inventories 6,500 Total current assets 32,650 Net building & equipment 88,000 Accumulated depreciation (34,000) Tota… read more
F. Naz
F. Naz
B.Com
5,480 satisfied customers
E14-1 Stephanies Cafes, Inc., has declared a dividend of $1.30
E14-1 Stephanie's Cafes, Inc., has declared a dividend of $1.30 per share for shareholders of record on Tuesday, May 2. The firm has 200,000 shares outstanding and will pay the dividend on May 24. How… read more
linda_us
linda_us
Master's Degree
1,402 satisfied customers
Linda do you have the answers to this still I am willing to
Linda do you have the answers to this still I am willing to pay you for them..$20 bucks correct.. 1) The goal of the firm should be A. maximization of profits B. maximization of shareholder wealth C. … read more
linda_us
linda_us
Master's Degree
1,402 satisfied customers
Show ALL workRatio Analysis. The Williams Corporations
Show ALL work Ratio Analysis. The Williams Corporation's forecasted 2010 financial statements follow, along with some industry average ratios. Forecasted Balance Sheet as of December 31, 2010 Cash $ 7… read more
ezcpa
ezcpa
Certified Public Accountant
Bachelor's Degree
254 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