Question
Complete the cash budget for February 2020 for BWS Corp. per the table below. Receivable and payable are all due on the second month: Company:
Complete the cash budget for February 2020 for BWS Corp. per the table below. Receivable and payable are all due on the second month: Company: BWS Corp. Sales and inventory schedule (forecast) 2020 forecast Dec. 2019 January February Sales $31,000 $30,000 $32,000 cash sales 60% $18,000 _______ receivables 40% $12,000 $12,000 _______ Cash Budget Beginning cash $40,000 _______ This month cash sales $18,000 _______ cash receipts from prior month $12,000 _______ Total cash in-flow $30,000 _______ Inventory (COGS at 40%) $12,400 $12,000 _______ cash 50% 6, 200 $6,000 _______ payables 50% $6,200 $6,000 _______ Total cash Inventory payment $12,200 _______ Total cash operating expenses $14,000 $14,000 Total cash outflow $26,200 _______ Net cash flow $3,800 _______ Ending cash $40,000 $43,800 _______
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