cash flow

  1. S

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    How Can I Change Columns Based on User Input?

    I have a worksheet that includes user input regarding the number of months required for the cash flow. I want the cash flow spreadsheet to automatically adjust (contract/expand) the number of columns pertaining to the number of months in the cash flow (the months are listed on the top of the...
  18. B

    Scale worksheet based on user input

    I have a worksheet that includes user input regarding the number of months required for the cash flow. I want the cash flow spreadsheet to automatically adjust the number of columns pertaining to each month in the cash flow (the months are listed on the top of the speadsheet). I cannot find out...

Some videos you may like

This Week's Hot Topics

Top