Using Excel

Investments B Div. no tax yes yes sells no, yes no yes yes Two investments, an investor wants to buy 200 shares each share 30 JD, the total amount has to be paid 6000 dd assume that the annual pretax return is 12% FOR FIVE YEARS the initial price for each share is 30 JD INVESTMENTS A has no div. INVESTMENT B has 8% div. assume that the tax rate is 25% find the followings: 1 IRR for Aif the investor does not sell his/her investment 2 IRR for A if the investor sells his/her investment 3 IRR FOR B if the investor does not sell his/her investment 4 IRR FOR B if the investor sells his/her investment