Problem 2 ABM Enterprise would like to evaluate/analyze an investment proposal. Given the following: Investment amount - 450,000 (2022) Dividends / Revenue stream - 100,000 for the first year and an interval of 5,000 for the succeeding years Discount rate - 14% a. NPV for the perio 2023 through 2029; b. Total NPV using manual computation; c. Total NPV using the Excel function; and d. IRR rate.

Please provide excel template to work thanku

rna.4

EconomicS 2. Referring to the given data in 6.7/317 at the end of Chapter 6 (Engineering Economy by Sullivan et al), select the best alternative using: (a) PW (b) AW © FW (d) IRR 6-7. Three mutually exclusive design alternatives are being considered. The estimated cash flows for each alternative are given next. The MARR is 20% per year. At the conclusion of the useful life, the investment will be sold. A в $28,000 $55,000 $40,000 Annual expenses $15,000 $13,000 $22,000 Annual revenues $23,000 $28,000 $32,000 $6,000 $8,000 $10,000 Investment cost Market value Useful life 10 years 10 years 10 years 26.4% 24.7% 22.4% IRR A decision-maker can select one of these alternatives or decide to select none of them. Make a recommendation using the PW method. (6.4)