Please explain how to enter the below onto an excel format. Please go into detail and show work.
Computing net present value. Compute the NPV of:
a. An investment of $15,000 that will yield $1000 for 28 periods at 4% per period.
b. An investment of $100,000 that will yield $250,000 eight years from now at 10% compounded semi-annually.