Cash Budget | Explained With Full Example | Cost Accounting

Counttuts
14 Mar 201921:46

Summary

TLDRThis educational video script offers a comprehensive guide to creating a cash budget, focusing on the importance of estimating cash flows for operational efficiency. It walks through an example of Scene Limited, detailing the process of calculating cash inflows from sales and credit collections, as well as outflows from purchases, expenses, and other payments. The script emphasizes the simplicity of the task and provides a step-by-step approach to ensure a clear understanding of cash budgeting.

Takeaways

  • πŸ˜€ A cash budget is an estimation of cash flows over a specific period and is crucial for ensuring a business has sufficient funds to operate.
  • πŸ’Ό It's important to remember that a cash budget only deals with actual cash movements, not accounting profits or debts.
  • πŸ“… Companies create cash budgets for specific time frames, such as months or years, to plan and manage their cash flow effectively.
  • πŸ“Š The script provides an example of Scene Limited, illustrating how to prepare a cash budget for the months of April, May, and June.
  • πŸ”’ The opening balance is a starting point for the cash budget and is given for the first month; subsequent months' balances are calculated based on the previous month's closing balance.
  • πŸ’Ή The cash budget includes both cash sales and credit sales, with specific percentages allocated to immediate cash inflow and future debtor collections.
  • πŸ“ˆ Forecast sales are essential for the cash budget, and the script explains how to calculate cash sales and credit collections based on these forecasts.
  • πŸ—“οΈ A debtors collection schedule helps in understanding when credit sales will be collected, typically spread over several months post-sale.
  • πŸ›’ Credit purchases are also accounted for in the cash budget, with payments often spread between the month of purchase and the following month.
  • 🏒 Other cash inflows, such as rent and salaries, are considered expenses and are subtracted from the total cash available to determine the closing balance.
  • πŸ“‹ The final step in creating a cash budget is calculating the closing balance, which reflects the business's cash position at the end of the budget period.

Q & A

  • What is the main purpose of a cash budget?

    -A cash budget is used to estimate cash flows over a specific period of time, helping companies ensure they have enough funds within the business to operate.

  • Why is it important to remember that a cash budget deals with actual movement of cash?

    -It is important because the cash budget only accounts for transactions that involve the actual movement of cash, excluding any non-cash transactions.

  • What is the first step in preparing a cash budget for Scene Limited?

    -The first step is to determine the opening balance of cash, which in the case of Scene Limited is given as twenty thousand Rand on the first of each month.

  • How does Scene Limited's sales forecast for April, May, and June impact the cash budget?

    -The sales forecast for these months helps determine the expected cash inflows from both cash sales and credit sales that will be collected during these periods.

  • What percentage of Scene Limited's sales are made in cash, and how does this affect the cash budget?

    -40% of Scene Limited's sales are made in cash, which directly contributes to the cash inflow for the month of sale in the cash budget.

  • How is the credit sales collection schedule used in the cash budget?

    -The credit sales collection schedule is used to determine when the remaining 60% of sales made on credit will be collected, which is spread out over the month of sale and the following two months.

  • What is the significance of the debtors collection schedule in the cash budget?

    -The debtors collection schedule helps in estimating the cash inflows from credit sales over the specified period, ensuring accurate cash flow forecasting.

  • How are other cash incomes incorporated into the cash budget?

    -Other cash incomes, such as any additional cash inflows from non-operational activities, are included in the cash budget to provide a comprehensive view of the total cash inflow.

  • Can you explain the process of calculating the cash available and the closing balance in the cash budget?

    -The cash available is calculated by adding all the cash inflows, including opening balance, cash sales, and collections from credit sales. The closing balance is then found by subtracting all cash outflows, such as purchases, expenses, and other payments, from the cash available.

  • What is the treatment of credit purchases in the cash budget?

    -Credit purchases are treated as cash outflows in the cash budget. Typically, 50% of credit purchases are paid in the month of purchase, and the remaining 50% is paid in the following month.

  • How does the cash budget account for expenses such as rent, salaries, and interest payments?

    -Expenses like rent, salaries, and interest payments are treated as cash outflows in the cash budget and are deducted from the cash available to find the closing balance.

Outlines

00:00

πŸ“Š Introduction to Cash Budgeting

