Question
Cash collections Ridenour Ltd. is preparing its first-quarter monthly cash budget for Year 4. The following information is available about actual Year 3 sales and
Cash collections Ridenour Ltd. is preparing its first-quarter monthly cash budget for Year 4. The following information is available about actual Year 3 sales and expected Year 4 sales:
November | December | January | February | March |
---|---|---|---|---|
$66,400 | $60,800 | $63,200 | $70,400 | $47,200 |
Tracing collections from prior year monthly sales and discussions with the credit manager helped develop a profile of collection behavior patterns. Of a given months sales, 40 percent is typically collected in the month of sale. Because the company terms are 1 percent (end of month) net 30, all collections within the month of sale are net of the 1 percent discount. Of a given months sales, 30 percent is collected in the month following the sale. The remaining 30 percent is collected in the second month following the month of the sale. Bad debts are negligible and should be ignored.
a. Prepare a schedule of cash collections for Ridenour Ltd. for January, February, and March of Year 4. Note: Enter amounts rounded to the nearest whole dollar.
Cash Collections | |||
---|---|---|---|
January | February | March | |
Nov. sales | |||
Dec. sales | |||
Jan. sales | |||
Feb. sales | |||
Mar. sales | |||
Total collections |
b. Calculate the Accounts Receivable balance at March 31, Year 4. $
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