Question
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 257,196 266,730 281,051 Credit
Consider the following third-quarter budget data for TAP & Brothers:
TAP & Brothers Third-Quarter Budget Data | |||
| July | August | September |
Credit Sales | 257,196 | 266,730 | 281,051 |
Credit Purchases | 97,670 | 117,507 | 135,447 |
Wages, Taxes, and Expenses | 26,578 | 31,582 | 33,100 |
Interest | 7,360 | 7,531 | 8,084 |
Equipment Purchases | 54,856 | 61,235 | 0 |
The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the following month. Credit purchases will be paid in the month following the purchase.
-In June, credit sales were $138,127, and credit purchases were $102,663
-Julys beginning cash is $184,624
If TAP maintains a policy of always keeping a minimum cash balance of $75,000 as a buffer against uncertainty and forecasting errors, what is the cash surplus/deficit at the end of the quarter (i.e., end of September)? (Answer surplus as a positive number or deficit as a negative number. Round answer to 0 decimal places. Do not round intermediate calculations)
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