Bill Norman comes to you for advice he has just purchased a large amount of inventory with the terms $210,$ N$/30.$ The amount of invoice is $310,000.$ He is currently short of cash but has decent credit. He can borrow the money needed to settle the account payable at an interest rate of $7\%.$ Bill is sure he will have the necessary cash by the due date of the invoice but not by the last day of the discount. Answer Question A by giving the excel equation for the answer using the information bellow.

discount rate $2\%$

End of Discount period $10$ days

Due date of the invoice $30$ days

Invoice Amount $$310,000$

Annuak Interest Rate $7\%$