business/ACCOUNTS HELP, CASH BUDGET ASAPPPP Watch

whoami68
Badges: 8
Rep:
?
#1
Report Thread starter 10 months ago
#1
I HAVE NO IDEA HOW TO DO THIS , Its due in an hour, someone please help


JUNE JULY AUGUST
RECIEPTS
Cash sales 8000 8000 10000
Cash from debtors 24000 26000 28000
32000 34000 38000
PAYMENTS
Payments made to creditors 8000 10000 11000
Cash purchases 4000 4000 4000
Payment for rent 18000
Payment for rates 1100
Payment for wages 6000 6000 6000
Payment for other expenses 2500 2750 2600
20500 40750 24700
Balance brought forward ?
Reciepts ?

Payments ?
Balance carried forward ?

cash in hand 31st may 200
stock 1 june 200
stock 31 august 300
0
reply
whoami68
Badges: 8
Rep:
?
#2
Report Thread starter 10 months ago
#2
Payment for rent 18000 july
Payment for rates 1100 august
tsr messed up my columns
0
reply
ROC10
Badges: 14
Rep:
?
#3
Report 10 months ago
#3
(Original post by whoami68)
I HAVE NO IDEA HOW TO DO THIS , Its due in an hour, someone please help


JUNE JULY AUGUST
RECIEPTS
Cash sales 8000 8000 10000
Cash from debtors 24000 26000 28000
32000 34000 38000
PAYMENTS
Payments made to creditors 8000 10000 11000
Cash purchases 4000 4000 4000
Payment for rent 18000
Payment for rates 1100
Payment for wages 6000 6000 6000
Payment for other expenses 2500 2750 2600
20500 40750 24700
Balance brought forward ?
Reciepts ?

Payments ?
Balance carried forward ?

cash in hand 31st may 200
stock 1 june 200
stock 31 august 300
What exactly are you confused about? This post is really not helpful at all I'm afraid.
0
reply
whoami68
Badges: 8
Rep:
?
#4
Report Thread starter 10 months ago
#4
How to calculate where there's a question mark
0
reply
whoami68
Badges: 8
Rep:
?
#5
Report Thread starter 10 months ago
#5
been up since yesterday, apologies if it's not as clear
0
reply
ROC10
Badges: 14
Rep:
?
#6
Report 10 months ago
#6
(Original post by whoami68)
I HAVE NO IDEA HOW TO DO THIS , Its due in an hour, someone please help


JUNE JULY AUGUST
RECIEPTS
Cash sales 8000 8000 10000
Cash from debtors 24000 26000 28000
32000 34000 38000
PAYMENTS
Payments made to creditors 8000 10000 11000
Cash purchases 4000 4000 4000
Payment for rent 18000
Payment for rates 1100
Payment for wages 6000 6000 6000
Payment for other expenses 2500 2750 2600
20500 40750 24700
Balance brought forward ?
Reciepts ?

Payments ?
Balance carried forward ?

cash in hand 31st may 200
stock 1 june 200
stock 31 august 300
(Original post by whoami68)
How to calculate where there's a question mark
Balance brought forward for the first month is just the opening balance it gives you in the question. For subsequent months, it will be the closing balance of the previous month (i.e. balance carried forward).

You have already included all of your receipts and payments so surely these just need to be added up to give you the totals.

Hope this helps!
1
reply
whoami68
Badges: 8
Rep:
?
#7
Report Thread starter 10 months ago
#7
Name:  Screen Shot 2018-05-08 at 06.04.40.png
Views: 25
Size:  77.9 KB
0
reply
DJKL
Badges: 17
Rep:
?
#8
Report 10 months ago
#8
You are pretty much given it.

On spreadsheet split re each month

Receipts
Cash sales
Cash received debtors


Totals 32,000,24,000,38,000 (check these)

Payments

Payments to Creditors
Cash purchases
Paid re rent
Paid re rates
Paid re wages
Paid re others

Totals 20,500,40,750,24,700 (check these)

So cashflow each month 11,500,-16,750,13,300 (if my arithmetic correct)

B/fwd June is 620 so c/fwd 12,120 (11,500+620) next month c/fwd-4,630 (12,120-16,750) third month 8,670 (-4.630+13,300)
2
reply
whoami68
Badges: 8
Rep:
?
#9
Report Thread starter 10 months ago
#9
Yeah, I realised that when I did it earlier, i just wasn't concentrating due to no sleep lol, but I appreciate all the help!
1
reply
whoami68
Badges: 8
Rep:
?
#10
Report Thread starter 10 months ago
#10
For July, 8000+26000= 34000. How did I just realise that lol
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

University open days

  • University of Birmingham
    Postgraduate Open Day Postgraduate
    Wed, 20 Mar '19
  • King's College London
    Postgraduate Taught Courses - Arts & Sciences - Strand Campus Postgraduate
    Wed, 20 Mar '19
  • University of East Anglia
    All Departments Open 13:00-17:00. Find out more about our diverse range of subject areas and career progression in the Arts & Humanities, Social Sciences, Medicine & Health Sciences, and the Sciences. Postgraduate
    Wed, 20 Mar '19

Where do you need more help?

Which Uni should I go to? (59)
15.21%
How successful will I become if I take my planned subjects? (38)
9.79%
How happy will I be if I take this career? (74)
19.07%
How do I achieve my dream Uni placement? (58)
14.95%
What should I study to achieve my dream career? (43)
11.08%
How can I be the best version of myself? (116)
29.9%

Watched Threads

View All