Present Value 640,000 Payments 2,802.91 Future Value Annual Rate% 3.3 Periods 360 Compounding Monthly PV PMT FV RATE PERIOD Mode End O Beginning This $2,803 30-year mortgage payment is significantly more affordable than the 15-year payment of ~$4,300 was. But is it affordable enough for Morty? Here is Morty's cash flows file again, now including his cash flows with the 15-year mortgage we've already calculated. Modify column D now, in order to understand if Morty can afford the 30-year mortgage. Using the exact same cash flow assumptions that applied to the 15-year mortgage calculation (those are already in the Excel file I linked to above), continuing to eliminate all the expenses he allowed us to eliminate, what will Morty's cash flow surplus / deficit be as a homeowner with a 30-year mortgage? Enter cash flow surplus as a positive answer, and cash flow deficit as negative.

This $2,803,30 year mortgage payment is significantly more affordable than the 15 -year poymens of $4,300 was. But is it affordable enough for Morty? Marty can alford the 30 year mortgage. Using the exact same cash flow assumptions that applied to the 15 pos mortgage cakculation (those are already in the frcel file I linked to abowe), continaing to as a positive anower, and cash forw dificit as negative