Infra Model DTA Modeling

Does anyone have a template of a three statement model specifically with deferred tax asset / liability built in? I can’t get this thing to balance and figure it may be helpful to take a look at a sheet with the coding built in to see what I’m doing wrong

3 Comments
 

Based on the most helpful WSO content, here are some steps and resources that might help you with your three-statement model, specifically with deferred tax assets (DTA) and liabilities (DTL):

  1. WSO Elite Modeling Package: This package includes comprehensive courses on financial statement modeling, which can help you understand the intricacies of DTAs and DTLs. It covers:

    • Financial Statement Modeling
    • DCF
    • M&A
    • LBO
    • Comps
    • Excel Modeling
  2. Free Financial Modeling Lessons: WSO offers 9 free financial modeling lessons taught by experienced private equity professionals and bulge bracket investment bankers. These lessons include:

    • Financial statement modeling
    • DCF
    • M&A
    • LBO
    • Comps
    • Excel Modeling
  3. Templates: The WSO platform provides 27 financial modeling templates in a swipe file, which can be very useful for understanding how to integrate DTAs and DTLs into your model.

  4. Community Help: You can also reach out to the WSO community for specific advice. For example, in the thread titled "Help with 3-Statement Model Test," a user mentioned having trouble with a balance sheet not balancing and received help from others in the community.

  5. Private Equity Resume Template and Stock Pitch Template: These templates might not directly address DTAs and DTLs but can provide a structured approach to financial modeling.

If you need more specific help, you might consider posting your detailed question in the WSO forums where experienced professionals can provide targeted advice.

I'm sorry, but it looks like this may be out of my ability to answer... maybe some of the links below might help?

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 

Officia eos similique voluptatem. Inventore iusto magni aut dicta accusantium et. Sed velit accusamus aut voluptatem numquam quaerat.

Rerum aut distinctio deleniti et eaque ipsam ex. Voluptas quibusdam dolor aut error non ut fugit. Neque esse nihil maxime ut doloremque at quos.

Excepturi quis reprehenderit dolor sed dolore. Et sed temporibus qui et at et omnis.

Molestiae incidunt facere et eaque. Est laborum nesciunt vel aliquam. Est deserunt dolor aliquam illo vitae. Blanditiis sit magni vero quaerat quia debitis.

Career Advancement Opportunities

June 2026 Private Equity

  • The Riverside Company 99.6%
  • Blackstone Group 99.3%
  • KKR (Kohlberg Kravis Roberts) 98.9%
  • Warburg Pincus 98.5%
  • Bain Capital 98.1%

Overall Employee Satisfaction

June 2026 Private Equity

  • Blackstone Group 99.6%
  • KKR (Kohlberg Kravis Roberts) 99.3%
  • The Riverside Company 98.9%
  • Ardian 98.5%
  • Starwood Capital Group 98.1%

Professional Growth Opportunities

June 2026 Private Equity

  • Bain Capital 99.6%
  • The Riverside Company 99.3%
  • Blackstone Group 98.9%
  • Starwood Capital Group 98.5%
  • KKR (Kohlberg Kravis Roberts) 98.1%

Total Avg Compensation

June 2026 Private Equity

  • Principal (9) $653
  • Director/MD (24) $547
  • Vice President (98) $365
  • 3rd+ Year Associate (104) $281
  • 2nd Year Associate (235) $272
  • 1st Year Associate (411) $229
  • 3rd+ Year Analyst (33) $157
  • 2nd Year Analyst (97) $134
  • 1st Year Analyst (272) $124
  • Intern/Summer Associate (38) $81
  • Intern/Summer Analyst (355) $62
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.9
10
Linda Abraham's picture
Linda Abraham
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”