Question: upload your excel file here. Please use all the cell reference and time value functions to do all the calculations inside the excel. Please lay
upload your excel file here. Please use all the cell reference and time value functions to do all the calculations inside the excel. Please lay out your input information separately and label it clearly. You are reviewing a new project and have estimated the following cash flows: Year 0: CF=165,000 Year 1: CF=63,120;NI=13,620 Year 2: CF=70,800;NI=3,300 Year 3: CF=91,080;NI=29,100 Average Book Value =72,000 Your required return for assets of this risk level is 12%. The company will accept a project that is paid off within 3 years. Should we adopt this new project? Make your decision based on different decision rules (NPV, IRR, payback period, average account return and profitability index)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
