Help please with what the excel formulas be for the below question?

The North Carolina Furniture Company $($NCFC$)$ manufactures upholstered furni$-$

ture, which it sells to various small retailers in the Northeast and Midwest on credit

terms of $"\frac{2}{10},$ net $60."$ The company currently does not grant credit to retailers

with a $3($fair$)$ or $4($limited$)$ Dun & Bradstreet Composite Credit Appraisal. If

NCFC were to extend credit to retailers in the "fair" category, an estimated addi$-$

tional $$1\mathrm{.}2$ million per year in sales could be generated. The estimated average col$-$

lection period for these customers is $90$ days, and the expected bad$-$debt loss ratio is

$6$ percent. Approximately $20$ percent of these customers are expected to take the

cash discount. NCFC$\text{'}$s variable cost ratio is $0\mathrm{.}70,$ and its required pretax rate of

return on current assets investments is $20$ percent. The company also estimates that

an additional investment in inventory of $$350,000$ is necessary for the anticipated

sales increase. Determine the net change in NCFC$\text{'}$s pretax profits from extending

credit to retailers in the "fair" category.

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

formulas in the yellowcells to determine the net change in NCFC$\text{'}$s pretax profits.

Additional bad$-$debt loss

Cost of additional cash discount

Net change in pretax profit

the north carl