Using a specific scenario, you will research your computer purchase options and make a choice. Here's the scenario: You need a new computer, and you are going to research this topic and create a list of possible computers to purchase. You will finance this purchase over one year with the complete payment of both the computer's cost and interest due at the end of that year. Since you are not sure of the interest rate that you will be charged or your budget, you will need to create a "What If$"$ scenario so that you can plug different interest rates and budget values into your "What If$"$ spreadsheet. You will be able to see different scenarios based on your budget and the interest rate. When complete, name your workbook "Computer Purchase" and upload to the assignment area.

Your spreadsheet must include the following:

$1.$ You must research between five and ten computers. $($Do not use the same computers as shown in the example.$)$

$2.$ Your results must include the computer model$/$name$,$ type of video, size of memory, the CPU type, hard drive or SSD size, and the cost to purchase.

$3.$ In Column G$,$ create a formula that uses the PMT$()$ function to calculate your monthly payment for the $12$ months. You must use absolute cell references for the interest rate.

$4.$ In Column H$,$ write a formula that displays the total cost to you $($the sum of your payments$).$

$5.$ In column I you must use IF$()$ functions with absolute cell references to the Annual Budget value in cell B$18.$ Have the formula display "Yes" if your budget allows for this purchase $($including interest$),$ or $"$No$"$ if it does not.