Estimate effective interest rates
Let's say you invested $1000 at 8% simple interest rate for 5 years. What kind of effective interest rates should you see across different compounding frequencies?
Use the following formula to estimate that rate:
(1 + Nominal Rate/Compound Freq)^Compound Freq - 1
यह अभ्यास पाठ्यक्रम का हिस्सा है
Google Sheets में फाइनेंशियल मॉडलिंग
अभ्यास निर्देश
- In
C8, enter the formula above with absolute cell references for the nominal rate and relative references for the compounding frequency. - Copy that formula to all compounding frequencies from
C8:C14.
इंटरैक्टिव व्यावहारिक अभ्यास
हमारे इंटरैक्टिव अभ्यासों में से किसी एक के साथ सिद्धांत को व्यवहार में बदलें
अभ्यास शुरू करें