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...
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:
In each cell I'd like to calculate...
I have a three shifts
I have a range of times E2 Column such as
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)
-risk free rate
I currently have the following equation to predict the daily movement of the share:
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...