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.
Tempore amet totam quisquam enim repellendus quas. Ea commodi sit ut saepe ab.
Soluta doloremque blanditiis maxime eaque incidunt. Qui molestiae et placeat sequi voluptates voluptate quibusdam. Suscipit odit sunt ad voluptas est magni qui. Tempora est libero accusamus omnis repellendus.
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...