INTERNACIONALNI UNIVERZITET TRAVNIK U TRAVNIKU
EKONOMSKI FAKULTET TRAVNIK U TRAVNIKU
PRAVNI FAKULTET TRAVNIK U TRAVNIKU
FAKULTET ZA MEDIJE I KOMUNIKACIJE TRAVNIK U TRAVNIKU
u saradnji sa
MIT UNIVERZITET SKOPLJE, SJEVERNA MAKEDONIJA
VEVU, VELEUČILIŠTE LAVOSLAV RUZIČKA U VUKOVARU, HRVATSKA
VELEUČILIŠTE VIMAL, SISAK, HRVATSKA
CKKPI, TRAVNIK, BOSNA I HERCEGOVINA
organizuju
31. MEĐUNARODNU KONFERENCIJU
EKONOMSKE, PRAVNE I MEDIJSKE INTEGRACIJE BOSNE I HERCEGOVINE I ZEMALJA ZAPADNOG
BALKANA KAO KLJUČNI POKRETAČ EUROPSKIH VRIJEDNOSTI
12. – 13. decembar 2025. godine
Faculty of Science, Department of mathematics, University of Tuzla, Bosnia and Herzegovina , Tuzla , Bosnia and Herzegovina
Business Faculty, University of "Haxhi Zeka" Peja, Kosovo , Peja , Kosovo
Business Faculty, University of "Haxhi Zeka" Peja, Kosovo , Peja , Kosovo
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's calculations of fixed assets amoritisation based on today's needs. All values for Excel's calculations are sorted into input and output, and input to main and nested. 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 amortisationvalues.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 stems 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.
The statements, opinions and data contained in the journal are solely those of the individual authors and contributors and not of the publisher and the editor(s). We stay neutral with regard to jurisdictional claims in published maps and institutional affiliations.
