Question

In: Finance

Bohemian Interior Design has projected the following quarterly sales. The accounts receivable at the beginning of...

  1. Bohemian Interior Design has projected the following quarterly sales. The accounts receivable at the beginning of the year is $1,030,000 and the collection period is 58 days. What are collections for the first quarter and second quarters? (5 points)

Q1

Q2

Q3

Q4

Sales

$

1,705

,000

$

1,765

,000

$

2,115

,000

$

2,135

,000

Solutions

Expert Solution

Collection Period = 58 days

Collection in Current Quarter’s Sales = (90 - Collection Period) / 90
Collection in Current Quarter’s Sales = (90 - 58) / 90
Collection in Current Quarter’s Sales = 32 / 90
Collection in Current Quarter’s Sales = 16 / 45

Collection from Previous Quarter’s Sales = 1 - Collection in Current Quarter’s Sales
Collection from Previous Quarter’s Sales = 1 - 16 / 45
Collection from Previous Quarter’s Sales = 29 / 45

Collection in 1st Quarter = Beginning Accounts Receivable + (16 / 45) * 1st Quarter’s Sales
Collection in 1st Quarter = $1,030,000 + (16 / 45) * $1,705,000
Collection in 1st Quarter = $1,030,000 + $606,222
Collection in 1st Quarter = $1,636,222

Collection in 2nd Quarter = (29 / 45) * 1st Quarter’s Sales + (16 / 45) * 2nd Quarter’s Sales
Collection in 2nd Quarter = (29 / 45) * $1,705,000 + (16 / 45) * $1,765,000
Collection in 2nd Quarter = $1,098,778 + $627,556
Collection in 2nd Quarter = $1,726,334


Related Solutions

Bohemian Interior Design has projected the following quarterly sales. The accounts receivable at the beginning of...
Bohemian Interior Design has projected the following quarterly sales. The accounts receivable at the beginning of the year is $1,030,000 and the collection period is 58 days. What are collections for the first quarter and second quarters? (5 points) Q1 Q2 Q3 Q4 Sales $ 1,705 ,000 $ 1,765 ,000 $ 2,115 ,000 $ 2,135 ,000
Westmore Products has projected the following quarterly sales. The accounts receivable at the beginning of the...
Westmore Products has projected the following quarterly sales. The accounts receivable at the beginning of the year is $420 and the collection period is 45 days. What are collections for the first quarter? Q1 Q2 Q3 Q4 Sales $ 695 $ 750 $ 835 $ 1,120 Please solve carefully
The following information relates to a company’s accounts receivable: accounts receivable balance at the beginning of...
The following information relates to a company’s accounts receivable: accounts receivable balance at the beginning of the year, $410,000; allowance for uncollectible accounts at the beginning of the year, $30,000 (credit balance); credit sales during the year, $1,500,000; accounts receivable written off during the year, $21,000; cash collections from customers, $1,400,000. Assuming the company estimates that future bad debts will equal 8% of the year-end balance in accounts receivable. 1. Calculate the year-end balance in the allowance for uncollectible accounts....
The Jallouk Company has projected the following quarterly sales amounts for the coming year:     Q1...
The Jallouk Company has projected the following quarterly sales amounts for the coming year:     Q1 Q2 Q3 Q4 Sales $450 $510 $570 $720    a. Accounts receivable at the beginning of the year are $240. 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 $...
The Jallouk Company has projected the following quarterly sales amounts for the coming year:     Q1...
The Jallouk Company has projected the following quarterly sales amounts for the coming year:     Q1 Q2 Q3 Q4 Sales $450 $510 $570 $720    a. Accounts receivable at the beginning of the year are $240. 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 $...
The following information relates to a company's accounts receivable: gross accounts receivable balance at the beginning...
The following information relates to a company's accounts receivable: gross accounts receivable balance at the beginning of the year, $420,000; allowance for uncollectible accounts at the beginning of the year, $31,000 (credit balance); credit sales during the year, $1,550,000; accounts receivable written off during the year, $22,000; cash collections from customers, $1,600,000. Assuming the company estimates bad debts at an amount equal to 2% of credit sales. 1. Calculate bad debt expense for the year. 2. Calculate the year-end balance in the...
The following information relates to a company’s accounts receivable: gross accounts receivable balance at the beginning...
The following information relates to a company’s accounts receivable: gross accounts receivable balance at the beginning of the year, $300,000; allowance for uncollectible accounts at the beginning of the year, $25,000 (credit balance); credit sales during the year, $1,500,000; accounts receivable written off during the year, $16,000; cash collections from customers, $1,450,000. Assuming the company estimates that future bad debts will equal 10% of the year-end balance in accounts receivable. 1. Calculate bad debt expense for the year. ( Please...
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year:...
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year:   Q1   Q2   Q3   Q4   Sales $ 750 $ 780 $ 860 $ 940 a. Accounts receivable at the beginning of the year are $340. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places, e.g., 32.16.): Q1 Q2...
The Litzenberger Company has projected the following quarterly sales amounts for the coming year: Q1 Q2...
The Litzenberger Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $ 790 $ 820 $ 900 $ 980 a. Accounts receivable at the beginning of the year are $380. 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 2 decimal places, e.g., 32.16. A negative answer should be indicated by...
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year:...
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year:   Q1   Q2   Q3   Q4   Sales $ 710 $ 740 $ 820 $ 900 a. Accounts receivable at the beginning of the year are $290. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places, e.g., 32.16.): Q1 Q2...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT