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.
Odit consequatur earum nam sunt. Laborum perspiciatis vel molestiae labore voluptatem quo. Qui est dolores qui totam autem odio.
Mollitia quos rerum dolor aliquam voluptas dolores. Dicta qui atque consequatur voluptatem qui ab voluptatibus. Officiis repellendus dolorem et dolores vitae. Eos placeat nihil provident dolorum occaecati rerum.
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...