{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel Solutions - Chapter 21

Excel Solutions - Chapter 21 - Chapter 21 Problems 1-19...

This preview shows pages 1–10. Sign up to view the full content.

Chapter 21 Problems 1-19, Appendix 1-5 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green

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

View Full Document
Chapter 21 Question 1 Input Area: Units 200 Unit price \$95 Terms 2% / 10 Net 30 Output Area: a. Days until account is overdue 30 Remittance \$19,000 b. Discount 2% Discount period 10 Remittance \$18,620 c. Implicit interest \$380 Days of credit 20
Chapter 21 Question 2 Input Area: Annual sales \$65,000,000 Collection period 48 # days per year 365 Output Area: Receivable turnover 7.604 Average receivables \$8,547,945

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

View Full Document
Chapter 21 Question 3 Input Area: Terms 2 / 10 Net 30 Percentage taking discount 65% Sales price \$2,200 Units sold per period 1,200 Periods per year 12 Output Area: a. ACP 17.00 b. Total annual sales \$31,680,000 Receivables turnover 21.4706 Average receivables balance \$1,475,506.85
Chapter 21 Question 4 Input Area: Credit sales \$18,000 Collection period 29 Cost of production (% of sales) 80% Output Area: Daily sales \$2,571.43 Average A/R \$74,571.43

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

View Full Document
Chapter 21 Question 5 Input Area: Terms 2% / 9 Net 40 a. New discount 3% b. New credit period 60 c. New discount period 15 Output Area: EAR (original terms) 26.85% a. EAR 43.14% b. EAR 15.56% c. EAR 34.31%
Chapter 21 Question 6 Input Area: Daily investment in receivables \$46,000 Collection period 52 # days per year 365 Output Area: Receivables turnover 7.0192 Annual credit sales \$322,884.62

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

View Full Document
Chapter 21 Question 7 Input Area: Terms 2% / 15 Net 40 Discount used % 60% New terms 4% / 10 New net 30 Units sold 4,000 Unit price \$400 Output Area: Total credit sales \$1,600,000 ACP 25.00 Receivables turnover 14.600 Average receivables \$109,589.04 If the firm increases the cash discount, then more people will pay sooner, thus lowering the average collection period. If the ACP declines, receivables turnover increases, which will lead to a decrease in average receivables.
Chapter 21 Question 8 Input Area: Average days past due 9 Annual credits \$8,000,000 Net 25 Output Area: ACP 34.00 Receivables turnover 10.7353 Receivables \$745,205.48

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 28

Excel Solutions - Chapter 21 - Chapter 21 Problems 1-19...

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

View Full Document
Ask a homework question - tutors are online