Executive Dashboard (Performance Report)

profileLeeTampa
FinancialRatioSpreadsheet.xlsx

Sheet1

Financial Spreadsheet
Company Name:
Financial Ratio Formula Company Result Industry Average
1. Current Ratio 2x
2. Total Debt/Total Assets 30.00%
3. Times Interest Earned 7x
4. EBITDA Coverage 9x
5. Inventory Turnover 10x
6. Days Sales Outstanding * 24 days
7. Fixed Assets Turnover 6x
8. Total Assets Turnover 3x
9. Profit Margin 3.00%
10. Return on Total Assets 9.00%
11. Return on Common Equity 12.86%
* Calculation is based on 365-day year.