ANSWER
Step 1:
Ending cash balance of quarter 2 is 246. Firm kept a cash balance of 200 and invested 46 in short term investments. Hence, beginning short term investment is 46.
Step 2:
Income on short term investment is 1%. Hence, income on short term investment would be
1% * 46 = .46
Step 3:
Cash balance at the end of quarter 3= Beginning cash balance + Net cash inflow + Income from short term investment + cash realised from sale of short term investment
= 200 + (-150) + .46 + 46(given)
= 96.46
Firm is required to keep minimum cash balance of 200 whereas current cash balance is just 96.46.
Therefore,
New short term borrowing in quarter 3 is = 200 - 96.46
= 103.54
Please show detailed calculation and explanation for calculating the numbers in the second question (second pic)....
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...
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...
15. Calculating the Cash Budget (L03) Cottonwood Inc. has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 03 04 $160 $175 $190 $215 Click here for a description of Table: Questions and Problems 15. 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 $68 million. Cottonwood has a 45 day collection period Cottonwood's purchases from suppliers in a quarter...
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...
Wildcat, Inc., has estimated sales (in
millions) for the next four quarters as follows:
Sales for the first quarter of the following year are projected
at $145 million. Accounts receivable at the beginning of the year
were $57 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 suppliers are
normally paid in 36 days. Wages, taxes, and other expenses run
about 20 percent...
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: Sales Q1 $125 Q2 $145 Q3 $165 Q4 $195 Sales for the first quarter of the year after this one are projected at $140 million. Accounts receivable at the beginning of the year were $55 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 are normally paid in...
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...