From the course: Forecasting Using Financial Statements

Unlock the full course today

Join today to access over 25,000 courses taught by industry experts.

Borrowing and interest expense

Borrowing and interest expense

From the course: Forecasting Using Financial Statements

Start my 1-month free trial Buy for my team

Borrowing and interest expense

“

- [Instructor] Let's keep knocking out some more of these line items in the balance sheet. I'm in 03_05_BS_Begin if you want to join me. And I want to turn my attention in particular to the long-term debt. That's our current portion in row 29 under liabilities. The amounts that we input here are the amounts owed as of the last day of each year. This is pretty straightforward. I don't imagine that the current portion of long-term loans will change too much. For the sake of having a little bit of flexibility, let's increase the amount 2% each year. So to do that, I'm going to click on D29 for projected 2018, and I'll simply say equals Historical 2017 times 1.02. We're increasing it by 2% each year. So I'm going to go ahead and apply the same type of logic to my other years. And you'll see that the long-term portion is increasing little, by little, by little. Okay, so let's think about the long-term debt section while we're at it. For now, I'm just going to assume that other long-term…

Contents