This paragraph introduces the concept of cash budgeting, emphasizing its importance for estimating cash flows over a specific period. It clarifies that cash budgets focus on actual cash movements, excluding non-cash transactions. The purpose of a cash budget for companies is to ensure operational liquidity. The example of Scene Limited is introduced, with sales figures for January, February, and March, and the task of preparing a cash budget for April, May, and June is outlined. The process begins with identifying the opening cash balance and forecasting cash sales based on a percentage of total sales.

05:01

πŸ—“οΈ Debtor Collection Schedule

The second paragraph delves into the debtor collection schedule, illustrating how to track and account for credit sales that are collected over time. It explains the distribution of credit collections over the months following a sale, with percentages allocated to the month of sale and subsequent months. The example continues with Scene Limited, showing calculations for credit sales collections in April, May, and June, based on previous months' sales. This process is crucial for understanding cash inflows from credit customers.

10:03

πŸ›’ Credit Purchases and Other Expenses

This paragraph discusses credit purchases and their payment schedule, highlighting that 50% of credit purchases are paid in the month of purchase and the remaining 50% in the following month. It also covers additional expenses such as rent, salaries, interest payments, and equipment purchases, all of which are cash outflows. The example provided calculates these expenses for April, May, and June, showing how they affect the cash budget.

15:03

πŸ’Ό Completing the Cash Budget

The fourth paragraph demonstrates the final steps in completing the cash budget. It shows how to calculate the closing balance for each month by subtracting all cash outflows from the cash available. The process involves totaling cash inflows, including sales and other income, and then accounting for expenses such as credit purchases, rent, salaries, and other payments. The paragraph emphasizes the importance of accuracy in reflecting cash movements within the business.

20:04

πŸŽ“ Conclusion and Engagement

In the concluding paragraph, the script summarizes the lesson on cash budgeting, reinforcing the simplicity of the process when focusing on cash flows. It invites viewers to share their learning experiences, ask questions, and engage with the content. The speaker encourages viewers to subscribe to the channel, like the video, and share it, and signs off with a friendly farewell until the next lesson.

Mindmap

Keywords

πŸ’‘Cash Budget

A cash budget is a detailed plan that estimates a company's cash inflows and outflows over a specific period of time. It is crucial for businesses to ensure they have sufficient funds to operate and to plan for any cash shortages. In the video, the cash budget is the central theme, with the example of Scene Limited's cash flows for April, May, and June being calculated to demonstrate the process.

πŸ’‘Cash Flows

Cash flows refer to the movement of cash into and out of a business. Positive cash flows occur when cash comes into the business, such as from sales, while negative cash flows occur when cash is spent, such as on expenses or investments. The script emphasizes the importance of estimating cash flows accurately within a cash budget.

πŸ’‘Opening Balance

The opening balance is the starting amount of cash a company has at the beginning of a budgeting period. It serves as the foundation for the cash budget calculations. In the script, the opening balance for April is given as 20,000 Rand, and subsequent opening balances are calculated based on the closing balances of the previous months.

πŸ’‘Sales

Sales represent the revenue generated from selling goods or services. In the context of a cash budget, the script distinguishes between cash sales (where payment is received immediately) and credit sales (where payment is received later). The company's forecasted sales for the months of April, May, and June are used to calculate expected cash inflows.

πŸ’‘Credit Sales

Credit sales are sales made on credit, where the customer is allowed to delay payment for a period. The script explains that a portion of the company's sales are credit sales and that these will be collected over time, impacting the cash budget as they are received.

πŸ’‘Debtors Collection Schedule

A debtors collection schedule is a plan that outlines when credit sales will be collected. It is used to predict future cash inflows from customers who have purchased on credit. The script provides an example of how to create this schedule, showing the distribution of collections over several months.

πŸ’‘Credit Purchases

Credit purchases are goods or services bought on credit, where payment is not made immediately. The script explains that these purchases need to be accounted for in the cash budget, as they represent cash outflows that the company will need to pay in the future.

πŸ’‘Rent

Rent is a fixed expense that a business pays for the use of a property. In the script, rent is mentioned as a consistent monthly expense that must be included in the cash budget, affecting the company's cash outflows.

πŸ’‘Salaries and Wages

Salaries and wages are the payments made to employees for their work. As a regular expense, they are included in the cash budget as cash outflows, showing the company's financial commitment to its workforce.

πŸ’‘Interest Payment

An interest payment is the cost of borrowing money, paid periodically to the lender. In the script, an interest payment due in May is highlighted as a specific cash outflow that needs to be accounted for in the cash budget.

πŸ’‘Equipment Purchase

