3) The following information pertains to Amigo Corporation: Month Sales Purchases ...

70.2K

Verified Solution

Question

Accounting

3) The following information pertains to Amigo Corporation:

Month Sales Purchases

July $30,000 $10,000

August 34,000 12,000

September 38,000 14,000

October 42,000 16,000

November 48,000 18,000

December 60,000 20,000

Cash is collected from customers in the following manner:

Month of sale 40%

Month following sale 40%

Two months following sale 10%

Uncollectible Accounts 10%

60% of purchases are paid for in cash in the month of purchase, and the other 40% is paid the following month.

Required: Complete the cash budget (no discounts) for the 4th quarter.

October November December

Beginning Balance: $10,000

Cash Collections from:

August

September

October

November

December

--------------- --------------- -----------------

Total Cash Collections

Total Cash Available

Cash Payments from:

September

October

November

December

-------------- ---------------- -------------------

Total Cash Payments

Ending Cash Balance

Amigo has $50,000 principal loan balance and needs to pay it, but also needs to keep a $10,000 minimum balance. What month is the earliest that Amigo can pay off this loan while keeping the minimum cash balance? ___________________

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