Pay off Balance using two sources

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.

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Administrative Note:

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect ('latest' is not specific enough - sorry). If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

The actual priority returns for 6/24/2023 displayed in sample.xlsx is 6,290,254.70 not 5,217,867 as implied in post #1.
Assuming that 6,290,254.70 is not correct, we need to know what the value should be and how it would be manually calculated so that we have something with which to compare the results of our proposed formulas/code.
Let us know if you have any questions.