Purchase Solution

Quarterly Cash Budget

Not what you're looking for?

Ask Custom Question

Given the new details below to do the following:
· Construct a quarterly cash budget for Lawrence
· Tell me what is the largest amount of bank debt needed and when is it needed
· Circle them in the on the borrowing line of the matrix
· What is the largest amount of surplus cash flow generated by Lawrence and when does it happen?
· Should Lawrence change their credit terms

Everything in the initial case remains the same with the exception of the credit policy which has been changed and the effects on receivable collection are as follows.

The company wants to institute a new credit policy that is 5/10 net 30. It is believed that the revised pattern for Cash received on credit sales will amount to 50 percent in the current month of sales, 50 percent in the month following the sales.

Revised Case

Quarter 1 Quarter 2 Quarter 3 Quarter 4
Inflows Work space
Cash sales        
Month 1        
Month 2      
Month 3        
Total Quarterly Cash Sales        
Receivables
Collections Month 1      
Collections Month 2        
Collections Month 3      
Total Quarterly Collections        
Outflows Work space      
Raw Materials        
Month 1      
Month 2        
Month 3      
Quarterly Raw materials Costs        
Operating Expenses      
Month 1        
Month 2      
Month 3      
Quarterly Operating Expenses    
Calculation Space      
     
Cash Inflows        
Total Quarterly Cash Sales        
Total Quarterly Collections      
Total Quarterly cash Inflows        
Cash Outflows      
Total Quarterly Raw Materials        
Total Quarterly Operating Expenses      
Total Quarterly Cash Outflows        
     
Pretax Quarterly Cash Flows        
Quarterly estimated Taxes      
Net Quarterly Cash Flows        
     
     
     
Beginning Cash Position 50,000      
Net Quarterly Cash flows      
Closing Quarterly Cash Position        
     
Required Minimum Cash Position 20,000 20,000 20,000 20,000
     
Required Borrowings For the Quarter        
     
Previous Borrowings Repaid        
     
Final Quarterly Cash balance        

Purchase this Solution
Solution Summary

The solution explains how to prepare a quarterly cash budget

Solution Preview

Please see the attached file.

· Construct a quarterly cash budget for Lawrence

This is given above

· Tell me what is the largest amount of ...

Purchase this Solution
Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

SWOT

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

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.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

View More Free Quizzes
Related BrainMass Solutions

  • Master Budget and Bank Loans

    It also creates a cash budget and budgeted income statement for three months.

  • Genesis Energy Cash Position Analysis

    This solution calculates the company's monthly cash budget for the forthcoming year and quarterly budget for the subsequent year. All steps are shown with brief instructions.

  • Master Budget

    The cash collection is not enough to meet these. The loan is repaid by the cash generated from reduction in Inventory due to Just in Time. The solution explains the preparation of a master budget for Victoria Kite Company

  • Master budget including a budgeted income statement

    Prepare a master budget including a budgeted income statement, balance sheet, cash budget, and supporting schedules for the months January through March 2008. 2.

  • Master Budget: Understanding the budget preparation process and the use of budgets

    How are long-term capital expenditures budgeted in a quarterly budgeting process? This needs to be done via a cash budget calculation over a given period.

  • Master Budget for Victoria Kite Company

    , cash collections, purchases budget, cash disbursement for purchases, operating expenses and disbursements for expenses for the months January thru March 2005. 2) Prepare cash budget and balance sheet for the months January thru March 2005.

  • how to prepare a master budget

    Prepare a master budget including a budget income statment, balance sheet,statement of cash receipts and disbursements, and supporting schedules for the months January through March 2005. 2.

  • Company's cash budget

    The company requires a minimum cash balance of $31,600 and may borrow any amount needed from a local bank at a quarterly interest rate of 1.4%.

  • Compute the Cash Collections from Sales for Each Quarter

    435660 Compute the Cash Collections from Sales for Each Quarter The sales budget for your company in the coming year is based on a 20 percent quarterly growth rate with the first-quarter sales projection at $150 million.

View More Related Solutions