Q$15-$ FM$2$

Fill out spaces in the table provided for cashflows and NPV:

Procter and Gamble $($Pty$)$ LTD$,$ the world's largest consumer goods company and home to the biggest iconic, trusted brand, wants to expand their footing into the African Market. They are considering opening a branch in Johannesburg, South Africa, with the following expected US$$-$denominated cashflows. The cost of capital is pegged at $9\%.$

$\backslash$table$[[$Year$,$Cash flows $($$$)],[0,500000],[1,150000],[2,150000],[3,275000],[4,125000],[5,135000]]$

As the Finance and Marketing manager, calculate the following:

a$)$ Net Present Value $(7)$

b$)$ IRR $(3)$

As the Finance and Marketing manager, calculate the following:

a$)$ Net Present Value $(7)$

b$)$ IRR $(3)$

Edit View Insert Format Tools Table Help

$\backslash$table$[[$Year$,$Cashflows,PVIF $(9\%),$NPV$],[0,,1,],[1,,0\mathrm{.}9174,],[2,,0\mathrm{.}8417,],[3,,0\mathrm{.}7722,],[4,,0\mathrm{.}7084,],[5,,0\mathrm{.}6499,],[,,,]]$