Here is a more advanced real estate investment amortization table with interest-only capability, multiple interest calculation methods (360/30, 365/Actual, 360/Actual), monthly and annual periods, duration calculation, lender yield calculation,  average life calculation. This model is a complement to the more basic amortization table tutorial I posted a few months back.

There are undoubtedly ways to improve this model, so please don’t hesitate to reach out to either Spencer or Mike with questions or comments you may have.

Advanced Amortization Table

This standalone amortization table includes three interest rate calculation methods, monthly and annual periods, duration calculation, average life calculation, lender yield calculation, interest-only module, and more.

Download other Excel real estate financial models.