The spreadsheet model is available online (see link provided in the paper). ![]() Starting from the informal description of the project, we build the model by breaking it down to 7 modules. ![]() 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. We guide the analyst step by step, cell by cell, to the creation of the Split-Screen Matrices describing the project film. In this second part, we show how to implement this theoretical framework onto a spreadsheet software. 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.
0 Comments
Leave a Reply. |