Calculate cash collections in each of the four quarters

Assignment Help Financial Management

Reference no: EM131972172

The MacFarlane Company has projected the following quarterly sales amounts for the coming year:

	Q1	Q2	Q3	Q4
Sales	$8,280	$10,050	$9,450	$7,950

a. Accounts receivable at the beginning of the year are $4,050. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.)

	Q1	Q2	Q3	Q4
Beginning receivables	$	$	$	$
Sales	8,280	10,050	9,450	7,950
Cash collections
Ending receivables	$	$	$	$

b. Accounts receivable at the beginning of the year are $4,050. The company has a 60-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.)

	Q1	Q2	Q3	Q4
Beginning receivables	$	$	$	$
Sales	8,280	10,050	9,450	7,950
Cash collections
Ending receivables	$	$	$	$

c. Accounts receivable at the beginning of the year are $4,050. The company has a 30-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.)

	Q1	Q2	Q3	Q4
Beginning receivables	$	$	$	$
Sales	8,280	10,050	9,450	7,950
Cash collections
Ending receivables

Reference no: EM131972172

Questions Cloud

Mean and the standard deviation for situation : a) What is the mean µ and the standard deviation for this situation? Show your computations.

Discuss the owned in a tax-advantaged plan : Explain the difference between "directly-owned" and "owned in a tax-advantaged plan" investments. Discuss a strategy for using both types of ownership.

What should x be for the expected payoff to be zero : Suppose you spend $1 to mark two spots (numbers). If the house hits both of your numbers, you win X dollar(s). Otherwise, you lose that $1.

Organization assignment and progress report : Project Code: XXSE 60108 Career path on organization assignment and progress report with literature review

Calculate cash collections in each of the four quarters : The company has a 60-day collection period. Calculate cash collections in each of the four quarters by completing the following.

Sample proportion of those who prefer chocolate : If a sample of 100 Americans is taken, what is the probability that the sample proportion of those who prefer chocolate is greater than 0.30?

Place the output on the same sheet as the data : Write hypothesis steps. Use Excel 1-way ANOVA test to find the test value and p-value. Place the output on the same sheet as the data.

What pretax amounts did s and l earnings : What pretax amounts did S&L include in its 2016 and 2017 earnings as a result of this investment?

Calculate the frequency one would expect : Calculate the frequency one would expect when surveying 400 people. Fill in the table below, rounding to two decimal places.

User Account

All Pages