This web page contains a live and functional spreadsheet created with
HVAC and Solar Energy calculations
An annual percentage rate (APR) is the annual rate charged for borrowing or earned through an investment.
% (APR) - 🛈
Number of Years for loan
N of Years - 🛈
N of Years
outstanding balance of mortgage
As monthly mortgage payments are made, the mortgage principal is reduced.
Principle - 🛈
Amount owed at a particular moment in time during the mortgage loan term.
Balance - 🛈