Transcription of Ratio Analysis Spreadsheet “TheScorecard”
1 Ratio Analysis Spreadsheet TheScorecard Year 1 Year 2 Year 3 Industry CompositeCalculations, Trends, or SHEET ratios : Stability (Staying Power) AssetsCurrent + Accts. -Wor t hTotal LiabilitiesNet WorthINCOME STATEMENT ratios : Profitability (Earning Power) MarginGross MarginNet Profit Before TaxSalesASSET MANAGEMENT ratios : Overall Efficiency to AssetsSalesTotal on AssetsNet Profit Before TaxTotal onInvestmentNet Profit Before TaxNet WorthASSET MANAGEMENT ratios : Working Capital Cycle TurnoverCost of Goods Turn-Days360 Inventory Receivable TurnoverSalesAccounts Receivable Turn-Days360 Accts. Rec. PayableTurnoverCost of Goods SoldAccounts Payable14 .Average PaymentPeriod360 Accts. Payable Turnovercopyright 2018 Business Resource Services
