Car Inventory You have been tasked with creating an Excel workbook that will allow sales persons the ability to search existing inventory by VIN. They must also be able to define any combination of search criteria that returns a list of results and summary data pertaining to that result set. They have also asked that you create a separate sheet to help them calculate how large of loan they can afford and an amortization schedule for the loan.
Populate Calculated Fields
You need to calculate the number of days each vehicle has been on the lot and if there are any special notes that need to be added to each vehicle. Any vehicle that has been on the lot for more than 200 days is eligible for a special employee bonus if they are able to sell that vehicle. Any vehicle that has been on the lot between 125 and 200 days will earn the seller one raffle ticket in the end of the month $1000 bonus.
a. Open exam2_data and save as Exam2_LastFirst.
b. On the Inventory worksheet, insert a function in H7:H206 to calculate the number of days each vehicle has been on the lot using 1/1/2018 as today’s date.
c. Insert a function in I7:I206 that will display "Bonus Eligible" for cars that have been on the lot more than 200 days, "Raffle Eligible" for cars that have been on the lot between 125 and 200 days, and nothing for the remaining vehicles.

the answerr would be 1

of the three mortgage options that demarco and tanya have to choose from, the balloon payment mortgage would be their best option, over adjustable payment and fixed payment plans.ultimately, the balloon payment plan would save demarco and tanya overall, in interest, would cost less monthly, and they would only have to make these payments for 8 years, opposing to 30 years for adjustable or fixed payment plans. 

overall, demarco and tanya would save $80,811 if they chose balloon payments over fixed payments, and would save $116,711 if they choose balloon payments over adjustable payments. benefits with choosing fixed payments over adjustable payments is that, in the end, the payments will still be $836.30 a month, while with adjustable payments, the initial monthly payments will be $763.38 to $1082.70 a month, ultimately leading to a more costly purchase. benefits with choosing fixed payments over balloon payments are not present. benefits in choosing adjustable payments over is that it has a lower interest rate, and starts with lower monthly payments initially. benefits in choosing adjustable payments over balloon payments include a lower interest rate, and lower initial monthly payments. benefits in choosing balloon payments over fixed payments include lower interest rates, lower overall price, lower monthly payments, takes less time to pay off, and does not require a downpayment. benefits in choosing balloon payments over adjustable payments include, lower monthly payments (when averaged), takes less time to pay off, and lower overall price.

hence, option c, balloon payments, is the best option for demarco and tanya to make this purchase, for it will save them a minimum of $80811, and a maximum of $116,711. 

the correct choice is a