
Package 3: Advanced Fina...
 WST Free Trial  Professional Development
 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)
 JPMAM 2015 Excel Exam
 JPMIM 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 PreWork 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: SuperComplex 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: BuySide Series
 Overview of Financial Markets + Exhibits
 Verification
 Certification
 AIB Addon
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 1 year 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