Accounting 504 Case Study Budgeting

In: Other Topics

Submitted By Floreece
Words 563
Pages 3
ACCT504 Case Study 3 on Cash Budgeting

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:59PM Mountain time of the Sunday ending 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…...

Similar Documents

Acct 504 Case Study 2

...LBJ Company: Internal Control Evaluation Accounting 504: Managerial Use & Analysis Case Study 2 Written by: 8/10/13 This evaluation is being presented as an assessment of the preparedness of the LJB Company to go public at a future date. By researching current regulations regarding publicly traded firms we hope to prepare for a smooth transition into the trading market. The Sarbanes-Oxley Act of 2002 (SOX) has established the following guidelines for publicly traded corporations and require adherence for internal controls and procedures for financial reporting. Senior management and executives will be responsible for ensuring that controls are effective and reliable. Outside auditors must periodically verify the accuracy of and adherence to the internal controls. As part of the annual Exchange Act report, an internal control report will generated along with the information recorded during each fiscal year. It is recommended that the LJB Company adopt the framework set forth by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) and remain in compliance with the SOX Act. This framework will follow six principles of internal control. 1) Establishment of Responsibility 2) Segregation of Duties 3) Documentation of Procedures 4) Physical Controls 5) Independent Internal Verification 6) Human Resource Controls Bruce Bulmer Consultations has completed its preliminary assessment of the current......

Words: 617 - Pages: 3

Capital Budgeting Case Study

...Capital Budgeting Case Study Atilano Bonilla QRB/501 October 14, 2013 Vladimir Crk Capital Budgeting Case Study The authors of this paper will analyze and interpret the answers to the Capital Budgeting Case Study presented in Week 6’s material of the Quantitative Reasoning for Business course. The paper presents the rationale behind the Net Present Value (NPV) and Internal Rate of Return (IRR) results, describes the relationship between the two and explains the reasons behind the acquisition recommendation (e) in the Microsoft Excel spreadsheet. Analyzing the Results The case study presents two corporations (A and B) with different revenue values and expenses as well as variable depreciation expenses, tax rates and discount rates. Members of the team computed both corporations’ cash flow, NPV and IRR value using a Microsoft Excel spreadsheet. The net present value (NPV) of an investment proposal is equal to the present value of its annual free cash flows less the investment’s initial outlay. Whenever the project’s NPV is greater than or equal to zero, we will accept the project; whenever the NPV is negative, we will reject the project. (Keown, 2014. p. 310) On the other hand Keown (2014) points out that “the internal rate of return is defined as the discount rate that equates the present value of the project’s free cash flows with the project’s initial cash outlay.” In effect, the NPV method implicitly assumes that cash flows......

Words: 515 - Pages: 3

Acct 504 Case Study 3 Cash Budgeting

...ACCT504 Sample Case Study 3 on Cash Budgeting Solution It is recommended that you share this solution file in Doc Sharing by the end of Week 5 with your students. The Cambridge Company has budgeted sales revenues as follows. Jan Feb Mar Credit sales $45,000 $36,000 $27,000 Cash sales 27,000 76,500 58,500 Total sales $72,000 $112,500 $85,500 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% 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 $97,500 in January, $67,500 in February, and $31,500 in March. Other budgeted cash receipts: (a) sale of plant assets for $18,525 in February, and (b) sale of new common stock for $25,275 in March. Other budgeted cash disbursements: (a) operating expenses of $10,125 each month, (b) selling and administrative expenses of $18,750 each month, (c) dividends of $28,500 will be paid in February, and (d) purchase of equipment for $9,000 cash in March. The company has a cash balance of $15,000 at the beginning of February and wishes to maintain a minimum cash balance of $15,000 at the end of each month. An open line of credit is available at the bank and carries an annual interest rate of 12%. Assume that all borrowing is done on the first day of the month in which......

Words: 557 - Pages: 3

Acct 504 Case Study 3 Cash Budgeting

