# cash flow

1. ### Dynamic XIRR for sum of CF's with Offset

Hello All, I have noticed that this has been a question in other threads on this forum; however I have been unable to locate this particular question using the formulas in the sheet below (vertically vs horizontally). Question: Is it possible to make a dynamic XIRR formula to search for the...
2. ### Payment schedule

I've got multiple payment dates and I want to match them to a time series and populate the cell with the individual payment amounts. Sounds simple use of xmatch and indexing or similar but I'm having a mental block. Any help appreciated
3. ### Payment terms (formula) for P&L impact and Cash flow - HELP

Hi everyone, how are you? Could I ask you to help me please? I need to calculate automatically 2 things (in the tab "Cost details"): 1/ The P&L impact (taking into account several variables - from cell L13 to cell S13) 2/ the Cash position (cashout) based on payment terms, total cost expense...
4. ### P&L impact and Cash flow impact (for expenses) - with payment terms

Hi everyone, how are you? Could I ask you to help me please? I need to calculate automatically 2 things (in the tab "Cost details"): 1/ The P&L impact (taking into account several variables - from cell L13 to cell S13 2/ the Cash position (cashout) based on payment terms, total cost expense...
5. ### Cash Flow Projection Probabilty

I have a years worth of Cash Flow projections for Capital projects that are based on the start and end dates of construction. Each month i have been tracking the actual's compared to what the projections were and creating a chart based on the projections and actual's. now i am being tasked...
6. ### Populating a dynamic table changing two inputs in excel

I have 3 inputs Say product price,loan period and monthly product sales. What I want is if the user changes the loan period I want to populate the table accordingly. I just can't figure out a way. If you think there is better way to show what I am trying to show as a table format I am open to...
7. ### VBA Code needed to repeat formulas

You guys have helped me in the past and I'm sure you will help me again: So I have Sheet1 that includes a list of assets from which I generate cash flows <colgroup><col><col><col><col><col></colgroup><tbody> <colgroup><col span="5"></colgroup><tbody> A B C D 1 Asset No. Asset Name...
8. ### Cash flow by date and type

Hi, I had an old template with a formula that doesn't seem to exist in Excel 2016. =CashFlowForecast(\$B\$3,J\$6,\$F12,\$H12,\$G12,\$E12,'Cash Curves'!\$A\$2:\$E\$403,\$D12)-SUM(\$H12:I12) This formula allowed me to cash flow my budget by date and then by type (front-loaded, back-end loaded, linear and...
9. ### Help with Lease Amortization Schedule

I am trying to amortize a lease liability schedule to zero using an assumed rate of 5%. I realize the implicit rate is different but I've discounted the cash flows at 5% and would like the amortization to zero out starting with the current lease liability derived using XNPV. I get close to...
10. ### Self Amortizing Loan with Varying Interest and Cash Flow

Hi, First time poster. I'm trying to back into the principal amount of a self amortizing loan with varying interest and cash flow. The interest rate will be 5% for the first year and 2% for years 2 - 6. There is no payment in year 1 and let's use \$100 for payments in years 2 - 6. Any...
11. ### total days between two dates by Month (VBA)

Hi I would like to calculate the total of days by month wise between two dates through VBA. I have seen some example at the below link but that's on the worksheet. Distributing Days Over Intervals Does anyone suggest VBA function to do the same ? (could return that in array format would...
12. ### Variable for rolling cash flow table?

Hi all, I came to the conclusion I was never going to work this out on my own, despite reading and experimenting. Here's what I'm trying to do. I'm creating a spreadsheet which will show me cash available on any given day and for days in the future, based on predicted income and expenditure...
13. ### Internal Rate of Return

Consider the cash flows seen here. The internal rate of return on the cashflows (rounded to the nearest 1%) is ....... Date Cash Flow 4/10/2011 -1000 5/1/2012 500 1/1/2014 600 4/10/2015 700
14. ### Payments for a Certain Time - Completely Stuck

I am developing a pro-forma and need to capture different types of funding during "X" time periods. However, I am not sure the best way to do this. I am thinking an if statement but I am not sure if this would be the best approach. As an example: - Debt Source #1 will start in year 1 but will...
15. ### Extraction and placement Macro

Hi all, basically here is what I do manually When I download my bank statement recurring (Direct Debits) entries come up like these two below - 07/05/2014 NSPCC (8.00) 01/05/2014 TV LICENCE MBP (12.12) I download this onto a file called "July 2014 data" to a tab called "[Month]"...
16. ### IF Date Monthly Cashflow

I have a cash-flow which I need to calculate how much interest is paid each month to the day. The interest is built up over the first 6 month then the total accumulated is paid on the 7th Month then the interest is paid on a monthly basis thereafter. I am currently doing this by using an IF...
17. ### Help with SUMIF Dates

My Formula is currently =SUMIF(\$F6:\$F9,D77,\$C6:\$C9) with the column C being different purchase costs, F being the respective purchase dates, and D77 contains the month of the cash-flow for the date to flow to below. At the moment the dates need to be on the first day of the month to flow to the...
18. ### Nested Countif in Vlookup is rejected by Excel...

Hello, I created a excel sheet (Sheet 2)that acts like MS PROJECT in that it looks at horizontal date and then if it is larger that the (vertical) project start date, it does a VLookUp on another sheet (Sheet 1-construction project cash flow). Sheet 2...
19. ### Using dates - If a calculated date falls on a weekend, how do I get Excel to return the date of the Friday before?

Hi, I'm putting together a cash flow forecast and am trying to work out the payment dates for our invoices based on invoice date + terms (30, 60, 90 etc) + paydate (some are paid on the 1st, some on the 3rd, some every Thursday, and some on the last working day of the month). At the moment some...
20. ### Filtering content from one spreadsheet to show it in another

I am creating an Excel spreadsheet designed to manage my company's accounts. Spreadsheet 1 is used like a bank statement to show payments going in and out of the company's bank account. Spreadsheet 2 is used as a cash flow chart. The sheet sis divided into left and right. Columns on the left...

### 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