PLEASE DO IN EXCEL FOR THUMBS UP

5. Find the IRR for an investment of $3785 that generates an annual net return of $1000 for 5 years. 6. The Brisbane Council has a budget, with no constraints, which must be spent in the current year. Three projects are proposed, and the discount rate is 10% per annum. The project benefits and costs are summarized in the following table: Project Benefits Project Cost Year o Year 1 Year 2 0 -30 | 30 | -70 50 100 a. Derive the Net Present Value (NPV), Internal Rate of Return (IRR) and Benefit/Cost Ratio (BCR) for each project [3 marks] b. Rank the projects according to the NPV, IRR and BCR investment criteria. [2 marks] C. Given a budget constraint, how would you rank the project? [1 mark]