Instructions $(5$ marks$)$

Answer each question on a separate excel sheet in your workbook: Q$1$; Q$2$; Q$3$; Q$4.$

Display two decimal places for all calculations you perform.

Use the specify Currency format as given in each question.

Submit a single Excel Workbook named "Assign$\_$studentnumber$\_$MAF$3782"$ on

Moodle before cut$-$off time!

Moodle cut$-$off time: Saturday $12$ Oct $2024-23$:$59$ PM

Question $1[25$ marks$]$

Consider the following two cash flows Project X and Project Y $.$ Assume the opportunity cost is $15\mathrm{.}5\%.$

$1\mathrm{.}1.$ Compute their respective net present values $($NPV$),$ use Excel data tables, to draw a graph of

the NPV of each one these projects as a function of the discount rate, and then find their

respective internal rates of returns IRR$(s)$ accurate to at least $2$ decimal places.

$4+3+3+3+3=16$

$1\mathrm{.}2.$ Assume you should be investing in one of the two projects, make a comprehensive report of

$10$ lines maximum justifying why you would be choosing one of the projects and not the other

one.