financial modelling

Hi - I've recently joined a company. We won't be able to implement any robust budgeting and planning tool so we are in excel. There is an extremely tight deadline and I'm just beginning to learn my predecessors excel financial models. from the existing files, I see 5 or 6 workbooks with about...

Hi everyone, how are you? Could I ask you to help me please? I need to calculate automatically 2 things (in the tab "Cost details"): 1/ The P&L impact (taking into account several variables - from cell L13 to cell S13) 2/ the Cash position (cashout) based on payment terms, total cost expense...

Hi everyone, how are you? Could I ask you to help me please? I need to calculate automatically 2 things (in the tab "Cost details"): 1/ The P&L impact (taking into account several variables - from cell L13 to cell S13 2/ the Cash position (cashout) based on payment terms, total cost expense...

Excel Version: Office for Mac 2016 Good day, I have a project that requires three rounds of equity investment (Tranche A, B, and C) and several loans (Loan 1, 2, 3, and 4). The project is expected to start generating a constant income on a monthly basis which will need to be divided in the...

Hi, I have an Okay knowledge of excel but have never used macros before. The workbook I am using currently has a lot of quarterly input data that I need to convert to annual figures. I have updated the formulas throughout for the calculations and outputs across a number of tabs but am hoping...

Hi, I have a huge excel financial model that has not been properly updated and hence I get Div/0 errors frequently. Is there any way to track the "original source/calculation which causes the Div/0 error"? I've been using precedents/antecedents to identify most but this one is particularly...

Hi Unfortunately I don't have any experience with Access and have little knowledge of what databases are capable of. Also my experience with excel is limited and i can only do the most BASIC functions.. so i was really hoping you guys could offer me some advice on whether this thing i need to...

Hello! I am trying to make a mortgage calculator and I'm ok with most of it but I'm hoping someone can help me with something I'm stuck on. I need the user to choose what they are trying to find out. Either they want to find the amount they need to borrow or they want to find out the amount...