...ACCT504 Practice Case Study 3 on Cash Budgeting This is a practice case study to help you become familiar with how to create a comprehensive cash budget. The cash budget relates to TCO D and is discussed in Chapter 7. Your professor will provide the solution by the end of Week 5 in Doc Sharing. The actual case study assignment 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 Cambridge Company has budgeted sales revenues as follows. Jan Feb Mar Credit sales $45,000 $36,000 $27,000 Cash sales 27,000 76,500 58,500 Total sales $72,000 $112,500 $85,500 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% 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 $97,500 in January, $67,500 in February, and $31,500 in March. Other budgeted cash receipts: (a) sale of plant assets for $18,525 in February, and (b) sale of new common stock for $25,275 in March. Other budgeted cash disbursements: (a) operating expenses of $10,125 each month, (b) selling and administrative expenses of $18,750 each month, (c) dividends of $28,500 will be paid in February, and (d) purchase of......

Words: 434 - Pages: 2

Acct 504 Case Study

...| | | | | | Keller UniversityACCT-504-61338 Accounting Finance: Managerial Use and Analysis Professor: Sean WrightMarch 2014 | | Table of Contents Abstract 1 Introduction 2 Part A: Communication Plan 2 Part B: Communication Piece: Company Email 3 Part C: Analysis of Media 4 References 6 Abstract Let me take this opportunity to thank you for choosing Kwakye and Associates Accounting Firm to evaluate LJB’s internal control systems. This report will inform you of any new internal control requirements if LBJ decides to go public. It will cover what the company is currently doing well, and what areas need improvement. There will also a recommendation on whether or not to purchase the indelible ink machine along with some valuable control activities that will prove beneficial for LJB to put into action. Introduction Internal controls….. Internal Control Rules and Regulations Before the LJB Company decides to go public, it is imperative that you review and understand the rules and regulations by Security and exchange commission as directed by Section 404 of the Sarbanes-Oxley Act of 2002. According to the report by Securities and Exchange Commission, LJB Company will have to adapt to rules requiring companies subject to the reporting requirements of the Securities Exchange Act of 1934, other than registered investment companies, to include in their annual reports a report of management on the company's internal control over......

Words: 1110 - Pages: 5

Case Study 3, Acct 504

...CASE STUDY 3—Cash Budget Template | | | | | | | | | | | | | | | | | | SCHEDULE OF EXPECTED CASH COLLECTIONS FROM CUSTOMERS May | June | 65,800 | | 26,850 | 62,650 | | 22,500 | 92,650 | 85,150 | | | | | | | May | June | 117,000 | | 54,000 | 81,000 | | 25,200 | 171,000 | 106,200 | | | | | | | | | | | May | June | $20,000 | $20,000 | | | 92,650 | 85,150 | 33,000 | | | 50,000 | 75,000 | 57,000 | 200,650 | 192,150 | 220,650 | 212,150 | | | 171,000 | 106,200 | 15,000 | 15,000 | 10,150 | 10,150 | 35,000 | | | 20,000 | 231,150 | 151,350 | (10,500) | 60,800 | | | | | 30,500 | | | (31,008) | $20,000 | 29,792 | | | To see all the figures look above | | | Credit Sales | | | May | June | (94000 x70%) | | 65,800 | | May(89500 x 30%), Jun (89500 x 70%) | | 26,850 | 62,650 | (75000 x 30%) | | | 22,500 | Total Cash Collections | | 92,650 | 85,150 | | | | | | | | | | | SCHEDULE FOR EXPECTED PAYMENTS FOR PURCHASE OF INVENTORY | | | Inventory purchases | | May | June | April(195000 x60%) | | 117,000 | | (135000 x 40%), Jun (135000 x 60%) | | 54,000 | 81,000 | ......

Words: 555 - Pages: 3

Acct 504 Case Study 2

