the value of an investment project. P8-4) – Calculate the net present value (NPV) for the following 20 year projects. Comment on the acceptability of each. Assume that the firm has an opportunity cost of 14%. A). – Initial cash outlay is $15,000; cash inflows are $13,000 per year 20yrs of $13,000 at a 14% discount rate, its NPV is $71,100.70; this is a positive NPV and is an acceptable project B). – Initial cash outlay is $32,000; cash inflows are $4,000 per year 20yrs of $4,000 at a 14% its NPV is $5,507.47, this is a negative NPV and isn’t acceptable C). – Initial cash outlay is $50,000; cash inflows are $8,500 per year 20yrs of $8,500 at a 14% discount rate its NPV is $6,296.61, this is a positive NPV and an acceptable project These are the correct answers I need, but I have to know what calculation to put into excel in order to get full credit.

CourseLover

(12)

Status NEW Posted 13 Dec 2017 02:12 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------ns.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------

Not Rated(0)

• Buy Answer