Answered step by step
Verified Expert Solution
Link Copied!

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.8Page 1023Budgeting 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.

image text in transcribed 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting Chapters 1-24

Authors: Tracie L Nobles, Cathy Scott

11th Edition

1111528306, 978-1111528300

More Books

Students also viewed these Accounting questions

Question

Who are the users of financial accounts? AppenedixLO1

Answered: 1 week ago

Question

What does this look like?

Answered: 1 week ago