Three statement modeling help needed

Hi,

I was doing the "Wall Street Prep" three statement modeling course (which is good but was done in 2014), so I tried creating my own Three statement model (for AAPL) with the most up to date 10-K.

Everything was done almost the same EXCEPT, in 2016 10-K Apple (AAPL) didn't include "deferred tax assets" on the balance sheet but the 2014 BS did (which is what WSP included in their model).

I tried doing troubleshoot to no avail. Should I forge "Deferred Tax Assets" altogether? Deferred Tax Liabilities is included though.

What should I do? I've included a screenshot of my model and the BS (link below).

http://imgur . com/a/JZNtb

Thank you,

0 Comments

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%
  • Evercore No 98.8%
  • Morgan Stanley 01 98.3%
  • BMO Capital Markets 13 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 01 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 (80) $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

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...”