K
K
kurales6662021-12-18 11:43:05
excel
kurales666, 2021-12-18 11:43:05

How to calculate the loan term using the formula?

"The bank took out a loan in the amount of 350,000 rubles at 31% per annum. Annual payments will amount to 20,000 rubles. Determine the period during which the borrower will be able to repay the debt on the loan?"

Converted annual payments into monthly payments (1667 rubles), converted 31% per annum into monthly interest (31% / 12 \u003d 2.58%) tried to solve through the NPER formula, but something doesn’t work (the result comes out in months, but small) .

Answer the question

In order to leave comments, you need to log in

1 answer(s)
H
hint000, 2021-12-18
@kurales666

350,000 * 131% = 458,500 Answer: never pay. :)
But I guess that there is an error in the conditions. Let's say monthly payments will be 20,000, then for 2 years.
61bda28d425a6047169231.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question