Explore BrainMass
Share

Explore BrainMass

    Purchase of house: evaluate two financing options

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

    You are contemplating the purchase of a house. You are offered two financing choices:

    A. Borrow $500,000 on a 30-year term at 9% p.a. with equal monthly payments in arrears, or

    B. Borrow the same amount interest-only for 10-years at 8.5% with an up-front fee of $10,000, the full amount of the principal to be repaid at the end of the term.

    Either loan can be prepaid without penalty. You only expect to stay in the house for 5 years. If your personal discount rate is 10%, which is the better deal? Ignore taxes.

    © BrainMass Inc. brainmass.com October 9, 2019, 3:29 pm ad1c9bdddf
    https://brainmass.com/business/derivatives/purchase-house-evaluate-two-financing-options-5327

    Solution Preview

    Look at the attached spreadsheet.

    I have attached amortization ...

    Solution Summary

    The Excel worksheet makes the calculations for the two possible loans, and then the narrative concludes which will be preference in the circumstances listed in the problem.

    $2.19