Heloo,can anyone help me to solve this, tq so much.really confuse n dun know where to start

Sales
Apr 180000
May 200000
June 210000
Aug 200000
Sept 190000
Oct 180000
Nov 170000
Dec 160000
Historically 40% of the compny's sales were on cash basis, credit sales will be collected equally in 1 mth and 2 mth after delivery. The compny purchase raw material 2 mth in advance of its sales equal to 60% of its total sales. The supllier is paid one 1 mth after delivery
The cmpny pay fixed mthly rent of 5,000
A depreciation expenses is 400 per mth. Dividen 3,000 will be received at t end of each quarter. Annual interest of 20,000 will be paid equally, twice per year on jan n July, taxes are 5,500 payable in dec. t company decided to repay 40,000 of their loan on aug. ending cash balance for June 3,000, t cmpny would like to maintain minimum csh balance of 20,000. Per mth.
Prepare cash budget for t compny for t 3rd quarter 2008 and determine the surplus/shortage cash for the cmpny.
:confused:

You have a go!

I answered your other question and gave you
The technique as how to solve these problems.

It is very helpful if you have EXCEL to help you.
It takes time to do these problems and
Time costs MONEY!
May be an acknowledgement of the first question (answered) would also be nice.

Rolcam

I've got assignment like this once and it's not difficult to solve those problem, but it does take time..
If you want, I could give you the excel format for this calculation and the calculation example, just give me your email & I'll send it to u..

Where to start is to make yourself 8 columns for all those sales. Then follow through each statement one at a time and read it carefully and see what they are saying.

What's it say first? That 40% of sales have been on a cash basis. So start there. If 40% is cash, what happened to the other 60%? Figure out those numbers on each month. That gets you started.

Go to the next thing it says and read that carefully. Figure out the amounts it's talking about. You have to just go through each sentence one at a time like this.

You have to make an attempt at doing your own work since we're not here to do it for you. This is a big problem and has lots of steps. Giving you a hint of how to get started, or a hint on one section, isn't really going to help with the rest of it. You have to go through these carefully & think about what they are saying.

See if you can at least get the thing started. Get done of it what you can. Not everything has to be done in the order given, so skip something if you have to and do another part.

And personally, I think setting it up in Excel is useful if you have to do it on a continual basis, but probably will take longer for just one problem. And if you can't do it manually, you won't know how to set it up on Excel. I really don't see how that would help.