Should CBA use descriptive or prescriptive discount rates? It should use both!

This is an agent based financial market model created in Excel that provides experimental data and calculation capabilities for the paper entitled "Should CBA use descriptive or prescriptive discount rates? It should use both!," the abstract of which is as follows:

Discounting project net flows that exclude financing costs with prescriptive rates fails to reflect costs of capital; discounting them with descriptive rates fails to reflect intertemporal preferences. A hybrid discounting method is proposed whereby descriptive rates are used to forecast costs of capital and prescriptive rates are used to discount all-inclusive net welfare flows. An agent-based capital market model audits the performance of alternative discounting approaches. There is no need to reconcile the discounting approaches. They should be viewed as complementary, not as competing. They are both necessary, and only jointly sufficient to achieve optimality in intertemporal resource allocation.