# Cash Flow Problem...stumped

#### JustinWWolcott

##### Board Regular
Howdy,

I have 6 different mortgages. What I'm doing is using the excess cash flow from the property income to pay them down. However; I have to pay them off in order.

I already have a spreadsheet built that's populating the numbers for cash flow (the top line), I'm just trying to figure out how to make this work as concise as possible.

Any ideas?
Book1
CDEFGHIJKL
2872,000600,000600,000600,000600,000600,000600,000600,000600,000
3
4890,00018,000--------
5700,000?????????
660,000?????????
71,000,000?????????
820?????????
9500,000?????????
Sheet1

### Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

#### JustinWWolcott

##### Board Regular
Re: Cash Flow Problem...stumped...and bumped

it looks easier than it is; unless I'm making it harder than it is. Guidance?

#### dcamos

##### Board Regular
Re: Cash Flow Problem...stumped...and bumped

I think you need to give some more information of what you are trying to do.

#### JustinWWolcott

##### Board Regular
Its kind of a waterfall.

I have amounts that need to be paid off from revenue. All money goes to one amount until its paid off. After it gets paid off, the money is applied to the next amount, and so on.

I'm trying to make a logical statment out of it, and I feel like I'm chasing my tail trying to figure it out.
Book1
BCDEFGH
5Period1Period2Period3Period4Period5Period6
6CashFlow800,000600,000500,000.00900,000.0060,000500,000
7
8Loan11,100,000300,000---
9Loan260,00060,000---
10Loan3400,000400,000260,000--
11Loan4800,000800,000800,000160,000-
12Loan520202020-
13Loan6700,000700,000700,000700,000-
14Loan755,00055,00055,00055,00015,020
Sheet3

#### dcamos

##### Board Regular
=IF(SUM(\$C\$5:C\$5)<SUM(\$B\$8:\$B8),SUM(\$B\$8:\$B8)-SUM(\$C\$5:C\$5)-SUM(C\$7:C7),0)

Paste that into C8 and copy it through the rest of the cells that you are looking to fill.

#### Banker1

##### Active Member
For some reason the entire formula isn't showing up in the normal thread window (for me at least). You might have to go to the quote screen to see it all...

Last edited:

#### JustinWWolcott

##### Board Regular

You're seeing the whole formula. I cheated, which is why it works for that example.

I was digging around some of our templates, and I found an example of something similar to what I'd like but its UGLY...

#### Banker1

##### Active Member
I was referring to dcamos solution, I see only this: =IF(SUM(\$C\$5:C\$5)

When I click on the quote button for that reply I see the whole formula.

Replies
0
Views
329
Replies
1
Views
200
Replies
4
Views
766
Replies
2
Views
421
Replies
1
Views
571

1,191,125
Messages
5,984,786
Members
439,911
Latest member
dk73

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back