When modeling out a PP&E schedule, should you include proceeds from sale of PP&E? I know this would affect the ending balance of PP&E for that period so would you need to show that historically? And would if you do have to include it would you just straight line it for the projected periods?
| +4,018 | Bank of America - Juniors Strike to start Monday May 6th | 422 | 8m | |
| +852 | BOFA ALREADY TRYING TO COVER UP THEIR TRACKS | 79 | 1d | |
| +604 | This is a dark day for Wall Street. | 46 | 14h | |
| +457 | BofA Associate Death - WSJ, FT, CNBC, Bloomberg | 51 | 18m | |
| +191 | How to strike without being fired. | 21 | 19h | |
| +185 | Analyst at Bofa FIG-Thoughts | 28 | 1d | |
| +171 | Big Layoff at Barclays - 5/1/24 | 88 | 1d | |
| +167 | Hey WSJ, BBG, CNBC, FT, it's been more than 72 hours that this BofA IBD Associate was reported dead | 23 | 14h | |
| +153 | BofA List | 37 | 12h | |
| +141 | Reporters, please post your info in this thread for visibility so people can easily reach out. | 4 | 3h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
bump
Yes, you'd reduce PP&E balance by the sale amount.
On balance sheet, PP&E is recorded at its net amount (sometimes you'll see Gross PP&E along with an accumulated D&A to get net PP&E) Therefore,
Net PP&E, end of period = Net PP&E, beginning of period (simply equal to Net PP&E, end of last period) + PP&E-related Capex during the period (maintenance + growth + acquisition) - D&A for the period - asset sales and PP&E write-downs during the period.
The actual cash proceeds from the sale would accrue to Cash Flow from Investing as a positive amount. Cash has no place on the PP&E schedule.
great thank you for the answer. In terms of forecasting PP&E what would I do with the sale of PP&E going forward? Would I just assume it is 0 or would I straight line the previous years sale amount or would I take a % of total PP&E?
If historically the company has been doing sales of PP&E (not sure for what reason...I'd find this strange), then put the average historical amount. Usually it should just be zero.
great thank you. the company is Raytheon btw
Took a quick look at their 10-K Cash Flow from Investing section. Seems like they do a 500-900mm of capex (PP&E) additions every year but their sales of PP&E number is very low (2-40mm). This is expected, as with any business, because sale of PP&E is obviously not their core business as a defense industry contractor (plus if it were truly their core business it would be recorded under the income statement revenues flowing into CFO net income). Therefore, just put down the average of the past 3 years as the future projected sales proceeds of PP&E. Or you can just zero them out completely; this tiny amount compared to net PP&E base of 3bn+ or $30bn annual revenue is negligible.
Dolorum dolorem reprehenderit expedita officiis nisi assumenda qui. Aut accusantium suscipit aut. Est aliquam quia voluptatem laboriosam vitae dicta. Et sunt et perferendis aliquid alias aut.
At voluptatem eos velit quam natus est ratione. Ad aperiam velit nisi et veniam.
Mollitia sunt aut aliquid ut ipsa. Esse officiis quaerat voluptates odio perferendis. Eaque occaecati quasi quibusdam aliquam aut est.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...