Purchase Solution

Calculating Cash Collection and Payments

Not what you're looking for?

Ask Custom Question

26-5: Using Excel: The Litzenberger Company has projected the following quarterly sales amounts for the coming year:
Q1 Q2 Q3 Q4
Sales $700 $630 $810 $930

a. Accounts receivable at the beginning of the year are $275. Litzenberger has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following:
Q1 Q2 Q3 Q4
Beginning receivables
Sales
Cash collections
Ending receivables

b. Rework (a) assuming a collection period of 60 days.
c. Rework (a) assuming a collection period of 30 days.
________________________________________

26-8:Using Excel: The Thakor Corporation's purchases from suppliers in a quarter are equal to 75% of the next quarter's forecast sales. The payables period is 60 days. Wages, taxes, and other expenses are 20% of sales, and interest and dividends are $73 per quarter. No capital expenditures are planned.
Here are the projected quarterly sales:
Q1 Q2 Q3 Q4
Sales $830 $1,050 $970 $860

Sales for the first quarter of the following year are projected at $970. Calculate the company's cash outlays by completing the following:

Q1 Q2 Q3 Q4
Payment of accounts
Wages, taxes and other expenses
Long-term financing expenses(interest and dividends)
Total

Purchase this Solution

Solution Summary

This solution is comprised of a detailed explanation to calculate cash collections in each of the four quarters.

Solution Preview

Please see the attached file.

Calculating Cash Collection and Payments

26-5: Using Excel: The Litzenberger Company has projected the following quarterly sales amounts for the coming year:
Q1 Q2 Q3 Q4
Sales $700 $630 $810 $930

a. Accounts receivable at the beginning of the year are $275. Litzenberger has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following:
Q1 Q2 Q3 Q4
Beginning receivables
Sales
Cash collections
Ending receivables

b. Rework (a) assuming a collection period of 60 days.
c. Rework (a) assuming ...

Purchase this Solution


Free BrainMass Quizzes
Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Lean your Process

This quiz will help you understand the basic concepts of Lean.