40 second DDTL build

@capital.academy_

40.4K followers · usually 4.6K views a post

Views

58.8K

Likes

3.3K

Comments

42

Shares

874

Selling · Course / Info

Capital Academyseen in 7 videos →capitalacademycourse.com ↗

Why it worked

The video provides a concise and practical demonstration of a complex financial modeling concept (DDTL) using a familiar tool (Excel). The clear on-screen text and step-by-step explanation make it accessible to a target audience interested in finance and modeling.

Summary

This video demonstrates how to build a DDTL (Debt Drawdown and Termination Logic) model in Microsoft Excel. It explains the assumptions and mechanics involved in calculating debt repayment, considering factors like growth capex, exit date, and excess cash.

Structure

1Introduction to DDTL model build
2Setting up drawdown logic and assumptions
3Calculating monthly payments and outstanding debt
4Incorporating exit date and excess cash considerations
5Building annual summaries and refi logic

Product placement

Microsoft Excel: ACTS - it is used to build a financial model. Removing it would change what happens in the video. Capital Academy: ACTS - it is the name of the course being promoted, and the creator's bio link leads to its website. Removing it would change what happens in the video.

Original caption

DDTL Model #fyp #finance #microsoftexcel #financialmodeling

More from @capital.academy_

Their other posts in the index, biggest breakout first.

Call to action

Enroll Today (link in bio)

On-screen text

40 second DDTL build SCHEDULE HERE STARTING WITH THE DRAWDOWN LOGIC WHICH GIVEN THERE'S NO M&A IN THE MODEL HERE WE'LL ASSUME IS ANNUALLY FUNDING NEXT 12 MONTHS GROWTH CAPEX WHILE BEGINNING PERIOD OF AND POSITIVE NUMBERS AT ALL TIMES. OUR AMORT'S GONNA BE THE LESSER OF OUTSTANDING DEBT AND THE MONTHLY PAYMENT WHICH IS 1% OF THE TOTAL DDTL DRAWDOWN TO DATE PAY DOWN MECHANIC THAT CONSIDERS OUR EXIT DATE ASSUMPTION AND ANY ECF STRUCTURE WHILE CONSIDERING ANY EXCESS CASH. AND FULLY TERMINATES THE COMMITMENT IN OUTSTANDING DOLLARS UPON THE ASSUMED EXIT DATE EXIT FLAG UP HEAR IN THE DATE HEADER. OUR ANNUAL SUMMARIES PULLING EXISTING X LOOKUPS FOR BEGINNING AND ENDING OF THE PERIOD DOLLARS AND SEE THE REFI LOGIC IS AND THE COMMITMENTS TERMINATED.

Transcript

3 things girls immediately notice in a guy features that guys have that girls notice immediately of DDTL schedule here starting with the drawdown logic which given there's no M&A in the model here we'll assume is annually funding next 12 months growth capex while beginning period of and positive numbers at all times. Our amort's gonna be the lesser of outstanding debt and the monthly payment which is 1% of the total DDTL drawdown to date pay down mechanic that considers our exit date assumption and any ECF structure while considering any excess cash. and fully terminates the commitment in outstanding dollars upon the assumed exit date exit flag up hear in the date header. Our annual summaries pulling existing X lookups for beginning and ending of the period dollars and see the refi logic is and the commitments terminated.