question: Use EXCEL Solver to discover the annual percentage increase in Project 2 revenues to create an IRR of 10% (4 Marks)

answer = 6%(the data is shown below, the original IRR is 3.59%)

pls, show in detail how to get the correct answer.

project 2 data:

Capital Costs	Operating Costs	Revenue	Net
40000			-40000
5000	1500	3700	-2800
0	1500	3737	2237
0	1500	3774	2274
0	1500	3812	2312
0	1500	3850	2350
0	1500	3889	2389
0	1500	3928	2428
0	1525	3967	2442
0	1550	4007	2457
0	1575	4047	2472
0	1600	4087	2487
0	1625	4128	2503
0	1650	4169	2519
0	1675	4211	2536
5000	1700	4253	-2447
0	1500	4296	2796
0	1500	4339	2839
0	1500	4382	2882
0	1500	4426	2926
0	1500	4470	2970
0	1500	4515	3015
0	1525	4560	3035
0	1550	4605	3055
0	1575	4652	3077
0	1600	4698	3098
0	1625	4745	3120
0	1650	4792	3142
0	1675	4840	3165
0	1700	4889	3189
0	1700	4938	3238