Past experience indicates that
Ask Expert

Be Prepared For The Toughest Questions

Practice Problems

Past experience indicates that

Task 3: Cash Flow & Budgeting

Using the data below (in US $), prepare a Cash Budget for Alma Corp.

1. Budgeted Sales Data:

 

June

July

August

Cash sales

90,000

215,000

185,000

Credit sales

135,000

145,000

90,000

Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month.

2.  Budgeted Purchase data:

 

June

July

August

Purchases

300,000

250,000

105,000

Purchases of inventory are all on credit and 50% is paid in the month of purchase and 50% in the month following purchase. 

3.  Other Cash payments:

Selling expenses are $48,000 each month, 

Rent for the period July-Dec -- will be paid in July - $103,000 

Purchase of equipment in August for $50,000 cash.

4.  Other data:

The company wishes to maintain a minimum cash balance of $40,000 at the end of each month. 

The company borrows money from the bank if necessary to maintain the minimum cash balance. $150 interest was paid in August.

Borrowed money is repaid in months when there is an excess cash balance. 

The beginning cash balance on July 1 was $50,000. 

Cash collection on credit sales:


Cash disbursement for purchase of inventory:



Hint
Accounts and Finance"Cash flow is an incoming and outgoing stream of money. The money earned is inflow, while money spent is outflow, and if the inflow is greater than the outflow, it is a positive cash flow i.e an amount left over at the month's end that can be invested. If it's a negative cash flow, that means money is being spent more than being earned. Calculating cash flow:1. Create a sp...

Know the process

Students succeed in their courses by connecting and communicating with
an expert until they receive help on their questions

1
img

Submit Question

Post project within your desired price and deadline.

2
img

Tutor Is Assigned

A quality expert with the ability to solve your project will be assigned.

3
img

Receive Help

Check order history for updates. An email as a notification will be sent.

img
Unable to find what you’re looking for?

Consult our trusted tutors.

Developed by Versioning Solutions.