please show work without XL and include formula

Question 1 reference image

Question to solve for:

(5 points) Mr. Diaz is creating a college fund for his daughter. He plans to make 5-yearly payments of $5,000 each with the first payment deposited today on his daughter's sih birthday (happy birthday!) Assuming his daughter will need four equal withdrawals from this account to pay for her education beginning when she is eighteen (i.e. 18, 19, 20, 21), how much will she have on a yearly basis for her university career? Mr. Diaz expects to earn a constant 10% annual return for the time interval of this problem. B 1 2 1 Annual rate of return 10% Annual rate of retu 0.1 3 4 5 6 7 Annual Deposit (from Sth birthday) No. of Deposit Value of Deposit on 10th birthday $5,000 5 $33,578.05 Annual Deposit from Sth birthday No. of Deposit Value of Deposit on 10th birthday 5000 5 -FV12.05-04.1) 8 Value of Deposit on 18th birthday $71,977.53 2 3 4 5 6 7 8 9 10 11 12 13 14 Value of Deposit on 18th birthday -C6 (1.28 9 10 11 No. of withdrawal (from 18 to 21) 4 No. of withdrawal (from 18 to 21) 4 Annual withdrawal amount $20,642.55 12 13 Annual withdrawal amount PMT(C2.010, C8, 1) 14 9. (5 points) For the bond in problem I, what are the capital-gains yield and the currenl-yield