Question: Please show how to arrive at the answer using Excel (please show steps, or calculations): Calculate PB, DPB, NPV, IRR and PI for the following
Please show how to arrive at the answer using Excel (please show steps, or calculations):
Calculate PB, DPB, NPV, IRR and PI for the following project: net cash flows for this 5 year project are: $250,000, $300,000, $400,000, $500,000 and $200,000 with an initial investment of $425,000. You use a discount rate of 12% and your tax rate is 30%. The machine will be sold in year 5 for $37,500 and it is 5-year property. The sale of the machine has not been calculated in year 5's net cash flow of $200,000.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
