Open the Excel document labeled Case Study $2$ with the following questions. Each question needs a sentence summarizing the solution. Round answers to $2$ decimal places where applicable.SDG #$4-$ Quality Education: Ensure inclusive and equitable quality education and promote lifelong learning opportunities for all.Part $1$: Exponential Finance in your life$1)$ You graduate from college and all you can think about is buying your DREAM vehicle.Your new job pays well and right now you can afford to put $$700$ into a high$-$yield savings account monthly that has a $4\mathrm{.}35\%$ APY. Look up what the Kelly Blue book value is for your DREAM vehicle. Find the future value savings in this account if you make the $$700$ deposit at the end of every month for $5$ years. Will you have enough money in this account to buy this dream vehicle in $5$ years if the total purchase price is the value you found on Kelly blue?Find the exact time $($#years and months$)$ to have enough money saved for that vehicle.EXAMPLE: $$56,495$ BMW $4$ series$2023$ BMW $4$ Series$($ Save$$56,495$ Starting Price$2)$ You decide you don't want to wait to save for the vehicle and you want it immediately. You go to the dealership, and they say they can offer you a rate of $6\mathrm{.}5\%$ for a $6$ year loan.Assuming the price you found is the loan amount, find your monthly payment? Create an amortization table and calculate the total interest you pay on this vehicle over the lifetime of this loan$\mathrm{.}3)$ Planning out your retirement. When you turn $60$ you would like to have enough money in your IRA to support your lifestyle. Find the amount necessary to fund the given withdrawals $($which will be made at the end of each period$).$ Quarterly withdrawals of $$5,000$ for $20$ years with interest rate $4\%$ compounded quarterly$\mathrm{.}4)$ Suppose you have $25$ years until retirement. Create a savings plan that will amount to #$1$ part B $($within a margin of $$30,000.$ State if your plan is an Ordinary Annuity or Annuity Due $($your choice$).$ What you chose for a rate, how often it was compounded and how much money you deposited. Use $25$ years for your time. Display the total amount in the savings after $25$ years.