Simple Debt Schedule

Note: This is a simplified modeling exercise for practice only — not a real-world case study. Overview Starbucks is a global coffee retailer that uses a combination of debt financing and operating cash flows to support store expansion, capital investments, and shareholder returns. Compared with highly leveraged companies, Starbucks has a relatively straightforward debt structure, making it an ideal example for learning the fundamentals of debt modeling. This practice focuses on building a simple Debt Schedule by rolling forward beginning debt, new borrowings, and debt repayments to calculate Ending Debt. It also introduces how to calculate Interest Expense using the average debt balance and interest rate, linking the schedule back to the Balance Sheet and Income Statement. Learning Goals Understand how a debt schedule rolls forward Beginning Debt, New Borrowings, and Debt Repayments to calculate Ending Debt. Learn how to calculate Interest Expense using the average debt balance and projected interest rate. Connect the debt schedule to the financial statements by linking Ending Debt to the Balance Sheet and Interest Expense to the Income Statement.

Practice Simple Debt Schedule with interactive Excel modeling exercises in our 3-Statement Supporting Schedules module.

This hands-on modeling exercise helps you master Simple Debt Schedule through real-world Excel practice and financial modeling techniques.