Developing a 3-statement operating and financial performance model for truck and rail infrastructure business: A case study of a model with automated retirement/reinvestment schedule

Andrey Artemenkov; Omonjon Ganiev; Michael Milgrim

doi:10.24294/jipd.v8i10.6284

Home - JIPD - Volume 8 - Issue 10

Submit to JIPD

Journal Browser

Volume | Year

Issue

• Current lssue

View All

News and Announcements

View All

Developing a 3-statement operating and financial performance model for truck and rail infrastructure business: A case study of a model with automated retirement/reinvestment schedule

Andrey Artemenkov

Omonjon Ganiev

Michael Milgrim

Journal of Infrastructure Policy and Development 2024, 8(10), 6284; https://doi.org/10.24294/jipd.v8i10.6284

Submitted：07 May 2024

Accepted：30 May 2024

Published：26 Sept 2024

Download PDF(1.16M)

Cite

XML

Abstract

This financial modelling case study describes the development of the 3-statement financial model for a large-scale transportation infrastructure business dealing with truck (and some rail) modalities. The financial modelling challenges in this area, especially for large-scale transport infrastructure operators, lie in automatically linking the operating activity volumes with the investment volumes. The aim of the paper is to address these challenges: The proposed model has an innovative retirement/reinvestment schedule that automates the estimation of the investment needs for the Business based on the designated age-cohort matrix analysis and controlling for the maximum service ceiling for trucks as well as the possibility of truck retirements due to the reduced scope of tracking operations in the future. The investment schedule thus automated has a few calibrating parameters that help match it to the current stock of trucks/rolling stock in the fleet, making it to be a flexible tool in financial modelling for diverse transport infrastructure enterprises employing truck, bus and/or rail fleets for the carriage of bulk cargo quantifiable by weight (or fare-paying passengers) on a network of set, but modifiable, routes.

Keywords

References

Access Analytic. (2021). If you’re not Modelling Depreciation like this, you’re doing it the hard way! Available online: https://accessanalytic.com.au/if-youre-not-modelling-depreciation-like-this-youre-doing-it-the-hard-way/ (accessed on 5 May 2024)

Artemenkov, A. I. (2023). A Financial Model Case Study: Creating a Regional Airline. SSRN Electronic Journal. https://doi.org/10.2139/ssrn.4412390

Artemenkov, A., Djalilov, A., & Milgrim, M. (2023). Analysis of the optimal service lives of trucks under EUAC and benefit-based methods: A case-study of a road tanker fleet. Transportation Research Interdisciplinary Perspectives, 21, 100880. https://doi.org/10.1016/j.trip.2023.100880

Avon, J. (2021). The Handbook of Financial Modelling: A practical Approach to Creating and Implementing Valuation projection models, 2nd ed. Apress. https://doi.org/10.1007/978-1-4842-6540-6

Botin, J. (1975). Mathematical model for maintenance scheduling and budgeting of an off-highway truck haulage system, Colorado School of Mines report. Available online: https://www.academia.edu/90870902/Mathematical_model_for_maintenance_scheduling_and_budgeting_of_an_off_highway_truck_haulage_system_A (accessed on 14 June 2024).

Büchel, P., Kratochwil, M., Nagl, M., et al. (2022). Deep calibration of financial models: turning theory into practice. Review of Derivatives Research, 25(2), 109–136. https://doi.org/10.1007/s11147-021-09183-7

Damodaran, A. (2014). Applied Corporate Finance, 4th ed. Wiley.

Efinancialmodels. (2023). Financial models aggregator website. Available online: https://www.efinancialmodels.com/downloads/category/financial-model/transport/trucking/ (accessed on 14 June 2024).

Eng truck and rail. (n.d.). Available online: https://disk.yandex.ru/i/auLPzXNKMzgVmg (accessed on 14 June 2024).

Fang, X., Ansell, J., and Chen, W. (2013). Modelling of a Small Transportation Company’s Start-Up with Limited Data during Economic Recession. Discrete Dynamics in Nature and Society.

Galkin, A., Olkhova, M., Iwan, S., et al. (2021). Planning the Rational Freight Vehicle Fleet Utilization Considering the Season Temperature Factor. Sustainability, 13(7), 3782. https://doi.org/10.3390/su1307378

