Calculate the Loan Payment per Year for each project. Notice that there are different interest rates for three loan amount ranges. For example, if the loan (i.e. initial cost) is $38,000 then the interest rate is 7%, if the loan is for $55,000 the interest rate is 8%, and so on. You will have to create one formula smart enough to select the correct interest rate based on the amount. Loan Payment per Year $20,196.53 [m Loan Payment per Year V 17.8781 9334.19