EXCEL EXERCISE #3: Mortgage Worksheet MORTGAGE …

days’ worth of interest for the current month and places that amount in the Interest due field on the loan record. This once-a-month calculation is the industry-standard approach for mortgage servicing, to give adequate time for the current month’s payment to be made (therefore interest due would be zero) before calculating the interest ................
................