-
Package 3: Advanced Fina...
- WST Free Trial - Professional Development
- WST Corporate Valuation Quiz/Exam
- Capital Group - 2021 Assessment - Quizzes
- Analyst Essentials
- Analyst Essentials Pro
- Merger Modeling Basics
- Overview of Financial Markets
- Accounting for Finance
- DBS MODULE 1: FUNDAMENTAL/FOUNDATION
- WST Internal Instructors
- Advanced Excel for Data Analysis (2016 Singapore)
- Fundamentals of Financial Modeling (PKA)
- Fundamentals of Valuation Modeling (PKA)
- JPM-AM 2015 Excel Exam
- JPM-IM 2015 Valuation Exam
- Strategic Alternatives: M&A and Buyout Options
- Excel for Entrepreneurs
- Wall Street Certification Bundle
- Financial Modeling Starter Kit
- WST Professional Development
- Quizzes & Exams - WST Internal
- Keys to Success
- Oppenheimer Pre-Work Package
- Package: Intensive Accounting Boot Camp
- Package 1: Basic & Fundamental Concepts
- Quiz/Exam for Package 1 - Finance 101
- Quizzes/Exams for Package 1
- Package 2: Core Fundamental Concepts
- Quizzes/Exams for Package 2
- USF - Corporate Valuation Methodologies
- Package 3: Advanced Financial Modeling
- Package 4: Valuation Modeling Topics
- Package 5: Merger Modeling Topics
- Package 6: Leveraged Buyout Modeling
- Package: Technical Applications - Excel
- Package: Private Company Valuation
- Package: Super-Complex M&A LBO Modeling
- Package: Distressed Financial Modeling
- Package: Bank Financial Modeling
- Package: Insurance Financial Modeling
- Package: Real Estate Development Modeling
- Package: REIT Financial Modeling
- Package: Buy-Side Series
- Overview of Financial Markets + Exhibits
- Verification
- Certification
- AIB Add-on
Core Model - Debt Sweep & Model Integration
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
why Revolver is reduced after you put 6000$ in cash in 2006 ? Please answer urgently thank you
why Revolver is reduced after you put 6000$ in cash in 2006 ? Please answer urgently thank you
Show All 1 Replies
Login to Reply
0
by Long N.
added 5 years ago
making cash flow statement and debt sweep into a quarterly model
I am having a hard time trying to figure out how the quarterly debt sweep forecasts should tie into the annual debt sweep forecasts. For example, I think the 4q Cash Before Discretionary Debt Repayment / (Borrowing) should be the same as the fiscal year end number. Same thing with the different de...
Read More
Revolver Priority in Bankruptcy
According to a recent training session that I attended, the instructor repeated that revolvers almost always get paid first before unsecured creditors. But my understanding is that revolvers are normally unsecured, and thus, rank pari passu with other unsecured creditors. Unless the revolving cred...
Read More
Automated S&P Debt Rating
Hello,
I noticed that the models we receive already has the automated S&P ratings for the debt ratios, would it be possible for you to let me know how we can actually implement this automation into excel? For example I want to receive the latest debt ratings ratios as of 2008 or 2009 but I'm n...
Read More
AFM Core Model: pay down down with all excess cash
how do you model in paying down the debt with all excess cash?
AFM Core Model: CPLTDs
I tried to see what woul;d happen if in the model we added another tranche of debt with extra CPLTD. It seems that the ending balance of Long Term Debt comes out wrong ( a negative number). I have tried anything i could come up with but i haven't found the proper solution. Dou you have any idea wha...
Read More
AFM Core Model: mandatory debt payment for commercial paper
Hi, why in the model , we don't have model out the mandatory payments for commercial paper? in cell i28, why the number is zero?
AFM Core Model: Current Portion of LT Debt
Hi, in the "Current Portion of LT Debt" calculation we are considering next year's Mandatory Repayment (line 11). However, if we look at the Mandatory Repayment formula it also includes the Commercial Paper paydown, and the same mandatory repayment cell (line 11) is used to determine the "Current Po...
Read More