Question
Please show detailed calculation and explanation for calculating the numbers in the second question (second pic). Thank you!
III. (Short-term financial planning. A total of 40 points) Wesson, Inc. has a beginning cash balance of $560 on Quarter 2 of
(2), Assume instead that the net cash inflow from operations is -$150 in Q3. Assume further that the firm keeps a minimum cas
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Add a comment
Know the answer?
Add Answer to:
Please show detailed calculation and explanation for calculating the numbers in the second question (second pic)....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You have recently beenhired by Piepkorn Manufacturing to work in its newly established treasury department. Piepkorn...

    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...

    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...

    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...

    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...

    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...

    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   ...

    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   ...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT