Question
Wonderland Company estimates sales (in $) for 2021 for the four quarters as follows : Q1 Q2 Q3 Q4 Sales $ 200 $ 300 $
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 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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started