If possible please show in excel, if you can't use excel please just show detailed work of some sort because I'm just not understanding how to find the costs of capital from this information.

Question 4 3 pts One rejected six-year project had cash flows of Year 0 1 2 3 4 5 A - $10,000 $1,000 $2,000 $3,000 $4,000 $5,000 One accepted project had cash flows of Year 0 1 2 3 4 5 B -$10,000 $5,000 $4,000 $3,000 $2,000 $1,000 If the management used solely IRR analysis to make decisions, what can you infer about the management's cost of capital estimate? (Report your answer as the positive difference between the maximum and minimum possible costs of capital to at least 4 decimal places.) Question 4 3 pts One rejected six-year project had cash flows of Year 0 1 2 3 4 5 A - $10,000 $1,000 $2,000 $3,000 $4,000 $5,000 One accepted project had cash flows of Year 0 1 2 3 4 5 B -$10,000 $5,000 $4,000 $3,000 $2,000 $1,000 If the management used solely IRR analysis to make decisions, what can you infer about the management's cost of capital estimate? (Report your answer as the positive difference between the maximum and minimum possible costs of capital to at least 4 decimal places.)