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

    Jun 27, 2014, 03:42 PM
    Cash budget
    How do I format the cash budget?



    Cash balance, November 1 24,000
    Sales 250,000
    Gross profit percentage( based on sales) 45%
    Increase in accounts Receivable during month 24,000
    Increase in accts. Payable during month 51,000
    Increase in inventory during month 98,000
    Selling expenses total 32,000 per month plus 15% of sales. Depreciation expense of 5,000 per month is included in fixed selling expenses. Prepare a worksheet to compute projected cash balance of 1,000 at end of November.
    paraclete's Avatar
    paraclete Posts: 2,706, Reputation: 173
    Ultra Member
     
    #2

    Jun 29, 2014, 06:13 AM
    do you have a text book, please read it

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!

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