Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2b. (5 Marks) Assume that you are one of the steering committes of a Project Management Office. The Office has received proopsals for the following
2b. (5 Marks) Assume that you are one of the steering committes of a Project Management Office. The Office has received proopsals for the following two marketing projects, Project A and Project B. Your task is to analyse these projects based on standard financial measures and make a suitable recommendation. The costs and benefits of each project are listed below: Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Project A: Cost RM 120,000 100,000 RM 75,000 RM 50,000 RM 50,000 RM 20,000 Benefit RM RM 60,000 RM 100,000 RM 120,000 RM 180,000 RM 100,000 Project B: Cost RM 75,000 RM 90,000 RM 30,000 RM 30,000 RM 20,000 RM 20,000 Benefit RM RM 85,000 RM 100,000 RM 75,000 RM 50,000 RM 25,000 Answer the following: i. Identify which project you would recommend based on Net Present Value (NPV). (1 Mark) ii. Show the NPV calculations for both projects assuming the discount rate is set at eight (8) percent. Start each project from Year 0. (4 Marks) Note: * You can try out the MS Excel NPV function, but it will be preferred to calculate the discount factor for this exam. Alternative calculations will be considered given they are correct. *Amounts should be rounded to 2 decimal places. Use the ROUND() function for numbers that will be added to calculate the NPV. It is bad business practice to let your software put in rounding errors. Therefore, rounding errors will incur a penalty of 1 mark for this
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started