Trumped-Up Development: Investment Capital Allocation using Excel

In this video I walk you though how to set up and solve a simple capital allocation problem in Microsoft Excel using the Solver Add-In. The goal is to allocate the firm’s capital in a fashion which maximizes the investment’s net present value while adhering to cumulative capital limits within the firm.

The post Trumped-Up Development: Investment Capital Allocation using Excel appeared first on Advance Innovation Group Blog.

Source: Advance Innovation Group Blog

Leave a Reply

Your email address will not be published. Required fields are marked *