KAEFER MANUFACTURING | ||||||
CASH BUDGET | ||||||
Q1 | Q2 | Q3 | Q4 | Q1 | ||
Budgeted Sales | 964440 | 997920 | 1075680 | 926640 | 1041595 | |
Collections from Sales | ||||||
From Current Quarter | 353628 | 365904 | 394416 | 339768 | ||
From Previous Quarter | 614700 | 610812 | 632016 | 681264 | ||
Total Collections | 968328 | 976716 | 1026432 | 1021032 | ||
Payment to Suppliers Current Quarter | 205128 | 221112 | 190476 | 214105.7 | ||
Payment to Suppliers Previous Quarter | 283974 | 293832 | 316728 | 272844 | ||
Wages, Taxes and Other Costs | 241110 | 249480 | 268920 | 231660 | ||
Interest on Long Term Debt | 190000 | 190000 | 190000 | 190000 | ||
Capital Expenditures | 0 | 0 | 325000 | 0 | ||
Total Payments | 920212 | 954424 | 1291124 | 908609.7 | ||
Net Cash Inflow | 48116 | 22292 | -264692 | 112422.3 | ||
Short Term Financial Plan | ||||||
Beginning Cash Balance | 130000 | 130000 | 130000 | 130000 | ||
Net Cash Inflow | 48116 | 22292 | -264692 | 112422 | ||
Income on short term Investments | 200 | 442 | 555 | 0 | ||
New Short term Investments | -48316 | -22734 | 0 | 0 | ||
Short term Investments Sold | 0 | 0 | 111050 | 0 | ||
New Short Term Borrowing | 0 | 0 | 153087 | |||
Interest on Short Term Borrowing | 0 | 0 | 0 | 1837 | ||
Short Term Borrowing Repaid | 0 | 0 | 0 | -114259 | ||
Ending Cash balance | 130000 | 130000 | 130000 | 130000 | ||
Minimum Cash balance | 130000 | 130000 | 130000 | 130000 | ||
Surplus/ Deficit | 0 | 0 | 0 | 0 | ||
Beginning Short term Investments | 40000 | 88316 | 111050 | 0 | ||
Ending Short Term Investments | 88316 | 111050 | 0 | 0 | ||
Beginning Short Term Loan | 0 | 0 | 0 | 153087 | ||
Ending Short term Loan | 0 | 0 | 153087 | 38828 | ||
Collections | ||||||
A 57 days cllection Period Means (90-57)/90 from Current Quarter | 0.366666667 | |||||
and Remaining From Previous Quarter | ||||||
Payments to Suppliers is 50% of Next Quarters Projected Sales | ||||||
And Payable Period is 53 Days | ||||||
So Payment to Suppliers for Previous Quarter = 50% of Next Quarter's Sales *(90-53)/90 | 0.411111111 | |||||
Q1 | Excess fund Start at $40000 invested for 1st Quarter earns .5% on $40000 | 200 | ||||
Q2 | Excess fund of 88316 invested earns .5% $88316 | 442 | ||||
Q3 | Excess fund of Rs. 111050 invested Earns .5 % *$111050 | 555 | ||||
Q4 | Interest on Short Term Loan of $153087 @ 1.2% | 1837 | ||||
KEAFER MANUFACTURING WORKING CAPITAL MANAGEMENT You have recently been hired by Keafer Manufacturing to work in...
I- KEASER MANUFACTURING WORKING CAPITAL MANAGEMENT You have recently been hired by Keaser Manufacturing to work in its established treasury department. Keaser Manufacturing is a small company that produces highly customized cardboard boxes in a variety of sizes for different purchasers. Adam Keaser, the owner of the company, works primarily in the sales and production areas of the company. Currently, the company basically puts all receivables in one pile and all payables in another, and a part-time bookkeeper periodically comes...
I- KEASER MANUFACTURING WORKING CAPITAL MANAGEMENT (60 ptos) You have recently been hired by Keaser Manufacturing to work in its established treasury department. Keaser Manufacturing is a small company that produces highly customized cardboard boxes in a variety of sizes for different purchasers. Adam Keaser, the owner of the company, works primarily in the sales and production areas of the company. Currently, the company basically puts all receivables in one pile and all payables in another, and a part-time bookkeeper...
You have recently beenhired by Piepkorn Manufacturing to work in its newly established treasury department. Piepkorn Manufacturing is a small company that produces cardboard oxes in a variety of sizes. Gary Piepkom, the owner of the company, works primarily in the sales and production areas. Currently, the company puts all receivables in one shoe box and all payables in another. Because of the disorganized system, the finance area needs work, and that's what you've been brought in to do. The...
You have recently been hired by KEEA Manufacturing to work in its newly established treasury department. KEEA Manufacturing is a small company that produces highly customized cardboard boxes in a variety of sizes for different purchasers. Ibrahim KEEA, the owner of the company, works primarily in the sales and production areas of the company. Currently, the company basically puts all receivables in one pile and all payables in another, and a part-time bookkeeper periodically comes in and works on the...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare comprehensive budgets for the upcoming second quarter in order to show management the...
You have recently been appointed as assistant to the financial controller of Frank plc, a manufacturing company. He has asked you to help with the finalisation of the financial statements for the year ended 31 December 2018 and year ended 31 December 2019. (a) The Key Financial Information for Frank plc for the last two years are as follows: Year 2018 Year 2019 Cash £30,000 £20,000 Accounts Receivables 200,000 260,000 Inventory 400,000 480,000 Property, Plant and Equipment 800,000 800,000 Total...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare comprehensive budgets for the upcoming second quarter in order to show management the...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...