Excel Online Structured Activity: Tightening Credit Terms

$15\%.$

The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions above.

Open spreadsheet

Assuming a $365-$day year, calculate the net income under the current policy and the new policy. Do not round intermediate calculations. Round your answers to the nearest dollar.

Current policy: $

New policy: $

Should the change in credit terms be made?