Installment sale or intra-family loan (Incl. IDGTs, SLATs)
Last updated: September 25, 2025
You can model hypothetical installment sales & intrafamily loans within the Estate Waterfall. This guide outlines how to get started modeling this wealth transfer strategy.
Step-by-step guide
Getting started
In a hypothetical waterfall, click on the Transfers button and click Add a new hypothetical transfer
You will be prompted to select which strategy you want to model. Click on either Installment sale or Intra-family loan
From a modeling standpoint, there is no difference in the inputs or outputs, but we have provided these as separate entry points as these are two different kind of transactions involving either a note or receivable.
Note, if modeling sale or loan, it is very common to model a seed gift to the recipient entity. In order to do so, model a Gift/transfer to the same recipient entity as the sale / loan transaction.
Enter Sale/loan details
On the left side panel, enter the following information:
Seller: select an existing entity or individual with assets
Recipient: select an existing entity or individual or you can create a new draft entity
Start date: this defaults to the current date, but can be in the future as well
Term years: enter a min of 1 and max of 30 years.
AFR: to reference the current AFR, there is a link provided to the published rates on the IRS website
Specify assumptions if the 1st grantor dies prior to term end of the sale/loan:
Sale is repaid at time of death: Upon death, assets are deducted from the receiving entity by the amount of the remaining note balance.
Sale is canceled: Assumes the remaining note balance is includable in the grantor’s taxable estate, and no additional assets are deducted from the receiving entity. The remaining balance reduces the grantor’s remaining lifetime exemption and taxes are assessed accordingly.
Please note that the cancel option does not represent a Self-Cancelling Installment Note (SCIN). Luminary does not currently calculate SCIN note payments at this time.
Assets
Enter the funding amount of the sale/loan.
This can be entered either as a specific $ or % amount, or you can select specific asset categories to fund the sale/loan with.
Adjust the ‘Assume growth rate applied to recipient toggle’ as necessary
If enabled, custom growth rates applied to the recipient will supersede those applied to the source for modeling growth.
For example, if the recipient entity has a growth rate of 10% and the source entity has a growth rate of 3%, we will assume the assets in the sale/loan will grow at a rate of 10%.
Payment
Enter the payment structure of the sale or loan:
Interest only with balloon: assumes interest only payments until the final year of the sale/loan in which the note principal will be due
Fully amortizing: interest and principal payments will be paid back over the duration of the sale/loam term
Single lump sum payment at term end: no payments will be made until the final year in which principal + compounded interest payments will be due
Growth rate and death order
In the top right corner, you will see the assumed growth profile and death years used for the simulation. Clicking on the button allows you to modify this.
After you are done with the sale/loan set up, click Create installment sale (or Create intra-family loan). You will then be redirected to the diagram view of the estate waterfall with the hypothetical strategy displayed.
FAQs
What is the difference between the Installment sale and Intra-family loan feature?
The inputs are inherently the same with the exception of the nomenclature that is used in each (“sale” for installment sale and “loan” for intra-family loan)
Can I model an installment sale or intra-family loan to a hypothetical/draft entity?
Yes, in sale/loan set up you have the option to create a draft entity as the recipient of the sale/loan
How are the values in the “Projected growth” table calculated?
‘Assets at year start’ are based on current assets in the recipient entity, and the resulting ‘Assets at year end’ are based on the sale/loan funding amount, growth on those assets, and any interest or principal paid during the year.
What assumptions are being made if one of the grantors dies during the term of the loan?
You have the ability to select between two options. We currently assume upon first death, the sale/loan is either:
Fully repaid at death and there are no tax consequences to the grantor
Canceled and the remaining balance of the sale or loan is considered to be includable in the grantor’s taxable estate
Why are the Payment schedule and Projected growth tables displaying $0 values before the term end of the sale/loan?
This likely is because you either need to adjust the death year or growth rate assumptions for the strategy
Can I apply a valuation discount on an installment sale or intra-family loan?
Yes, on the funding amount tab, there is an option to include a valuation discount %. The note payments will subsequently be calculated off of the discounted value of the sale or loan. See this page for more details: Apply Valuation Discounts to Entities