dikmah
Apr 9, 2009, 02:08 AM
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:
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: