In excel sheet and formula. Help please. Thank you. Cement Company anticipates the following fourth-quarter sales for
Fantastic news! We've Found the answer you've been seeking!
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). 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?
Posted Date: