Purchase Solution

PrimeTime Sportswear: Prepare a cash budget

Not what you're looking for?

Ask Custom Question

See attached file for the tables.

PrimeTime Sportswear is a custom imprinter that began operations six months ago. Sales have exceeded management's most optimistic projections. Sales are made on account and collected as follows: 50% in the month after the sale is made and 45% in the second month after sale. Merchandise purchases and operating expenses are paid as follows:

In the month during which the merchandise
is purchased or the cost is incurred 78%
In the subsequent month 22%
________________________________________

PrimeTime Sportswear's income statement budget for each of the next four months, newly revised to reflect the success of the firm, follows:

Cash on hand June 30 is estimated to be $39,620. Collections of June 30 accounts receivable were estimated to be $20,420 in July and $15,280 in August. Payments of June 30 accounts payable and accrued expenses in July were estimated to be $23,820.

(a) Prepare a cash budget for August and September. (Enter all amounts as positive value except for Beginning Ending cash which has to be indicated with a minus sign if it is negative amount. Leave no cells blank - be certain to enter "0" wherever required.)

Purchase this Solution

Solution Summary

The expert prepares a cash budget for PrimeTime Sportswear.

Solution Preview

See attached file for formulas.

answer
july august sep oct
sales 42400 54200 67600 59100
first month 20420 21200 27100 33800
second month 15280 19080 24390 30420
total cash ...

Purchase this Solution


Free BrainMass Quizzes
Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking