Internal rate of return method
The internal rate of return method is used by Testerman Construction Co. in analyzing a capital expenditure proposal. The following data is provided:
DATA
Period	Cash flow
0	-$149,630
1	$45,000
2	$45,000
3	$45,000
4	$45,000
5	$45,000
6	$45,000
Using formulas and cell references, perform the required analysis, and input your answer into the Amount column.
	Amount	Formula
Internal rate of return