cash flow modeling

Hi everyone, I'm so excited to join this group. I recently watched some videos on the dynamic array function in Excel and I think this is gonna change a lot of things. I'm looking forward to learn more from all of you. Here is my problem: As the pictures show, Table 1 is a simple...

Hi all, quick question. I am looking to calculate the future value (FV) of an investment. I have a lump sum to start with, a known rate of return and I would be making consistent, monthly contributions ($100). However, I would also like to add a large payment once a year into the investment...

Hi, I am trying to model my in- and outgoing cash flow and want to have them dynamically change when I change the payment terms. Any ideas? Thanks! <colgroup><col width="184" style="width: 138pt;"><col width="128" style="width: 96pt;"><col width="87" span="9" style="width...

I am building a cash flow model to determine my IRR depending on when I sell the investment. The logic I am trying to follow for the equation is: If current period is equal to harvest period, then populate the cell with the sell price minus the cash outflow for that period. If current period...

Hi, I have a loan on a property that expires in 7 years. I want to model the property's sale in year 7 or earlier but not after year 7. I am trying to think of a formula that looks up what year the cash flow is in and what year the holding period is and if the cash flow year matches the...