Loan Calculation Spreadsheet

The Loan Calculation Spreadsheet calculates automatically the Monthly, Quarterly and Annual Mortgage Constant. Just enter the interest rate and number of years of your choice and the spreadsheet will automatically calculate all three mortgage constants.

It also calculates automatically Month-by-Month, Quarter-by-Quarter, and Year-by-Year Full Loan Amortization Schedules with Beginning Balance, Mortgage Payment, Interest portion of payment, Principal portion of payment, and the Ending Balance of any Loan of up to 40 years. Just enter the Property Value, Loan to Value Ratio, the Loan Term (duration), and the interest rate, and the spreadsheet will automatically calculate the Loan Amount and the corresponding Monthly, Quarterly and Annual amortization schedules.

Finally, it provides the formulas for:
Loan-To-Value Ratio
Monthly Interest Rate
Quarterly Interest Rate
Mortgage Constant
Mortgage Payment
Interest Payment
Principal Payment
Ending Balance
Beginning Balance

Download now the e-book Real Estate Investment Mathematics and we will send you FOR FREE THIS LOAN CALCULATION SPREADSHEET
For any questions regarding the spreadsheet send your inquiry to admin@property-investing.org

Return from Loan Calculation Spreadsheet to Real Estate Investment Mathematics

SBI!

Mortgage Constant and Loan Calculation Spreadsheet