how to compute the implied discount rate


Joined
Mar 31, 2022
Messages
2
Reaction score
0
Country
Egypt
hello,

can someone help me how to calculate the implied discount rate like this example

277563600_387392679875969_5544944049223745534_n.png
 
Ad

Advertisements

Joined
Apr 1, 2020
Messages
63
Reaction score
11
Country
United States
Hi Omartarek

You need to use a financial calculator or Excel to use a function called IRR, internal rate of return. First read the directions provided with either Excel or the financial calculator on how to use the function. Most likely you will set the $2,000,000 as the initial cash out and the 24 payments each as $92,000 cash in. Then solve for the internal rate of return, which here is the implied interest rate.

Regards,

Kat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top