A user is looking for a way to create a model that quantifies the cash flow impact of various investments, including leases and loans, to better understand financial overlaps and government incentives. This feature would help finance teams manage complex cash flow scenarios more effectively.
Hi guys! I have just started working for a small company that does not have a financial structure. Since I have a degree in economics and finance, everything related to corporate finance is handled by me and my boss. I was given a task and I’m currently stuck, so I would like to ask for your help. The company is planning to make several investments: new vehicles (through financial leasing), a corporate acquisition (financed for most of the amount through a bank loan), and the purchase of an SAP management system. What I would like to create is a model to quantify the impact of all these expenses on cash and cash flow, in order to understand the following: which months will be the heaviest, considering that existing leases, new leases, the monthly loan repayment installment, and another monthly repayment for a different loan will all overlap. Another aspect I should consider is specific government incentives from my country, which are credited to the tax account a few months after the financing is granted. In the image I included two different models that I created, but it seems to me that I’m completely getting the logic wrong because I’m mixing debt repayment with lease repayment. In short, I’m very confused and I don’t know how to proceed. Please help! P.S! I am assuming that the **change in working capital is zero** because we use **factoring and collect payments immediately**. https://preview.redd.it/dig8uvb5ofog1.png?width=1886&format=png&auto=webp&s=e5c2c6fd9578f7a2a2bc10849a4fc33917977c98 https://preview.redd.it/b1ekp9ugofog1.png?width=1830&format=png&auto=webp&s=e6798848d3b5670118d0329489820fbd3b16cfc5