p&l

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...

Hello - I’m trying to make a P&L statement from a trial balance in PowerPivot vs. the historical lookup method. In a simple example, this was easy to do in PowerPivot, but now that I’m trying to add in a pairing that needs to occur I cannot create the relationships. In my simple example I have...

I have three different macros that make various format adjustments. 1) intacct_CMA 2) intacct_events 3) Intacct I'm trying to consolidate the three macros into one by using a Select Case Statement based on the Worksheet names. I would like for: - macro #1 to run on the worksheet named...

Hi there I am trying to introduce a toggle in my financial model wherein if the toggle is OFF then a of the business unit's P&L and BS wont be counted towards the consolidated total. I already have the P&L and B&S in the excel and now I have to introduce the IF statement around the driver cells...

I KNOW there's an easier way to do this.... Thanks in advance for looking! Goal: I only want the sub-totals of each CATEGORY in the Income Statement as well as the Total Income. I have an Income Statement I'm reviewing that's 220 lines long. There is currently NO grouping. Below is an...

Hi All, Please help me...... I am looking for an in cell formula to tell me the max value losing streak or drawdown for the the table i have attached the image of. I have search hi and low and can only find vaalue by value drawdown, drawdown against peak value and losing steak by number of...

Hello Excel Experts, I would like to know if there is a way i can automate my P&L savings (Profit and Loss) in excel since currently i am doing it manually. Our P&L date savings calculation is not from Jan to Dec but from Nov 01, 2013 to Oct 31, 2014 for YR 2014 and from Nov 01, 2014 to Oct...

Hi everyone, I'm not too good with Excel and I would greatly appreciate your help with this project. I receive monthly P&L reports from 4 brands . Within each brand, there are 2-3 stores. These P&L reports are individual excel files. My aim is to consolidate all the P&L reports into a single...

I'm having a problem every time my P&L statement updates. This report pulls from 3 tabs (month to date, quarter to date, and year to date). The MTD tab pulls from an outside data source (Cognos) and QTD aggregates that data for every three months, and YTD aggregates for every 12. Everything...

We have built a 5 year financial plan by month. We have cum columns such as year totals for each row. Example, revenues. We also have a cum column titled Cash Flow Positive (CFP) which is the sum of all revenues, spending, and EBITDA from inception to CFP (the last negative number on the...