The Split-Screen Approach for Project Appraisal (Part II: Spreadsheet Modeling)

Davide Baschieri and Carlo Alberto Magni
Additional contact information
Davide Baschieri: Graf Industries S.p.A., 41015 Nonantola, Italy

JRFM, 2023, vol. 16, issue 3, 1-67

Abstract: This paper employs the newly conceived accounting-and-finance engineering system (AFES) described in a previous paper (Magni 2023, “The Split-Screen Approach for Project Appraisal (Part I: The Theory)”), addressed to the analysis of capital asset investments. In this second part, we show how to implement this theoretical framework onto a spreadsheet software. We guide the analyst step by step, cell by cell, to the creation of the Split-Screen Matrices describing the project film. Because the AFES is based on two arithmetic relations (law of motion and law of conservation), we can use a minimal approach to modeling, with a frugal use of the most common spreadsheet functions (essentially INDEX and MATCH) and no use of the traditional financial functions, yet fulfilling the requisite of clearness, transparency, consistency, and ease of use. Starting from the informal description of the project, we build the model by breaking it down to 7 modules. The spreadsheet model is available online (see link provided in the paper).

Keywords: capital budgeting; engineering economics; project; accounting-and-finance engineering system; spreadsheet modeling; financial model (search for similar items in EconPapers)
JEL-codes: C E F2 F3 G (search for similar items in EconPapers)
Date: 2023
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
https://www.mdpi.com/1911-8074/16/3/157/pdf (application/pdf)
https://www.mdpi.com/1911-8074/16/3/157/ (text/html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:gam:jjrfmx:v:16:y:2023:i:3:p:157-:d:1084505

Access Statistics for this article

JRFM is currently edited by Ms. Chelthy Cheng

More articles in JRFM from MDPI
Bibliographic data for series maintained by MDPI Indexing Manager ().