Purchase Solution

cash budget

Not what you're looking for?

Ask Custom Question

A company had sales of $50k in March and $60k in April. Forecast sales for May, June, and July are $70k, $80k, and $100k, respectively. The firm has a cash balance of $5k in May 1 and wishes to maintain a minimum cash balance of $5k. Given the following data, prepare a cash budget for the months of May, June and July.

1) The firm makes 20% of sales for cash, 60% are collected in the next month, and the remaining 20% are collected in the second month following sale.
2) The firm receives other income of $2,000 per month.
3) The firm's actual or expected purchases, all made for cash, are $50k, $70k and $80k for the months of May, June and July, respectively.
4) Rent is $3k per month.
5) Wages and salaries are 10% of the previous month's sales.
6) Cash dividends of $3k will be paid in June.
7) Payment of principal and interest of $4k is due in June.
8) A cash purchase of equipment costing $6k is scheduled in July.
9) Taxes of $6k are due in June.

Purchase this Solution
Solution Summary

The cash budget is assessed.

Solution Preview

Hello!
The cash budget is in the Excel file I've attached.

Several of the fields in it are pretty self-explanatory, but let's go through the details of May as an example; the next 2 months are done in the same way:

We have that the firm receives in the current month in cash 20% of the sales in the current month, 60% of the sales made last month, and 20% pf the sales made two months ago. We know that in May it ...

Purchase this Solution
Free BrainMass Quizzes
Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

View More Free Quizzes
Related BrainMass Solutions

  • What information is needed in order to prepare a cash budget?

    171897 Cash Budgets and Operating Budgets What information is needed in order to prepare a cash budget? What is the relationship between an operating budget and a cash budget? Why is it important for an organization to prepare a cash budget?

  • Description of a cash budget & its useful to an organization

    The cash budget is somewhat based upon the operating budget, as sales are used to calculate what is expected in terms of the cash receipts budget. As you will find out, cash is king.

  • Budgeting

    8276 Cash budgeting: production budget, purchasing budget, sales budget and cash budget See attachment for a cash budgeting question. Please see the attached file.

  • Operating budget and cash budgets

    235866 Operating budget and a cash budget What information is needed in order to prepare a cash budget? What is the relationship between an operating budget and a cash budget? Why is it important for an organization to prepare a cash budget?

  • Cash Budget

    Why is it important to create a cash budget? Please see the attachment The solution explains how to create a cash budget and explains the importance of cash budget

  • The Purpose of the Cash Budget

    Cash budget sales budget, purchase budget, production budget etc. The cash budget is a summary of the firm's expected cash inflows and Outflows over a particular period of time.

  • Budgets for Healthcare Organization

    The expense budget lists all operating expenses that are expected to be incurred during the budget period, both fixed and variable. 3) Cash budget The cash budget represents the organization's cash inflows and outflows.

  • What are the steps to creating a cash budget?

    This is usually the last budget that the company prepares. To prepare a cash budget, the first number used to start the budget is the beginning cash balance.

  • Budget Discussion Questions for Mama's Needlework

    Cash Budget: Why doesn't the Net Cash from Operations of $93 match the Annual Budget $105? One reason is that our budget components were only for Product B. What is the other reason? Cash Budget: Why did they borrow $50 in the first quarter?

  • cash budget

    251803 Solving a cash budget problem Is there concerns with the cash budget and the company with this budget attachment. Is there concerns with the cash budget and the company with this budget attachment Let us understand about budget.

View More Related Solutions