Melissa has owned a rental property for 30 years and she loves the cash flow, but is tired of the management.  She is looking to sell her property.

Melissa prefers to have a steady stream of income for the rest of her life rather than a lump sum of cash in the bank earning little interest.  So, she decides that she is going to sell her property and "carry back" a mortgage, which will allow her to receive a steady stream of income for the rest of her life from the new buyer without Melissa having to deal with the hassle of management.

Melissa sells her rental property for $600,000, she takes $50,000 down and carries the remaining $550,000 at 4% interest.  Melissa does not want to outlive her money as she wants to be sure that she get the monthly payments of $2,500 for the rest of her life.  Assume that the loan is fully amortized, so it will pay off in the end.  For how many months can Melissa receive $2,500/month?

Answer:

(These are the key strokes to enter into your financial calculator)

N = ?? (this is what we are solving)

I = 4 (this is her desired interest rate)

PV = ($550,000) (this is the amount of the mortgage that Melissa is "carrying back."  Note that it is entered into the calculator as a negative)

PMT = $2,500 (this the desired monthly cash flow that Melissa would like.  This number is entered into the calculator as a positive)

PV = 0 (the note is fully amortized)

N = 397.19 (Melissa will receive monthly payments of $2,500 for 397.19 months, or 397 full months and then a partial payment on the final 398th month)


My Dog Piglet Wants to Know If You Want to Receive Valuable Tips, Strategies and Insights for Calculating Your Financial Freedom?

Get Your Guide!