modelling

  1. H

    Excel online Training or Books

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

    Recommendations? building a 3-way model with >240 tabs (possible size issue)

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

    Financial Modelling Skills

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

    Modelling with Multiple Variables

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

    Time ranges in Excel Modelling

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

    Modelling best practice - referencing cells

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

    ModelOff 2014 - starts 25th October!

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

    Financial modelling/monte carlo - predicting share price movement with dividend

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

    Need guidance on Weibull Analysis + modeling

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

Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
Top