Cash Flow Problem...stumped

JustinWWolcott

Board Regular
Joined
Mar 20, 2007
Messages
158
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
Joined
Mar 20, 2007
Messages
158
Re: Cash Flow Problem...stumped...and bumped

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

dcamos

Board Regular
Joined
May 21, 2008
Messages
225
Re: Cash Flow Problem...stumped...and bumped

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

JustinWWolcott

Board Regular
Joined
Mar 20, 2007
Messages
158
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
 
Upvote 0

dcamos

Board Regular
Joined
May 21, 2008
Messages
225
=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.
 
Upvote 0

Banker1

Active Member
Joined
Mar 10, 2005
Messages
463
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:
Upvote 0

JustinWWolcott

Board Regular
Joined
Mar 20, 2007
Messages
158
:)

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...
 
Upvote 0

Banker1

Active Member
Joined
Mar 10, 2005
Messages
463
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.
 
Upvote 0

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top