Question: please show how to solve problem in Excel All techniques Rieger Intemational is evaluating the feasibility of investing $101,000 in a piece of equipment that

All techniques Rieger Intemational is evaluating the feasibility of investing $101,000 in a piece of equipment that has a 5 -year life. The firm has estimated the cash inflows associated with the proposal as shown in the following table: The firm has a cost of capital of 11%. a. Calculate the payback period for the proposed investment. b. Calculate the discounted payback period for the proposed investment c. Calculate the net present value (NPV) for the proposed investment. d. Calculate the probability index for the proposed investrient e. Calculate the mternal rate of retum (IRR) for the proposed investment F. Calculate the modified internal rate of return (MIRR) for the proposed investment. g. Evaluate the acceptability of the proposed investment using NPV, IRR, and MIRR (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
