a. What is the annual return that is needed to grow an $50,000 investment to $1,000,000 in 30 years?\table[[I,],[N,],[PMT,],[PV,],[FV,]]Note: ? indicates I is what we are solving for. Fill the N, PMT, PV and PV in the highlighted cells, and solve for I in the shaded cell below:Use the RATE function to solve for L. Keep two decimal places for the percentage obtained.I ??????b. Find the PV and FV of a 10 year, $100 annuity due with 7% market interest rate.INPMITPVFVTuetexel's PV and PV) Factions.PVA=FVA=C. Find the present value of the following cash flow stream. Interest rate =10%.1,10%First, find the PV of each casPVA=FVA=c. Find the present value of the following cash flow stream. Interest rate =10%.I10%First, find the PV of each cash flows and sum them up.\table[[t,0,1,2,3],[CF,,-$200.00,$200.00,$300.00h flows and sum them up.\table[[,0,1,2,$?3