The basic mathematical operators are +, -, * and/ Addition: To add the values in cells A1 and B4, the formula is =A1+B4 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1-B4 Multiplication: To multiply the values in cells A1 and B4, the formula is =A1*B4 Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 Using the PMT function: The PMT function has the following syntax: --PMT(Rate,Nper, Pv, Fv, Type) Note: To return the payment as a positive value, you must include a negative sign, either before the PMT or as a negative PV amount. Prepare the amortization schedule for the loan. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cell address(es). Entering a value will be marked as incorrect. 5 Loan amount $150,000 Term (years) Annual interest % 10% Payments per year 1) What is the amount of each semiannual loan payment? The PMT function must be used, and formula must return a positive value. 2) Complete the amortization schedule for this note. All formulas must return a positive value. Semiannual Interest Period Beginning Balance Debit Interest Expense Debit Notes Payable Credit Cash Ending Balance