Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales...

70.2K

Verified Solution

Question

Accounting

Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows:
Month Sales Revenue Month Sales Revenue
January $300,000 March $200,000
February 210,000 April 190,000
All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of sale. Operating expenses total $41,000 per month and are paid during the month incurred. The cash balance on February 1 is estimated to be $20,000.
Prepare monthly cash budgets for February, March, and April.
Use negative signs only with beginning and ending cash balances, when appropriate. Do not use negative signs with disbursement answers.
Wilson's Retail Company
Cash Budgets
February, March, and April
February, March, April
Cash balance, beginning Answer Answer Answer
Total Cash receipts Answer Answer Answer
Cash available Answer Answer Answer
Total disbursements Answer Answer Answer
Cash balance, ending Answer Answer Answer

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students