Financial Accounting Project - Ratio Analysis of Fixed Assets NEED ASAP

profileEstero1
etejada_finacctinprojectspreadsheet_101114.xlsx
Home>Business & Finance homework help>Accounting homework help>Financial Accounting Project - Ratio Analysis of Fixed Assets NEED ASAP

Vertical_Horizonal Analysis

Week 1 fill in the numbers-this tab only. Complete blue highlighted areas only. There are no calculations in week one.
Table I (Amounts in $thousands, except per share amounts)
TRANSDIGM GROUP INCORPORATED Vertical Analysis year 1 Vertical Analysis Year 2 Horizontal Analysis
Income Statement 2013 2012 2011
Net Revenue (net sales) 1,924,400 1,700,208 1,206,021
Cost of Goods 874,838 754,491 544,836
Gross Profit 1,049,562 945,717 661,185
Total Operating Expenses 300,107 245,942 193,959
Earnings from Operations 749,455 699,775 467,226
Interest Expense 300,966 211,906 257,710
Net Earnings 448,489 487,869 229,425
Balance Sheet
Cash/cash equivalents (cash) 564,740 440,524 376,183
Short term investments 51,725 53,721 39,499
Net Accounts Receivable 240,449 235,783 189,293
Inventory 413,581 320,503 265,317
Current Assets 1,320,495 1,050,531 870,292
Net Fixed Assets 4,828,384 4,409,086 3,643,344
Total Assets 6,148,879 5,459,617 4,513,636
Current Liabilities 31,045 20,500 206,859
Long Term Liabilities 6,454,215 4,220,283 3,495,828
Total liabilities 6,485,260 4,240,783 3,702,687
Stockholders Equity - 336,381 1,218,834 810,949
Total liabilities + Stockholders Equity 6,168,879 5,459,617 4,513,836
Prepared by your name
Select numbers taken from financial statements
TRANSDIGM GROUP INCORPORATED AND SUBSIDIARIES ANNUAL REPORT ON FORM 10-K FISCAL YEAR ENDED SEPTEMBER 30, 2013
Optional Information
Any Preferred Stock
Dividends paid Common shareholder 1,991,350 3,299 2,811
Dividents paid to Preferred shareholder - - -
Outstanding Shares Common Stock 53,172,551 52,157,225 50,829,276
Basic EPS (Earnings Per Share) $2.39 $ 5.97 $ 3.17
Auditing Firm Ernst & Young Ernst & Young Ernst & Young

Financial Ratios

Table II
Company Company* Company* Competition or Industry Ratio**
Formula Year 1 Year 2 give the year here
Liquidity Ratios 1. Complete the formula column. See example for gross profit percent.
Current Ratio 2. Use the numbers on the previous page to complete the ratios-Use Excel formulas.
Acid Test Ratio 3. One * means you did the calculations
Two ** means you got the information from another source (cite that source)
Asset Management Ratio 4. For column E choose a competitor or the Industry.
Inventory Turnover You do not need to calculate the competitor ratios, you can use pre-calculated ratios
just remember to cite your source. (like a database)
Solvency Ratios
Debt ratio
Times Interest Earned Ratio
Profitability Ratios
Gross Profit Percent
Return on Net Sales
EPS**
Market Analysis
Price Earning Ratio**
Dividend Yield**
*Calculated by Author
** Information from give souce
Prepared by

Sheet3