Determine i* per year for the cash flows shown using factors and the IRR function. (Note: See Problem 7.55 for additional spreadsheet work with this series.)
 FIGURE 1.png)
Factors: Move all cash flows to year 1
0 = -80,000 + 9000(P/F,i*,1) + 70,000(P/F,i*,2) + 30,000(P/F,*i,3)
By trial and error, i* = 15.32%
Spreadsheet: Enter amounts for years 0 to 4 in cells B2:B6 or years 1 to 4 in cells B3:B6
= IRR(B2:B6) displays i* = 15.32%
or = IRR(B3:B6) displays i* = 15.32%
You might also like to view...
Vacuum problems can be caused by incorrect hose routing or defects with a backpressure transducer, thermal switching valve, or solenoid.
Answer the following statement true (T) or false (F)
What does an injection pressure regulator (IPR) valve control?
A. length of HEUI effective stroke B. time of HEUI duty cycle C. actuation oil pressure D. fuel injection pressure
Technician A says to inflate the tires to manufacturer's specifications before performing a wheel alignment. Technician B says to thoroughly inspect the steering and suspension components before performing a wheel alignment. Which technician is correct?
A) Technician A only B) Technician B only C) Both technicians A and B D) Neither technician A nor B
How does air from air-conditioning vents affect open display cases?
A) Open display cases are not affected by external air sources because of their powerful built-in air curtains. B) Open display cases are not affected by external air sources because of their engineered air baffles. C) It improves their performance by lowering the temperature of the air surrounding the display case. D) It disrupts the case's air curtain, causing them to rise in temperature.