An equipment purchase is an investment in machinery or tools for the business. The script mentions an equipment purchase made in cash in April, which is a significant cash outflow that affects the company's cash position.

πŸ’‘Closing Balance

The closing balance is the remaining cash balance at the end of a budgeting period. It is calculated by subtracting all cash outflows from the total cash inflows. In the script, the closing balance for each month is determined and used as the opening balance for the next month, illustrating the cyclical nature of cash flow management.

Highlights

Introduction to the concept of a cash budget, emphasizing its importance for estimating cash flows over a specific period.

Explanation of why companies create cash budgets, to ensure sufficient operational funds.

Description of the process for preparing a cash budget, focusing on the months of April, May, and June.

Clarification on the importance of opening balances in a cash budget and how they relate to the previous month's closing balance.

Detailing the method to calculate cash sales from forecasted sales, highlighting the percentage received in the month of sale.

Introduction to the debtors collection schedule for credit sales, explaining how to track cash inflows from credit customers.

Demonstration of how to create a debtors collection schedule for the months of April, May, and June.

Explanation of how to account for credit purchases and their payment schedule in the cash budget.

Guidance on calculating cash outflows for rent, salaries, wages, and interest payments within the cash budget.

Inclusion of one-time cash outflows such as equipment purchases and trading fines in the cash budget.

Step-by-step instruction on how to total up cash inflows and outflows to find the closing balance for each month.

Emphasis on the simplicity of the cash budget process once the initial setup is understood.

Reinforcement of the focus on cash movements only, distinguishing cash budgets from other financial analyses.

Encouragement for viewers to apply the knowledge gained to create their own cash budgets with confidence.

Invitation for viewers to share their educational level and feedback in the comments section.

Call to action for viewers to like, share, and subscribe to the channel for more informative content.

Transcripts

play00:00

welcome to contacts in this lesson we're

play00:02

going to be looking at the cash budget

play00:04

we're going to go through an example and

play00:06

I'm confident that after this lesson it

play00:08

should be able to do a cash budget on

play00:10

your own why do we do the cash budget or

play00:12

what is a cash budget this is when we

play00:15

estimate cash flows over a specific

play00:17

period of time and it is very important

play00:20

to remember that we are estimating cash

play00:22

flows and so we are dealing with actual

play00:24

movement of cash so if anything that is

play00:27

not cash will not be dealt with in the

play00:29

cash budget and it's over a specific

play00:32

period of time so whenever you ask to do

play00:34

a cash budget you'll be told for which

play00:36

months or for which years to do the cash

play00:38

budget for and why do companies do the

play00:41

cash budget

play00:41

well companies do this in order to

play00:44

ensure that they have enough funds

play00:45

within the business to operate so when

play00:48

you do the cash budget you are looking

play00:50

at what is the cash flows during that

play00:52

specific period over which you are doing

play00:54

the cash budget so let's go to the

play00:57

example in this example we are told that

play01:00

scene Limited had sales of 100,000 ran

play01:04

in January 800,000 and in February and

play01:07

90,000 rain in March and we also given

play01:10

the other information and at the bottom

play01:12

here we asked to prepare the cash budget

play01:14

for scene limited for the months of

play01:15

April May and June so there we have our

play01:19

periods we asked to do it for every May

play01:21

and June and that is the only months we

play01:24

are going to focus on so how do you do

play01:27

the cash budget this is the table that

play01:29

we are going to use we have a table it's

play01:30

written cash budget we have the details

play01:32

on the left and we have raw three months

play01:34

on the right April May and June what is

play01:38

the first thing that we do want to look

play01:39

at the cash budget we will have our

play01:41

opening balance so what is our opening

play01:44

balance so let's add opening balance day

play01:47

and let's look down here we are told in

play01:50

additional information that the company

play01:52

had a cash balance of twenty thousand

play01:54

ran on the first of every so we'll put

play01:58

that under opening balance on April

play02:00

twenty thousand right now for May and

play02:03

June we don't have the opening balances

play02:06

the reason for that is because we have

play02:07

to complete the cash flows for eppley

play02:11

and their closing balance for every

play02:13

rupee the opening balance for me and

play02:14

likewise the closing balance for me will

play02:17

be the opening balance for June and that

play02:20

is why we don't have for May and June so

play02:22

always remember that you will usually be

play02:24

given the opening balance for the first

play02:27

month so let's move on to the next thing

play02:30

what do we have what we our sales were

play02:32

told here that feel limited had sales of

play02:35

