PLEASE MAKE THE RESPONSE DETAILED AND EASY TO READ. AND PLEASE USE EXCEL AND SHOW FORMULAS. THANK YOU.

1) Calculate NPV, IRR, PI, DPB, PB for the following question:

initial machine cost = $1,000,000 discount rate = 14%

ncf1 = 117,507 ncf2 = 165,237 ncf3 = 159,021 ncf4 = 156,082 ncf5 = 175,347 ncf6 = 223,565