...Case Study 2 The five internal control procedures are: Smart Hiring Practices and Separation of Duties: In a business with good internal controls, no important duty is overlooked. Each person in the information chain is important. The chain should start with hiring. Background checks should be conducted on job applicants. Proper training and supervision, as well as paying competitive salaries, helps ensure that all employees are sufficiently competent for their jobs. Employee responsibilities should be clearly laid out in position descriptions. Comparisons and Compliance Monitoring: No person or department should be able to completely process a transaction from beginning to end without being cross-checked by another person or department. Adequate Records: Accounting records provide the details of business transactions. The general rule is that all major groups of transactions should be supported by either hard copy documents or electronic records. Limited Access: To complement segregation of duties, company policy should limit access to assets only to those persons or departments that have custodial responsibilities. Proper Approvals: No transaction should be processed without management’s general or specific approval. The bigger the transaction, the more specific approval it should have. For individual small transactions, management might delegate approval to a specific department. Situation A In evaluating the internal control over cash payments of......

Words: 779 - Pages: 4

Acct 504 Week 6 Case Study 3 – Cash Budgeting – Lbj Company

...A++PAPER;http://www.homeworkproviders.com/shop/acct-504-week-6-case-study-3-cash-budgeting-lbj-company/ ACCT 504 WEEK 6 CASE STUDY 3 – CASH BUDGETING – LBJ COMPANY ACCT504 CASE STUDY 3 ON CASH BUDGETING 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:59PM Mountain time of the Sunday ending 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...

Words: 466 - Pages: 2

Acct-504 Week 6 Case Study 3 – Cash Budgeting – Lbj Company

...ACCT-504 Week 6 Case Study 3 – Cash Budgeting – LBJ Company Click Link Below To Buy: http://hwcampus.com/shop/acct-504/acct-504-week-6-case-study-3-cash-budgeting-lbj-company/ Or Visit www.hwcampus.com ACCT504 Case Study 3 on Cash Budgeting 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:59PM Mountain time of the Sunday ending 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......

Words: 475 - Pages: 2

Acct 504 Week 6 Case Study 3 – Cash Budgeting – Lbj Company

...ACCT 504 WEEK 6 CASE STUDY 3 – CASH BUDGETING – LBJ COMPANY A+ Graded Tutorial Available At: http://hwsoloutions.com/?product=week-6-case-study-3-cash-budgeting-lbj-company Visit Our website: http://hwsoloutions.com/ Product Description ACCT 504 Week 6 Case Study 3 – Cash Budgeting – LBJ Company, What are the three sections of a Cash Budget, and what is included in each section? 1. The cash receipts section includes expected receipts from the company’s principal source(s) of cash. It also shows anticipated receipts 0f intersest and dividends, and proceeds from planned sales of investments, plant assets, and the company’s capital stock. 2. The cash disbursements section shows expected payments for inventory, labor, overhead, and selling and administative expenses. This section also includes projected payments for income taxes, dividends, investments, and plant assets. 3. The financing section shows expected borrowings and the repayment of the borrowed funds plus interest. The financing entry when there is a deficiency or when the cash balance balance is less than management’s minum required balance. ACCT 504 Week 6 Case Study 3 – Cash Budgeting – LBJ Company, What are the three sections of a Cash Budget, and what is included in each section? 1. The cash receipts section includes expected receipts from the company’s principal source(s) of cash. It also shows anticipated receipts 0f intersest and dividends, and proceeds from planned sales of investments, plant...

Words: 306 - Pages: 2

Accounting 504 Week 5 Case Study

...Case Study ACCT504 Acct Fin: Managerial Use Analysis Devry University Carmeshia Motes Professor Melinda Howerton February 7th, 2016 Situation A. In evaluating the internal control over inventory for the Williams Oil Services Company, an auditor learns that the warehouse receiving clerk is responsible for ordering parts for supply inventory use in drilling services, counts the inventory when received at the dock, records the receipts into the inventory ledger, and takes the annual inventory, No supervisor reviews the receiving clerk’s work. Missing Internal Control Characteristic: The important missing factor is that same person is responsible for conducting all the activities of inventory. He or She is responsible for ordering parts, counting the inventory, recording inventory ledger and taking up of annual stock. Problem of the Firm: The firm does not have any internal control mechanism to cross check the authenticity of documents and physical inventory of stores. All the duties are being performed by same person, there is no segregation of duties which could prevent or decrease the errors and willful fraud. Proposed Solution: Segregation of duties is one of the methods of internal which helps in preventing and reducing the occurrence of frauds and errors. It is done by segregating the duties in a department and by ensuring that no single person is having control on all the transactions. There are four general categories of duties: authorization, custody,......

