More Journalizing Assignment

In this assignment, you will determine and record various calculations with respect to discounted sales figures, and you will analyze source documents and record various entries in three different sales journals. Then, you will consider HST calculations within all journal entries.

Part A: Calculating Discounts

In the spreadsheet file provided, complete the table shown below on the first tab named Part A$.$ Excel Tables Help

Notes: Discounts apply to the subtotal only, and the HST is still calculated on the regular price. The HST in New Brunswick is $15\%.$

Finish the calculations using formulas for the example provided to be sure you are following the correct procedure. Review 'Terms of Sale' content material. Spreadsheet Formulas Help

$\backslash$table$[[\backslash$table$[[$Invoice$],[$Subtotal$]],\backslash$table$[[$HST$],[(15\%)$