Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
Separately, with my company X model, which I also filled in following Mr. Lin, my term loan balances go down because of excess cash flow payments that get directed there (above and beyond the Mandatory Debt Repayments), per his instructions, but the interest expense does not go down from Year 1 to Year 5, even though the Term Loan is paid off in Year 4, nor does it change if I switch from a 1 (Beginning Balance) to a 2 (Average Balance).
Finally, In year 4 in my company X model, the beginning balance is 149.1, the Mandatory Debt Paydown is (112.5), but the Borrowing/(Paydown) line shows a (59.1) and the ending balance shows 0, even though that math doesn't work. I have tested these again and again against the video and all my formulas are correct. So what is going on?
These problems hve stopped me in my tracks from doing more models on my own.
Thanks. Read More