Question
3). You are required to prepare a cash budget (by filling in the gaps in the Table-A provided below) for the Lollypop Bhd for the
3). You are required to prepare a cash budget (by filling in the gaps in the Table-A provided below) for the Lollypop Bhd for the month of July, August, and September 2019.
The companys cash receipts and cash disbursements are provided in the table based on the amount of projected sales and the purchase (expenses) payments respectively for the month of July, August, and September.
Month | July | August | September |
Cash receipts | RM127,500 | RM152,500 | RM145,000 |
Cash disbursements | RM133,000 | RM142,404 | RM114,000 |
The company plans to apply for the short-term borrowing needed and the interest on the accumulated loan is 12% per annum. In addition, it plans to repay the loan in the following month given the availability of cash.
The beginning balance in July 2019 is RM1,000 and the company must maintain a minimum cash balance of RM6,000 each month.
Table-A
| Month | July | August | September |
1 | Beginning cash balance | RM1,000 |
|
|
2 | Cash receipts | RM127,500 | RM152,500 | RM145,000 |
3 | Cash disbursements | RM133,000 | RM142,404 | RM114,000 |
4 | Net change in cash |
|
|
|
5 | New short-term borrowing (Additional financing) |
|
|
|
6 | Interest on loan |
|
|
|
7 | Short term borrowing repaid (Financing repayment) |
|
|
|
8 | Ending cash balance |
|
|
|
9 | Minimum cash balance | (RM6000) | (RM6000) | (RM6000) |
10 | Cumulative surplus (Deficit) |
|
|
|
11 | Beginning short term debt |
|
|
|
12 | Change in short term debt |
|
|
|
13 | Ending short term debt (Accumulated Loan) |
|
|
|
THIS IS FINANCIAL MANAGEMENT SUBJECT
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