Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Waterway, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Waterway desires to maintain a $15,000 minimum
Waterway, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Waterway desires to maintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $1,000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)
October | November | December | Quarter | ||||
Beginning cash balance | $ | $15,480 | $ | $16,260 | |||
Collections from sales | 56,010 | 242,980 | |||||
Total cash available | 72,270 | 98,480 | 125,080 | ||||
Less disbursements | |||||||
Materials purchases | 9,440 | 13,770 | 34,860 | ||||
Direct labor | 5,150 | 6,030 | 7,620 | 18,800 | |||
Manufacturing overhead | 20,090 | 23,140 | 21,770 | ||||
Selling & administrative expenses | 28,900 | 29,670 | |||||
Equipment purchase | 15,380 | ||||||
Dividends | 5,210 | 5,210 | |||||
Total disbursements | 65,790 | ||||||
Excess (deficiency) of cash | 30,200 | ||||||
Minimum cash balance | 15,000 | 15,000 | 15,000 | ||||
Cash available (needed) | -8,520 | 15,710 | |||||
Financing: | |||||||
Borrowings | 9,000 | ||||||
Repayments | -9,000 | ||||||
Interest | -90 | -90 | |||||
Total financing | -9,090 | -90 | |||||
Ending cash balance | $15,480 | $21,110 | $ | $ |
Click if you would like to Show Work for this question: | Open Show Work |
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