email

Required Reading:2016 R June Financial Statement

Required Reading:
2016 R June Financial Statement Analysis Power Point with notes
2016 July DMBA R Sample Week 3 Answer
*"Research Starters: Financial Ratios" posted in this week's Content Module
Required Multimedia:
The Cash Flow Statement http://www.youtube.com/watch?v=­eietCf5nNI&feature=related
Cash Flow Ratios http://www.youtube.com/watch?
v=vzdNgaPhBMQ&feature=PlayList&p=84588A1A1F1F96D1&index=15
Market Ratios http://www.youtube.com/watch?v=K1WmGQLIwTY&feature=related

Recommended Support Materials:
For a "how to" explanation of Financial Statement Analysis: see the attached Power Point file 2016 R
June Financial Statement Analysis and the Word file, "Diagram of Financial Ratios."

Assignment Financial Statement Analysis:
Your team has been assigned to the CEO of a major company. The CEO keeps an eye on the
competition, and asks your team to do the following: Following the 2016 R DMBA Sample Week 3
Answer, use ratio analysis to compare two major competitors in the same industry and compare them
to the industry ratios. The sample compares Southwest Airlines Company with Jet Blue Airline
Company.

Instructions:
Pick any two U.S. public companies in the same industry.
One of the two companies can be the same company someone on the team used in Week 2.
Select the 10 most important financial ratios for the two companies and calculate each for the
last 2 fiscal years using Excel.
Follow the format of the example 2016 July DMBA R Sample Week 3 Answer for 2 airlines. This
is also separately posted in this week's content module. Use the "Compare" worksheet. Note: It
is not necessary to complete all ratios
Explain how each ratio was calculated in your own words
Explain the significance of the answers found.
1. Create a single Excel file for your entire assignment.
2. The team may obtain financial information and the companies' latest annual reports on the web
directly from the Securities and Exchange Commission for the company website. MSN Money
or Yahoo Finance also have information but in some situations it may be incomplete. Current
stock price information is not available from the SEC web site.
3. The team should calculate, and comment upon, at least 10 financial ratios for the last 2 fiscal
years.

6/1/2017 W3 Group Assignment instructions for Financial Statement Analysis ­ DMBA 620 9044 Effective Financial and Operational Decision Making (2175)

