1

Amortization Schedule including escow?

Submitted by Merk_man on April 26, 2008 - 22:35.

Can anyone either explain how to do in Excel or show me a link to where I can calculate an amortization schedule that includes escrow for property taxes and home owners insurance?

I am 2 years into a 20 year loan and would like to create an excel spreadsheet to track the additional principal payments I have recently started sending in, but the amount I can send every month varies. I would like to track my progress and project in "real time" so to speak.

Thanks in advance.

Reply

Please keep the comments civil and on-topic. Abusive or inappropriate comments will be removed without warning. By posting here you agree to our terms of use.

The content of this field is kept private and will not be shown publicly.
If you leave a link (include the http:// part), your name will be linked to your homepage.

You may use some HTML for formatting: <strong>bold text</strong>, <em>italics</em>, and <a href="">for links</a>. Empty lines are automatically converted to paragraph breaks.

Or click the link above that says 'enable rich-text' to use the fancy editor.

Captcha
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
5 + 1 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Have more to say? Join the discussions at Wise Bread's Finance and Frugality Forums.

Finance Blogs - Blog Top Sites