Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

HYD company Bhd is about to prepare a monthly cash budget for the upcoming 3 months (from January to March 2020). The following transactions are

HYD company Bhd is about to prepare a monthly cash budget for the upcoming 3 months (from January to March 2020). The following transactions are recorded:

  • About 60% of sales are collected 1 month after the sale and the remainder is collected in the second month following the sale.
  • The company purchases are 80% of future sales forecasted. These are made 2 months in advance of expected sales.
  • Payments for these purchases are made in the next month after purchase.
  • Other expenses such as monthly wages and salaries are estimated at 5% of monthly forecast sales.
  • You are required to complete the 3-month (January, February, and March) cash budget below for HYD company. Note: Provide answers ONLY for coloured boxes A to X

November

December

January

February

March

April

May

Sales

50,000

60,000

70,000

85,000

98,000

100,000

110,000

Purchases

56,000

68,000

A

I

Q

Cash receipts / collections

Sales collected after one month

B

J

R

Sales collected after two months

C

K

S

Total cash receipts

D

L

T

Cash disbursements

Payments for purchases

E

M

U

Wages and Salaries

F

N

V

Total cash disbursements

G

O

W

Net change in cash

H

P

X

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

The Oxford Handbook Of Sovereign Wealth Funds

Authors: Douglas J. Cumming, Geoffrey Wood, Igor Filatotchev, Juliane Reinecke

1st Edition

0198754809, 978-0198754800

More Books

Students also viewed these Finance questions

Question

Explain the nature of human resource management.

Answered: 1 week ago

Question

Write a note on Quality circles.

Answered: 1 week ago

Question

Describe how to measure the quality of work life.

Answered: 1 week ago

Question

1. Are my sources credible?

Answered: 1 week ago

Question

3. Are my sources accurate?

Answered: 1 week ago

Question

1. Is it a topic you are interested in and know something about?

Answered: 1 week ago