Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
pieton Status Razan Company has the following information during the month of June 2020 Cash Balance, May 31 S45,000 Dividends paid in June 12,000 Cash paid for operating expenses in June 36,800 Equipment depreciation expense in June 4,500 Patent amortization expense in June 2,000 Cash collections on sales in June 112,500 Merchandise purchases paid in June 86,200 Purchase equipment for cash in June 17,500 Sales commission (50% paid in June) 30,500 Razan Company wants to keep a minimum cash balance of $10,000
pieton Status Razan Company has the following information during the month of June 2020 Cash Balance, May 31 S45,000 Dividends paid in June 12,000 Cash paid for operating expenses in June 36,800 Equipment depreciation expense in June 4,500 Patent amortization expense in June 2,000 Cash collections on sales in June 112,500 Merchandise purchases paid in June 86,200 Purchase equipment for cash in June 17,500 Sales commission (50% paid in June) 30,500 Razan Company wants to keep a minimum cash balance of $10,000. Assume that borrowing occurs at the beginning of the month and repayments occur at the end of the month. Monthly interest of 1% is paid in cash at the end of each month when debt is outstanding Borrowing and repayments are carried out in multiples of $1,000, Required: Prepare a cash budget for June
Expert Solution
Cash Budget for the month of June
| Particulars | Amount |
| Opening Balance as on june 1 | $45000 |
| Receipts | |
| cash collection on sales | $112500 |
| Total receipts | 112500 |
| Payments | |
| Dividend Paid | $12000 |
| Cash paid for operating expenses | $36800 |
| Merchandise Purchases | $86200 |
| Equipment Purchase | $17500 |
| Sale commision paid (30500 * 50%) | $15250 |
| Total Payments | $167750 |
| cash balance at end | -10250 |
Since the cash balance is to be maintained at 10000, we will have to borrow money which can be done in multiples of 1000. Hence Amount to be borrrowed = Negative cash balance end + 10000 to be maintained
= 10250+10000 =20250
This has to be round off to 21000
| Borrowed amount | $21000 |
| Less: Negative cash balance calculated above | $(10250) |
| Less: interest (21000*1%) | $(210) |
| Final closing balance at the end of june | $10540 |
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.
