modelling

I am looking for good Excel online training or Books on : 1) Budgets & forecasts 2) Financial Modelling It would be appreciated if someone could provide me with recommendations

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

Which is the best place to enhance the financial modelling skills? If anybody know please suggest me.

I have a financial model forecast that is based off a number of variables on an input sheet. I'm trying to create a matrix that shows the following: <tbody> Year 1 Year 2 Year 3 Year 4 Year 5 Variable 1 Variable 2 Variable 3 </tbody> In each cell I'd like to calculate...

Hi There I have a three shifts 06:00-14:00- Morning 14:00-22:00- Evening 22:00-06:00- Nights I have a range of times E2 Column such as 18:44 21:49 02:59 06:54 (ect) I want to return in the column next to the time if the time falls in-between the shift times whether its a Morning, Evening...

Am working on a standard leveraged buyout model. Quick question. I am creating a formula on Sheet A ... what is best ... referencing the input cell directly on another sheet (sheet B) or referencing the same value from elsewhere on Sheet A (which the input has already fed into)? What is...

Welcome to ModelOff 2014 - the 3rd Annual Financial Modeling World Championships. After the success of Alex Gordon (NZ) in 2012 and Hilary Smart (UK) in 2013, we're on the hunt for our newest World Champion! If you are or know someone talented in Excel, spreadsheets, and financial modeling...

I am trying to model a future share price, based on: - Dividend per year - yearly volatility (standard deviation) - price -exercise price -risk free rate -Time period I currently have the following equation to predict the daily movement of the share: =J8*(1+NORMINV(RAND(),0,$J$10)) Where J8...

I need to construct a spreadsheet model to simulate these situations for 100 trials assuming, the bulbs’ lifespan follows the Weibull distribution. 1) to change the light bulbs after a certain use time systematically from room to room before they even have the chance to fail. 2) put two...