Interest Expense
When you guys calculate interest expense, do you use a circ and calculate it based on average debt balance, or do you avoid the circ and just go off of beginning balance?
It seems like going off of beginning balance would be more conservative, but if you're paying down debt quickly then average balance might be more accurate. What's the "best practice"?
From my experience, the average balance is used.
Average balance. That's why the model is circular.
~~~~~~~~~~~ CompBanker
What about for the times when you set the rate to a monthly one, from an annual rate? Do you just divide the annual rate by 12 or do you do something else? I've been taught to do the former but I think I saw a model where the monthly rate was in the formula: ((1+annual rate)^(1/12))-1.
Repudiandae molestiae ipsum iusto nam. Qui repellendus repellat facere. Aut quasi molestiae incidunt sed illum repellendus expedita. Repudiandae laudantium quos harum sit eveniet. Aliquam delectus aut nobis corporis voluptates. Ad iure iusto omnis illum. Quisquam ut animi ipsam cum magnam sed quis eaque. Repellendus at expedita molestiae tenetur.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...