Hello. I need to Use the NPV numbers from the table on the left to populate grids
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667b1b8c88edb_012667b1b8c5026a.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667b1b8ceaa8f_012667b1b8cc3cee.jpg)
Hello. I need to Use the NPV numbers from the table on the left to populate grids for different scenarios in excel. The following picture has the numbers I am using, please use them to make one or both of the graphs in the second picture and explain by formulas and such how you completed them so I better understand please. Thank you. If you need any other info just let me know. I think you only need the two pics but including a third picture with extra data just in case. Just need the NPV Analysis Grid: NPV vs Discount Rate & Cost of Goods Sold (CoGS) Percent Ranges grid completed and the NPV Analysis Grid: NPV vs Discount Rate & Year 1 Sales Ranges grid completed. please help and explain how filled them out thanks.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667b1b8d626cd_013667b1b8d3ca02.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667b1b8dda0b5_013667b1b8db14f8.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667b1b8e811c5_014667b1b8e5538c.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667b1b8f209e6_014667b1b8ee6c31.jpg)
Posted Date: