Another marketing strategy you decided is based on the Shipping Fee.Depending on the Invoice Subtotal will depend on how much shipping fee is charged using the Shipping Fee lookup table.

Insert a function to lookup the Invoice Subtotal and return how much shipping will be charged to the client.

Insert a function to calculate the Invoice Total

Term 12 months and interest rate is 3.5%

shipping fees: Invoice Subtotal Shipping Fee 0 $50 250 $40 500 $30 750 $20 100 $0

You decided to offer a monthly payment option for this client's invoice in case they cannot pay the entire invoice. In cell G23, insert a function to calculate the monthly payment for this invoice using the interest rate and terms listed on the invoice.

M21 X V fx A B C D F F 8 Bill To: G H 9 10 Tax Amount 15% 11 12 Phone: 13 Email: 14 15 Quantity Product# Product Name Description Unit Price Amount 16 21 11 Dunks Bits Dough to make the Bits $10.00 17 21 12 coffee Coffee powder to drink $5.00 18 21 13 suger Suger to put in drinks $3.00 Invoice Subtotal 19 Tax Amount 20 If you have any questions concerning this invoice, please contact me at the email above. Shipping Fee 21 Thank you for your business! Invoice Total 22 Monthly Payment 23 24 Invoice Template Inventory Customer List + EER Ready 26C 60924 O 9 * W Type here to search