Answered You can buy a ready-made answer or pick a professional tutor to order an original one.
FIN/ 571 - Week 1 Financial Ratio Analysis
The purpose of this assignment is to help students gain a better understanding of the financial statements used for corporate financial reporting and the key ratios used to make business decisions.
Assignment Steps
Select a Fortune 500 Company from one of the following industries:
- Pharmaceutical
- Energy
- Retail
- Automotive
- Computer Hardware
Review the balance sheet and income statement in the company's 2015 Annual Report.
Calculate the following ratios using Microsoft® Excel®:
- Current Ratio
- Quick Ratio
- Debt Equity Ratio
- Inventory Turnover Ratio
- Receivables Turnover Ratio
- Total Assets Turnover Ratio
- Profit Margin (Net Margin) Ratio
- Return on Assets Ratio
Note: All ratios must be calculated in Excel. Clearly labelled source financial statements must also be provided in Excel using separate tabs. All calculations must be traceable back to the source financial statements. Any deviation from these instructions will result in zero points awarded for the ratios.
Analyze in 1,050 words why each ratio is important for financial decision making.
Submit your analysis as well as your calculations.
Click the Assignment Files tab to submit your assignment.
- @
- 165 orders completed
- ANSWER
-
Tutor has posted answer for $30.00. See answer's preview
*************************** ********* Analysis: ***** ********** NameProfessor ********** ************************* Financial decision ****** in *** corporation ** based ** *** ********* ********** ********* ********** *** *** ********* **** are **** ** ********* *** financial ****** ** *** ******* They ******* a ******** ***** *** ******** ******** **** **** ********** ****** ********* *** ** *** ******* *** ***** numbers ******** ** ********* ********** *** of ****** ********* ***** **** *** compared ** relation ** other ******* ***** ******** is the *** **** **** facilitates *** ******** to **** ********* business ********* ** ******* the ******** ** ******* the ******* with ***** numbers **** **** the ********* statement ******** more meaningful The ****** *** **** be ******** **** ***** years ** **** out *** *********** ** *********** They *** **** ** ******** **** ******** ******** ** ********* This paper ***** ** ******* to calculate *** ****** ** Apple Inc for ********* **** **** All the ****** *** ******** **** ******* to ***** ********** *** financial ************** **************** ****** ****** that *** ******** ** ****** ******* *** users ** know more about *** *********** ********* ****** *** **** help **** ** ******* *** *** company’s ******* ********* ** ******** the financial ****** ** Apple *** ***** ****** *** ********** *** **************** Ratio It ** * ********* ***** that measures the ability of the corporation to ***** its short **** obligations **** *** current ****** ** ********** what the ******* *** ** ******* ****** ******* **** dollar ** ******* *********** *** current ***** ** Apple *** *** *** ****** *** ****** **** **** ***** ********* ** *** ****** *** ****** year 2015 ** ********* **** *** ********* ** *** ******* *** ******** during the ****** **** 2015 and *** ******* has ********** ******* ****** ** pay its current *********** **** ***** ** ********* in ********* decision ****** because ** analyzes the ********* position ** the ******* *** its ability ** *** ***** term obligationsCurrent ***** = ******* Assets/Current **************************** ******* ****** 68531Current ************ ****** 63448Current ***** 111108 Quick Ratio It ** **** * ********* ratio *** measures the ******* ** * corporation to honor its short term *********** **** *** ***** ****** ** ********** what *** ******* has in quick assets against **** ****** ** ******* liabilities *** ***** ratio ** ***** Inc was *** ****** *** ****** **** **** ***** improved ** *** ****** *** ****** year 2015 * ***** ***** ** * ** ********** ideal *** higher ***** ratio ********* higher ******* ** *** ******* ** ***** *** short term *********** ** **** ** ** ********* ** ********* ******** making because ** analyzes the promptness ** *** ******* ** ****** *** current liabilitiesQuick Ratio * Quick ************** ************************ ******* ****** ************ Liabilities$ 80610$ 63448Quick *************** ** Equity ** ** a financial ratio *** ******** *** ***** debts ** the ******* **** its total ****** ** ********** *** ********** ** ********* of *** ******* **** ***** from *** creditors ** *** **** ** equity ** higher **** it ** an ********** **** *** ******* *** **** **** ****** ********* *** ***** ** ***** *** *** *** ****** *** ****** **** **** which increased ** 143 ****** the ****** **** 2015 ** ********* ** ******** ** *** ratio *** ******** **** the ******* is ****** ***** ** $143 against each ****** of ****** ** ** ********* ** ********* decision ****** because ** tells about *** debts *** ******* ** ******* having *** to **** ****** ** *** increase ** ***** ********* ** ****** * ***** ***************** Equity20152014Total Liabilities$ ******* *********** Equity$ 119355$ ********** ** ****** 143108 Inventory ******** Ratio This ** an ********** ratio *** ******** the ability *** ********** ** the ******* ** ******** *** inventory It ******** the ****** ** times *** ******* has ****** its ********* **** **** during * given ****** The ********* ******** ** ***** Inc *** **** ****** *** ****** **** **** ***** improved *** stood at **** ****** the ****** year **** ** suggests that *** ******* *** ******* its ********* **** *********** ****** *** fiscal year **** **** ***** ** ********* in ********* ******** making ******* it ******* *** ********** ** **** ********** ** ******* ********* *** inventory as large amount ** ******* ******* ** ********* ** blocked ** ******************** Turnover = **** ** ***** Sold/Average ********************* ** ***** ***** ******* 112258Average ********** ***** ************* ******** ********************* ******** ** ** **** an efficiency ***** *** ******** *** ******* ** *** ******* ** ********** its ****** sales into cash It ******** *** ****** ** ***** the company *** ********* its ****** ***** **** **** The ***** ** ******* *** **** ****** *** ****** year 2014 ***** improved ** **** ****** *** ****** **** **** ** ********* that *** company *** ******* *** *********** **** efficiently ****** the ****** **** **** It ** important ** ********* decision ****** because it ******* *** management to **** *** *** **** *** money **** be ******** **** *** ******** receivablesReceivables ******** = Net Credit Sales/Average Accounts Receivable20152014Net ****** ****** ******* ************* ******** Receivables$ ****** **************** ******** *************** ****** Turnover ** ** also an ********** ***** *** ******** the ******* ** the ******** ** ******** ******* or ***** from *** ****** *** ***** ** Apple Inc ******** **** 083 in ****** year **** ** 089 ****** the fiscal **** **** It ********* **** the ******* *** ******* *** ****** in **** ********* manner ** ******** **** ****** *** fiscal **** **** **** ***** ** ********* *** ********* decision ****** ******* ** ******* *** ******** ****** ***** the return **** *** ** generated **** the assetsTotal ****** ******** = *** Sales/Average ***** Assets20152014Net ****** 233715$ 182795Average ***** Assets$ ******* *********** Assets ******** ************** ****** This ***** ******** *** ************* of *** company ** making * comparison between net ****** *** net sales *** ***** of ***** *** *** ***** ****** *** ****** **** **** ***** ********* ** ***** during ****** **** 2015 ** ******** **** the profitability ** *** ******* *** increased ****** the fiscal **** 2015 **** ***** ** ********* for ********* ******** making ** ** ******* *** ******** ****** ** ******** *** ***** **** will *********** get ** **** ** ************* ****** * Net ********** Sales20152014Net Income$ 53394$ ******** ****** ******* ************ ****** ****************** ** ****** ** ** a ************* ***** *** ******** *** ******* ** the ******* ** generate net ****** **** *** assets *** ***** ** ***** *** *** ***** ****** *** fiscal **** **** ***** improved ** ***** ****** *** ****** **** **** It ********* **** *** company *** ******** *** ****** ** a ****** ****** during the ****** year **** *** ***** ** ********* *** financial ******** ****** as ** enables *** decision ****** to know ***** the *** ****** *** company ** ******* ** its ************ ** ****** * *** ************** ***** ***************** ******* 53394$ 39510Average Total ******* ******* ************ on ************************************************ * ****** *** ** ******* **** ******** ***** financial ratiosBusiness ************ Bank ****** **** FoundationForm **** (2015) ***** *** ********* *********************************************************************************************************************************************