hundred thousand ran in January

play02:37

eighty thousand ran in February and

play02:39

ninety thousand ran in March so those

play02:41

are some of the sales and we are told

play02:42

what they they the forecast sales are

play02:45

for the months of April May and June

play02:48

it's very important to always remember

play02:50

that you're dealing with cash here and

play02:53

not anything on credit so we have to

play02:56

deal with the cash movements here so we

play02:58

look at the details like this forty

play02:59

percent of the company's sales are in

play03:01

cash so what is the first thing that

play03:03

we're going to do we're going to do

play03:04

sales cash sales right this is the sale

play03:07

that we will have in April May and June

play03:10

and will receive the money in that same

play03:12

month and then we'll also have sales

play03:15

credit sales where we'll receive the

play03:17

money in April May and June but you look

play03:19

at that a bit later on but let's look at

play03:22

the sketch sales

play03:23

we're told that 40% of the company's

play03:25

sales are in cash then we're told the

play03:28

company's forecasts sales for the coming

play03:31

months as follows a print hundred ten

play03:33

thousand one may hundred thousand Rand

play03:35

and June hundred and twenty thousand

play03:37

right so we know that forty of forty

play03:39

percent of that will be paid in the

play03:41

month of sale so we're going to take

play03:43

hundred and ten thousand grand for the

play03:45

month of April times the forty percent

play03:47

to get the cash sale for that month it

play03:49

gives us forty four thousand gram so put

play03:52

that for the four thousand redundant

play03:53

apron and we'll do the same for me and

play03:56

June so May they their sales

play03:59

forecast is a hundred thousand Rand

play04:01

multiply that by 40 percent and it gives

play04:04

us 40 thousand Rand so we put that under

play04:06

me and we do the same for June one

play04:09

hundred and twenty thousand ten times

play04:10

forty percent will give us what the cash

play04:14

sale was forty-eight thousand Rand and

play04:16

who could

play04:16

that June now you can see how a simple

play04:19

exercise this is whenever you're given

play04:21

the sales forecast or the sales for the

play04:23

months you have to do the cashback that

play04:24

for only look in the information and see

play04:28

how many percent of those we're in cash

play04:30

and you'll take that and put that under

play04:32

sales and then cash and then we move on

play04:35

to the next one remember if 40% was on

play04:38

cash we know that 60% was on credit now

play04:40

we ask ourselves the question when will

play04:42

that be paid whatever would be paid in

play04:45

the month in question or in the months

play04:47

at which you are doing the cash budget

play04:48

April May and June we have to include

play04:50

that because that will be our cash

play04:52

inflow so if you can see down here we're

play04:54

told that the trade debtors or credit

play04:56

things are collected as follows so now

play04:58

this is the 60% how is it collected

play05:00

we're told that 20% during the month of

play05:04

sales 50% during the first month

play05:08

following the same 20% during the second

play05:10

month following the month of sale and

play05:12

10% during the third month following the

play05:14

month of sale now I hope you can see

play05:16

from this that we have to do what is

play05:18

called the debtors collection schedule

play05:19

or the credit collections and if you'd

play05:22

like to check that one out we have a

play05:23

video specifically for that to help you

play05:25

understand how to do the credit

play05:26

collections is a very simple one as well

play05:28

so if you'd like to check that one out

play05:29

you can find a link in the description

play05:31

below or you can click the link on the

play05:33

top right of the screen right now but

play05:35

here's the table that we will use to do

play05:36

that debtors collection schedule for you

play05:39

to know how easy it is to do that so

play05:41

I've already drawn the data collection

play05:42

schedule have already plugged in the

play05:43

month day just for the sake of time and

play05:45

you can ask yourself the question why do

play05:47

I put January February March April May

play05:49

June when because we might collect some

play05:53

money from January in April when you

play05:55

might collect the money from February in

play05:56

April or May and we'll see that just now

play05:59

we are told that during a 20% is

play06:02

collected during the month of sale so if

play06:05

the sale happened back then in January

play06:07

20 % was collected and then 50% was

play06:09

collected during the first month

play06:11

following the sale so it means that 50%

play06:14

of January sale was collected in

play06:16

February and 20% during the second month

play06:19

following the month of sale it means 20%

play06:22

of January sale was collected in March

play06:24

and then 10% during the

play06:26

so that means that 10% of January Sain

play06:28

will be collected during the third month

play06:30

which is every and that's why we have

play06:32

January here we want everything that

play06:34

effects April May and June because we

