MARR = 16%
For IRR, we need to find Net cash flow and use IRR formula in excel
For simple payback period, we do not discount future cash flows. we find Cumulative cash flow (CCF), we need to find the year in which CCF turns positive
Simple payback period = Year bef CCF turns positive + (Absolute value of CCF bef it turns positive/Value of cash flow in the year in which CCF turns positive)
year | investment | Net Revenue | Salvage value | Net Cash Flow | Cumulative Cashflow |
0 | -110000 | -110000 | -110000 | ||
1 | 18000 | 18000 | -92000 | ||
2 | 28000 | 28000 | -64000 | ||
3 | 38000 | 38000 | -26000 | ||
4 | 48000 | 48000 | 22000 | ||
5 | 58000 | 9000 | 67000 | 89000 | |
IRR | 18.8% |
Simple payback period = 3 + 26000/48000 = 3.5416 years
As IRR>MARR but the simple payback period is greater than 2 years, so the project is not acceptable
Problem 5-53 (algorithmic) Show WorkQuestion Help Advanced Modular Technology (AMT) makes energy ...
Advanced Modular Technology (AMT) makes energy cleaner, safer, more secure and more efficient. It typically exhibits net annual revenues that increase over a fairly long period. In the long run, an AMT project may be profitable as measured by IRR, but its simple payback period may be unacceptable. Evaluate this AMT project using the IRR method when the company MARR IS 12% per year and its maximum allowable payback period is three years. What is your recommendation? Capital investment at...
Problem 5-49 (algorithmic) Show Work | Question Help In this problem, we consider replacing an existing electrical water heater with an array of solar panels. The net installed investment cost of the panels is $1,520 ($1,900 less a 20% tax credit from the government). Based on an energy audit, the existing water heater uses 200 kilowatt hours (kWh) of electricity per month, so at $0.14 per kWh, the cost of operating the water heater is $28 per month. Assuming the...
Problem 5-49 (algorithmic) Question Help Consider the two mutually exclusive projects in the table below. Salvage values represent the net proceeds (after tax) from disposal of the assets if they are sold at the end of each year. Both projects B1 and B2 will be available (or can be repeated) with the same costs and salvage values for an indefinite period. Click the icon to view the additional data about the mutually exclusive projects. Click the icon to view the...
1 A renewable energy electricity supply technology has the following characteristics: Capital cost ($) Annual operating cost ($) Lifetime (years) Salvage value ($) Annual electricity supplied (MWh) 300 000 27 200 25 40 000 400 1.1 If the owner can sell the electricity at 25 c/kWh, what is the simple payback period for the technology? 1.2 Would the owner invest in this technology if (s)he set a strict maximum four-year payback period? 1.3 What would the selling price for the...