Piepkom Manufacturing | |||||
Cash Budget | |||||
Q1 | Q2 | Q3 | Q4 | ||
Beganing Cash balance | $ 154000 | 100000 | 100000 | 100000 | |
Cash inflow | |||||
Cash Sales (Working note -1) | $ 459250 | $ 498000 | $ 462000 | $ 454000 | |
Total Cash inflow (a) | $ 459250 | $ 498000 | $ 462000 | $ 454000 | |
Cash Outflow | |||||
Purchase of Machinery | $ 325000 | ||||
Interest on long term debt | $ 115000 | $ 115000 | $ 115000 | $ 115000 | |
Wages, Tax and others cost | $ 289050 | $ 275550 | $ 298800 | $ 277200 | |
Total Cash outflow(b) | $ 404050 | $ 390550 | $ 413800 | $ 717200 | |
Net cash inflow (a-b) | $ 209200 | $ 207450 | $ 148200 | -$ 163200 | |
Minimum Cash Balance ( c) | -$ 100000 | -$ 100000 | -$ 100000 | -$ 100000 | |
Cumulative surpuls (a-b-c) | $ 109200 | $ 107450 | $ 48200 | -$ 263200 | |
Short Term Investment (> figure of (a-b-c)) | $ 109200 | $ 108542 | $ 50377 | ||
Sold of Short term Investment | $ 260497 | ||||
Interest received on short term Investment | $ 1092 | $ 2177 | $ 2703 | ||
Cash Balance | $ 100000 | $ 100000 | $ 100000 | $ 100000 |
Working Notes : |
|||||
Cash inflow from sales |
|||||
in Question it is mention Piepkom orders 50% of next Quarter Gross Sales |
|||||
As all sales are cash sales , so cash received in each Quarter will be equal to 50% of next sales |
|||||
Hence |
|||||
Cash received in Q1 |
Sales of Q2 x 50% |
=$918500 X 50% |
$ 459250 |
||
Cash received in Q2 |
Sales of Q3 x 50% |
=$996000 X 50% |
$ 498000 |
||
Cash received in Q3 |
Sales of Q4 x 50% |
=$924000 X 50% |
$ 462000 |
||
Cash received in Q3 |
Sales of Q1 nex year x 50% |
=$908,000 X 50% |
$ 454000 |
||
Total Cash inflow from sales |
$ 1873250 |
||||
Cash Outflows |
|||||
Purchase of Machinery in Q4 |
$ 325000 |
||||
Interest paid on long term debt ($115000 per quarter) |
|||||
Q1 |
$115000 |
||||
Q2 |
$115000 |
||||
Q3 |
$115000 |
||||
Q4 |
$115000 |
$ 460000 |
|||
Wages, Tax and others cost |
|||||
Q1 |
=$963500 X 30% |
$289050 |
|||
Q2 |
=$918500 X 30% |
$275550 |
|||
Q3 |
=$996000 X 30% |
$298800 |
|||
Q4 |
=$924000 X 30% |
$277200 |
$ 1140600 |
||
Computation of Short term investment |
|||||
Q1 (Cumulative Surplus amount) |
$109200 |
||||
Q2 (Cumulative Surplus amount + Interest received) |
$108542 |
||||
Q3 (Cumulative Surplus amount + Interest received) |
$ 52555 |
||||
Interest Computation |
|||||
We assume invest on end of the quarter and sold the investment on end of quarter |
|||||
Interest on Q2 |
=$109200 X1% |
$ 1092 |
|||
Interest on Q3 |
=$217742X1% |
$ 2177 |
|||
($109200+$108542) |
|||||
Interest on Q4 |
=$270297X1% |
$ 2703 |
|||
Sold of investment |
|||||
Q4 Cumulative surplus -Interest received |
=$263200-$2703 |
$260497 |
Q1 | Q2 | Q3 | Q4 | |
Bengining Cash Balance | $ 154000 | $ 100000 | $ 100000 | $ 100000 |
Net Cash Inflow | $ 209200 | $ 207450 | $ 148200 | -$ 163200 |
Less :-New Short term Investment | $ 109200 | $ 108542 | $ 50377 | $ 0 |
New Short term Borrowing | $ 0 | $ 0 | $ 0 | $ 0 |
Income from short term investment | $ 0 | $ 1092 | $ 2177 | $ 2703 |
Interest Short term Borrowing | $ 0 | $ 0 | $ 0 | $ 0 |
Sold Short term Investment | $ 260497 | |||
Ending Cash Balance | $ 254000 | $ 200000 | $ 200000 | $ 200000 |
Minimum Cash flow | -$ 100000 | -$ 100000 | -$ 100000 | -$ 100000 |
Cumulative Surplus (Deficit) | $ 154000 | $ 100000 | $ 100000 | $ 100000 |
Beganing Short term Investment | $ 0 | $ 0 | $ 0 | $ 0 |
Beganing Short term Debt | $ 0 | $ 0 | $ 0 | $ 0 |
Ending Short term Investment | $ 0 | $ 0 | $ 0 | $ 7622 |
Ending Short term Debt | $ 0 | $ 0 | $ 0 | $ 0 |
You have recently beenhired by Piepkorn Manufacturing to work in its newly established treasury department. Piepkorn...
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...
KEAFER MANUFACTURING WORKING CAPITAL MANAGEMENT You have recently been hired by Keafer Manufacturing to work in its newly established treasury department. Keafer Manufacturing is a small company that produces highly customized cardboard boxes in a variety of sizes for different purchasers. Adam Keafer, 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...
please answer b1 and b2 Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 155 $ 175 $ 195 $ 225 Sales for the first quarter of the year after this one are projected at $170 million. Accounts receivable at the beginning of the year were $67 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 105 $ 125 $ 145 $ 175 Sales for the first quarter of the year after this one are projected at $120 million. Accounts receivable at the beginning of the year were $47 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecast sales, and suppliers...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 150 $ 170 $ 190 $ 220 Sales for the first quarter of the year after this one are projected at $165 million. Accounts receivable at the beginning of the year were $65 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecast sales, and suppliers...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 150 $ 170 $ 190 $ 220 Sales for the first quarter of the year after this one are projected at $165 million. Accounts receivable at the beginning of the year were $65 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecast sales, and suppliers...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 105 $ 125 $ 145 $ 175 Sales for the first quarter of the year after this one are projected at $120 million. Accounts receivable at the beginning of the year were $47 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecast sales, and suppliers...
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...
Can you please show calculations. Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $200 $220 $240 $270 Sales for the first quarter of the year after this one are projected at $215 million. Accounts receivable at the beginning of the year were $85 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 50 percent of the next quarter's forecast sales, and...
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...