Purchase Solution

Cash Budgeting; ways to maintain cash flow

Not what you're looking for?

Ask Custom Question

Theorize the following questions based upon provided data. See attached file.

a. What changes could the company make if they wanted to maintain a cash balance of $650,000, rather than $350,000?
b. What is the company's cost of borrowing was 6%, rather than 12%? What recommendations would you make to them?
c. What is the company experienced 10% of bad debt per year? What would be the impact on their ending cash?

Revenues Schedule 1 $36,860,000
Cost of goods sold Schedule 7 24,440,000
Gross margin 12,420,000
Operating costs
Product design Schedule 8 $1,024,000
Marketing costs Schedule 8 3,725,900
Distribution costs Schedule 8 3,876,000 8,625,900
Operating income 3,794,100

Budgeted Cash Flows Quarters
1 2 3 4
Collections from customers $9,136,600 $10,122,000 $10,263,200 $8,561,200
Disbursements
Direct materials 2,947,605 2,714,612 2,157,963 2,155,356
Payroll 3,604,512 2,671,742 2,320,946 2,562,800
Manufacturing overhead costs 2,109,018 1,530,964 1,313,568 1,463,450
Nonmanufacturing costs 1,847,750 1,979,000 1,968,250 1,705,000
Machinery purchase â?" â?" 758,000 â?"
Income taxes 725,000 400,000 400,000 400,000

Attachments
Purchase this Solution
Solution Summary

Your tutorial is in Excel (attached). Click in cells to see computations.

Solution Preview

Your tutorial is in Excel (attached). Click in cells to see computations.

a. What changes could the company make if they wanted to maintain a cash balance of $650,000, rather than $350,000?

I don't have the opening cash but I am presuming that the $350,000 is approximately the "net" cash for the year (see E123) after ...

Solution provided by:
Carol Sargent, PhD
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

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.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Motivation

This tests some key elements of major motivation theories.

View More Free Quizzes
Related BrainMass Solutions

  • cash budget

    Cash Budget helps in management of cash flow of the organization. Budgeting helps managers make decisions about resources needed and financial results expected for the coming period.

  • Benefits of depreciation, cash budgeting, and cash flow

    Financial managers use cash budgeting to monitor short term cash flow inflows and outflows.

  • Working Capital Policy

    Inevitably the company had to borrow additional funding in order to maintain a $50,000 cash balance and to cover additional expenses for the day-to-day operations.

  • Depreciation and capital budgeting

    = 5,000 Tax = 2,000 Net Income = 3,000 Since depreciation is non cash we now add it back to get the net cash flow as 3,000+5,000=$8,000 Thus depreciation increases the cash flow by $2,000 which is the tax shield due to depreciation (calculated

  • Capital Budgeting Decision: Terminal Cash Flow

    35076 Capital Budgeting Decision: Terminal Cash Flow A corporation is evaluating the relevant cash flow for a capital budgeting decision and must estimate cash flow.

  • cash inflows

    In some projects it is customary to assume that the cash flow takes place at the end of a year. In some other projects it may be important to estimate the cash flow bi-annually or even at the end of every three months.

  • I need some assistance analyzing "Capital Budgeting"!

    Many companies will also use capital budgeting to assess their cash flow, particularly when it comes to new projects and investment opportunities.

  • Capital budgetings

    No it will not be treated as incremental cash flow Why is it important to identify the incremental cash flows in the context of calculating the NPV for capital budgeting purposes?

  • Capital budgeting Cash flow

    462381 Capital budgeting Cash flow ABC company is evaluating its first year operating cash flows (at t=1).

  • Operating Cash Flows

    The solutions to other problems are in the attachment titles Soln.xls Operating cash flow accounting profits are determined. The solution focuses on cash flows as opposed to net income in capital budgeting.

View More Related Solutions