Wonderland Company estimates sales (in $) for 2021 during the four quarters as follows :
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.
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?