Excel-Skills.com

100% UNIQUE EXCEL TEMPLATES

TEMPLATE CATEGORIES / ASSETS, LOANS & VALUATIONS / LOAN CALCULATION & ANALYSIS

36 Loan Calculation & Analysis Template

Use this loan calculator template to compile a loan account statement based on the same methodology as used by most financial institutions. Monthly loan repayments, daily interest calculations and capitalization of interest on the last day of each calendar month. Designed specifically for loans which are subject to variable interest rates (like home loans). Includes a loan repayment forecast for remaining loan period.

  • Suitable for loans subject to monthly repayment & daily interest
  • Automated loan account statement based on limited user input
  • Automated calculation of interest & monthly interest capitalization
  • Multiple ad hoc loan repayments & interest rate changes
  • Automated monthly loan account summary
  • Loan forecasts for remaining scheduled & ad hoc loan repayments
  • Calculates interest saving resulting from ad hoc loan repayments
  • Accommodates increased instalments & lump sum repayments