Part 1You are considering purchasing a vehicle with a sticker price of 42,270 ( nonnegotiable with no down payment required )You wish to make monthly payments for six years and the most that you would like to pay is 750 a monthYour local bank/credit union has agreed to loan you the money at 4.47 % annual interest rate Create an amortization table reporting the beginning ending loan balance, total payment, the portion of payment going to interest and principal, and remaining loan balanceCreate a IF statement that answers the question of whether you can afford the loanWhat is your monthly loan payment and what is the total interest paid on the loanWRITE HERE Part You are that the recent in new vehicle prices and interest rates will make it difficult to finance your purchase at the above ratescosts Create a two-way data table using prices ranging from 43,000 to 46,000 using 500 increments and interest rates of 4.5% to using 0.25\% increments. For ease of interpretation, use your a reference for your data table (not your payment per )