Question: In excel sheet and formula. Help please. Thank you. Cement Company anticipates the following fourth-quarter sales for 2021: $1,800,000 (October), $1,600,000 (November), and $2,100,000 (December).

In excel sheet and formula. Help please. Thank you.

Cement Company anticipates the following fourth-quarter sales for 2021: $1,800,000 (October), $1,600,000 (November), and $2,100,000 (December). It posted the following sales figures for the third quarter of 2021: $1,900,000 (July), $2,050,000 (August), and $2,200,000 (September). Sales is anticipated to decrease by 10% in the first quarter of 2022.

The company sells 90% of its products on credit, and 10% are cash sales. The credit sales are collected as follows: 60% in the following month, 20% two months later, 19% three months later, with 1% defaults. What are the anticipated cash inflows for the last quarter of 2021?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!