The authors present a derivation of the formulas for the calculation of consumer credit in three different schemes. The article demonstrated the benefits of consumer credit calculation using Excel. Shows the practice of calculating the actual profitability of the bank