1) Complete the Lease Term in Months column. Use embedded IF statements to find the lease term in months. Hockney typically uses the following lease terms. Strive to include the following lease terms in the if condition statements:

a. 3, 4, 5, 6, 7, 8, 9 and 10 years

b. 24, 36, 48, 60, 72, and 84 months

c. The last condition should be to note the word VERIFY for any terms that are not included in this standard list.

d. For any items that result in VERIFY, manually input the lease term in months.

HINT: You will need lots of IF statements. An example of one of the embedded If statements is:

IF(F7="9 Y",108

Remember to have the appropriate number of parenthesis for the embedded if statements.