please WRITE OUT steps and do not use excel screenshots for answer. thanks

5.1.4 Transactions A and B are to be compared. Transaction A has net cashflows of CA = -5, G4 = 3.72, CA =0, CA = 4 and Transaction B has net cashflows CB = -5, CP = 3, C = 1.7, CB = 3. Find the yield rate for each transaction to at least 6 decimal plac- es. Show that Transaction A is preferable to B at interest prefer- ence rates less than 11.11% and at interest preference rates greater than 25%, and Transaction B is preferable at interest preference rates between 11.11% and 25%. 5.1.4 (use given cash flows but only show NPV for 10%, 20% and 30%), 5.1.5 A project requires an initial capital outlay of 30,000 and will return the following amounts (paid at the ends of the next 5 years): 14,000, 12,000, 6,000, 4,000, 2,000. Solve for each of the following. (a) Internal rate of return. (b) Modified internal rate of return assuming a cost of capital of 10% per year. c) Net present value based on a cost of capital of 10% per year