House mortgage spreadsheet

House mortgage spreadsheet - 31,840 9,952-21,888 159,059...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Column 1 2 3 4 6 Date / Period Cash Interest Reduction of Mortgage Payments to Expesne Mortgage Balance Bank Equal to Interest .055*Mortgage Expense less Balance at Beg. Cash paid of Period 1/1/2012 240,000 1/1-1/1/2013 31,840 13,200 -18,640 221,360 1/1-1/1/2014 31,840 12,175 -19,665 201,694 1/1-1/1/2015 31,840 11,093 -20,747 180,947 1/1-1/1/2016
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 31,840 9,952-21,888 159,059 1/1-1/1/2017 31,840 8,748-23,092 135,967 1/1-1/1/2018 31,840 7,478-24,362 111,605 1/1-1/1/2019 31,840 6,138-25,702 85,903 1/1-1/1/2020 31,840 4,725-27,116 58,787 1/1-1/1/2021 31,840 3,233-28,607 30,180 1/1-1/1/2022 31,840 1,660-30,180...
View Full Document

This note was uploaded on 11/08/2011 for the course ACC 814 taught by Professor Manzon during the Summer '11 term at BC.

Ask a homework question - tutors are online