Answered step by step
Verified Expert Solution
Question
1 Approved Answer
chedule 4: Disbursements for Purchases 50% of last month's purchases 50% of this month's purchases Disbursements for merchandise 38,640 59,570 59,570 51,520 41,860 33,810
chedule 4: Disbursements for Purchases 50% of last month's purchases 50% of this month's purchases Disbursements for merchandise 38,640 59,570 59,570 51,520 41,860 33,810 51,520 41,860 33,810 28,840 98,210 111,000 93,380 75,670 62,650 chedule 5: Wages and Commissions Wages, all fixed 5,750 5,750 5,750 5,750 5,750 Commissions (15% of current sales) Total 13,800 17,250 27,000 19,550 23,000 33,350 20,700 26,450 17,250 13,800 23,000 19,550 Schedule 6: Disbursements Wages/Comm 50% of last month's expenses 50% of this month's expenses Total 9,775 11,500 16,675 13,225 11,500 11,500 21,275 28,175 16,675 13,225 29,900 11,500 9,775 24,725 21,275 Cash Budget Beginning cash balance April 23,000 May 23,000 23,000 June July August 23,000 23,000 Cash receipts Collections from customers 105,800 Total cash available for needs, before fin. 128,800 156,400 156,400 124,200 179,400 179,400 147,200 Cash disbursements: Merchandise 98,210 111,090 Wages and commissions 21,275 28,175 93,380 75,670 29,900 24,725 Miscellaneous expenses 5,750 9,200 6,900 5,750 Rent 4,600 4,600 4,600 4,600 Truck purchase 6,900 0 0 Total disbursements. 136,735 153,065 134,780 110,745 Minimum cash balance desired 23,000 23,000 23,000 23,000 Total cash needed 159,735 176,065 157,780 133,745 Excess of total cash 30,935 3,335 21,620 13,455 Financing 30,935 0 0 New Borrowing 2 Repayments 2,871 21,199 6,865 3 Loan balance 30,935 28,064 6,865 0 4 Interest i 0 464 421 103 5 Total effects of financing 30,935 3,335 21,620 6,968 6 Cash balance 23,000 2.3,000 23,000 29,487 7
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