Using excel оr а cаlculаtоr. The use оf AI for this question is not allowed. 1.calculate the NPV, IRR, and MIRR for the following Data and answer below.2.Would you invest in this and why? No TaxesInitial Investment = $245,000Terminal value = $3000Cashflows = $67,000 each year for 10 yearsDiscount rate = 8%Finance rate = 6%