(Answered) Need the question solved on excel (reference book engineering economy by Leland Blank and Anthony…

➤ What Excel functions compute NPV, IRR, and equivalent annual worth for textbook cash flows?
Use NPV and IRR for regularly spaced cash flows and XNPV/XIRR for irregular dates. Calculate equivalent annual worth with PMT applied to the NPV or by using annuity factors. Use PV, FV, RATE, and NPER for basic time-value conversions and PMT for levelized annual costs or benefits.