Hello,
I'm working on a cash flow analysis, and I am looking for some help (hopefully not requiring a macro solution if possible).
In looking at a net cash flow analysis, I have a variable setup that says in X years, we will be looking to fully replace equipment with a value of Y. How can I get my cash flow to subtract that value depending on how many year we expect to we will need to replace the equipment?
For example-
(X) Replacement Cost: 100,000
(Y) Years: 3
Annual Estimated Net Cash Flow: 250,000
Year 0: -100,000 (initial equipment purchase)
Year 1: 250,000
Year 2: 250,000
Year 3: 150,000 (first replacement)
Year 4: 250,000
Year 5: 250,000
Year 6: 150,000 (second replacement)
Anyway, I'm hoping to make this dynamic so management can easily change the variables (except for cash flow which is inputted from another formula).
Thank you!
Brian
I'm working on a cash flow analysis, and I am looking for some help (hopefully not requiring a macro solution if possible).
In looking at a net cash flow analysis, I have a variable setup that says in X years, we will be looking to fully replace equipment with a value of Y. How can I get my cash flow to subtract that value depending on how many year we expect to we will need to replace the equipment?
For example-
(X) Replacement Cost: 100,000
(Y) Years: 3
Annual Estimated Net Cash Flow: 250,000
Year 0: -100,000 (initial equipment purchase)
Year 1: 250,000
Year 2: 250,000
Year 3: 150,000 (first replacement)
Year 4: 250,000
Year 5: 250,000
Year 6: 150,000 (second replacement)
Anyway, I'm hoping to make this dynamic so management can easily change the variables (except for cash flow which is inputted from another formula).
Thank you!
Brian