Goryaeva, I., Goryaeva, E. (2012). Dependency of the costs of spares on the age of the road transport stock. Economics and Management series (Russian). Available online: https://cyberleninka.ru/article/n/zavisimost-zatrat-na-zapasnye-chasti-ot-vozrasta-podvizhnogo-sostava-avtomobilnogo-transporta (accessed on 14 June 2024).

Hilliard W. M. (1985). A Model for Forecasting Transportation Program Cash Flow Transportation Research Record. Available online: https://onlinepubs.trb.org/Onlinepubs/trr/1991/1305/1305-001.pdf (accessed on 14 June 2024).

Kodjak, D. (2011). Global evolution of heavy-duty vehicle fuel economy and GHG regulations. Carbon Management, 2(3), 245–260. https://doi.org/10.4155/cmt.11.25

Loske Dominic. (2020). The impact of COVID-19 on transport volume and freight capacity dynamics: An empirical analysis in German food retail logistics. Transportation Research Interdisciplinary Perspectives, 6, https://doi.org/10.1016/j.trip.2020.100165

Malykha E. F., Ashmarina, T., Sergeyeva, N., Biryukova. T. (2023). Formation of a System for the Disposal of Agricultural Machinery in the Agro-Industrial Transport Complex, Transportation Research Procedia, 68, 870–875. https://doi.org/10.1016/j.trpro.2023.02.123

Rees, M. (2018). Principles of Financial modelling: Model design and Best Practices Using Excel and VBA. Wiley Finance Series.

Pignataro, P. (2013). Financial modelling and Valuation: A practical guide to Investment banking and Private Equity. Wiley Finance Series.

Prievozník P., Strelcová S., Sventeková E. (2021). Economic Security of Public Transport Provider in a Three-Dimensional Model. Transportation Research Procedia, 55, 1570-1577.

Projectionhub. (2023). Financial Projections Template for Trucking Company. Available online: https://www.projectionhub.com/template/trucking-financial-projections-forecast (accessed on 14 June 2024).

Queiroza, C., Mladenovicb, G. (2020). A Review of Tools for Project Financial Assessments. Transportation Research Procedia, 45, 54-61.

Rout, C., Li, H., Dupont, V., Wadud, Z. (2022). A comparative total cost of ownership analysis of heavy duty on-road and off-road vehicles powered by hydrogen, electricity, and diesel. Heliyon, 8(12), e12417.

SharpSheets. (2023). How To Build a Financial Model for a Trucking Business. Available online: https://sharpsheets.io/blog/how-to-build-financial-model-trucking/ (accessed on 14 June 2024).

Sime, M., Bailey, G., Hajj, E. Y., & Chkaiban, R. (2020). Road Load Based Model for Vehicle Repair and Maintenance Cost Estimation. Transportation Research Record. Journal of the Transportation Research Board, 2674(11), 490-497.

Škerlič, S., Sokolovskij, E. (2020). Analysis of heavy truck maintenance issues. Available online: https://www.researchgate.net/publication/342569444_Analysis_of_heavy_truck_maintenance_issues (accessed on 14 June 2024).

Swan, J. (2007). Financial modelling: A Finance and Management special report. Institute of Chartered Accountants of England and Wales.

Swan, J. (2016). Practical Financial Modelling: The development and audit of Cash flow models, 3rd ed. Elsevier.

Tennent, J., & Friend, G. (2011). The Economist guide to Business Modelling. Economist Books.

Wania, S. (2021). Financial Analysis for Logistics Case Study, Financial Analysis Case Study. Available online: https://oakbusinessconsultant.com/case-study-financial-analysis-for-logistics/#14_duka_capex (accessed on 14 June 2024).

The World Bank. (2021) Financial Analysis Training: Transport Infrastructure Finance and Guarantees. Available online: https://www.un.org/ohrlls/sites/www.un.org.ohrlls/files/session_3_financial_analysis_and_modeling_for_transport_projects_presentation_final_0.pdf (accessed on 14 June 2024).

Hassan, M. & Abdull, R., Nurul, L. & Badri Shah, N. (2022). Financial Performance Analysis of Transportation Industry Pre and During Covid 19 Pandemic: A Profitability Approach. Jurnal Intelek, 17, 149-159.

Previous
article in this issue

Next
article in this issue