play06:36

are doing the cash budget based on these

play06:39

three months so we'll just run through

play06:41

this if you'd like to see a similar

play06:42

example like I said you can click on the

play06:44

link in the description below so for

play06:48

January how much was the same the sales

play06:50

for January was hundred thousand Ren and

play06:52

ten percent would be collected in the

play06:55

third month following the month of sale

play06:56

we are not concerned with this three

play06:58

because twenty percent was collected in

play06:59

January fifty percent in February twenty

play07:01

percent in March we only concerned what

play07:03

what happens in these three months and

play07:05

we know that ten percent during the

play07:07

third month following the month of sale

play07:08

so we're going to take a hundred

play07:10

thousand gram which is the same for

play07:11

January and we're not going to multiply

play07:15

that by ten percent yet because we know

play07:16

forty percent of it was cash so one the

play07:19

sixty percent

play07:19

we just don't read it so we take hundred

play07:22

thousand rand times the sixty percent we

play07:24

just on credit time is the 10% we just

play07:26

collected in the third month following

play07:28

the month of saying which is every and

play07:29

gives us an amount of 6000 yen so put

play07:32

six thousand Rand a and then we do the

play07:35

same thing for February we are told that

play07:37

eighty percent is in February that was

play07:39

the sale in February and we know that 40

play07:41

percent wasn't was in cash so we know

play07:44

sixty percent is on credit so one that

play07:45

sixty percent so we say eighty percent

play07:47

eighty thousand Rand times sixty percent

play07:49

time is a twenty percent who just

play07:51

collected during the second month

play07:53

following the month of sale so that is

play07:55

how very same the second month following

play07:57

the month of sale is April so that 9600

play07:59

goes to three and then we move on to

play08:03

much 90,000 ran was the sale in March

play08:06

and we know forty percent was in cash so

play08:08

60% was on credit so that's what we want

play08:11

so 60% of much much sale is on credit

play08:14

how much of it will be collected in in

play08:17

April when we are told here that fifty

play08:19

percent is collected during the first

play08:21

month following the month of sale so 50

play08:23

percent of what was on credits from much

play08:26

sales will be collector in heparin so we

play08:28

take ninety thousand Rand total sale

play08:30

times sixty percent that's the total

play08:33

charge on credit Simon's fifty percent

play08:34

which is blue sheet

play08:35

like that in April which is 27,000 run

play08:38

so between the 7000 ran down day and

play08:41

then we move on to every now we are in

play08:45

the month in question that's why we have

play08:46

April also here so we know that in have

play08:49

real hundred and ten thousand rain is

play08:50

forecasted as the sales and we know that

play08:53

for the person is on cash so we've dealt

play08:54

with that one already

play08:55

and then the 50 percent which is on

play08:57

credit you know that 20 percent of the

play08:59

tool to collected in April so we have

play09:01

hundred and ten thousand current sales

play09:03

times sixty percent the total credit

play09:05

sales times twenty percent which would

play09:07

be correct in the month of sale which is

play09:09

April we get 13,200 so good 13200 so we

play09:13

are done with April

play09:15

we have ever done everything that we

play09:16

needed to do in April now the rest will

play09:19

do now for May and June so for me with

play09:22

anything from January collected in May

play09:24

when we can see twenty percent would be

play09:26

collection the month of saying that is

play09:27

January fifty percent well attend the

play09:30

first month following the month of sale

play09:31

of February twenty percent during the

play09:32

second month following the month of sale

play09:34

there is much and ten percent during the

play09:36

third month following the month of

play09:38

saying that's every so we can see that

play09:39

January's credit sales do not affect me

play09:42

though or have been all collected by

play09:45

April so we have nothing day in January

play09:48

now February you know the ten percent

play09:50

would be June the third month following

play09:52

the month of sale and there is February

play09:54

March April and May so much April and

play09:57

May

play09:57

so another 10% of February credit sales

play10:00

would be collected in May and who do the

play10:02

exact same thing we did before January

play10:04

we take February's total sales eighty

play10:06

thousand run times sixty percent the

play10:09

total credit sales time is what I'm able

play10:12

to collected in May which is 10% and get

play10:15

4800 right so put 4800 ran in February

play10:19

and then how much of much much credit

play10:23

sales are collected in me well we know

play10:25

it's 20% concerts during the second

play10:27

month following the month of sale so how

play10:29

much were the sales in March

play10:31

sales in March were 90,000 grand so we

play10:33

