Hi! Please answer only A and C. not b. This is the third time ive submitted this probelm. I will attatch one of the answers i got but I need to understand the functions in all the cells. Thanks so much

18. An investment is expected to produce the following annual year-end cash flows: year 1: $5,000 year 2: $1,000 year 3: $0 year 4: $5,000 year 5: $6,000 year 6: $863.65 The investment will cost $13,000 today. a. Will this investment be profitable? b. What will be the IRR (compounded annually) on this investment? c. Prove your answer in (b) by showing how much of each year's cash flow is recovery of the $13,000 investment and how much of the cash flow is return on investment. (Hint: See Exhibit 3-13and Concept Box 3.2)