...CASE STUDY 3 - Cash Budget | | | | | | | | | | | | | | | | | | SCHEDULE OF EXPECTED CASH COLLECTIONS FROM CUSTOMERS: | | | Credit Sales | | | May | June | April | | (94,000 * 0.70) = 65,800 | 65,800 | | May | | (89,500 * 0.30) = 26,850, June (89,500 * 0.70) = 62,650 | 26,850 | 62,650 | June | | (75,000 * 0.30) = 22,500 | | 22,500 | Total Cash Collections | | 92,650 | 85,150 | | | | | | | | | | | SCHEDULE FOR EXPECTED PAYMENTS FOR PURCHASE OF INVENTORY | | | Inventory purchases | | May | June | April | | (195,000 * 0.60 ) = 117,000 | 117,000 | | May | | (135,000 * 0.40) = 54,000, June (135,000 * 0.60) = 81,000 | 54,000 | 81,000 | June | | (63,000 * 0.40) = 25,200 | | 25,200 | Total Payments for Inventory Purchases | 171,000 | 106,200 | | | | | | | | | | | | LBJ Company | | | | Cash Budget | | | | For the Two Months of May and June | | | | | | May | June | Cash balance | | | $20,000 | $20,000 | Add: Receipts | | | | Collections from customers | 92,650 | 85,150 | Sale of plant assets | | 33,000 | | Sale of new common stock | | 50,000 | Cash sales | | | 75,000 | 57,000 | Total receipts | | | 200,650 | 192,150 | Total Available Cash | | 220,650 | 212,150 | Less: Disbursements | | | | Purchases of inventory | | 171...
Words: 674 - Pages: 3
...AC 504 E EXTERNAL AUDITING FALL 2015 Final Exam Case Study: Auto Parts Inc. Instructor: Héri RAKOTOVOLOLONA 1 “Auto Parts Inc.” Final Exam Case Study AC504 – External Auditing Date: December 1, 2015. Instructions 1. This final exam case study is the second element of the assessment to the course and represents 60% of your overall grade. It has to be completed individually or in group of up to three (3) persons, maximum. 2. Whilst there is no formal limitation of pages, you are requested to be very synthetic, clear and straightforward in your answers and recommendations as if it should be for a structured and argued management consulting report prepared for your executive manager. 3. Upon completion, your contribution work should be UPLOADED on the e-learning platform (Moodle) in WORD format no later than Saturday 19 December 2015 (11:59 pm). Other electronic formats such as PDF or JPG are NOT accepted. 4. File identification to be sent (very important): AC504 (FE) – Students names (F2015). At least, the name of one (1) group member should be included in the file name, AND the names of ALL group members mentioned on the cover page. 5. In case of emergence (ONLY), your message could be sent or forwarded to heri.rakoto@esc-rennes.com Guidance Notes I. You should primarily refer to the International Accounting Standards (IAS/IFRS) to analyze the different accounting issues raised in the case or, at least, to the French accounting rules. II...
Words: 312 - Pages: 2