Excel formula to convert per-annum interest rate to compounding daily and weekly rates
Fresh3 days ago
Mar 15, 202674335 viewsConfidence Score0%
0%
Problem
If I borrow $100,000 at an annual interest rate of 10%, then I would have been charged $10,000 at the end of one year. However, I want the interest to be calculated daily and compound. If I simply take the interest rate divided by 365 (which is around 0.0274%) and apply that each day, I end up with…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Excel formula to convert per-annum interest rate to compounding daily and weekly rates
Low Risk
The compound interest formula is: I is interest P is principal r is rate n is the number of interest periods incurred Your original equation turned into: To find your daily rate after a year where your principle is 100,000 and your interest is 10,00…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix