"Az-buki" National Publishing House
Ministry of Education and Science
Facebook
Wikipedia
Mathematics and Informatics
Няма резултати
Вижте всички резултати
  • Home
  • Editorial Board Members
  • Contents
  • Guidelines
    • Guide for Authors
    • Reviewer's Guide
  • Publishing Ethics
  • Contact
  • Subscribe now
  • Home
  • Editorial Board Members
  • Contents
  • Guidelines
    • Guide for Authors
    • Reviewer's Guide
  • Publishing Ethics
  • Contact
  • Subscribe now
Няма резултати
Вижте всички резултати
Mathematics and Informatics
Няма резултати
Вижте всички резултати
Home Uncategorized

Excel’s Calculation Of Basic Assets Amortisation Values

in Uncategorized

Vehbi Ramaj 1), Prof. Dr. Sead Rešić 2), Anes Z. Hadžiomerović 3),
Samira Aganović 2)
1)University of “Haxhi Zeka” – Peja (Kosovo)
2)University of Tuzla (Bosnia and Herzegovina)
3)Second Gymnasium Mostar (Bosnia and Herzegovina)

https://doi.org/10.53656/math2021-5-4-exs

Abstract. For Excel’s calculation of basic (fixed) assets amortisation values, the investigated economic and mathematical foundation with required values and their relations were used. The investigated and introduced theory is adapted to Excel calculations of fixed assets amortisation based on today’s needs. All values for Excel’s calculations are sorted into input and output values, and input to main and nested calculations. Two methods for calculating fixed assets amortisation were introduced using Excel. The first method is based on a linear decreasing function,
G(t) = G0 (1-pt), which presents the simple interest calculation of the reduced equities for equal periodic amortisation values. The second method is based on the exponential degrading function, G(t) = G0qt, which presents a complex interest calculation of the reduced equities for periodic amortisation amounts in a descending sequence. The continuity of the introduced functions results from the continuity of: the life of the fixed asset, periodic amortisation, accumulated amortisation and non-amortized amount (residual value) of the fixed asset. It is particularly important to introduce dates with the exact time, for the beginning and the end of each amortisation period of the fixed asset. The theory for Excel’s calculation of the fixed asset output values for an arbitrary (planned or unplanned) term has also been explored and introduced. Such calculations relate mainly to terms of alienation, permanent damage, permanent loss of the process function of a fixed asset and periodic accounting reporting.
Keywords: asset; values; amortisation

Log in to read the full text
shareTweetshare
Previous article

PREPARATION FOR THE XXV YOUTH BALKANIADE IN MATHEMATICS 2021

Next article

AUGMENTED REALITY IN ONLINE TEACHER TRANING FOR DIGITAL COMPETENCE

Next article

AUGMENTED REALITY IN ONLINE TEACHER TRANING FOR DIGITAL COMPETENCE

Educational Environment As A Form For Development Of Math Teachers Methodological Competence

ORGANIZATIONAL MODEL FOR PEDAGOGICAL PRACTICES OF INFORMATICS AND IT

Последни публикации

  • Annual Contents of Mathematics and Informatics, vol.65/ 2022
  • Mathematics and Informatics, Number 6/2022, Volume 65
  • Mathematics and Informatics, Number 5/2022, Volume 65
  • Mathematics and Informatics, Number 4/2022, Volume 65
  • Mathematics and Informatics, Number 3/2022, Volume 65
  • Mathematics and Informatics, Number 2/2022, Volume 65
  • Mathematics and Informatics, Number 1/2022, Volume 65
  • Годишно съдържание на сп. „Математика и информатика“, 2021 г.
  • INFORMAL LINGUISTIC TOURNAMENTS
  • Mathematics and Informatics, Number 6/2021, Volume 64
  • Mathematics and Informatics, Number 5/2021, Volume 64
  • PREPARATION FOR THE XXV YOUTH BALKANIADE IN MATHEMATICS 2021
  • THE 17TH ZHAUTYKOV OLYMPIAD IN MATHEMATICS, PHYSICS AND COMPUTER SCIENCE
  • Mathematics and Informatics, Number 4/2021, Volume 64
  • Mathematics and Informatics, Number 3, Volume 64
  • Mathematics and Informatics, Number 2/2021, Volume 64
  • Mathematics and Informatics, Number 1/2021, Volume 64
  • Annual contents of Mathematics and Informatics, 2020
  • Mathematics and Informatics, Number 6/2020, Volume 63
  • Mathematics and Informatics, Number 5/2020, Volume 63
  • Mathematics and Informatics, Number 4/2020, Volume 63
  • Mathematics and Informatics, Number 3/2020, Volume 63
  • Accsess to public information
  • Условия за ползване
  • Профил на купувача

© 2019 "Az-buki" National Publishing House

Няма резултати
Вижте всички резултати
  • Home
  • Editorial Board Members
  • Contents
  • Guidelines
    • Guide for Authors
    • Reviewer's Guide
  • Publishing Ethics
  • Contact
  • Subscribe now

© 2019 "Az-buki" National Publishing House

Login to your account below

Forgotten Password? Sign Up

Fill the forms bellow to register

All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In
en_US
bg_BG en_US