The attached is a discounted cash flow worksheet that I am using. I am trying to re-engineer the worksheet so that I can choose a specific amount of years, a discounted cash flow, and a terminal value. I want to have the worksheet calculate the annual cash flows as well as the present value. Can this be done?
Bookmarks