Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the excel formula for this question?, especially for pw, fw, aw, and err Find the excel formula to solve this question TER 5
What is the excel formula for this question?, especially for pw, fw, aw, and err
Find the excel formula to solve this question
TER 5 / EVALUATING A SINGLE PROJECT guess for the IRR value (using the MARR is a good idea). Unlike the trial-and- error approach required when solving for the IRR by hand, the Excel IRR function is direct and simple. In cell E18, the IRR is calculated to be 22.03%. 5-13 Evaluation of New Equipment Purchase, Using the Internal Rate of Return Method (Example 5-1 Revisited) A piece of new equipment has been proposed by engineers to increase the productivity of a certain manual welding operation. The investment cost is $25,000, and the equipment will have a market (salvage) value of $5,000 at the end of its expected life of five years. Increased productivity attributable to the equipment will amount to $8,000 per year after extra operating costs have been subtracted from the value of the additional production. Use a spreadsheet to evaluate the IRR of the proposed equipment. Is the investment a good one? Recall that the MARR is 20% per year. Spreadsheet Solution The spreadsheet solution for this problem is shown in Figure 5-7. In column E of Figure 5-7(a), the individual EOY cash flows for year five (net annual savings mendation Capital investment at time 0 Net revenues in year k Market (salvage) value Life $100,000 $20,000+$10,000*(k-1) $10,000 5 years Assignment 5-5 (Please do it with spreadsheets and attach them): Refer to Example 5-13. Create a single spreadsheet that calculates PW, FW, AW, IRR, and ERR for the proposed investment. Assume that eMARR 20% per year. Does your recommendation change if the MARR decreases to 18%? Increases to 22%. TER 5 / EVALUATING A SINGLE PROJECT guess for the IRR value (using the MARR is a good idea). Unlike the trial-and- error approach required when solving for the IRR by hand, the Excel IRR function is direct and simple. In cell E18, the IRR is calculated to be 22.03%. 5-13 Evaluation of New Equipment Purchase, Using the Internal Rate of Return Method (Example 5-1 Revisited) A piece of new equipment has been proposed by engineers to increase the productivity of a certain manual welding operation. The investment cost is $25,000, and the equipment will have a market (salvage) value of $5,000 at the end of its expected life of five years. Increased productivity attributable to the equipment will amount to $8,000 per year after extra operating costs have been subtracted from the value of the additional production. Use a spreadsheet to evaluate the IRR of the proposed equipment. Is the investment a good one? Recall that the MARR is 20% per year. Spreadsheet Solution The spreadsheet solution for this problem is shown in Figure 5-7. In column E of Figure 5-7(a), the individual EOY cash flows for year five (net annual savings mendation Capital investment at time 0 Net revenues in year k Market (salvage) value Life $100,000 $20,000+$10,000*(k-1) $10,000 5 years Assignment 5-5 (Please do it with spreadsheets and attach them): Refer to Example 5-13. Create a single spreadsheet that calculates PW, FW, AW, IRR, and ERR for the proposed investment. Assume that eMARR 20% per year. Does your recommendation change if the MARR decreases to 18%? Increases to 22%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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