Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch08/ExcelShort51-54.xlsx
Learn how to create a dynamic spilled array formula to build a Net Present Value Profile Table based on varying Required Rate of Return values and then build a chat to visualize the relationship between RRR and NPV. See how to visualize with an X-Y Scatter Chart.