cash flow

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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]"...

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

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

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

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

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