FI504 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
Premium Budget Sales Receipt
Buckman 7/28/10 Using a Cash Budget for Planning Purposes Introduction Let me begin by explaining what a cash budget is. A cash budget is a tool that helps individuals and companies forecast a short term financing needs. Investopedia defines a cash budget as‚ “an estimation of the cash inflows and outflows for a business or individual for a specific period of time.” (Cash Budget) A cash budget is used to determine the borrower’s ability to generate cash and repay debt. A cash budget also provides
Premium Cash flow Generally Accepted Accounting Principles Financial statements
Case Study 3 - Cash Budget SCHEDULE OF EXPECTED CASH COLLECTIONS FROM CUSTOMERS: Credit Sales August September July ($30‚000 x 40%) 12‚000 August ($24‚000 x 60%)‚ September ($24‚000 x 40%) 14‚400 9‚600 September ($18‚000 x 60%) 10‚800 Total Cash Collections 26‚400 20‚400 SCHEDULE FOR EXPECTED PAYMENTS FOR PURCHASE OF INVENTORY Inventory purchases August September July ($65‚000 x 50%) 32‚500 August ($45‚000 x 50%)
Premium Money Investment Asset
CASH BUDGET FOR CONGO LIMITED | | FEBRUARY $’000 | MARCH $’000 | APRIL $’000 | Total $’000 | Cash On Hand | 1‚800 | 3‚568 | 2‚805 | 8‚173 | | | | | | Cash Receipts | | | | | Cash Sales | 1‚850 | 1‚620 | 1‚400 | 4‚870 | Collections from CR Accounts | 13‚110 | 11‚875 | 10‚545 | 35‚530 | Total Cash Receipts | 14‚960 | 13‚495 | 11‚945 | 40‚400 | Total Cash Available | 16‚760 | 17‚063 | 14‚750 | 48‚573 | | | | | | Cash Paid Out | | | | | Purchases Resale | (7
Premium Cash Generally Accepted Accounting Principles Bond
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 4. The actual case study assignment should be uploaded to the Week 6 Assignment Dropbox by 11:59 p.m. mountain time on Sunday at the end of Week 6. You are encouraged to use the Excel template file provided in Doc Sharing. The Cambridge Company has budgeted sales revenues as follows
Premium Budget Sales Case study
capital for each year and the cash flow due to investments in net working capital. The firm needs to increase its net working capital by 12% of incremental sales revenues. This amount is needed in the year before the sales revenue is earned. The amount for year 0 is 12% x $250‚000 = $30‚000.00‚ and that for year 1‚ 2‚ and 3 are $30‚900.00‚ $31‚827.00‚ and $32‚781.81 respectively. The cash flow due to the changes in the working capital is shown in Table 2. Year 0 1 2 3 4 Cash flow due to the changes in
Premium Net present value Investment Risk
Hittle Company Ltd (Case Study) You are a financial analyst for the Hittle Company. The director of capital budgeting has asked you to analyze two proposed capital investments‚ project X and Y. Each project has a cost of $10000 and the cost of capital for each project is 12 percent. The projects expected net cash flows are as follows: |Expected Cash flows | | | | | |year
Premium Net present value
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
Premium Investment Asset Receipt
Instructor Explanation: Chapter 1 page 6 Points Received: 3 of 3 Comments: 2. Question : (TCO C) Debt securities sold to investors that must be repaid at a particular date some years in the future are called: Student Answer: accounts payable. notes receivable. taxes payable. bonds payable. Instructor Explanation: Chapter 1 page 9 Points Received: 3 of 3 Comments: 3. Question : (TCO C) Which activities involve putting the resources
Premium Scientific method Logic Mind
Scenario E4-5 A) List the weaknesses in internal control over cash disbursements. 1) Checks are not pre-numbered. When checks have no numbers‚ no one will know if a check is misplaced or stolen. 2) Too many people are authorized to sign checks. The treasurer should be the only person authorized. 3) Checks are not being kept in a safe area. A filing cabinet‚ even a locked one can be easily pried open and checks stolen. 4) Segregation of duties is not being done‚ the purchasing agent should
Premium Cheque English-language films Accounts receivable