In: Finance
Masco Company. expects sales of $5,400, $6,100, $5,900, and $6,400 for the months of March through June, respectively. The company collects 50 percent of sales in the month of sale, 25 percent in the month following the month of sale, and 20 percent in the second month following the month of sale. The remaining 5 percent of sales is never collected. How much money does the company expect to collect in the month of June?
$4,975.00
$6,250.00
$5,300.00
$6,725.00
$5,895.00
Solution :
The amount of money the company expects to collect in the month of June = $ 5,895
The solution is Option 5 = $ 5,895.00
Please find the attached screenshot of the excel sheet containing the detailed calculation for the solution.