Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Accounting Basics Expert

The cash budget was covered during Week 4 when we covered TCO D and you read Chapter 7. There is also a practice case study to work on. Your professor will provide the solution to the practice case study at the end of Week 5. This case study should be uploaded by 11:59 p.m. mountain time on Sunday at the end of Week 6 to the Week 6 Assignment Dropbox. You are encouraged to use the Excel template file provided in Doc Sharing.

The LBJ Company has budgeted sales revenues as follows.

April May June
Credit sales $94,000 $89,500 $75,000
Cash sales 48,000 75,000 57,000
Total sales $142,000 $164,500 $132,000

Past experience indicates that 30% of the credit sales will be collected in the month of sale and the remaining 70% will be collected in the following month.

Purchases of inventory are all on credit and 40% is paid in the month of purchase and 60% in the month following purchase. Budgeted inventory purchases are $195,000 in April, $135,000 in May, and $63,000 in June.

Other budgeted cash receipts: (a) sale of plant assets for $33,000 in May, and (b) sale of new common stock for $50,000 in June. Other budgeted cash disbursements: (a) operating expenses of $15,000 each month, (b) selling and administrative expenses of $10,150 each month, (c) purchase of equipment for $35,000 cash in May, and (d) dividends of $20,000 will be paid in June.

The company has a cash balance of $20,000 at the beginning of May and wishes to maintain a minimum cash balance of $20,000 at the end of each month. An open line of credit is available at the bank and carries an annual interest rate of 10%. Assume that all borrowing is done on the first day of the month in which financing is needed and that all repayments are made on the last day of the month in which excess cash is available. Also assume that there is no outstanding financing as of May 1.
Requirements:

1. Use this information to prepare a cash budget for the months of May and June, using the template provided in Doc Sharing.

2. What are the three sections of a cash budget, and what is included in each section?

3. Why is a cash budget so vital to a company?

4. What are the five basic principles of cash management that a company can follow in order to improve its chances of having adequate cash?

 

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M948361

Have any Question? 


Related Questions in Accounting Basics

This assignment will assess the following learning

This assignment will assess the following learning outcomes: - Demonstrate the impact on the financial statements and the implication for different users of accounts of alternative ways of treating controversial accounti ...

To make sure you are up to date on the special guidelines

To make sure you are up to date on the special guidelines the GASB has declared, your manager asked you to research GASB Statement No. 56. He also asked you to show him, side by side, how government accounting journal en ...

Write a 600-800 word memo to your accounting committee on

Write a 600-800 word memo to your accounting committee on fraud detection discussing the 6 steps of the Proactive Method of Fraud Detection found in figure 6.1 of Chapter 6. Include methods to gather information about a ...

District water company issued 10-year bonds with a face

District Water Company issued 10-year bonds with a face value of $100,000 and a stated interest rate of 8.0%. The bonds are dated April 1, 2016, and call for semiannual interest payments on each April 1 and October 1. Du ...

Ics manufacturing company produces plastic parts for the

ICS Manufacturing Company produces plastic parts for the automotive industry. Here is their Income Statement for 2015 - ICS Manufacturing Company Income Statement for 2015 Sales Revenue $35,500,000 Cost of Goods Sold 12, ...

Accounting questions1 if cash is 2345 in 20x2 and 3671 in

Accounting Questions 1. If Cash is $2,345 in 20X2 and $3,671 in 20X1, what is the percentage of increase or (decrease) from 20X1 to 20X2? A. 56.55%******* B. (56.55%) C. 36.12% D. (36.12%) 2. Gross profit by department a ...

Learning outcomescode descriptiona1 in-depth and systematic

Learning outcomes Code Description A1 in-depth and systematic understanding of key investment concepts to facilitate strategic real estate investment decision-making A4 critical awareness and understanding of the evolvin ...

Assignment question 1 -impulse pty ltd impulse is an

Assignment Question 1 - Impulse Pty Ltd (Impulse) is an entertainment system manufacturer that was established in 2005. Your audit firm King & Queen have been the auditor of Impulse since its formation. The audit report ...

Accountingscenariothe park family consists of the

Accounting Scenario: The Park family consists of the following: • Jackie O. Park; age 40; SSN: XXX-XX-XXXX; business analyst; single; unmarried • Leslie T. Park; age 16; SSN: 000-00-0000; daughter; high-school student; l ...

Accounting assignmentaccounting is the study of how

Accounting Assignment Accounting is the study of how businesses track their income and assets over time. Accountants engage in a wide variety of activities in addition to preparing financial statements and recording busi ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen