Creating Fixed Assets Registers

In this video, I show you how to create fixed assets registers using about 7 Excel functions. You learn how these Excel functions work and how they can be used to create fixed assets resisters.

#fixedassets #microsoftexcel #financialmodeling

📈 Get Personalized Training and Financial Modelling Expertise! 📊

Are you looking to enhance your financial planning and Excel skills?
Need a professional to handle your financial modeling tasks? I'm here to help! Contact info below

👨‍🏫 One-on-One Training:
I offer personalized, one-on-one hourly training sessions to help you master Microsoft Excel and financial modeling. Contact info below

📊 Financial Modelling Services:
Need assistance with financial modeling?
With over 15 years of experience in financial planning and analysis, I can provide you with top-notch financial models to support your business decisions. Contact info below

🌍 Open to Remote Work:
I am available for remote work opportunities in Operations Management, Business Intelligence, and Financial Analysis. Let's collaborate to achieve your business goals!

📚 Join My Email List:
Interested in hands-on guided practice in Microsoft Excel, Data Analysis and Financial modeling? Join my email list

📧 Contact Me:

WhatsApp: [phone]

Don't hesitate to reach out for more information or to schedule a session. I look forward to working with you!

[H-dotr]

Great tutorial!
Speaking about the disposal, what about if I want to dispose a part of an asset amount not an entire asset?

[miwbuneman]

Thank you so much Charles. This is quite in details covering all possible scenarios and easy to understand/work with.

[enochtamakloe]

Thank you for this very insightful tutorial. Please can you help on how to build the 'List sources' on the second tap?

[peteriruogu]

I appreciate the informative video. Currently, I'm experiencing problems with the index formula as it doesn't capture the total amount for a specific asset class, eg for furniture and fittings. The index formulae seems to be missing some asset values when calculating the gross black for the same asset asset class on different rows

[alibasureaidah]

Thank you for this tutorial, I hope if make some development wit use SLN Deprecation method

[vTechUBDev]

Thank you for this. How do you treat additions made within the year and disposal

[tungam]

Its good, simple and logical. Only focuses on straight line depreciation and also left out the formula to remove the disposed asset from the "gross block". As it is it will still be overstating that total.

[mohamedaden]

Thank you for this. Which formula will be used to add up multiple items in the same class in the summary table? and how would you treat Gains/losses on Disposal?

For Example, if I have 3 Motor Vehicles in the Fixed Asset Register and want to show their summary as a total value, total Acc.depn and total net book value since they are in the same class.

[sday]

Hi - Trying to do the Gross Block - the formula only calculates the first row of figures and not the 10 ( I have 11 rows of assets) any ideas ??

[emmanueliyanuoluwa]

This is really helping, Thanks really for this.

Pls can you forward me the link to get this document??

[ravindharmadas]

What is the Report Date and how do I know about the Report Date

[kaluanyim]

Thanks for the insightful tutorial, Sir. Can the formula be adjusted to depreciate for a full year irrespective of the purchase date of the asset?

[martiesouthey]

WHAT IS THE DEPRECIATION PERCENTAGEES FOR EACH CATEGORIES PLEASE

[accountsaccounts]

Thanks Charles this is brilliant. Please help should I want my accumulated depreciation on 01 Jun 20 to include the accumulated depreciation of the asset disposed on 31 Mar 20, how do I go about it.

[dabbahprosperprince]

Is a good practical PPE register. I tried it but released that the depreciation per day is not zero when the asset reached its useful life. Therefore push the lapse days more than the uesful life days abd the net effect is in negative

[iyaboishola]

To get the end date I can't get the answer, is showing #Value

[sikofrederic]

Merci beaucoup pour la vidéo. Please can you send me the file?

[brandsouqriyadh]

please text sumif formula apply in gross block

[sindhujamilkuri-kc]

What is the Report Date and how do I know about the Report Date