take 90,000 grand times 60 percent the

play10:36

total credit sales time is 20 percent

play10:39

which should be collected in May get

play10:40

10,000 it

play10:42

under Glenn I hope it's making sense as

play10:44

we go along so I'm just gonna speed it

play10:45

up right now and then how much from

play10:48

April collected in May when you can see

play10:50

here has two percent during the first

play10:51

month following the month of sale so we

play10:53

take April total sales hundred and ten

play10:56

thousand ran time sixty percent times

play10:58

fifty percent will be collected in May

play11:00

instead of thirty thousand runs so put

play11:02

thirty three thousand ran and then May's

play11:04

credit sales how much of it will be

play11:05

collected in May when it's 20 percent

play11:07

cause during the month of sale so we

play11:09

take the total sales from a hundred

play11:13

thousand run time is sixty percent times

play11:15

twenty percent able collected in the

play11:17

month of sale

play11:18

gives us a total of twelve thousand

play11:20

right and there we have just completed

play11:21

me so let's go to June so now we know

play11:25

that nothing in February collected in

play11:27

June costly to be all collected by the

play11:30

month of May so we know that ten percent

play11:33

would of match his credit failing to

play11:35

collected in June so we take much sales

play11:38

total sales 90,000 run time is 60

play11:41

percent together total credit sales

play11:43

times ten percent who should be

play11:44

collected in June at 5400 and then for

play11:47

April how much of April's credit sales

play11:50

of collected in June we know that it's

play11:52

the twenty percent so we take hundred

play11:54

and ten thousand read total sales for

play11:56

April times sixty percent times twenty

play11:59

percent she programs in June we have

play12:01

thirteen thousand two hundred grand who

play12:03

put that down and then May's credit

play12:05

sales how much of it in prorated in June

play12:06

it's fifty percent so we take one

play12:09

hundred thousand Rand which is May's

play12:11

total sales times sixty percent that is

play12:14

the total credit sales times fifty

play12:16

percent which a product collected in

play12:17

June we put that thirty thousand reign

play12:20

over they how much of June's credit

play12:22

sales would be collected in June

play12:24

well we know that it's twenty percent so

play12:26

we take total sales in June hundred and

play12:28

twenty thousand run time is sixty

play12:30

percent which is the total credit sales

play12:32

time soon the person who she was elected

play12:34

in the month of sale which is June 14

play12:36

thousand four hundred so we have just

play12:38

done June so we are done with the data

play12:40

collection schedule or the credit

play12:42

collections for the month of April May

play12:44

and June now what we have to do is total

play12:46

them up so we know that these are the

play12:49

cash inflows from credit sales that will

play12:52

be collected in the

play12:53

three months so what we have to do you

play12:55

have to put it in our cash budget so

play12:57

we're gonna take our cash our they cash

play13:00

inflows from data collection schedule

play13:02

and put it in our cash budget so we're

play13:04

gonna put sales credit so that we know

play13:07

that this is from the credit collections

play13:08

and then we put these totals here

play13:11

fifty-five thousand eight hundred six

play13:12

thousand six hundred and sixty thirty

play13:14

thousands in their month so we'll put

play13:17

that down and then we move on to the

play13:18

next one here we are told that the

play13:21

company anticipate other cash income as

play13:23

follows so here we go to other cash

play13:26

income we have for April May and June so

play13:29

we have to include that in our cash

play13:31

budget because there is cash moving in

play13:34

or coming into the business that is a

play13:35

cash inflow so let's put that down

play13:37

AdvoCare the description doesn't really

play13:41

matter via routine have a cash income or

play13:43

other cash that doesn't matter as long

play13:44

as you are doing your cash budget

play13:45

correctly and then you put the three so

play13:49

put them all day so we are done with

play13:51

that one and then we are told that the

play13:53

credit purchases from March amounts to

play13:55

sixty thousand and so you can see from

play13:56

here going down these are just purchases

play13:59

and expenses so what I like to do when

play14:02

I'm doing the cash budget is to just

play14:04

have my total income or the total cash

play14:06

inflow down here so it's easy when I

play14:10

calculate the final figures even if you

play14:12

don't do it I don't you'll be penalized

play14:13

for that so I put cash available and

play14:16

what that means is that I'm adding up

play14:20

all the inflows or the cash that we have

play14:23

received to deal in the month and put in

play14:25

the total down here so I'll put down the

play14:28

one for April so I had them up together

play14:29

it comes to 129 800 now for May and June

