Case 3 Spreadsheet - 2010 2010 2010 Before Retail--After...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Case 3 – Accounts Receivable Valuation Worksheet - Dolls Corporation (all $ in thousands) **** **** Dolls Corporation 2010 2010 Without Retail, Inc. Write-Off 2010 ---------------After Bad Debt Expense------------------- Before Retail Balance Sheet Income Statement write-off and Method Method 2009 Bad Debt Expense Method Method Accounts Receivable 2,650 2,980 2,980 2,980 Allowance for Bad Debts 265 100 * 298 190 Allowance as % of A/R 10.0% 3.4% * 10.0% 6.4% Current Assets 3,115 * 2,817 2,925 Current Liabilities 1,485 * 1,485 1,485 Current Ratio (CA/CL) 2.1 * 1.90 1.97 Sales 12,500 15,000 * 15,000 15,000 Bad Debt Expense 150 0 * 198 90 Net Income (Loss) 425 155 * (43) 65 Dolls Corporation With Retail, Inc. Write-Off
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2010 2010 2010 Before Retail--After Retail write-off and Bad Debt Expense--- write-off and Balance Sheet Income Statement 2009 Bad Debt Expense Method Method Accounts Receivable 2,650 2,980 * 2,790 2,790 Allowance for Bad Debts 265 100 * 279 190 Allowance as % of A/R 10.0% 3.4% * 10.0% 6.8% Current Assets 3,115 * 2,836 2,925 Current Liabilities 1,485 * 1,485 1,485 Current Ratio (CA/CL) 2.1 * 1.91 1.97 Sales 12,500 15,000 * 12,500 15,000 Bad Debt Expense 150 * 369 90 Net Income (Loss) 425 155 * (214) 65 Retail, Inc. Write-Off 190 **** Cells in these two columns must have a formula or a cell reference to determine the cell amount....
View Full Document

This note was uploaded on 01/23/2012 for the course ACCOUNTING 301 at Wisconsin.

Ask a homework question - tutors are online