Calculating Cash Collection and Payments
Not what you're looking for?
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.