Using excel or what ever method you would like except asking…
Using excel or what ever method you would like except asking some one else, 1. Calculate the NPV, IRR, and MIRR for the following Data and answer below. (Round to 2 Decimals) 2. Would you invest in this and why? There are no taxes to figure.Initial Investment = $200,000Terminal value = $5,000Operating Revenue = $100,000 each year for 5 years Operating Expense = $ 50,000 each year for 5 yearsDiscount rate = 12%Finance rate = 5%