financial model

Dear All, I would like to kindly ask for your assistance on a bottleneck that i am facing the last couple of weeks in excel and can't solve myself. I have attached a simplified version of my model just for illustration purposes in order to make it easier for someone that could assist me. So...

We are to build 5 year financial model and considering to put 3% salary increment every year based on hire date Excel File <- data FOR EXAMPLE Dept Annual Salary Year of service hire date Annual Bonus Taxes Benefits Total Burden oct-20 Nov-20 Support 60000 10.3 11/22/2010 00 7860 1423...

Hi friends I am struggling to build a dashboard which shows quarterly and annual results side by side. I have my detailed sales information in another sheet like this: Column A Column B to Column AZ # of Referrals Month wise data (i.e. the # of referrals...

Hey Guys, Long time lurker, first time poster. I am currently building a 3-way forecast model for a group of 27 Vendors who between them have 54 sites. Each site will require a P&L, BS and CF. I will be consolidating the sites to a Vendor level and then to an overall Group level. I will also be...

Hello Power BI forum! I am trying to develop a PowerPivot based Income Statement report (my previous version is a Power Query table with SUMIFS but that has become extremely slow with 20k records of data - this is mistery to me too) and I cannot figure out how to filter YTD periods with slicer...

Hi good people, I am creating a monthly financial model from Jan-17 to Dec-19. I need help with the rent calculation. In my input sheet I have two inputs for rent 1) Start Date 2) Amount (annual figure) which is paid quarterly. What ever my start date is I want my rent to start on that date and...

I have 24 months in my SaaS financial model and some costs have to charged on annual basis. I am unable to draw a formula that can be applied across all the rows consistently and only give me costs at the end of the year e.g. in months 12, 24, 36, and so on. Similarly, I have to apply a rate at...

Hi, I have a "waterfall" / stream of revenue numbers going across a row in Excel, starting with January 2015. I need to sensitize the model so that I can shift the timing of the start of this waterfall. I would like to build a toggle on my output page which lets me select which month I want...