Originally posted by Johnny P.:
great job! But i have to say these number are confusing me?!?!?!?
If these numbers confuse you I would recommend reading Lonnie Scruggs Deals on Wheels books. He goes over them in more detail. I'll try to explain.
N = Number of Payments
I = Interest Rate
PMT = Monthly Payment
FV = Future Value / Loan Amount / How much you have invested in the deal
What you try to solve for is the bottom I amount. This is your rate of return.
To be honest I probably didn't do this calculation 100% correct it was just a quick calculation but it probably wouldn't change the rate of return to much.
The first thing I tried to do is calculate my average payments I'll receive over the life of the 3 years. To get FV for the top row I added up how much I am owner financing on these MH so take the total sale price minus how much you collect in down payments and you will get 48400.
N I PMT FV
36 13.5 48400
You will need to run a loan amortization to get the payments. Plug in the values and you will get 1642.47.
N I PMT FV
36 13.5 1642.47 48400
Now you can solve the bottom Row of values. Drop in what you already know.
N I PMT FV
36 1642.47
To get the FV for the bottom row you need to know how much you currently have invested in the deal. Take your purchase price plus repairs (13,500 minus the down payments (3600) you collected. This will end up being 9900
N I PMT FV
36 1642.47 9900
Solve for I using a financial calculator / loan amortization and you will get back 198.28%
Hope this helps.
Dustin