Purchase Solution

Prepare and Calculate a cash budget

Not what you're looking for?

Ask Custom Question

What will be the cash budget for this company: The company predicts that 5% of its credit sales will never be collected, 35% of its sales will be collected in the month of the sale, and the remaining 60% will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2003, credit sales were $315,000.

Item April May June
Credit Sales $380,000 $340,000 $420,000
Credit Purchses $160,000 $190,000 $150,000
Cash disbursements
Wages, taxes, expenses $79,000 $75,000 $86,000
Interest $8,000 $8,000 $8,000
Equipment purchases $50,000 $70,000 $175,000

Item April May June
Beginning cash balance April =$230,000 May ? June ?
Cash disbursements April = $160,000

Ending Cash Balance April? May? June?

Purchase this Solution
Solution Summary

Given the data, the solution constructs a format of a cash budget and provides an answer complete with explanations and calculations.

Solution Preview

See the attached file.

The basic elements of cash flows are as follows:
a. Starting Cash. This is the starting balance - what is on hand at the beginning of each month
b. Cash In. This is all cash received, including sales, paid receivables, interest or cash from sales of stock or assets
c. Cash Out. Includes cash put out for all fixed and variable expenses
d. Ending Cash. This is the ending balance.

The basic formula is to add starting cash to cash in for total cash then subtract cash out. An example is listed in ...

Purchase this Solution
Free BrainMass Quizzes
Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Introduction to Finance

This quiz test introductory finance topics.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

View More Free Quizzes
Related BrainMass Solutions

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

    What is the relationship between an operating budget and a cash budget? Why is it important for an organization to prepare a cash budget? There are several types of cash budgets used in planning and decision making.

  • Manufacturing Costs

    Prepare a sales budget in units and dollars, by month and in total, for the fourth quarter (October, November, and December) of 2004. b. Prepare a schedule of cash collections from sales, by month and in total, for the fourth quarter of 2004.

  • Monthly Cash Budget for Ritz-Carlton

    56721 Prepare a monthly cash budget and calculate profit increases. Suppose Ritz-Carlton has a 300 room hotel in the tropical climate.

  • Flexible Budget / capital budgeting

    Please see the cell formula and cell comments to get the calculation details The solution explains how to prepare a flexible budget, calculate cash flows and the IRR and NPV for a project

  • Genesis Energy Cash Position Analysis

    One of Genesis Energy's potential lenders tells the team that in order to be considered as a viable customer, Genesis Energy must prepare and submit a monthly cash budget for the current year and a quarterly budget for the subsequent year.

  • Accounting Problems

    Prepare a schedule of cash collections from sales, by month and in total, for the fourth quarter of 2004. C. Prepare a production budget in units, by month and in total, for the fourth quarter of 2004. D.

  • Master budget

    316568 Accounting F-12 *Please describe how to calculate!!!! Tappet Corporation is preparing its master budget fo the quarter ending March 31. It sells a single product for $25 a unit. Budgeted sales are 40% cash and 60% on credit.

  • Cash Budget Control Movement

    617998 Cash Budget Control Movement Cash Budgets A cash budget helps a company plan and control the movement of cash into and out of the company.

  • Budgeting/variance/capital budgeting

    Prepare a schedule of cash collections from sales, by month and in total, for the fourth quarter of 2010. c. Prepare a production budget in units, by month and in total, for the fourth quarter of 2010. d.

  • Cyrus Brown Manufacturing: Cash Budget for Nine Month Period

    You have been asked to prepare the cash budget for CB Manufacturing and then to answer a set of questions that follow: In order to prepare the budget you need to note the following important points: 1) To calculate the sales collection under cash

View More Related Solutions