mortgage calculator: Spreadsheet Formulas: Calculating Home Payments
- 05/05/08 10:50 AM
For a lot of homebuyers, calculating a prospective mortgage payment is an online experience. For example, a search on Google for "mortgage calculator" returns 39 million options. Some people, however, prefer to plan on their local hard drive using spreadsheets. For these people, the hardest part is often figuring out what formulas to use. Interest Only Payments Home loans with interest only payments are much more simple to calculate than amortizing loans. Using the graphic at right as a guide, enter your loan size and your interest rate into two separate spreadsheet cells. Then, create a third cell and input the … (1 comments)
For a lot of homebuyers, calculating a prospective mortgage payment is an online experience. For example, a search on Google for "mortgage calculator" returns 39 million options. Some people, however, prefer to plan on their local hard drive using spreadsheets. For these people, the hardest part is often figuring out what formulas to use. Interest Only Payments Home loans with interest only payments are much more simple to calculate than amortizing loans. Using the graphic at right as a guide, enter your loan size and your interest rate into two separate spreadsheet cells. Then, create a third cell and input the … (1 comments)
;)
;)
