Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Re Imagining Offshore Finance

Authors: Christopher M. Bruner

1st Edition

0190466871, 978-0190466879

More Books

Students also viewed these Finance questions

Question

How is the WACC for a firm calculated?

Answered: 1 week ago

Question

Determine miller indices of plane A Z a/2 X a/2 a/2 Y

Answered: 1 week ago

Question

Is conflict always unhealthy? Why or why not? (Objective 4)

Answered: 1 week ago