IDEAS home Printed from https://ideas.repec.org/a/gam/jjrfmx/v16y2023i3p157-d1084505.html
   My bibliography  Save this article

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

Author

Listed:
  • Davide Baschieri

    (Graf Industries S.p.A., 41015 Nonantola, Italy
    “Marco Biagi” Foundation, University of Modena and Reggio Emilia, 41121 Modena, Italy)

  • Carlo Alberto Magni

    (Department of Economics “Marco Biagi”, School of Doctorate E4E (Engineering for Economics–Economics for Engineering), University of Modena and Reggio Emilia, 41121 Modena, Italy)

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).

Suggested Citation

  • Davide Baschieri & Carlo Alberto Magni, 2023. "The Split-Screen Approach for Project Appraisal (Part II: Spreadsheet Modeling)," JRFM, MDPI, vol. 16(3), pages 1-67, March.
    • Handle: RePEc:gam:jjrfmx:v:16:y:2023:i:3:p:157-:d:1084505
    as

    Download full text from publisher

    File URL: https://www.mdpi.com/1911-8074/16/3/157/pdf
    Download Restriction: no
    File URL: https://www.mdpi.com/1911-8074/16/3/157/
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Carlo Alberto Magni, 2023. "The Split-Screen Approach for Project Appraisal (Part I: The Theory)," JRFM, MDPI, vol. 16(3), pages 1-49, March.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.

      Corrections

      All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:gam:jjrfmx:v:16:y:2023:i:3:p:157-:d:1084505. See general information about how to correct material in RePEc.

      If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

      If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

      If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

      For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: MDPI Indexing Manager (email available below). General contact details of provider: https://www.mdpi.com .

      Please note that corrections may take a couple of weeks to filter through the various RePEc services.

      IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.