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.
Posted on Format Video