The Fortunate Co. is preparing a cash budget for the 2nd quarter. The following information is...

Free

90.2K

Verified Solution

Question

Accounting

The Fortunate Co. is preparing a cash budget for the 2ndquarter. The following information is available:
Projected cash sales:Â Â $10,000 each month
Projected credit sales: $ 8,000 each month
One half of the credit sales are collected in the month of sale,and the remainder collected in the following month (there are nouncollectible accounts).
Accounts receivable on April 1^st were $3,000.
Operating expenses (paid in cash): $20,000 for April, and$13,000 for each of the following two months.
Cash balance-4/1: $7,000
The company must maintain a minimum cash balance at the end ofeach month of Â Â $5,000.
Any deficiency must be borrowed, and repaid (with no interest)the following month.
Complete the following cash budget for Fortunate (22points).
April
May
June
Beg. Balance
Cash Sales
Credit Sales
Cash Expenses
Balance before borrowing
Borrow/Repay
End. Balance

Answer & Explanation Solved by verified expert

3.8 Ratings (506 Votes)

	April	May	June
Beg. Balance	7,000	5,000	9,000
Cash sales	10,000	10,000	10,000
Credit sales	7,000	8,000	8,000
Cash expenses	(20,000)	(13,000)	(13,000)
Balance before borrowing	4,000	10,000	14,000
Borrow / Repay	1,000	-1,000	0
End. Balance	5,000	9,000	14,000

Point to see -

Cash collection from credit sales (April) = Opening accounts receivable + (Credit sales made in the month of April * 0.5)

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â = $3,000 + ($8,000 * 0.5)

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â = $7,000

Cash collection from credit sales (May) = (Credit sales made in the month of April * 0.5) + (Credit sales made in the month of May * 0.5)

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â = ($8,000 * 0.5) + ($8,000 * 0.5)

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â = $8,000

Similarly, cash collection from credit sales (in June) is equal to $8,000.

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

	April	May	June
Beg. Balance
Cash Sales
Credit Sales
Cash Expenses
Balance before borrowing
Borrow/Repay
End. Balance