Spreadsheet: mary_fischer__25738__Quebecor Amort
Sheet: Quebecor 5 @ 60 mos

 |  |  |  |  |  |  |  |  |  | Quebecor Promo Based on a 5 Year Amortization $5MM
[NAME] | Constructiondate | sCapitalInjected | sOverwriteCashflow | sMortgageShape | sPrincipalpaid | sIDRpaid | sIDCpaid | sStrfeepaid | CatID | Month | Outstanding Principal | Payment | Principal | Interest | Remaining Periods
344 | 2000-04-01 00:00:00 | 5000000 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2000-04-01 00:00:00
344 | 2000-05-01 00:00:00 | 0 | 0 | 62725.5639 | 26170.9334 | 36554.6305 | 0 | 0 | 4 | 2000-05-01 00:00:00 |  | 62725.5639 | 26170.9334 | 36554.6305
344 | 2000-06-01 00:00:00 | 0 | 0 | 62725.5639 | 26362.2672 | 36363.2967 | 0 | 0 | 4 | 2000-06-01 00:00:00 |  | 62725.5639 | 26362.2672 | 36363.2967
344 | 2000-07-01 00:00:00 | 0 | 0 | 62725.5639 | 26554.9998 | 36170.5641 | 0 | 0 | 4 | 2000-07-01 00:00:00 |  | 62725.5639 | 26554.9998 | 36170.5641
344 | 2000-08-01 00:00:00 | 0 | 0 | 62725.5639 | 26749.1414 | 35976.4225 | 0 | 0 | 4 | 2000-08-01 00:00:00 |  | 62725.5639 | 26749.1414 | 35976.4225
344 | 2000-09-01 00:00:00 | 0 | 0 | 62725.5639 | 26944.7024 | 35780.8615 | 0 | 0 | 4 | 2000-09-01 00:00:00 |  | 62725.5639 | 26944.7024 | 35780.8615
344 | 2000-10-01 00:00:00 | 0 | 0 | 62725.5639 | 27141.6931 | 35583.8708 | 0 | 0 | 4 | 2000-10-01 00:00:00 |  | 62725.5639 | 27141.6931 | 35583.8708
344 | 2000-11-01 00:00:00 | 0 | 0 | 62725.564 | 27340.1241 | 35385.4399 | 0 | 0 | 4 | 2000-11-01 00:00:00 |  |  |  |  | 54
344 | 2000-12-01 00:00:00 | 0 | 0 | 62725.5639 | 27540.0057 | 35185.5582 | 0 | 0 | 4 | 2000-12-01 00:00:00 |  |  |  |  | 53
344 | 2001-01-01 00:00:00 | 0 | 0 | 62725.5639 | 27741.3486 | 34984.2153 | 0 | 0 | 4 | 2001-01-01 00:00:00 |  |  |  |  | 52
344 | 2001-02-01 00:00:00 | 0 | 0 | 62725.5639 | 27944.1636 | 34781.4003 | 0 | 0 | 4 | 2001-02-01 00:00:00 |  |  |  |  | 51
344 | 2001-03-01 00:00:00 | 0 | 0 | 62725.5639 | 28148.4613 | 34577.1026 | 0 | 0 | 4 | 2001-03-01 00:00:00 |  |  |  |  | 50
344 | 2001-04-01 00:00:00 | 0 | 0 | 62725.5639 | 28354.2526 | 34371.3113 | 0 | 0 | 4 | 2001-04-01 00:00:00 |  |  |  |  | 49
344 | 2001-05-01 00:00:00 | 0 | 0 | 62725.564 | 28561.5485 | 34164.0155 | 0 | 0 | 4 | 2001-05-01 00:00:00 |  |  |  |  | 48
344 | 2001-06-01 00:00:00 | 0 | 0 | 62725.5639 | 28770.3598 | 33955.2041 | 0 | 0 | 4 | 2001-06-01 00:00:00 |  |  |  |  | 47
344 | 2001-07-01 00:00:00 | 0 | 0 | 62725.5639 | 28980.6978 | 33744.8661 | 0 | 0 | 4 | 2001-07-01 00:00:00 |  |  |  |  | 46
344 | 2001-08-01 00:00:00 | 0 | 0 | 62725.5639 | 29192.5735 | 33532.9904 | 0 | 0 | 4 | 2001-08-01 00:00:00 |  |  |  |  | 45
344 | 2001-09-01 00:00:00 | 0 | 0 | 62725.5639 | 29405.9983 | 33319.5656 | 0 | 0 | 4 | 2001-09-01 00:00:00 |  |  |  |  | 44
344 | 2001-10-01 00:00:00 | 0 | 0 | 62725.5639 | 29620.9834 | 33104.5805 | 0 | 0 | 4 | 2001-10-01 00:00:00 |  |  |  |  | 43
344 | 2001-11-01 00:00:00 | 0 | 0 | 62725.5639 | 29837.5402 | 32888.0237 | 0 | 0 | 4 | 2001-11-01 00:00:00 |  |  |  |  | 42
344 | 2001-12-01 00:00:00 | 0 | 0 | 62725.5639 | 30055.6802 | 32669.8837 | 0 | 0 | 4 | 2001-12-01 00:00:00 |  |  |  |  | 41
344 | 2002-01-01 00:00:00 | 0 | 0 | 62725.5639 | 30275.4151 | 32450.1488 | 0 | 0 | 4 | 2002-01-01 00:00:00 |  |  |  |  | 40
344 | 2002-02-01 00:00:00 | 0 | 0 | 62725.5639 | 30496.7564 | 32228.8075 | 0 | 0 | 4 | 2002-02-01 00:00:00 |  |  |  |  | 39
344 | 2002-03-01 00:00:00 | 0 | 0 | 62725.564 | 30719.716 | 32005.848 | 0 | 0 | 4 | 2002-03-01 00:00:00 |  |  |  |  | 38
344 | 2002-04-01 00:00:00 | 0 | 0 | 62725.5639 | 30944.3055 | 31781.2584 | 0 | 0 | 4 | 2002-04-01 00:00:00 |  |  |  |  | 37
344 | 2002-05-01 00:00:00 | 0 | 0 | 62725.564 | 31170.5371 | 31555.0269 | 0 | 0 | 4 | 2002-05-01 00:00:00 |  |  |  |  | 36
344 | 2002-06-01 00:00:00 | 0 | 0 | 62725.564 | 31398.4226 | 31327.1414 | 0 | 0 | 4 | 2002-06-01 00:00:00 |  |  |  |  | 35
344 | 2002-07-01 00:00:00 | 0 | 0 | 62725.5639 | 31627.9741 | 31097.5898 | 0 | 0 | 4 | 2002-07-01 00:00:00 |  |  |  |  | 34
344 | 2002-08-01 00:00:00 | 0 | 0 | 62725.5639 | 31859.2039 | 30866.36 | 0 | 0 | 4 | 2002-08-01 00:00:00 |  |  |  |  | 33
344 | 2002-09-01 00:00:00 | 0 | 0 | 62725.5639 | 32092.1242 | 30633.4397 | 0 | 0 | 4 | 2002-09-01 00:00:00 |  |  |  |  | 32
344 | 2002-10-01 00:00:00 | 0 | 0 | 62725.5639 | 32326.7473 | 30398.8166 | 0 | 0 | 4 | 2002-10-01 00:00:00 |  |  |  |  | 31
344 | 2002-11-01 00:00:00 | 0 | 0 | 62725.5639 | 32563.0858 | 30162.4781 | 0 | 0 | 4 | 2002-11-01 00:00:00 |  |  |  |  | 30
344 | 2002-12-01 00:00:00 | 0 | 0 | 62725.5639 | 32801.1521 | 29924.4118 | 0 | 0 | 4 | 2002-12-01 00:00:00 |  |  |  |  | 29
344 | 2003-01-01 00:00:00 | 0 | 0 | 62725.5639 | 33040.9589 | 29684.605 | 0 | 0 | 4 | 2003-01-01 00:00:00 |  |  |  |  | 28
344 | 2003-02-01 00:00:00 | 0 | 0 | 62725.5639 | 33282.5189 | 29443.045 | 0 | 0 | 4 | 2003-02-01 00:00:00 |  |  |  |  | 27
344 | 2003-03-01 00:00:00 | 0 | 0 | 62725.5639 | 33525.8449 | 29199.719 | 0 | 0 | 4 | 2003-03-01 00:00:00 |  |  |  |  | 26
344 | 2003-04-01 00:00:00 | 0 | 0 | 62725.5639 | 33770.9499 | 28954.614 | 0 | 0 | 4 | 2003-04-01 00:00:00 |  |  |  |  | 25
344 | 2003-05-01 00:00:00 | 0 | 0 | 62725.5639 | 34017.8468 | 28707.7171 | 0 | 0 | 4 | 2003-05-01 00:00:00 |  |  |  |  | 24
344 | 2003-06-01 00:00:00 | 0 | 0 | 62725.5639 | 34266.5488 | 28459.0151 | 0 | 0 | 4 | 2003-06-01 00:00:00 |  |  |  |  | 23
344 | 2003-07-01 00:00:00 | 0 | 0 | 62725.5639 | 34517.069 | 28208.4949 | 0 | 0 | 4 | 2003-07-01 00:00:00 |  |  |  |  | 22
344 | 2003-08-01 00:00:00 | 0 | 0 | 62725.5639 | 34769.4207 | 27956.1432 | 0 | 0 | 4 | 2003-08-01 00:00:00 |  |  |  |  | 21
344 | 2003-09-01 00:00:00 | 0 | 0 | 62725.5639 | 35023.6174 | 27701.9465 | 0 | 0 | 4 | 2003-09-01 00:00:00 |  |  |  |  | 20
344 | 2003-10-01 00:00:00 | 0 | 0 | 62725.5639 | 35279.6725 | 27445.8914 | 0 | 0 | 4 | 2003-10-01 00:00:00 |  |  |  |  | 19
344 | 2003-11-01 00:00:00 | 0 | 0 | 62725.564 | 35537.5996 | 27187.9644 | 0 | 0 | 4 | 2003-11-01 00:00:00 |  |  |  |  | 18
344 | 2003-12-01 00:00:00 | 0 | 0 | 62725.5639 | 35797.4123 | 26928.1516 | 0 | 0 | 4 | 2003-12-01 00:00:00 |  |  |  |  | 17
344 | 2004-01-01 00:00:00 | 0 | 0 | 62725.564 | 36059.1246 | 26666.4394 | 0 | 0 | 4 | 2004-01-01 00:00:00 |  |  |  |  | 16
344 | 2004-02-01 00:00:00 | 0 | 0 | 62725.5639 | 36322.7501 | 26402.8138 | 0 | 0 | 4 | 2004-02-01 00:00:00 |  |  |  |  | 15
344 | 2004-03-01 00:00:00 | 0 | 0 | 62725.5639 | 36588.3031 | 26137.2608 | 0 | 0 | 4 | 2004-03-01 00:00:00 |  |  |  |  | 14
344 | 2004-04-01 00:00:00 | 0 | 0 | 62725.5639 | 36855.7975 | 25869.7664 | 0 | 0 | 4 | 2004-04-01 00:00:00 |  |  |  |  | 13
344 | 2004-05-01 00:00:00 | 0 | 0 | 62725.5639 | 37125.2475 | 25600.3164 | 0 | 0 | 4 | 2004-05-01 00:00:00 |  |  |  |  | 12
344 | 2004-06-01 00:00:00 | 0 | 0 | 62725.5639 | 37396.6674 | 25328.8965 | 0 | 0 | 4 | 2004-06-01 00:00:00 |  |  |  |  | 11
344 | 2004-07-01 00:00:00 | 0 | 0 | 62725.5639 | 37670.0717 | 25055.4922 | 0 | 0 | 4 | 2004-07-01 00:00:00 |  |  |  |  | 10
344 | 2004-08-01 00:00:00 | 0 | 0 | 62725.5639 | 37945.4748 | 24780.0891 | 0 | 0 | 4 | 2004-08-01 00:00:00 |  |  |  |  | 9
344 | 2004-09-01 00:00:00 | 0 | 0 | 62725.5639 | 38222.8914 | 24502.6725 | 0 | 0 | 4 | 2004-09-01 00:00:00 |  |  |  |  | 8
344 | 2004-10-01 00:00:00 | 0 | 0 | 62725.5639 | 38502.3361 | 24223.2278 | 0 | 0 | 4 | 2004-10-01 00:00:00 |  |  |  |  | 7
344 | 2004-11-01 00:00:00 | 0 | 0 | 62725.5639 | 38783.8238 | 23941.7401 | 0 | 0 | 4 | 2004-11-01 00:00:00 |  |  |  |  | 6
344 | 2004-12-01 00:00:00 | 0 | 0 | 62725.5639 | 39067.3695 | 23658.1944 | 0 | 0 | 4 | 2004-12-01 00:00:00 |  |  |  |  | 5
344 | 2005-01-01 00:00:00 | 0 | 0 | 62725.564 | 39352.9882 | 23372.5758 | 0 | 0 | 4 | 2005-01-01 00:00:00 |  |  |  |  | 4
344 | 2005-02-01 00:00:00 | 0 | 0 | 62725.5639 | 39640.6949 | 23084.869 | 0 | 0 | 4 | 2005-02-01 00:00:00 |  |  |  |  | 3
344 | 2005-03-01 00:00:00 | 0 | 0 | 62725.5639 | 39930.5051 | 22795.0588 | 0 | 0 | 4 | 2005-03-01 00:00:00 |  |  |  |  | 2
344 | 2005-04-01 00:00:00 | 0 | 0 | 62725.5639 | 40222.4341 | 22503.1298 | 0 | 0 | 4 | 2005-04-01 00:00:00 |  |  |  |  | 1
344 | 2005-05-01 00:00:00 | 0 | 0 | 62725.564 | 40516.4974 | 22209.0666 | 0 | 0 | 4
344 | 2005-06-01 00:00:00 | 0 | 0 | 62725.5639 | 40812.7105 | 21912.8534 | 0 | 0 | 4 | Totals:
344 | 2005-07-01 00:00:00 | 0 | 0 | 62725.5639 | 41111.0892 | 21614.4747 | 0 | 0 | 4
344 | 2005-08-01 00:00:00 | 0 | 0 | 62725.5639 | 41411.6493 | 21313.9146 | 0 | 0 | 4
344 | 2005-09-01 00:00:00 | 0 | 0 | 62725.5639 | 41714.4068 | 21011.1571 | 0 | 0 | 4
344 | 2005-10-01 00:00:00 | 0 | 0 | 62725.5639 | 42019.3778 | 20706.1861 | 0 | 0 | 4
344 | 2005-11-01 00:00:00 | 0 | 0 | 62725.5639 | 42326.5783 | 20398.9856 | 0 | 0 | 4
344 | 2005-12-01 00:00:00 | 0 | 0 | 62725.5639 | 42636.0248 | 20089.5391 | 0 | 0 | 4
344 | 2006-01-01 00:00:00 | 0 | 0 | 62725.5639 | 42947.7336 | 19777.8303 | 0 | 0 | 4
344 | 2006-02-01 00:00:00 | 0 | 0 | 62725.564 | 43261.7214 | 19463.8426 | 0 | 0 | 4
344 | 2006-03-01 00:00:00 | 0 | 0 | 62725.5639 | 43578.0046 | 19147.5593 | 0 | 0 | 4
344 | 2006-04-01 00:00:00 | 0 | 0 | 62725.5639 | 43896.6002 | 18828.9637 | 0 | 0 | 4
344 | 2006-05-01 00:00:00 | 0 | 0 | 62725.5639 | 44217.525 | 18508.0389 | 0 | 0 | 4
344 | 2006-06-01 00:00:00 | 0 | 0 | 62725.5639 | 44540.796 | 18184.7679 | 0 | 0 | 4
344 | 2006-07-01 00:00:00 | 0 | 0 | 62725.5639 | 44866.4305 | 17859.1334 | 0 | 0 | 4
344 | 2006-08-01 00:00:00 | 0 | 0 | 62725.564 | 45194.4457 | 17531.1183 | 0 | 0 | 4
344 | 2006-09-01 00:00:00 | 0 | 0 | 62725.5639 | 45524.8589 | 17200.705 | 0 | 0 | 4
344 | 2006-10-01 00:00:00 | 0 | 0 | 62725.5639 | 45857.6878 | 16867.8761 | 0 | 0 | 4
344 | 2006-11-01 00:00:00 | 0 | 0 | 62725.5639 | 46192.9499 | 16532.614 | 0 | 0 | 4
344 | 2006-12-01 00:00:00 | 0 | 0 | 62725.5639 | 46530.6632 | 16194.9007 | 0 | 0 | 4
344 | 2007-01-01 00:00:00 | 0 | 0 | 62725.5639 | 46870.8454 | 15854.7185 | 0 | 0 | 4
344 | 2007-02-01 00:00:00 | 0 | 0 | 62725.5639 | 47213.5147 | 15512.0492 | 0 | 0 | 4
344 | 2007-03-01 00:00:00 | 0 | 0 | 62725.5639 | 47558.6892 | 15166.8747 | 0 | 0 | 4
344 | 2007-04-01 00:00:00 | 0 | 0 | 62725.5639 | 47906.3873 | 14819.1766 | 0 | 0 | 4
344 | 2007-05-01 00:00:00 | 0 | 0 | 62725.564 | 48256.6274 | 14468.9366 | 0 | 0 | 4
344 | 2007-06-01 00:00:00 | 0 | 0 | 62725.5639 | 48609.428 | 14116.1359 | 0 | 0 | 4
344 | 2007-07-01 00:00:00 | 0 | 0 | 62725.5639 | 48964.8079 | 13760.756 | 0 | 0 | 4
344 | 2007-08-01 00:00:00 | 0 | 0 | 62725.5639 | 49322.786 | 13402.7779 | 0 | 0 | 4
344 | 2007-09-01 00:00:00 | 0 | 0 | 62725.5639 | 49683.3813 | 13042.1826 | 0 | 0 | 4
344 | 2007-10-01 00:00:00 | 0 | 0 | 62725.5639 | 50046.6128 | 12678.9511 | 0 | 0 | 4
344 | 2007-11-01 00:00:00 | 0 | 0 | 62725.5639 | 50412.4999 | 12313.064 | 0 | 0 | 4
344 | 2007-12-01 00:00:00 | 0 | 0 | 62725.5639 | 50781.0619 | 11944.502 | 0 | 0 | 4
344 | 2008-01-01 00:00:00 | 0 | 0 | 62725.5639 | 51152.3185 | 11573.2454 | 0 | 0 | 4
344 | 2008-02-01 00:00:00 | 0 | 0 | 62725.564 | 51526.2894 | 11199.2746 | 0 | 0 | 4
344 | 2008-03-01 00:00:00 | 0 | 0 | 62725.5639 | 51902.9942 | 10822.5697 | 0 | 0 | 4
344 | 2008-04-01 00:00:00 | 0 | 0 | 62725.5639 | 52282.4532 | 10443.1107 | 0 | 0 | 4
344 | 2008-05-01 00:00:00 | 0 | 0 | 62725.564 | 52664.6864 | 10060.8776 | 0 | 0 | 4
344 | 2008-06-01 00:00:00 | 0 | 0 | 62725.5639 | 53049.714 | 9675.8499 | 0 | 0 | 4
344 | 2008-07-01 00:00:00 | 0 | 0 | 62725.5639 | 53437.5565 | 9288.0074 | 0 | 0 | 4
344 | 2008-08-01 00:00:00 | 0 | 0 | 62725.5639 | 53828.2345 | 8897.3294 | 0 | 0 | 4
344 | 2008-09-01 00:00:00 | 0 | 0 | 62725.5639 | 54221.7688 | 8503.7951 | 0 | 0 | 4
344 | 2008-10-01 00:00:00 | 0 | 0 | 62725.5639 | 54618.1801 | 8107.3838 | 0 | 0 | 4
344 | 2008-11-01 00:00:00 | 0 | 0 | 62725.5639 | 55017.4896 | 7708.0743 | 0 | 0 | 4
344 | 2008-12-01 00:00:00 | 0 | 0 | 62725.5639 | 55419.7184 | 7305.8455 | 0 | 0 | 4
344 | 2009-01-01 00:00:00 | 0 | 0 | 62725.5639 | 55824.8879 | 6900.676 | 0 | 0 | 4
344 | 2009-02-01 00:00:00 | 0 | 0 | 62725.5639 | 56233.0195 | 6492.5444 | 0 | 0 | 4
344 | 2009-03-01 00:00:00 | 0 | 0 | 62725.564 | 56644.135 | 6081.429 | 0 | 0 | 4
344 | 2009-04-01 00:00:00 | 0 | 0 | 62725.5639 | 57058.256 | 5667.3079 | 0 | 0 | 4
344 | 2009-05-01 00:00:00 | 0 | 0 | 62725.5639 | 57475.4047 | 5250.1592 | 0 | 0 | 4
344 | 2009-06-01 00:00:00 | 0 | 0 | 62725.5639 | 57895.6032 | 4829.9607 | 0 | 0 | 4
344 | 2009-07-01 00:00:00 | 0 | 0 | 62725.5639 | 58318.8736 | 4406.6903 | 0 | 0 | 4
344 | 2009-08-01 00:00:00 | 0 | 0 | 62725.5639 | 58745.2386 | 3980.3253 | 0 | 0 | 4
344 | 2009-09-01 00:00:00 | 0 | 0 | 62725.5639 | 59174.7207 | 3550.8432 | 0 | 0 | 4
344 | 2009-10-01 00:00:00 | 0 | 0 | 62725.5639 | 59607.3427 | 3118.2212 | 0 | 0 | 4
344 | 2009-11-01 00:00:00 | 0 | 0 | 62725.5639 | 60043.1276 | 2682.4363 | 0 | 0 | 4
344 | 2009-12-01 00:00:00 | 0 | 0 | 62725.5639 | 60482.0985 | 2243.4654 | 0 | 0 | 4
344 | 2010-01-01 00:00:00 | 0 | 0 | 62725.5639 | 60924.2786 | 1801.2853 | 0 | 0 | 4
344 | 2010-02-01 00:00:00 | 0 | 0 | 62725.5639 | 61369.6915 | 1355.8724 | 0 | 0 | 4
344 | 2010-03-01 00:00:00 | 0 | 0 | 62725.5639 | 61818.3608 | 907.2031 | 0 | 0 | 4
344 | 2010-04-01 00:00:00 | 0 | 0 | 62725.5639 | 62270.3103 | 455.2536 | 0 | 0 | 4