Investment Analysis: Seller Financing Amortization / Tax Basis Calculator

Description
Latest update: Added two loan types (interest only and a term loan)

Seller financing involves: Purchasing something as an investment > selling it to a buyer > buyer repays with a down payment and then installments over time.

The template will calculate the final IRR of the investor based on their cash flows over time.

The user can enter in assumptions for the initial cost, sell price, down payment, and amortization terms (interest rate, payments per year, and term of amortization). An amortization will then populate the principal and interest repaid per period.

All the repayments are separated between taxable and return of basis. An annual summary displays the sub-totals of each component of the repayment as well as interest (all interest is going to be taxed as regular income).

Note, the down payment is also separated between how much is counted as 'return of basis' vs. taxable capital gain.

All logic is contained on a single tab and this makes it easy to expand the model to many transactions by simply duplicating the tab as many times as you need. The annual summary has its own start year and the amortization schedule has its own start month. 

In this way, it is easy to aggregate all the transactions on the same annual timeline in order to see relevant total interest, principal, and taxable gains that happen each year.

This will often be used for investing and reselling real estate or automobiles.

This template is also included in two bundles:
- All Models Bundle: https://www.eloquens.com/tool/P8Y4TX4v/finance/financial-forecasting-models/financial-models-120-useful-and-usable-logic
- Real Estate: https://www.eloquens.com/tool/vJdYH9R7/finance/real-estate/the-complete-real-estate-bundle