How to deal with VAT calculation in the models

Since companies are obliged to transfer value added tax they collect on their products (assume 20%), we don't take into account them in the models and just calculate revenues without VAT as there is no any cash flow effect for the company except the timing of cash flows. However, usually the expenses we use in the models are with VATs and company can actually use them to reduce the amount of collected VATs that they would need to transfer to tax authorities and do netting, causing discrepancy in the financial models. How do you deal with this problem since we literally can't know which of company expenses are with VAT or not? Thanks.

2 Comments
 

Hi torres657, any of these threads helpful:

  • Notes for Technical Interview Questions oil reserves or book value, depending on the industry and situation How do you do a DCFF?- First model ... forecast, you find the Free Cash Flow to Firm in each year: + EBIT- Tax on EBIT- Capex + Depreciation ... value o For this purpose, you would combine the Terminal Value with the
  • Forget excel models, just use a pocket calculator to do your valuations! Being the eager beaver intern, I quickly started to look into the company's financials, research ... value the company. After some elbow grease I produced the standard football field to present to my VP, ... I am interning with a boutique corporate advisory firm in an APAC emerging market when I saw this
  • Value and Taxes: Breaking down the Pfizer- Allergan Deal its growth rate, at the time that you initiate the deal to be able to walk away with value added. Note ... With state and local taxes, it amounts to close to 40% in 2015. The rest of the world has moved away ... with a global
  • Why subtract cash when we calculate Enterprise Value cash and debt is then added to market capitalization to produce the enterprise value. enterprise value ... decide to pay yourself a dividend with the remaining $3 in cash on the company's books. So you pay ... Why do we subtract cash when calculating enterprise value? Sh
  • What's the deal with 'modelling skills'? my fair share of models from the baby ones where you click a few buttons in SPSS or something to the ... Ok, so after almost 2 years in S&T I looked at my first I-Banking 'operating model ... numbers, added and subtracted together with a few toggles. That generally say 'yes' and ...
  • How do you all deal with anxiety or stress? constant anxiety. How do you guys deal with this? to Saturday, February 10, 2018- 1:55pm Off Topic Forum ... Consulting Case Interview Questions Financial Modeling Templates Professional Resume Review Career Coach for ... Going through a bad moment for university, internship and so on, so Im pretty stressed out with ...
  • Finance Interview Questions and Answers | Wall Street Oasis The final cash flow in year N will be equal to the sum of the terminal value calculation and the final ... is added to retained earnings from the prior period's Balance Sheet to come up with retained ... depreciation expense affect each of the three
  • More suggestions...

Maybe one of our professional members will share their wisdom: Jarbiksaro Tristan-Freeman cwambua

If those topics were completely useless, don't blame me, blame my programmers...

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

Doloribus qui ea quis harum in. Facere fugit modi nesciunt unde sint inventore aut. Non sunt quod totam necessitatibus odit eaque et.

Quam eligendi delectus non sit harum adipisci ipsam. Architecto dolorem accusantium omnis eius praesentium.

Molestiae quo quidem quaerat nemo. Saepe sed consequuntur et consequatur quidem assumenda animi. Vel illum et et tempore sequi est distinctio. Molestiae voluptate sequi sit beatae id. Id et laborum aut qui est. Illum debitis harum dicta. Nulla similique at aliquam ea sit est ad fugit.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.3%
  • BMO Capital Markets 12 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan No 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (79) $150
  • Intern/Summer Analyst (73) $101
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
DrApeman's picture
DrApeman
98.9
6
GameTheory's picture
GameTheory
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Mimbs's picture
Mimbs
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...”