play14:33

I'm not gonna do them as yet because I

play14:35

don't have the opening balances remember

play14:37

like I said the opening balance for me

play14:38

would be found from the closing balance

play14:40

of April and the closing balance for May

play14:43

will be found I will be will be the

play14:45

opening balance for June so we'll wait

play14:47

until we get the closing balance for

play14:49

April then be able to get the rest so

play14:52

now that Jeff we have totaled that up

play14:55

let's look at the credit purchases we're

play14:58

told that the credit patches for March

play15:00

amounted to 60,000 RAM and

play15:03

focus for the next three months as

play15:04

follows and we are given the focus

play15:05

create purchases for April May and June

play15:08

and what is important is here fifty

play15:10

percent of credit purchases are paid in

play15:12

the month of patches and the balance is

play15:14

paid in the following month so you

play15:17

paying fifty percent in the month that

play15:18

you have put in that you have done the

play15:20

credit purchases and you're paying the

play15:22

remainder fifty percent in the following

play15:24

month so that should be easy so let's

play15:26

draw a table similar to the debtors

play15:27

collection schedule called the credit

play15:29

purchases which will make it very simple

play15:32

so we'll just run through it quickly

play15:34

now how much of matches credit progestin

play15:37

per collected in April but we know that

play15:39

in match fifty percent was collected

play15:41

while I was paid of the a credit

play15:43

purchases was paid and then in April

play15:45

fifty percent would be paid so who take

play15:48

the credit badges for match g6 2000 ram

play15:51

we multiply that by 50 percent and we

play15:54

get thirty thousand run so there is how

play15:55

much will be collected in April for

play15:57

March and then in every and how much

play15:59

alcohol except for for it in April

play16:02

amateur collector for April for the

play16:04

month of April when we are told that

play16:06

fifty percent is collected in the month

play16:07

of patches and who purchased fifty

play16:10

thousand ran worth of purchases in April

play16:14

so we'll collect 50 percent of that in

play16:16

April so we'll take fifty thousand times

play16:18

fifty percent would get twenty five

play16:19

thousand Rand so put down twenty five

play16:22

thousand Rand we just finished with

play16:23

April so this one is a simple one

play16:25

so an in May we know that we have

play16:27

finished collecting the one from match

play16:29

cause you collected 50 percent in March

play16:30

and fifty percent in April and for a

play16:32

period we've collected fifty percent in

play16:34

April and they remained a 50 percent

play16:36

collected in the following month which

play16:37

is March so what is the amount for April

play16:39

it's 50,000 run so fifty thousand grams

play16:41

times fifty percent we get twenty five

play16:44

thousand Rand and that's how much should

play16:45

be collected in me and how much of male

play16:47

speaker will be collected in May we know

play16:49

that it's fifty percent so we take the

play16:51

maze maze amount forty thousand Rand you

play16:54

multiply that by 50 percent it gives us

play16:57

twenty thousand Rand and you put down

play16:59

twenty thousand rain and we've just

play17:01

completed the collections or the

play17:03

payments for April the credit payment

play17:06

for April remember always remember these

play17:08

are credit purchases that we made as a

play17:09

company so we are paying out so this is

play17:12

an expense going over

play17:14

business and then in June while you're

play17:17

not collecting anything from Matt's

play17:18

cause if collected it all in April we're

play17:21

not collecting anything from April

play17:23

because we've collected all by May and

play17:25

then how much of May salmon will be

play17:27

collected in June it's 50% so we'll take

play17:30

May's amount which is called a thousand

play17:32

time times 50% and we are paying twenty

play17:36

thousand wren of May's amount in June so

play17:38

put twenty thousand REM day and then

play17:40

June how much of June's amount collected

play17:43

in June it's 50 percent again

play17:44

so we'll take forty thousand rent for

play17:46

June the purchases that we made times

play17:49

fifty percent and we paid out twenty

play17:51

thousand times for June and have just

play17:53

completed the credit purchases that's

play17:55

how easy this one is so we just toss all

play17:57

those up so just sort of them up and

play17:59

then we'll go back to our cache budgets

play18:01

who put their purchases and then under

play18:04

purchases who put down the totals that

play18:07

we have here but remember who putting

play18:08

them in brackets because it's a cash

play18:10

outflow it's money that is leaving our

play18:12

business so put the amounts they in

play18:14

brackets then we move on the rest should

play18:17

be very simple we are told that rent

play18:19

paid amounts to five thousand rent per

