Financial Statement Analysis
Financial Statement Analysis
Financial Statement Analysis
Horizontal Analysis
1. 2.
3.
Vertical Analysis
1. Financial statements reduced to
3. Income statement:
ALPHA Co. Illustration Dollars % Net revenue $100,000 100% Cost of sales 35,000 35 Labor costs 30,000 30 Other expenses 30,000 30 Net income $5,000 5%
Ratio Analysis
Comparing two related numbers from financial statements Expressed as $, %, times, days, etc. Purposes for managers: Express goals for business Track performance of the operation Communicate financial performance Result must be compared to a standard
2007 Pearson Education, Inc. Upper Saddle River, NJ 07458
Standards
Budget
Classes of Ratios
Liquidity can the firm meet its short-term
obligations? Solvency can the firm meet its long-term obligations? Activity how is management using the propertys assets? Profitability how profitable is the business? Operating how efficient is management in running the business?
2007 Pearson Education, Inc. Upper Saddle River, NJ 07458
Liquidity Ratios
Current Ratio indicates relationship between current assets and current liabilities Formula: CR = Current Assets/Current Liabilities
Acid-Test Ratio
Acid-Test Ratio:
Quick Assets Current Liabilitie s
Purpose of ratio is compare operating cash flows to current debt. (Cash pays the bills, not CA!) OCF to CL Ratio = OCF/Average CL
Evaluation
The current and acid-test ratios are increasing throughout the 2008-2010 period. The AR T/O is decreasing resulting in relatively more accounts receivable outstanding. ACP was 30.4 days at the end of 2008 and increased to 36.5 days at the end of 2010. This increase should be further investigated. Operating cash flows are increasing overtime in relation to the current obligations. Overall liquidity is improving; however, there is some concern regarding accounts receivable.
Andrew, Damitio, Schmidgall Financial Management for the Hospitality 2007 Pearson Education, Inc. Upper Saddle River, NJ 07458
Solvency Ratios
Two major perspectives balance sheet and income statement Balance sheet Debt-equity LTD to total capitalization Income statement Number of times interest earned (TIE) Fixed charge coverage SCF: OCF to total liabilities ratio
2007 Pearson Education, Inc. Upper Saddle River, NJ 07458
Debt-Equity Ratio
Shows amount of debt for each $1 of owners equity DE Ratio: total liabilities/total owners equity
Indicates the number of times interest can be covered with income TIE = EBIT/Interest Expense
Lease expense is added to the numerator and denominator of the TIE ratio FCC Ratio = (EBIT + Lease Expense)/ (Interest + Lease Expense)
Evaluate the changing solvency of BC, Inc. over the three years
Andrew, Damitio, Schmidgall Financial Management for the Hospitality 2007 Pearson Education, Inc. Upper Saddle River, NJ 07458
Evaluation
Both the debt-equity and LTD to total capitalization ratios reveal relatively less debt to equity over the three years. The increasing TIE and OCF to TL ratios suggest an increasing ability to pay the longterm liabilities. The decreasing fixed charge average ratio suggests lease expense (and most likely the number of leases) are increasing over time. Overall solvency has improved and in part this has happened by switching to leasing as a means of finance.
Andrew, Damitio, Schmidgall Financial Management for the Hospitality 2007 Pearson Education, Inc. Upper Saddle River, NJ 07458
Activity Ratios
Inventory Turnover Property and Equipment Turnover Asset Turnover Non-financial ratio: occupancy
Inventory Turnover
This ratio shows how quickly inventory
is moving
Provides the average number of days inventory is held prior to sale FIHP =
365 Food Inventory Turnover
Rooms sold include all rooms occupied except for complimentary rooms
Rooms available include rooms that could be sold and generally exclude out-of-order rooms
2007 Pearson Education, Inc. Upper Saddle River, NJ 07458
How has managements use of the companys resources changed over the three year period?
Evaluation
Food inventory is turning more quickly from 2008 through 2010 as is both property and equipment and total assets. This result is considered good. Paid occupancy is declining slightly. Management appears to be selling few rooms; however, the ADR (price per room) could be a major factor. This requires additional management attention.
Andrew, Damitio, Schmidgall Financial Management for the Hospitality 2007 Pearson Education, Inc. Upper Saddle River, NJ 07458
Profitability Ratios
These ratios measure the overall effectiveness of management Major ratios include: Profit Margin Operating Efficiency Ratio Return on Assets Return on Equity EPS PE Ratio
2007 Pearson Education, Inc. Upper Saddle River, NJ 07458
Profit Margin
Measures the profits from sales Profit Margin =
Net Income Total Revenue
Reflects the relationship between the market price per share and the EPS
PE =
Evaluation
Profit margin is increasing each year even though the operating efficiency ratio is in decline. ROA, ROE, and EPS are increasing each year. This suggests that greater profits are being achieved by relative reductions in fixed charges such as interest expense and depreciation. The market appears to be reacting favorably to these changes since the PE ratio has increased from 10 times in 2008 to 12 times in 2010. The market price at the end of 2008 was $20 and at the end of 2010 it was $26.40.
Andrew, Damitio, Schmidgall Financial Management for the Hospitality 2007 Pearson Education, Inc. Upper Saddle River, NJ 07458
Operating Ratios
Assist management in analyzing the
REVPAR
Measures a combination of paid occupancy % and ADR REVPAR = Paid OCC % X ADR
labor costs and revenue Labor cost generally is the highest single cost of a hospitality organization Labor costs include salaries, wages, fringe benefits, and payroll taxes Ratio should be computed for each profit center of the operation
2007 Pearson Education, Inc. Upper Saddle River, NJ 07458
Labor Cost %
Labor Cost % =
Evaluate the operating activities of the Wisker Restaurant & Inn over the three-year period based on the above four ratios
Andrew, Damitio, Schmidgall Financial Management for the Hospitality 2007 Pearson Education, Inc. Upper Saddle River, NJ 07458
Evaluation
First, one should be very careful when evaluating any aspect of business with so few ratios. Even so, these four ratios suggest Prices are increasing but the amount per room available is
decreasing from 2008 through 2010. This appears to suggest some price resistance and management should undertake further evaluation. Both food cost and labor cost percentages are decreasing over the three year period. If quality is not sacrificed this is good from a financial perspective.
Are they in the same industry? Are they using the same or similar
accounting procedures?
Andrew, Damitio, Schmidgall Financial Management for the Hospitality 2007 Pearson Education, Inc. Upper Saddle River, NJ 07458
Summary
Financial analysis includes horizontal, vertical and ratio analysis Ratios can be used to efficiently communicate, control and set targets Major classes of ratios include liquidity, solvency, activity, profitability, and operating Ratios vary in importance to major user groups Ratios must be compared to a standard to be meaningful
2007 Pearson Education, Inc. Upper Saddle River, NJ 07458