I have a spreadsheet that is partially completed. I'm trying to put together a simple "Cashflow" Analysis that includes a calculation for the Break Even Point and the Net Present Value in a 36 month Analysis. I get the cash "benefits" in a yearly number that is then spread out based on the number/12 and then started in the benefit start month.
Take a look at the model and I think you will see what I'm attempting to accomplish. Any help would be appreciated. For the question, let's just do the Break Even Point calculation and then I'll ask another question if I need help with NPV.
Thank you in advance,