financial function

Mr. Francisco has decided to purchase some new lawn care equipment for the business, at a cost of $25,000. He is considering several financing options for this purchase, and has asked you to consider the following scenarios. (You should create a worksheet named Financing Options. All formulas and functions should use cell referencing. Set up the worksheet as shown below. The monthly payment for the equipment, with No Down payment, and an APR of 6%, compounded monthly. (The loan will be for 2 years.) The monthly payment for the equipment, with a Down payment of 25% of anticipated April Revenue, and an APR of 4%, compounded monthly. (The loan will be for 2 years.) The number of years it would take to pay off the loan, with monthly payments of $500 at an APR of 5%, and no down payment. The loan will be compounded quarterly. (Round the value to the nearest month) How many quarters would take to pay off the loan described in question three? Mr. Francisco purchased a CD 10 years ago that will be maturing in the next month. The APR for the CD was 5%, compounded monthly. He would like you to determine if the value of the CD would be enough to purchase the lawn equipment without financing. If the value of the CD is sufficient to buy the lawn equipment display "Cash" in the cell, otherwise display "Finance". (The initial value of the CD was $15,000.)