BSBI525: Income Statement and Balance Sheet Financial Statements - Accounting Assignment Answer

BSBI525 Accounting Assignment Task

Case Project 
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 – Ford (stock symbol F) and Microsoft (stock symbol MSFT) and are asked to do the following analysis including computing stock ratios for F and MSFT, comparing and contrasting those ratios, and analyzing the performance of the stocks versus the industry averages.
Complete the following tasks and write a four- to five-page report on your findings, including the analysis in Questions 2 and 3 below.

Q1. Download the income statement and balance sheet financial statements for each company.

A. Navigate to Morningstar (http://www.morningstar.com/). In the Quote box at the top of the page, enter each stock symbol, choose your companies, and click on the Financials tab. You will see underneath Financials tab the three financial statements (Income Statement, Balance Sheet, and Cash Flow). An Export button is to the far right.
B. Next, you will need historical data for each stock. Navigate to Yahoo! Finance enter each stock symbol, click on Historical Data, and select ending date of the most recent full reported year (for example, if the income statement ending is December 2016, select December 30 to 31, 2016).
Note the company’s stock closing price for the last day of the financial statement reporting period you will use for this assignment.

To determine each organization’s market capitalization at the closing date of the most recent annual statements you downloaded from Morningstar, multiply the number of shares outstanding by the stock price you obtained from Yahoo! Finance. Use the number of shares outstanding by using Basic under Weighted Average Shares Outstanding on the income statement you downloaded from Morningstar (remember, the share value will be in millions of shares so make the adjustment by adding 0s).

Q2- Compute the following ratios for F and MSFT for the most recent year of financial statements downloaded from Morningstar:

a. Price-earnings ratio (for EPS, use diluted EPS total)
b. Market-to-book ratio (aka price-to-book ratio)
c. Operating margin
d. Net profit margin
e. Return on equity
f. Current ratio
g. Quick ratio
h. Debt-to-equity (for debt, use long-term debt) Obtain industry averages for each company by going to Reuters Click the magnifying glass search
icon, enter each company’s name, click on Companies, select each company, and then the Financials tab. Scroll down under Valuation Ratios and each ratio you calculated to the industry (ignore the current company ratios as these are not the same as you calculated).

Q3- Analyze the performance of each firm versus the industry, and comment on what you find in terms of strengths and weaknesses.

Q4- Compare and contrast the ratios for F and MSFT.

1. What might explain the differences between them? 
2. Would you recommend investors buy, hold, or sell F and MSFT, based on your analysis? 

Q5- What ethical issues could confront a financial manger? 

This Accounting Assessment has been solved by our Accounting experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.