3 Statement Financial Modeling - Property, Plant, and Equipment model - Step 4

This video is part of a 10-part FREE video series which simulates the valuation training investment bankers go through on their first few weeks of work. Over the series, you will learn to build a full 3-statement financial model which is fully 'balancing' (the different financial statements communicate with each other based on a set of inputs and assumptions).

You will learn a wide variety of skills needed to become a financial analyst - you will learn excel skills, basic accounting skills, basic valuation skills, and modeling techniques!

To follow along, download the excel models here:

Completed model:

Starting model:
-------------------------------------
This video covers how to build your property, plant, and equipment schedule

[dipindersingh]

I think the reason for different dipreciation in income statement and in cash flow is because of Ammortization is being added in one place

[HenryEdward]

Hi Ezra, thanks very much for your video. A quick question, if I may. If I add the net value of (CapEx - Depreciation) from 2014, to the value of PP&E at the end of 2013, there is a discrepancy of about 30, 000. I’ve noticed discrepancies in other companies’ financial statements as well. Please could you explain how the new values of PP&E are calculated and why there is this discrepancy? Many thanks in advance.

[himankjoshi]

Can you help me understand from where did you reference CAPEX straight away from the cash flow statement ?

[vickyvidre]

Dep as % of sale look wrong as there is no relation between sale & Dep