The president of Vacuity, Inc, has just approached the company\'s bank seeking s

Question

The president of Vacuity, Inc, has just approached the company's bank seeking short-term financing for the coming year, Year 2. Vacuity is a distributor of commercial vacuum cleaners. The bank has stated that the loan request must be accompanied by a detailed cash budget that shows the quarters in which financing will be needed, as well as the amounts that will be needed and the quarters in which repayments can be made To provide this information for the bank, the president has directed that the following data be gathered from which a cash budget can be prepared: a. Budgeted sales and merchandise purchases for Year 2, as well as actual sales and purchases for the last quarter of Year 1, are as follows Merchandise SalesPurchases Year 1 250,000$150,000 Fourth quarter actual First quarter estimated Third quarter estimated Year 2 $350,000$230,000 Second quarter estimated $450 000 $280 000 S550,000$340 000 Fourth quarter estimated$430 000 $210.000

Explanation / Answer

1.a. Vacuity Inc.

Schedule of Expected Cash Collections:

1b. Schedule of Expected Disbursements for Merchandise Purchases:

2. Cash Disbursements for Selling and Administrative Expenses:

First Quarter Second Quarter Third Quarter Fourth Quarter Total Collection of Sales of $ $ $ $ $ Last Quarter, Year 1 125,000 0 0 0 125,000 First Quarter, Year 2 168,000 175,000 0 0 343,000 Second Quarter, Year 2 216,000 225,000 0 441,000 Third Quarter, Year 2 264,000 275,000 539,000 Fourth Quarter, Year 2 206,400 206,400 Total Cash Collections $ 293,000 $ 391,000 $ 489,000 $ 481,400 $ 1,654,400

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.