play18:21

month so this is rent for each of the

play18:24

three months that we are doing the cash

play18:25

budget for so we'll put the rent and put

play18:29

five thousand rent for each of the three

play18:31

months and who put them in brackets

play18:32

because it's a cash outflow and then

play18:35

we're told that salaries and wages

play18:36

amounted to 20,000 rent per month we do

play18:39

the exact same thing we did for rent so

play18:40

good salaries and wages and who put

play18:42

twenty thousand rain in brackets for the

play18:44

three months then we also told that an

play18:47

interest payment of five thousand rent

play18:49

is due in May so this is just

play18:51

specifically for me so nothing in April

play18:53

and nothing for June so put interest

play18:55

expense nothing for April nothing for

play18:57

June but inmates five thousand ran like

play18:59

we are told and then we're told

play19:00

equipment valued at 7,500 remember

play19:03

purchased in cash in April so they have

play19:06

put equipment purchases or equipment

play19:08

patches and it's only in April so put

play19:11

down seven thousand five hundred around

play19:13

nothing in May and nothing in June

play19:15

because we are not told of connecting

play19:16

with regards to equipment for those two

play19:18

months and then a trading fine of ten

play19:21

thousand rayna's payable in June so it's

play19:23

not in April it's know

play19:24

may its in June so put trading fine and

play19:27

we'll put it on by June 10,000 written

play19:30

in brackets so you can see you put all

play19:32

our expenses in brackets all the cash

play19:35

outflows in bracket and then we have

play19:37

just completed the cash budget because

play19:40

that is the last one that we have just

play19:41

done so what you do you put our closing

play19:44

balance at the bottom so put closing

play19:46

balance and what we will take since we

play19:48

have already totaled up the cash

play19:49

available I'm going to take the cash

play19:51

available and deduct all of these

play19:53

expenses or all these cash outflows will

play19:56

deduct them to get our closing balance

play19:57

what you could have done as well you

play19:59

could have totaled up your your your

play20:01

cash outflows all these ones in brackets

play20:04

and put it down here well I didn't do it

play20:06

but you could have done it for the sake

play20:07

of simplicity but it does not matter as

play20:09

long as you do your cash budget

play20:11

correctly and your closing balance is

play20:13

correct so I just took my cash available

play20:15

and - all these expenses or cash

play20:18

outflows and we get the closing balance

play20:20

of thirty two thousand three hundred

play20:22

rent now we go to me and put our opening

play20:24

balance remember like I said I open in

play20:26

balance for me is the closing balance

play20:28

for April so good for the two thousand

play20:30

three hundred and then we and I can now

play20:32

have our cash available we add them up

play20:34

together we get the cash available of

play20:36

150 four thousand nine hundred grand and

play20:39

now that we have our cash available we

play20:41

can deduct all our expenses so all our

play20:43

cash outflows to get our closing balance

play20:45

for me and seventy nine thousand nine

play20:47

hundred gram and we take a closing

play20:49

balance for me and put it as an opening

play20:51

balance for June so could the seventy

play20:53

nine thousand nine hundred rende and

play20:55

then we get our cash available at them

play20:57

we add up all our cash inflows we get

play21:00

two hundred and one thousand nine

play21:01

hundred rent and we deduct all our cash

play21:03

outflows we get hundred and twenty-six

play21:05

thousand nine hundred Rand and we have

play21:07

just completed our cash budget so you

play21:10

can see how simple doing the cash budget

play21:11

is always remember cash budget deals

play21:13

with cash flows only the movement of

play21:16

cash and we are dealing with these three

play21:18

months specifically so you're paying

play21:19

attention to what is happening in this

play21:22

day months I hope that has helped I hope

play21:24

it has made sense if you have any

play21:25

questions or any queries you can leave

play21:27

them in the comment section below

play21:28

otherwise if you have learned something

play21:31

from this lesson if you have gained

play21:32

value from this lesson

play21:34

please leave a comment down below and

play21:36

let us know also let us know what level

play21:38

of education you are at and subscribe to

play21:40

our channel and like our video and

play21:42

sharing our video if you can until next

play21:45

time Cheers

Rate This
β˜…
β˜…
β˜…
β˜…
β˜…

5.0 / 5 (0 votes)

Related Tags
Cash BudgetingFinancial PlanningBusiness LiquiditySales ForecastCredit CollectionsDebt CollectionExpense TrackingBudget ManagementFinancial EducationLiquidity Analysis