Penn Interest: Cash Flow Modeling Using Excel (Part 3: Problem Solution) Video by Brandon Foltz

Pranay Kumar

Aug 5, 17

In this video I walk you though how to set up and solve a cash flow problem in Microsoft Excel using the Solver Add-In. The goal is to manage Penn Interest’s cash flow during an economic downturn. To meet it’s cash flow needs, the business must borrow funds from it’s bank, JK Moregain. Our goals are to 1) maximize the firm’s cash balance ten years from now, 2) meet the firm’s ongoing cash needs, and 3) maintain the firm’s minimum cash balance threshold.

share on ...Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInPin on Pinterest
Posted on Format Video

Leave a Reply