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 )

x fr Question 1 (100 points): Part 1: You 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 month. Your local bank/credit union has agreed to loan you the money at a 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 balance. Create a IF statement that answers the question of whether you can afford the loan. What is your monthly loan payment and what is the total interest paid on the loan? WRITE HERE: Part 2: You are concerned that the recent runup in new vehicle prices and interest rates will make it difficult to finance your purchase at the above rates/costs. Create a two-way data table using purchase prices ranging from $43,000 to $46,000 using $500 increments and annual interest rates of 4.5% to 6.5% using 0.25% increments. For ease of interpretation, use your IP statement eutcome as a reference for your data table (not your payment per period value). 14 Place Data Table Analysis Hare 13 Place New Vehicle Loan Analysis Here Loan Principal 42,270 is Term Years Term months annuel intrest 18 11 Quest 2 Part Question Part 16 AIR Ready Readin Question stv 4 V ***