Complete the attached questions in excel, thank you.

PS #5 (Present Value Analysis). 16. Given a 10% discount rate.tinti the present value of a cash flow stream of $ lot) at the end of the rst year, $200 at the cm! of the second. $300 at the end of the third, andh$ollill at the end of the fourth. 20. Given a 14% discount rate. find the present value of the following cash flow stream: Year Amounl 1 SF i 50 2-i0 300 ' l l . -200 i2 0 13-19 300 20 ' 1,000 25. Prepare the repayment schedule for a $10,000 loan at 10% interest. The loan. is repaid in equal installments at the end of each year over 5 years (Don't worry if your table is not exactly correct because the discount factors, by necessity, have been rounded off). 26. Frank Tepper will retire in 10 years and wishes to set up a personal savings plan to supplement his employer's pension plan. Fntuit will deposlt 2,000 at the end of each of those 10 years Into an account earning 3%. a. How much would he have in the account after the last payment is - made? . b. What is the most that he could withdraw in equal amounts over 10 , years. starting 1 year after the last payment has been made into the account? I 28. You have just inherited SFIO0,000. You have two investment alternatives. Which alternative is best (assuming they are of equal risk)? Alternative I. invest SFiO0,000 in real estate. You estimate that in 10 years you will be able to sell out for SF440.500. Alternative 2. Lend SF100.000 to a business associate and be repaid in 10 equal annual installments ofSFl9.170 each