Purchase Solution

Cash Budget

Not what you're looking for?

Ask Custom Question

Please help with this problem in excel attached.

Show all working in work format

BM Accounting what the numbers mean 8th edition

a. Cash Budget
MARINE TECH, INC.
Cash Budget
For the months of April, May, and June, 2009

April May June
Beginning Cash Balance
Cash Receipts:
From cash sales made in current month - - -
From credit sales made in:
February (from analysis in Step 1 above) -
March (from analysis in Step 1 above) - -
April (from analysis in Step 1 above) - -
May (from analysis in Step 1 above) -
Total Cash Available $ - $ - $ -
Cash Disbursements:
For cost of goods sold/operating expenses incurred in:
March (from analysis in Step 1 above) $ -
April (from analysis in Step 1 above) - -
May (from analysis in Step 1 above) - -
June (from analysis in Step 2 above) -
For payment of note payable and interest
For capital expenditures
For payment of income taxes
For payment of dividends
Total Disbursements $ - $ - $ -
Ending cash balance $ - $ - $ -
b. Cash Budget (revisions shown in bold)

MARINE TECH, INC.
Cash Budget
For the months of April, May, and June, 2009

April May June
Beginning Cash Balance
Cash Receipts: Same as cash budget in part a

From cash sales made in current month - - -
From credit sales made in:
February (from analysis in Step 1 above) -
March (from analysis in Step 1 above) - -
April (from analysis in Step 1 above) - -
May (from analysis in Step 1 above) -
Total Cash Available $ - $ - $ -
Cash Disbursements:

For cost of goods sold/operating expenses incurred in: Same as cash budget in part a
March (from analysis in Step 1 above) $ -
April (from analysis in Step 1 above) $ - -
May (from analysis in Step 1 above) - -
June (from analysis in Step 2 above) -
For payment of note payable and interest -
For capital expenditures -
For payment of income taxes -
For payment of dividends -
Total Disbursements $ - $ - $ -

Excess (deficiency) of available cash
over disbursements $ - $ - $ -
Borrowings
Repayments
Interest
Ending Cash Balance
1. How do revenues in the income statement differ from cash receipts in the cash budget for the same period of time?
2. How do expenses in the income statement differ from cash payments in the cash budget for the same period of time?
3. Explain how the minimum cash balance requirement in part b of the problem affects the monthly cash budgets prepared in part a of the problem.
4. Explain a cash management strategy that might require a minimum, as well as a maximum, cash balance of $20,000 at the end of each month.

Attachments
Purchase this Solution
Solution Summary

The solution explains how to prepare cash budget

Purchase this Solution
Free BrainMass Quizzes
Basics of corporate finance

These questions will test you on your knowledge of finance.

Income Streams

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

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

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.

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