Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Grretings, I need help with the following question with an explanation provided in an excel sheet.I know this is the answer as was given to
Grretings, I need help with the following question with an explanation provided in an excel sheet.I know this is the answer as was given to me by a tutor 12%*800,000+6%800,000+70%*(98%*880,000)+10%*880,000=$835,680which answers the question but I need an explanation of the steps of the process in order to understand it.
E23.8 | Page 1023 | Budgeting Cash Receipts |
Sales on account for the first two months of the current year are budgeted as follows: | ||
Jan. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $800,000 | ||
Feb. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 880,000 | ||
All sales are made on terms of 2/10, n/30 (2% discount if paid in 10 days, full amount by 30 days); | ||
collections on accounts receivable are typically made as follows: | ||
Collections within the month of sale: | ||
Within discount period . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70% | ||
After discount period . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 | ||
Collections within the month following sale: | ||
Within discount period . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 | ||
After discount period . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 | ||
Returns, allowances, and uncollectibles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 | ||
Total . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100% | ||
Compute the estimated cash collections on accounts receivable for the month of February. |
Page 1023 Budgeting Cash Receipts E23.8 Sales on account for the first two months of the current year are budgeted as follows: Jan. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $800,000 Feb. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 880,000 All sales are made on terms of 2/10, n/30 (2% discount if paid in 10 days, full amount by 30 days); collections on accounts receivable are typically made as follows: Collections within the month of sale: Within discount period . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70% After discount period . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Collections within the month following sale: Within discount period . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 After discount period . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 Returns, allowances, and uncollectibles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Total . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100% Compute the estimated cash collections on accounts receivable for the month of February. Answer: E23.8
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started