Ask Experts Questions for FREE Help !
Ask
    Nithihasa's Avatar
    Nithihasa Posts: 1, Reputation: 1
    New Member
     
    #1

    Mar 10, 2013, 01:17 PM
    Cash Budget
    How to prepare a cash budget according to below details.

    Opening cash balance Jan 2013 - 10,000
    Borrowings - 5,000 due in July 2013

    Purchasing Wages Other Expenses
    Jan-13 £20,000.00 £10,000.00 £19,000.00
    Feb-13 £20,000.00 £8,000.00 £4,000.00
    Mar-13 £30,000.00 £12,500.00 £4,500.00
    Apr-13 £40,000.00 £16,000.00 £5,000.00
    May-13 £45,000.00 £17,500.00 £5,500.00
    Jun-13 £50,000.00 £20,000.00 £6,000.00
    Jul-13 £54,000.00 £35,000.00 £7,800.00
    Aug-13 £50,000.00 £35,000.00 £8,900.00
    Sep-13 £40,000.00 £32,000.00 £5,475.00
    Oct-13 £45,900.00 £23,950.00 £10,500.00
    Nov-13 £46,000.00 £35,000.00 £9,500.00
    Dec-13 £60,000.00 £52,500.00 £12,500.00

    Please help me on this. Thanks in advance.
    Sam
    pready's Avatar
    pready Posts: 3,197, Reputation: 207
    Ultra Member
     
    #2

    Mar 10, 2013, 02:40 PM
    You do not have enough information to solve your problem. You will need information about cash receipts.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How master budget is different from cash budget [ 1 Answers ]

What are the differences between master budget and cash budget?

Schedule of Expected Cash Collections; Cash Budget [ 4 Answers ]

Problem 9-23 Schedule of Expected Cash Collections; Cash Budget Herbal Care Corp. a distributor of herb-based sunscreens, is ready to begin its third quarter, in which peak sales occur. The company has requested a $39,000, 90-day loan from its bank to help meet cash requirements during the...

Preparing a cash collections and cash budget - I need advice - thank you! [ 0 Answers ]

I am having difficulty figuring this out. Any help would be appreciated to answer the 3 requirements. I am not certain how to set up these budgets. Thank you. Problem 4-3: You will be required to prepare a December cash budget. You are provided with the following information: a] Cash...

Prepare a Budgeted Income Statement, Cash Budget, Sales Budget/Cash Collections, Purc [ 1 Answers ]

The CEO of Kingston Cart Inc. asked the Chief Financial Officer to prepare a Master Budget for the next three months, beginning July 1, 2010. The company's policy is to maintain a minimum cash balance of $6,000 at each month end. Sales are forecasted at an average selling price of $70 per cart....

In a cash budget the cumulative cash balance is equal to? [ 1 Answers ]

a. Cumulative loan balance minus the ending cash balance. B. cumulative loan balance plus the ending cash balance. C. net cash flow minus the beginning cash balance. D. net cash flow plus the beginning cash balance.


View more questions Search