Do it on Excel and please show the steps

B B C E F G H 1 K L M N 0 P 0 A 1 (a) 2 discount rate D (b) discount rate NPV and IRR Year Payment Year Payment 3 4 5 6 7 8 9 Wild Cat Bancorp (WCB) has a new security for sale: You pay WCB $2,000 today and the company will give you back $100 at the end of the first year, $200 at the end of year 2, ..., $1000 at the end of year 10. a. Create the cash flow stream and calculate the NPV of this investment, assuming the appropriate discount rate is 12%. ON 1 2 3 4 b. In a different area, repeat the cash flow stream, NPV calculation, and use Goal seek to find the discount rate that makes the NPV zero