Fixed Asset Tracking and Depreciation Calculation In Excel

Chris Benjamin, Instructor, MBA and CFO

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
10 Videos (46m)
    • Course Introduction

      1:41
    • Instructor Introduction

      0:47
    • Headers

      6:30
    • Headers Formatting

      5:09
    • Data Entry Part A

      4:48
    • Data Entry Part B

      6:32
    • Calculations and Entries

      5:36
    • Adding Additional Months

      6:47
    • Adding Additional Categories and Wrap Up

      7:24
    • Course Conclusion

      0:52

About This Class

Template included with course! Learn best practices for tracking assets and keeping a running depreciation schedule

JOIN THE 100'S OF STUDENTS AND COMPANIES I HAVE HELPED IMPLEMENT BEST ACCOUNTING PRACTICES, AND LEARN FROM A PROFESSIONAL CFO CONSULTANT WITH A PROVEN TRACK RECORD FOR SUCCESS!

Three reasons to TAKE THIS COURSE right now!

  1. You get lifetime access to lectures, including all new lectures, assignments, quizzes and downloads I add
  2. You can ask me questions and see me respond to every single one of them thoroughly!  This is an interactive course!
  3. You will are being taught by a professional with a proven track record of success!

Fixed assets are one area of accounting that require very detailed record keeping.  Besides backing up the book value on your financial statements, you need to accurately calculate, book and track your depreciation each period.  The larger your asset base, the more complex this task can become.  Using best accounting practices, in this course we will develop a spreadsheet to track all of the key data points related to your assets, such as date of acquisition, location, depreciation period, net book value, and much more.  

As well I provide the template we build in the course for you to download! If you don't have the time or desire to build your own, you can simply use the fixed asset tracking and depreciation spreadsheet we build in the course and modify it to meet your needs.  

Become a fixed asset expert and accounting wizard with this course!! 

This course is 100% in Microsoft Excel, showing you from start to finish how to build a template to use for fixed asset tracking and depreciation.  Starting with a blank worksheet, by the end of the course we have a fully developed Excel template.  

What We Do In The Course:  

  • Start with teaching basic Excel functionality 
  • Start with a blank Excel workbook which will become our fixed asset spreadsheet
  • Build the proper structure for documenting and tracking fixed assets
  • Format the spreadsheet so it is easy to read and follow
  • Place formulas in to calculate totals where appropriate
  • Show you how to track your fixed assets over time
  • Teach you how to then use that information to make informed decisions
  • And Much More!!!

At any point if you have a question, please feel free to ask through the course forum, I'd be happy to answer any and all questions.  

****************************************************************************************************************************************************

***** Click the button and enroll today!  Let me help you improve your fixed asset tracking and depreciation methods! *****

*****************************************************************************************************************************************************

About The Instructor

Chris Benjamin, MBA & CFO is a seasoned professional with over 20 years experience in accounting, finance, financial reporting, and small business, and employee management.  Having spent the first 10 years of my career in corporate settings with both large and small companies, I learned a lot about the accounting process, managing accounting departments, financial reporting, external reporting to board of directors and the Securities and Exchange Commission, and working with external auditors.  

The following 10+ years I decided to go into CFO Consulting, working with growing companies and bringing CFO level experience to companies.  I help implement proper best business practices in accounting and finance, consult on implementation of accounting systems, implementing accounting procedures, while also still fulfilling the CFO roll for many of my clients which includes financial reporting, auditing, working with investors, financial analysis and much more.  

Thank you for signing up for this course. I look forward to being your instructor for this course and many more!

Chris Benjamin, Instructor, CFO & MBA

7

Students

--

Projects

0

Reviews (0)

Chris Benjamin

Instructor, MBA and CFO