Purchase Solution

Cornerstones of Managerial Accounting

Not what you're looking for?

Ask Custom Question

The president of Cleantech, Inc. has just approached the company's bank seeking short-term financing for the coming year, Year 2. Cleantech is a distributor of commercial vacuum cleaners. The bank has stated that the loan request must be accompanied by a detailed cash budget that shows the quarters in which financing will be needed as well as the amounts that will he needed and the quarters in which repayments can be made. To provide this information for the bank, the president has directed that the following data be gathered from which a cash budget can be prepared:

a. Budgeted sales and merchandise purchases for Year 2, as well as actual sales and purchases for the last quarter of Year I, are as follows:

Please see the attached PDF document

b. The company typically collects 33% of a quarter's sales before the quarter ends and another 65% in the following quarter. The remainder is uncollectible. This pattern of collections is now being experienced in the actual data for the Year I fourth quarter.

c. Some 20% of a quarter's merchandise purchases are paid for within the quarter. The remainder is paid in the following quarter.

d. Operating expenses for Year 2 are budgeted at $90.000 per quarter plus 12% of sales. Of the used amount, $20.000 each quarter is depreciation.

e. The company will pay $10,000 in cash dividends each quarter.

f. Land purchases will be made as allows during the year: $80.000 in the second quarter and $48,500 in the third quarter.

g. The Cash account contained $20,000 at the end of Year I. The company must maintain a minimum cash balance of at least 18,000.

h. The company has an agreement with a local bank that allows the company to borrow in increments of $10,000 at the beginning of each quarter, up to the total loan balance of $100,000. The interest rate on these loans is 1% per month, and for simplicity, we will assume that interest Is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the year.

i. At present, the company has no loans outstanding.

Required:
1. Prepare the following, by quarter and in total, for Year 2:
a. A schedule of expected cash collections on sales.
b. A schedule of expected cash disbursements for merchandise purchases.

2. Compute the expected cash disbursements for operating expenses, by quarter and in total, for Year 2.

3. Prepare a cash budget by quarter and in total for Year 2.

Attachments
Purchase this Solution
Solution Summary

The following posting helps with problems involving managerial accounting. Concepts discussed include expected cash collections and disbursements and cash budgets.

Solution provided by:
Chidi Ngene, M. Sc.
Education
  • B. Sc., University of Nigeria
  • M. Sc., London South Bank University
Recent Feedback
  • "Thank you."
  • "thank you Chidi Ngene.. if you have any APA references would be great"
  • "Thank you so much for your help, your explanations were easy to understand and apply!"
  • "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
  • "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

IPOs

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

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.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Managerial Accounting - Capital Investment Decisions

    Kent Baker John Wiley and Sons, 2011 (2)Cornerstones of Managerial Accounting Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger E4, Cengage Learning, 2011

  • Analyzing the difference between Variable Costing vs. Absorption Costing

    Cornerstones of Managerial Accounting. USA: Cengage Learning. Warren, C.S. (2013). Managerial Accounting. Cengage Learning. The solution analyzes the difference between variable costing vs. absorption costing.

  • Effective research based cornerstones in education

    328903 Effective Research Based Cornerstones in Education How do research-based cornerstones support student involvement in assessment and analyze how it would support the intellectual, social and/or physical development of the learner?

  • Wal-Mart Business Finanacial Report

    Principles of Accounting (10th ed.). Cengage Learning. Rich, J.S., Jones, J.P., Heitger, D.L., Mowen, M.M. & Hansen, D.R. (2009). Cornerstones of Financial & Managerial Accounting. Cengage Learning. Soderquist, D. (2005).

  • Managerial accounting and financial accounting

    Analyzing cost-volume-profit relationships is part of managerial accounting. 3. Preparation of budgets is part of financial accounting. 4. Managerial accounting applies only to merchandising and manufacturing companies. 5.

  • Distinguishing features of managerial accounting

    331591 T F questions about managerial accounting and financial accounting Chris Martin has prepared the following list of statements about managerial accounting and financial accounting. 1.

  • Definition and basic concepts of managerial accounting

    598413 Definition and basic concepts of managerial accounting 1. What is managerial accounting and what are the differences between managerial accounting and financial accounting? 2. What are the main functions of managerial accounting? 3.

  • This post addresses financial and managerial accounting.

    404664 whether each phrase is more descriptive of financial or managerial accounting M13-14 Financial and Managerial Accounting: Indicate whether each phrase is more descriptive of financial accounting or managerial accounting a.

  • Role of managerial accounting

    458491 Managerial Accounting Describe the role of managerial accounting in your current or former place of business. Describe the role of managerial accounting in your current or former place of business.

View More Related Solutions