please show in excel

Consider the following Excel project. Make sure your responses to the questions are clearly written on an Excel | document. Lastly, upload this word document to word by the due date of Friday. 11:59 P.M., August 2, 2019. Helen Bowie, the new credit manager of the Muslera Corporation, was alarmed to find that Muslera sells on credit terms of net 50 days whereas industry-wide credit tems have recently been lowered to net 30 days. On annual credit sales of $3.1 million, Muslera currently averages 60 days' sales in accounts receivable. Bowie estimates that tightening the credit terms to 30 days would reduce annual sales to $2.6 million, but accounts receivable would drop to 35 days of sales. She also expects the level of bad debts to decrease from its current level of 5 percent to 3 percent with the change in credit terms, because the loss in sales will likely include many customers who are classified as having poorer credit than those who continue to purchase from Muslera. In addition, collection costs will increase from $150,000 to $175,000 because the collection department will put more effort into collecting delinquent accounts Muslera's variable cost ratio is 70 percent, and its marginal tax rate is 40 percent. Now answer the following in this Excel project: a. If the Muslera's required rate of retum is 10.75 percent, should the change in credit terms be made? Assume all operating costs are paid when inventory is sold. b. Suppose that Bowie reevaluates her sales estimates because all other firms in the industry have recently tightened their credit policies. She now estimates that Muslera's sales would decline to only $2.8 million if she tightens the credit policy to 30 days. All of the original information will remain the same a as previously stated. Would the credit policy change be profitable under these circumstances