Xem mẫu
Chapter 6 – Support
Financial Statement Analysis
6b.1 Van Horne and Wachowicz, Fundamentals of Financial Management, 13th edition. © Pearson Education Limited 2009. Created by Gregory Kuhlemeyer.
Remember?
Common-size Analysis
An analysis of percentage financial statements where all
balance sheet items are divided by total assets and all income statement items are divided by net sales or revenues.
6b.2 Van Horne and Wachowicz, Fundamentals of Financial Management, 13th edition. © Pearson Education Limited 2009. Created by Gregory Kuhlemeyer.
and Remember? Index Analyses
An analysis of percentage financial statements where all balance sheet
or income statement figures for a base year equal 100.0 (percent) and subsequent financial statement items are expressed as percentages of their values in the base year.
6b.3 Van Horne and Wachowicz, Fundamentals of Financial Management, 13th edition. © Pearson Education Limited 2009. Created by Gregory Kuhlemeyer.
Use Excel to Conduct a Common-Size Analysis
First, go to http://finance. yahoo.com and type in ‘GOOG’ in the ‘Get Quotes’ box to find a company like Google.
Source: Reproduced with permission of Yahoo! Inc. ® 2008 by Yahoo! Inc. YAHOO! and YAHOO! logo are trademarks of Yahoo! Inc.
6b.4 Van Horne and Wachowicz, Fundamentals of Financial Management, 13th edition. © Pearson Education Limited 2009. Created by Gregory Kuhlemeyer.
Use Excel to Conduct a Common-Size Analysis
Next, click the ‘Get Quotes’ box to access the Google data.
Notice on the left side all of the data that Yahoo! Provides for users.
Source: Reproduced with permission of Yahoo! Inc. ® 2008 by Yahoo! Inc. YAHOO! and YAHOO! logo are trademarks of Yahoo! Inc.
6b.5 Van Horne and Wachowicz, Fundamentals of Financial Management, 13th edition. © Pearson Education Limited 2009. Created by Gregory Kuhlemeyer.
...
- tailieumienphi.vn
nguon tai.lieu . vn