Explore BrainMass
Share

Explore BrainMass

    Compounding Interest on a Mortgage

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Question: I just bought a house and have a mortgage of $150,000. The mortgage is for 30 years and has a nominal rate of 8% (compounded monthly). After 36 payments (3 years) what will be the remaining balance of the mortgage?

    © BrainMass Inc. brainmass.com October 9, 2019, 8:51 pm ad1c9bdddf
    https://brainmass.com/business/interest-rates/compounding-interest-mortgage-165007

    Solution Preview

    From your Question:

    N = 30 years x 12 = 360

    r = 0.08/12 = 0.006667

    PV = -150,000

    Since the ...

    Solution Summary

    Using the PV of annuity formula, this solution provides a detailed response to the given problem including the full amortization table. The full solution has been completed in an attached Word document and the amortization table is presented in an Excel document.

    $2.19