Lessor 1st lease amortization spreadsheet

Lessor 1st lease amortization spreadsheet - 562 4,915...

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 Net recevied from Income Net Investment investment Lessee in leases Equal to Cash paid .08*Net Investment less Balance at Beg. Interest Exp. of Period 1/1/2012 7,478 1/1/2012 1,000 0 1,000 6,478 1/1/2012-1/1/2013 1,000 518 482 5,997 1/1/2013-1/1/2014 1,000 480 520 5,477 1/1/2014-1/1/2015 1,000 438
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 562 4,915 1/1/2015-1/1/2016 1,000 393 607 4,308 1/1/2016-1/1/2017 1,000 345 655 3,652 1/1/2017-1/1/2018 1,000 292 708 2,945 1/1/2018-1/1/2019 1,000 236 764 2,180 1/1/2019-1/1/2020 1,000 174 826 1,355 1/1/2020-1/1/2021 1,000 108 892 463 1/1/2021-1/1/2022 37-37 500...
View Full Document

Ask a homework question - tutors are online