Question

Help with Finance management homework

Wonderland Company estimates sales (in $) for 2021 during the  four quarters as follows :

 


Q1

Q2

Q3

Q4

Sales

 $ 200

$ 300

$ 250

$ 400

 

The accounts receivable at the beginning of 2021 is $ 120. The account receivable collection period is 45 days. Purchases from suppliers by Wonderland Company for each quarter are 60% of the estimated sales for the next quarter. Sales for Q1 2022 are $ 350. Payments to suppliers are the same as purchases from the previous period (quarter). Each month is assumed to have 30 days. Salaries, taxes and other expenses are estimated at 20% of sales. Interest and dividend expenses are $ 20 each quarter. Capital expenditure for business expansion in 2021 is planned for the second quarter for $ 100.  The management of Wonderland Company has a policy to maintain a minimum cash balance (minimum cash balance) of $ 10 each quarter, and in early 2021 there is no cash balance.

Question:

a. Calculate the cash inflow and cash outflow projections of Wonderland Company

b. Calculate the Net Cash Inflow and cumulative financing for 2021. Is the cumulative financing a surplus or a deficit?


0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Help with Finance management homework
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • The Thunder Dan's Corporation's purchases from suppliers in a quarter are equal to 65 percent of the next quarter's forecasted sales. The payables period is 60 days. Beginning accounts pay...

    The Thunder Dan's Corporation's purchases from suppliers in a quarter are equal to 65 percent of the next quarter's forecasted sales. The payables period is 60 days. Beginning accounts payables is $200. Wages, taxes, and other expenses are 16 percent of sales, and interest and dividends are $60 per quarter. No capital expenditures are planned. Sales for the first quarter of the following year are projected at $720. The receivables period is 45 days. Beginning accounts receivables is $150. Initial...

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

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

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

  • Intro It is the beginning of January. Actual sales for the previous quarter (Q4) and estimated...

    Intro It is the beginning of January. Actual sales for the previous quarter (Q4) and estimated sales for the next five quarters are as follows (in $ million): Quarter Q4 Q1 Q2 Q3 Q4 Q1 Sales 24 25.2 26.46 27.78 29.17 30.63 You collect 50% of sales in the current quarter and the remainder in the following quarter. You expect to spend 40% of the following quarter's sales on purchases of components from suppliers, and to pay 70% of those...

  • Intro It is the beginning of January. Actual sales for the previous quarter (Q4) and estimated...

    Intro It is the beginning of January. Actual sales for the previous quarter (Q4) and estimated sales for the next five quarters are as follows (in $ million): Quarter Q4 Q1 Q2 Q3 Q4 Q1 Sales 24 25.2 26.46 27.78 29.17 30.63 You collect 50% of sales in the current quarter and the remainder in the following quarter. You expect to spend 40% of the following quarter's sales on purchases of components from suppliers, and to pay 70% of those...

  • 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 $120 Q2 Q3 Q4 $140 $160 $190 Sales for the first quarter of the year after this one are projected at $135 million. Accounts receivable at the beginning of the year were $53 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 40 percent of the next quarter's forecast sales, and suppliers are normally paid in...

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

  • Short term investments sold is not 57.98 I am stuck on that one Wildcat, Inc., has...

    Short term investments sold is not 57.98 I am stuck on that one Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Sales Q1 $120 Q2 $140 Q3 $160 Q4 $190 Sales for the first quarter of the year after this one are projected at $135 million. Accounts receivable at the beginning of the year were $53 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 40...

  • 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