Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 253,212 264,430 283,538 Credit

Consider the following third-quarter budget data for TAP & Brothers:

TAP & Brothers Third-Quarter Budget Data

July August September

Credit Sales 253,212 264,430 283,538

Credit Purchases 97,638 117,432 136,343

Wages, Taxes, Expenses 26,594 31,260 33,326

Interest 7,361 7,516 7,949

Equipment Purchases 54,673 61,725 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,573, and credit purchases were $102,502
  • July's beginning cash is $184,769

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Basic Finance An Introduction to Financial Institutions Investments and Management

Authors: Herbert B. Mayo

10th edition

1111820635, 978-1111820633

More Books

Students also viewed these Finance questions

Question

What is a qualitative variable?

Answered: 1 week ago

Question

What is stepwise regression?

Answered: 1 week ago

Question

What is an odds ratio?

Answered: 1 week ago