Hi I'm totally lost.

I don't understand this whole "Discount Rate and NPV Stuff" Can you help put together an Excel Doc?

Prof: "Hey! I think Exercise 3 is fairly self-explanatory and straightforward. Please note that there are actually two questions: (1) which loan and (2) how much to borrow. I recommend starting out by selecting a loan size and doing the amortizations for all loan options. Then, you can vary the loan size and see what happens. What happens to what? Try an IRR and a NPV. But what discount rate is correct for the NPV calculation?"

Assignment Files:

https://drive.google.com/drive/folders/1PbZCeoFqnx7o9xmKegaGRDdrLDuqhvPL?usp=sharing

Blank Google Excel Sheet:

https://docs.google.com/spreadsheets/d/1rLMxbEpVtlZfV0_ZUq-UdVv_esfJIhzk8guUgAiUHeM/edit?usp=sharing