Excel_Student_07-49kh

Excel_Student_07-49kh - Amount Percentage Uncollectible 0 -...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
07-49 Name: kathy haines Enter the appropriate amounts/formulas in the blue-shaded cells, or select from the drop-down list. The word “Wrong” will appear to the left of incorrect entries. Uncollectible Loss Percentage Year 0-30 days 31-60 days 61-90 days 91-120 days Ov 2012 0.30% 0.90% 8.70% 52.10% 2011 0.50% 0.80% 9.00% 49.20% 2010 0.40% 1.10% 9.50% 53.70% 2009 0.40% 1.00% 9.90% 51.30% 2008 0.20% 1.10% 8.90% 49.90% Average 0.36% 0.98% 9.20% 51.24% Average Loss Estimated Age of Accounts
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Amount Percentage Uncollectible 0 - 30 days $478,600 0.36% $1,723 31-60 days 172,300 0.98% 1,689 61-90 days 79,200 9.20% 7,286 91-120 days 21,300 51.24% 10,914 Over 120 days 8,300 82.02% 6,808 $759,700 $28,420 GENERAL JOURNAL Account Title Debit Credit Adjusting Entry Bad Debt Expense 3,296 Allowance for Bad Debts 3,296 ver 120 days 84.10% 80.30% 82.00% 78.50% 85.20% 82.02% le Correct Balance...
View Full Document

This note was uploaded on 08/12/2011 for the course ACCT 2201 taught by Professor Alvarez during the Spring '11 term at FIT.

Page1 / 2

Excel_Student_07-49kh - Amount Percentage Uncollectible 0 -...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online