This is an easy to use Excel mortgage calculator template. Simply download from the link below and start using it. It requires home value, loan amount, interest rate, loan term and property tax rate inputs. It calculates your monthly payments. It also calculates the breakdown of your total payments by total principal paid, total interest paid, total PMI paid, and total tax paid.
How to Turn Excel Templates into Web Applications
You can turn this or any Excel file into a web application with SpreadsheetWeb. Delivering it as a web application helps protect your data and business logic. Your users can still access parts of your file, enter data and see the calculation results. But they won't be able to see the actual formulas nor modify them. Delivering your Excel file as a web application will allow many users accessing it at the same time while protecting their data. They cannot see each others data. Their data is fully protected.
The web application created from this Excel template is below: