Investments Mgmt.

17.00 €
35.00 €
Excel course/files short description

Excel Investments Management Template.

Excel course/files description


This Excel spreadsheet (template) is intended to assist in tracking an organization's investments and annual depreciation estimates. You can plan and monitor investments by project, such as procurement of hardware and software for implementing IT system, investment property, cleaning machines, kitchen equipment, and electrical installations…

You can also track investments by cost centers and suppliers.

The Excel template includes the following reports:

  • List of investments by years of acquisition, as data are entered for several years, the history of data is preserved,
  • List of investments by projects,
  • List by accounts and account groups,
  • Calculation of annual and monthly depreciation based on the depreciation rate,
  • Depreciation calculation by months in the year of purchase,
  • Calculation of the number of years of depreciation.

You can also create your own report.

Suggestion: Add the labor cost from the Task Management template ›  to the project investment cost, and you will get the full cost of the project.


YOU WILL GET THE FOLLOWING FILES IN ZIP FORMAT:
Excel Files are in English and Slovenian languages.

EN
Investments.xlsm (in ZIP archive).

SLO
Investicije.xlsm

Recommended: for users who want to make their work with Microsoft Excel easier and better

For: Microsoft Excel 2016, 2019, 2021, and Microsoft Office 365.