This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: F INANCE 307-07 & 08: Survey of Finance EXCEL ASSIGNMENT #1: Financial Ratio Analysis Dr. H. Christine Hsu Spring 2010 The objective of this assignment is to evaluate the financial performance of Apple Inc. against its industry norm. Students will perform the industry comparative analysis based upon the following financial ratios in four performance areas: Leverage Ratios : to measure the extent to which the company’s assets are financed with debt and to the company’s ability to service the debt Liquidity Ratios : to measure the company’s ability to pay its bills Efficiency Ratios : to measure the company’s ability to utilize its assets Profitability Ratios : to measure the company’s ability to generate earnings TO DO L IST: 1. I ndustry Comparative Analysis To retrieve Company / Industry comparison report: • Go to MSN Money home page (http: / / moneycentral.msn.com /home.asp) • Enter Company Symbol: AAPL • On Company page, scroll down and double click on Financial results...
View Full Document
- Spring '10
- Ratio Analysis, Financial Ratio, ratio Current Ratio, Ratio Leverage Ratio