Must use the best option between the functions: PMT; FV; NPER; PV, & or RATE!

Design and create a workbook to compare the purchase versus lease of an automobile. The car you wish to purchase is $18,400. Your monthly net income (after taxes) is $3,024. You need to decide whether to lease the car over three years or buy the car with the aid of bank loan for $18,400. Design and create your solution using Excel. Format your workbook attractively and appropriately based on the principles learned in this course. You may need to use the function wizard to explore functions. Be sure your calculations support your conclusions. The following information is provided: - If you were to purchase the vehicle with the aid of a bank loan with zero down for three years (interest rate is 7% ), what would your monthly payment be? What would be the total cost to own the vehicle at the end of three years? - How much would you pay, over and above the price of the vehicle, for each option