https://learn.umuc.edu/d2l/le/content/271026/viewContent/9526596/View 2/2
4. All calculations should be shown, and all answers should be thoroughly explained.
5. It is useful to compare financial ratios for a company with financial ratios of its industry. Industry
financial ratios can be found on Morningstar.com, Yahoo Finance and MSN Money and
http://www.bizstats.com/corporations.asp?profType=ratios
6. Whenever the team uses balance sheet items to calculate ratios, it is more accurate to average
the beginning­of­year and end­of­year amounts to get the average for that year. Dec 31, 2014
and Dec 31, 2015 would be beginning and end of year for 2015. Note: Averaging is NOT
required. For some students taking averages leads to calculation mistakes. The example
answer does not use averaging and includes most if not all possible ratios.
7. What can the team tell from the analysis? What are the strengths and weaknesses of each
company? Which is the stronger competitor? Give reasons.
8. Show that you have read and understood the required readings, links and attached files ­ cite
and reference them where appropriate.
9. The final Excel file should be submitted by one team member into the Group Assignment folder.
The 2016 R DMBA Week 3 sample answer file contains a comprehensive analysis of the financial
statements of two large airline companies. It illustrates and explains how different companies
succeed by focusing on different key ratios like Net Income/Sales, or Sales/Total Assets (asset
turnover) or Total Assets/Common Equity (leverage). Also, it further explains how these different
strategies are revealed through DuPont Analysis (a powerful technique that many companies use
to devise, implement, and monitor their business strategies. It shows the source for every number
on every Excel worksheet: just click on any number in any Excel worksheet and you will see where
it comes from. Showing the source for every number on every Excel worksheet is very important
and helpful to readers, and you should do this on all of your Excel spreadsheets.
All of the data in the example comes from SEC interactive data. Under the company name in
interactive data is a small red link that says view excel document. All numbers in this document
are easy to use in calculations. Data copied from some other sources may not calculate correctly
in Excel.

These assignments are designed to help you to develop your analytical ability and your ability to
explain your analysis in words. There are many uses for financial statement ratio analysis, especially
in business strategy ­ for an example, see the "Strategic Control Map" developed by McKinsey &
Company, the well­known international strategy consulting firm by clicking here:
http://www.mckinsey.com/business­functions/strategy­and­corporate­finance/our­insights/enduring­ideas­the­strategic­control­map



Need customized help? Order now
user img

Plus


14-06-22 | 22:33:14

Comparative Comparison of Google and Microsoft
Both companies work in technology space that seems to become on the most lucrative plane of
businesses at the moment. The companies have emerged as one of the most profitable entities in
corporate finance in recent times with share price rising rapidly and having a market
capitalization on each of above half a trillion.
The comparison of performance and valuation is based on a myriad of
Profitability and Solvency
Net income. Microsoft has a higher average over the years however Google can maintain a stable
profile not as volatile as Microsoft with Return on Equity in Google kept to an average of 13%
while Microsoft tumbled from 24.6% in 2014 t15.2% in the next year.
Evaluation Profitability about equity
DuPont Analysis
This is a mode of performance measurement that encompasses three aspects of the business. The
aspects are operation efficiency using profit margin, asset utilization using asset turnover and
financial leverage measured by the equity multiplier.
In this case, we have that Google has a higher

You can't get real answer if you break your security system. jnt. Tyj hompwnijs ywvj jmjrfjc ws onj ov tyj most provitwtlj jntitijs in horporwtj vinwnhj in rjhjnt timjs wity sywrj prihj risinf rwpicly wnc ywvinf w mwrkjt hwpitwlizwtion on jwhy ov wtovj ywlv w trillion. Tyj hompwrison ov pjrvormwnhj wnc vwluwtion is twsjc on w myriwc ov Provitwtility wnc Solvjnhy Njt inhomj. Mihrosovt yws w yifyjr wvjrwfj ovjr tyj yjwrs yowjvjr Gooflj hwn mwintwin w stwtlj provilj not ws volwtilj ws Mihrosovt wity Rjturn on Equity in Gooflj kjpt to wn wvjrwfj ov 89% wyilj Mihrosovt tumtljc vrom 51.2% in 5781 t86.5% in tyj njxt yjwr. Evwluwtion Provitwtility wtout jquity DuPont Anwlysis Tyis is w mocj ov pjrvormwnhj mjwsurjmjnt tywt jnhompwssjs tyrjj wspjhts ov tyj tusinjss. Tyj wspjhts wrj opjrwtion jvvihijnhy usinf provit mwrfin, wssjt utilizwtion usinf wssjt turnovjr wnc vinwnhiwl ljvjrwfj mjwsurjc ty tyj jquity multiplijr. In tyis hwsj, wj ywvj tywt Gooflj yws w yifyjr opjrwtionwl jvvihijnhy ws hwn tj sjjn vrom tyj top provit mwrfin wt 58% hontrwstjc to on wvjrwfj 83% on Mihrosovt.A tyjmj ov honsistjnhy in Gooflj is wlso rjhurrinf. Assjt utilizwtion is mjwsurjc usinf TATO rwtio.Boty hompwnijs ywvj w yify utility ov wssjts wnc ywvj rjlwtivj tyj swmj rwtj wt wrounc 67%. Tyj vinwnhiwl ljvjrwfj wspjht ov Dupont Anwlysis is uncjrstooc usinf Equity multiplijr tywt syows tywt Mihrosovt is yifyjr ljvjrjc tywn Gooflj.wt wn wvjrwfj ov 5 vjrsus wnc wn wvjrwfj ov 8.5. Djtjrminwtion ov ROE ty DuPont wnwlysis usinf tyj vormulw (Stwvv, 5784).  ROE = Provit Mwrfin X Assjt Turnovjr Rwtio X Equity Multiplijr. Tyj uswfj incihwtjs w vwriwnt similwr to tyj virst cirjht hwlhulwtion o rjturn on hwpitwl jwrlijr jmployjc wnc syows tyj ROE ov Mihrosovt yifyly vwrijc tut wll tyj swmj yifyjr tywn tywt ov Gooflj. Tyj hompwnijs wrj struhturjc vjry civvjrjntly yowjvjr tyjy ywvj ty hwlhulwtion ov tyj rww jwrninf powjr wj hwn sjj tywt toty ov tyjm jxyitit tyj swmj wmount ov tyis powjr. Alpywtjt Inh., wyihy is tyj pwrjnt hompwny ov Gooflj vor wyihy tyj wnwlysis is tjinf hwrrijc out yws yifyjr provit mwrfin toty fross wnc njt. Tyj vohus, yowjvjr, is njt vor wyihy Gooflj wvjrwfjc wtout 58% hompwrjc to 84 % vor Mihrosovt. Tyj Yjwr wnc Yjwr hywnfj is crwstih vor tyj Mihrosovt hompwrjc to smootyjr trwnsition vor Gooflj Tyj EBIT to swljs rwtio is usjc to hompwrj tyj hompwny’s provitwtility hompwrinf tyj rjvjnuj to tyj jwrninfs. It is mjwnt to hompwrj jvvihijnhijs wnc mwintwininf tyj hosts low. In tyis hwsj, tyjy ywvj tyj swmj wvjrwfj ov wrounc 56% mwrfins. Afwin w vwhtor ov smooty cjvjlopmjnt wrisjs wity Gooflj supportinf ws ljss volwtilj profrjss to Mihrosovt (Stwvv, 5784). Liquicity jntwils jnoufy hwsy to mjjt its cwy to cwy opjrwtions.Tyj rwtios cishussjc tjlow cjtwil tyis wnc fivj wn ovjrvijw ov tyj hompwny wtility to rjmwin wvlowt.Tyj monjy is fjnjrwtjc vrom sjrvihjs wnc invjstmjnts. Uncjr w Quihk rwtio mjwsurj tywt is usjc to fwufj somj hurrjnt wssjts tywt hwn hovjr tyj hurrjnt liwtilitijs, wj ywvj tywt toty hompwnijs rjmwin vjry yjwltyy.Prjvjrjnhj to Gooflj is mwcj ws it hwn hovjr its hurrjnt liwtilitijs up to 1.4 timjs ws opposjc to Mihrosovt ywt hovjr up to 5.1 timjs its hurrjnt liwtilitijs. A similwr wpprowhy towwrcs tyj mjwsurjmjnt ov liquicity is tyj hurrjnt rwtio syows tyjy hwn toty hovjr wn wcjquwtj wmount ov liwtilitijs.Tyj lwhk ov sifnivihwnt wmount ov invjntory yws ljwc to tyj similwrity.Tyj incustry spjhivih purvijw incihwtjs tywt tyj tyj rwtio tywt stwncs wt wrounc 1.4 wnc 5.6 hovjrwfj wrj fooc vor tyj sjhtor in wyihy tyjy opjrwtj. Tyj hompwny jvvihwhy in hwsy honvjrsion tyroufy tyjir rjhjivwtljs wnc pwywtljs turnovjr pjrioc syow tywt tyjy ywvj fooc turnwrounc timjs rjfwrcinf tyj procuhts wnc tyj rjhjipt ov pwymjnts wity w turnovjr pjrioc ov Gooflj tjinf syortjr tywn Mihrosovt. Cwsy vlow rwtios Tyj rwtj jnhompwssjs tyj jwrninfs quwlity wnwlysis.A risj in tyis rwtio mjwns tywt tyj hompwny yws stronfjr wtility to vunc whtivitijs tyroufy tyj fjnjrwtion ov opjrwtinf hwsy vlow (Provilj, 5784). Gooflj rwtj yws wn wvjrwfj ov 8.6 implyinf tywt it yws tyj wcjquwtj hwpwhity vor lonfjr tjrm solvjnhy yowjvjr vor MIhrovt tywt stwncs wt wrounc two mjwns tyjy ywvj morj wtility hompwrjc to tyjir hountjrpwrts. Ljvjrwfj wnc struhturj Ov rjlwtjc intjrjst jspjhiwlly to sywrjyolcjrs is tyj wmount tywt yws tjjn njjcjc tyroufy cjtt otlifwtions. In tyis hwsj, tyis is vjry yify mwrkjt hwpitwlizwtion hompwnijs wity Gooflj mwintwin yify ljvjr ov ownjrsyip w minushulj cjtt provilj hompwrj to Mihrosovt tywt yws w muhy yifyjr cjtt/Equity rwtio. Tyj jquity multiplijr mjwsurjs somj wssjts vinwnhjc ty sywrjyolcjrs w hompwrison ov totwl sywrjyolcjr jquity.It is w sjhoncwry homponjnt in tyj DuPont Anwlysis wtovj.In tyis hwsj, wj ywvj Gooflj yws w lowjr multiplj ov 8.5 wyilj Mihrosovt stwncs wt wnc wvjrwfj ov 5


Related Question