Explore BrainMass

Explore BrainMass

    Annuity

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

    You borrow $250,000 to buy a house; if the annual interest rate is 22.5% and the term of the loan is twenty years, what is the annual payment required to retire the mortgage loan?

    Please provide response in Excel.

    © BrainMass Inc. brainmass.com June 3, 2020, 6:19 pm ad1c9bdddf
    https://brainmass.com/business/annuity/annuity-55739

    Solution Preview

    We need to calculate PVIFA
    PVIFA= Present Value Interest Factor for an Annuity
    It can be read ...

    Solution Summary

    The annuity (annual payment) required to retire the mortgage loan is calculated.

    $2.19

    ADVERTISEMENT