Please, solve in excel and show excel functions used.

3. Problem Three: Fiterman Bank expects to receive $250,000 at the end of each year, for the next 15 years. The nominal interest rate is 4.25%. As shown in class, (a) use a Discounted Cash Flow (DCF) model to compute the present value of these future cash flows, and verify your answer by using the NPV function, (b) if the interest rate changes to 3.75%, how does that affect your present value (all other parameters being the same as in part (a)