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 2 Internal Control of Ljb Company |Case study : 2 | |Internal Control Evaluation | |LJB Company | | | To whom to be submitted: Prof. Kim Chung By whom to be submitted: Md.Tanvir Apon Submission Date: 02/09/2014 Table of Contents |S/L. |Description |Page No. | |1. |Preface |3 | |2. |LGB Company: Internal Control Evaluation |4-6 | |3. |References |7 |
Premium Public company Computer security Internal control
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
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
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
5 : Capital Budgeting Practices in Selected Indian Companies 5.1 Introduction 5.2 Data Analysis and Findings 5.3 Conclusion 129 Chapter 5 : Capital Budgeting Practices in Selected Indian Companies 5.1 Introduction: This chapter examines the trend in capital budgeting practices of twenty eight companies operating in different industry. The search for a reliable method of project appraisal dates back to decades. The issue not only continues to be a matter of concern
Premium Net present value Capital budgeting Internal rate of return