Currently working on a waterfall in excel. I have NOI of 1,200,000 and a lump sum of 4,017,867 available to pay down. The balance I owe is 4,017,867 plus 840,300 +6% interest on top of that. I want only show the amount in one cell the actual pay down using both sources. The number paid should actually be 5,099,238, not 5,217,867.
Any help would be greatly appreciated.
Bookmarks