Question

In: Finance

3). You are required to prepare a cash budget (by filling in the gaps in 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 company’s 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

Solutions

Expert Solution

month

July

August

September

1

Beginning cash balance

RM1,000

RM6,000

RM6,000

2

Cash receipts

RM127,500

RM152,500

RM145,000

3

Cash disbursements

RM133,000

RM142,404

RM114,000

4

Net change in cash

(RM5,500)(2-3)

RM10,096(2-3)

RM31,000(2-3)

5

New short term borrowing(Additional financing)

RM10,500

0

0

6

Interest on loan

0

[{0.12*10500}/12]= (RM105)

[{0.12*509}/12]= (RM5.09)

7

Short term borrowing repaid(Financing repayment)

0

(RM9,991)

(RM509)

8

Ending cash balance

RM6,000

RM6,000

RM36,485.91

9

Minimum cash balance

(RM6000)

(RM6000)

(RM6000)

10

Cumulative surplus (Deficit)

0

0

RM30,485.91(8+9)

11

Beginning short term debt

0

RM10,500Endg STD, July

RM509Endg STD, Aug

12

Change in short term debt

RM10,500

(RM9,991)

(RM509)

Loan Taken( 5)

Loan Taken( 5)

Loan repaid (7)

13

Ending short term debt(STD)(Accumulated Loan)

RM10,500(11+12)

RM509(11+12)

0 (11-12)


Related Solutions

3). You are required to prepare a cash budget (by filling in the gaps in 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 company’s 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...
On this topic, you are required to prepare your monthly cash budget for the month of...
On this topic, you are required to prepare your monthly cash budget for the month of June 2020, if (assuming) there are 4 different sources of income and 12 different expenses and debt repayments. “Preparing monthly cash budget is an indicator for your personal financial growth’’. In reference to this statement, you are required to provide the reasons/importance of preparing your monthly cash budget. (1200 words) Note: Please write 1200 words
Required: 1. Prepare the Sales budget for 2019. 2. Prepare the Production budget for 2019. 3....
Required: 1. Prepare the Sales budget for 2019. 2. Prepare the Production budget for 2019. 3. Prepare the Direct materials purchases budget (units and dollars) for 2019. 4. Prepare the Direct labor budget for 2019. 5. Prepare the Factory overhead budget for 2019. 6. Prepare the Cost of goods sold and ending finished goods inventory budgets for 2019. 7. Prepare the Selling and administrative expense budget, broken down into two components: Selling Expenses, and Administrative Expenses for 2019. 8. Prepare...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $119,000 $151,000 $190,000 Manufacturing costs 50,000 65,000 68,000 Selling and administrative expenses 42,000 45,000 72,000 Capital expenditures _ _ 46,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $129,000 $164,000 $213,000 Manufacturing costs 54,000 71,000 77,000 Selling and administrative expenses 37,000 44,000 47,000 Capital expenditures _ _ 51,000 The company expects to sell about 12% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the...
Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget...
Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: January February March Sales $89,000 $105,000 $144,000 Manufacturing costs 37,000 45,000 52,000 Selling and administrative expenses 26,000 28,000 32,000 Capital expenditures _ _ 35,000 The company expects to sell about 12% of its merchandise for cash. Of sales on account, 70% are expected to be collected in full in the month...
Cash Budget The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: March April May Sales $130,000 $155,000 $205,000 Manufacturing costs 55,000 67,000 74,000 Selling and administrative expenses 38,000 42,000 45,000 Capital expenditures _ _ 49,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $126,000 $160,000 $205,000 Manufacturing costs 53,000 69,000 74,000 Selling and administrative expenses 37,000 43,000 45,000 Capital expenditures _ _ 49,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $120,000 $146,000 $197,000 Manufacturing costs 50,000 63,000 71,000 Selling and administrative expenses 35,000 39,000 43,000 Capital expenditures _ _ 47,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 65% are expected to be collected in the month following the...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budgetinformation: September October November Sales $111,000 $139,000 $189,000 Manufacturing costs 47,000 60,000 68,000 Selling and administrative expenses 39,000 42,000 72,000 Capital expenditures _ _ 45,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT