Wonderland Company estimates sales (in $) for 2021 for 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?
Wonderland Company estimates sales (in $) for 2021 for 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
b. Calculate the Net Cash Inflow and cumulative financing for 2021. Is the cumulative financing a surplus or a deficit?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
