Assignment 3 - Credit Analysis and Loan Evaluation

profilelisagonzalez23
ComparisonWithIndustryPeers.xls

Cover

Company
Student Name
ID Number

FR & COMPARISONS

Financial Ratios - Trends and Comparisons with Industry
Company Name:
Amounts In: Comparison Ratio
Period: of Company Ranking
Statement Type: RMA Ratios to the within the
Date: FY 1* FY 2* FY 3* FY 4* Trend Norm RMA Norms Group
Financial Summary
Current Assets
Current Liabilities
Total Assets
Total Liabilities
Total Net Worth
Working Capital
Cash
Marketable Securities
Accounts receivable, net
Inventories
Net Fixed Assets
Intangibles
Accounts payable
Accrued expenses
Working Assets
Working Liabilities
Working Investment
Long Term Debt
Tangible Net Worth
Average Annual Long-term Debt Maturities **
Operating Cash Flow ***
Net Sales
Cost of Goods Sold
Lease Payments
Gross Profit
Depreciation & Amortization
Operating Profit
EBITDA
Interest Expense
Net Income
Liquidity/Activity Ratios
Current Ratio (x)
Quick Ratio (x)
Cash Flow Liquidity Ratio (x)
Accounts Receivable (x)
Accounts Receivable (Days)
Inventory Turnover vs COGS (x)
Inventory Turnover vs Aver Sales (Days)
Accounts Payable vs COGS (Days)
Accounts Payable vs Aver Sales (Days)
Cash Conversion Cycle (Days)
Leverage Ratios
Debt Ratio (%)
Long-term Debt to Total Capitalization (%)
Debt to Worth (x)
Debt to Tangible Net Worth (x)
Times Interest Earned (x)
Fixed Charge Coverage (x)
Cash Flow Adequacy (x)
Performance Ratios
Fixed Asset Turnover (x)
Total Asset Turnover (x)
Gross Profit Margin (%)
Operating Profit Margin (%)
EBITDA Margin (%)
Net Profit Margin (%)
Cash Flow Margin (%)
Return on Assets (%)
EBITDA/Total Assets (%)
Return on Equity (%)
Cash Return on Assets (%)
Officers' Compensation/Sales (%)
Sales/Working Capital (x)
Sales Growth (%)
Earnings Growth (%)
Total Asset Growth (%)
* You need to change these headings to match the four most recent fiscal year ends for your company.
** See AALTDM Tab for an explanation.
*** From Cash Flow Statement.

Working Investment

Debt

AALTDM

Average Annual LTD Maturities (AALTDM)
Fiscal Year FY 1 FY 2 FY 3 FY 4
FY 2 3rd most recent report balance sheet
FY 3 3rd most recent report debt footnote 3rd most recent report debt footnote
FY 4 3rd most recent report debt footnote 3rd most recent report debt footnote 2nd most recent report debt footnote
FY 5 3rd most recent report debt footnote 3rd most recent report debt footnote 2nd most recent report debt footnote Latest report debt footnote
FY 6 3rd most recent report debt footnote 3rd most recent report debt footnote 2nd most recent report debt footnote Latest report debt footnote
FY 7 3rd most recent report debt footnote 2nd most recent report debt footnote Latest report debt footnote
FY 8 2nd most recent report debt footnote Latest report debt footnote
FY 9 Latest report debt footnote
Total Amount Sum of 5 yrs above Sum of 5 yrs above Sum of 5 yrs above Sum of 5 yrs above
Divide by 5 5 5 5

Dupont

EVA

EVA