Calculation guide
Advance and financed fee are credited at inception; monthly draws and charges are added at each month end after interest. Constant nominal rate. Equity may be negative; recourse protections are not modeled.
B₀ = initial + financed fee; Bₘ = Bₘ₋₁ × (1 + APR/1200) + monthly draw + monthly fee.
Inputs
Initial advance
Example entry 40000 (in the selected currency).
Financed upfront fee
Example entry 2000 (in the selected currency).
Monthly cash draw
Example entry 500 (in the selected currency).
Monthly financed charge
Example entry 20 (in the selected currency).
Nominal annual interest rate
Example entry 6 %. Allowed range 0 to 100.
Months remaining
Example entry 60. Allowed range 1 to 600. Use whole numbers.
Sale price
Example entry 200000 (in the selected currency).
Sale costs
Example entry 10000 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Initial advance | 40,000 |
| Financed upfront fee | 2,000 |
| Monthly cash draw | 500 |
| Monthly financed charge | 20 |
| Nominal annual interest rate | 6% |
| Months remaining | 60 |
| Sale price | 200,000 |
| Sale costs | 10,000 |
| Result | Value |
|---|---|
| Loan balance at sale | 92,932.122272 |
| Total accrued interest | 19,732.122272 |
| Equity before any nonrecourse adjustment | 97,067.877728 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Initial advance | 40,000 | 44,000 | Loan balance at sale | 92,932.122272 | 98,327.522882 |
| Financed upfront fee | 2,000 | 2,200 | Loan balance at sale | 92,932.122272 | 93,201.892303 |
| Monthly cash draw | 500 | 550 | Loan balance at sale | 92,932.122272 | 96,420.623798 |
| Monthly financed charge | 20 | 22 | Loan balance at sale | 92,932.122272 | 93,071.662333 |
| Nominal annual interest rate | 6% | 7% | Loan balance at sale | 92,932.122272 | 96,768.569761 |
| Months remaining | 60 | 66 | Loan balance at sale | 92,932.122272 | 98,914.429666 |
| Sale price | 200,000 | 220,000 | Equity before any nonrecourse adjustment | 97,067.877728 | 117,067.877728 |
| Sale costs | 10,000 | 11,000 | Equity before any nonrecourse adjustment | 97,067.877728 | 96,067.877728 |
