Help with Excel $$formulas $$for $$the $$below $$question $$please$.$

Epstein Company, a wholesale distributor of jewelry, sells to retail jewelry stores on terms of "net $120."$ Its average collection period is $150$ days. The company is considering the introduction of a $4$ percent cash discount if customers pay within $30$

days. Such a change in credit terms is expected to reduce the average collection

period to $108$ days. Epstein expects $30$ percent of its customers to take the cash

discount. Annual credit sales are $$6$ million. Epstein's variable cost ratio is $0\mathrm{.}667,$

and its required pretax return on receivables investment is $15$ percent. The company

does not expect its inventory level to change as a result of the change in credit

terms. Determine the net effect on Epstein's pretax profits.

Instruction: Please key in the relevant information in the blue cells in the Data Section. Then type

formulas in the yellow cells to determine the net effect on Epstein's pretax profits.

Direct cost of the discount

Net change in pretax profit