,I don’t know how to show these answers on EXCEL. I can’t find the correct function. Is it IPMT, INTRATE, IRR, ISPMT?,,5-3 Your parents will retire in 18 years. They currently have $250,000, and they think they will need $1,000,000 at retirement. what annual interest rate must they earn to reach their goal, assuming they don’t save any additional funds?,5-13,Find the interest rates, or rates of return, on each,Find the interest rates, or rates of return, on each of the following:,a. You borrow $700 and promise to pay back $749 at the end of 1 year.,b. You lend $700 and receive a promise to be paid $749 at the end of 1 year.,c. You borrow $85,000 and promise to pay back $201,229 at the end of 10 years.,d. You borrow $9,000 and promise to make payments of $2,684.80 per year for 5 years., ,