Hi Thanks for such a good work . I really learned from Financial model perspective . One question is when you calculate depreciation running totals , you only include depreciation in the additions in future year . What about the assets costs and related depreciation of 2000 in 2023 ?
Good question, for 2023 I literally just made up the numbers to focus on explaining modeling future capex and depreciation. In order to account for fixed assets in place as of the first year, I would expand the years in the fixed assets schedule backward to the dates those assets were purchased. Then your virtual depreciation schedule and the measures in this video should all work and account for those.
Dude! I finally found a page to subscribe to that is helpful. I appreciate the gems (ex., formatting all measures at once).
Well explained, Thanks for sharing.
This is really good mate
Thanks a lot !
I am new to BI to bring all FS to Bi . So your videos going to help me a lot , God bless you
These videos are really awesome, thank you! If you have multiple assets, say a chairlift in 2024 and also again 2026, does that change the formulas?
nice
Loving for thr excel file that defines the reporting hierarchy (grouping) for the balance sheet segment.
Let me upload it to the templates area
Hi
Thanks for such a good work . I really learned from Financial model perspective .
One question is when you calculate depreciation running totals , you only include depreciation in the additions in future year .
What about the assets costs and related depreciation of 2000 in 2023 ?
Good question, for 2023 I literally just made up the numbers to focus on explaining modeling future capex and depreciation. In order to account for fixed assets in place as of the first year, I would expand the years in the fixed assets schedule backward to the dates those assets were purchased. Then your virtual depreciation schedule and the measures in this video should all work and account for those.
Sir,do more real world projects