Words: 949 - Pages: 4

Acct 504 Case Study 3

...ACCT 504 Case Study 3 http://homeworklance.com/downloads/acct-504-case-study-3/ (Learning Objective 5: Construct and use a cash budget) Nathan Farmer, chief financial officer of Wang Appliance Store, is responsible for the company’s budgeting process. Farmer’s staff is preparing the Wang cash budget for 2014. A key input to the budgeting process is last year’s statement of cash flows, which follows (amounts in thousands): Wang Appliance Store Statement of Cash Flows 2013 (in thousands) Cash Flows from Operating Activities Collections from customers $51,000 Interest Received 500 Purchase of inventory (36,000) Operating expenses (10,200) Net cash provided by operating activities 5,300 Cash Flows from Investing Activities Purchase of equipment (3,500) Purchase of investments (500) Sale of investments 1,000 Net cash used for investing activities (3,000) Cash Flows from Financing Activities Payment of long term debt ...

Words: 284 - Pages: 2

Capital Budgeting Case Study

...Team B Capital Budgeting Case Study Karissa Hall, M. Paul Mitchell & Augustine Flores QRB 501 November 9, 2015 Dorrell Crittenden Team B Capital Budgeting Case Study INTRODUCTION A Capital budget is defined as, the process of decision making with respect to investments made in fixed assets—that is, allowing for one to determine what course of action to take especially as concern whether a proposed project should be accepted or rejected or whether an investment should be made (Keown, Martin, & Petty, 2014). Team B’s goal this week was to define, analyze, and interpret a Capital Budgeting Case, that included, (a) a five-year projected income statement, (b) a five-year projected cash flow, (c) Net present value (NPV), and (d) Internal rate of return (IRR). The team has attached a spreadsheet detailing the analysis done for each corporation as well as offering a recommendations of which of the two corporation should be acquired. RATIONALE BEHIND NET PRESENT VALUE (NPV): Net present value ************* ****************** ***************** ******* *************** ************** ************* *********** ************** ******** ********** ************ ************ ************ ************* ********** ****** ********* *************** ************** ************* ******* ******* ********** ************** ****** ********** ************ ************ ****** ******* ******* ************* ********** ************* ************* ********** ******** ******** *******......

Words: 250 - Pages: 1

Acct 504 Week 6 Case Study 3 – Cash Budgeting Lbj Company

...ACCT 504 Week 6 Case Study 3 – Cash Budgeting LBJ Company To Buy This material Click below link http://www.uoptutors.com/acct-504/acct-504-week-6-case-study-3—cash-budgeting-lbj-company 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:59PM Mountain time of the Sunday ending 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 $19,000 cash in June, and......

Words: 472 - Pages: 2

Fi 504 Case Study

...FI504 Case Study 2 -Internal Control Due by Sunday of week 5, 11:59PM, Mountain Time LJB Company, a local distributor, has asked your accounting firm to evaluate their system of internal controls because they are planning to go public in the future. The President wants to be aware of any new regulations required of his company if they go public so he met with a colleague of yours at a local restaurant. The President of the company explained the current system of internal controls to your colleague. Your colleague has since been promoted to a tax position so she has passed on the information below so you can generate recommendations for the partner at your accounting firm to share with the President of LJB Company. Since LJB Company is a relatively lean organization, they have a lot of faith in their long-term employees. They have one accountant who serves as Treasurer and Controller which streamlines many of their processes. In this dual role, he purchases all of the supplies and pays for these purchases. He also receives the checks and completes the monthly bank reconciliation. The accountant is so busy that the company handles petty cash a bit differently. All employees have access to the petty cash in a desk drawer and are asked to only place a note if they use any of the cash. The accountant has recently started using pre-numbered invoices and wants to buy an indelible ink machine to print their checks. The President is waiting to hear from you if this is a......

Words: 612 - Pages: 3