How to calculate interest on a loan in excel?

Question

2 answer(s)

Answer # 2 #

Use formula: <code=PrincipalRateTime for simple interest.

Answered by: Mayank Jutt [3 Month]

(3)

Answered by: Pucci zsgbzao Naseebullah · Accepted Answer

Answer # 1 #

For compound interest: =Principal(1+Rate/Number_of_periods)^(Number_of_periodsTime)-Principal

Answered by: Pucci zsgbzao Naseebullah [3 Month]

(5)