Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Serena Enterprise is applying for loan with a local bank in order to expand her business. The following is available regarding her cash utilization. Cash

Serena Enterprise is applying for loan with a local bank in order to expand her business. The following is available regarding her cash utilization.

  1. Cash balance as at 1st January 2020 is expected to be RM25,000.
  2. Forecast sales and purchases for December 2019 to March 2020 are as follows:-

Month

Purchases

Sales

Units

Units

December 2019

25,000

22,000

January 2020

30,000

28,000

February 2020

35,000

34,000

March 2020

40,000

40,000

  1. Terms of purchase: Purchase price is RM3 per unit. 70% of the monthly purchases are on a cash basis and balance is settled in the month following the purchase.
  2. Sales price is RM4.25 per unit. 60% of the monthly sales are on a cash basis and balance is collected in the month following the sales.
  3. Forecasted expenditure for the months are as follows:-
  • Wages amounting to RM17,500 is paid at the end of each month.
  • Rent of RM7,200 is payable semi-annually. The first payment to be paid in January 2020.
  • Office Computer will be bought in January 2020. A deposit of RM1,000 to be paid immediately. The balance to be paid in installments of RM250 per month.
  • General Expenses of RM 380 is expected to be paid each month.
  • A loan of RM2,000 is to be repaid in February 2020.
  • The owner Serena is expected to make a monthly withdrawal of RM500.

You are required to produce a Cash Budget from January to March 2020.

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_2

Step: 3

blur-text-image_3

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

Foundations In Personal Finance

Authors: Dave Ramsey

1st Edition

0981683967, 978-0981683966

More Books

Students also viewed these Finance questions