Business Functions Library for Excel

      1. Getting Started
      2. Using The Help File
      3. Top Dozen Functions
      4. Golden Rules
      5. Excel 2007
      1. Go To
      2. Function Selector
      3. CalculateFull
      4. Calculate WorkSheet
      5. Trace Facility
      6. Quick Paste Example
      7. Tutorials
      8. Function Finder
      9. Examples
      10. Help
      11. Excel"s Function Wizard
      12. Access Internet
      13. Usage of Functions (Audit)
      14. Uninstall
      1. Time Periods
      2. Inclusive and Exclusive Dates
      3. Using Daycount
      4. Examples of DayCount
      5. Annual Date Sequences
      6. ProjMode and Inclusive Dates
      7. Date Rolling Convention
      1. Rate Projections Functions Walkthrough
      2. Accruals and Cash
      3. Repeating Formulae
      4. Range Names and References
      5. Optional Parameters
      6. Using PmtsPerYear
      7. Modelling Seasonality
      8. Calculating Interest
      9. Using Business Functions in VBA (Visual Basic for Applications)
      10. Array Functions
      11. Volatility
      12. Annual Equivalent Rates
      13. Array Function
      14. Auto Multi Functions
      15. Variable Plurality
      16. GoalSeek
      1. Introduction To the Worked Examples
      2. Daycount
      3. General Projections
      4. Business Plans
      5. Cashbasis And Periods
      6. Using Timebases
      7. Using Dates
      1. How To Generate a time scale for a structured financing
      2. How To Project Rents off a Rental Forecast
      3. How To Run a model on different time bases
      4. How To Isolate The Cause of a Errors in Cells using Trace
      1. Introduction to the Utilities
      2. Audit
      3. Synchronized Range Insert/Delete
      4. Database Edit
      5. Insert Macro Button
      6. Link Analyser
      7. Range Describer
      8. PrintScript (beta)
      9. Create Local Range Name
      1. Number Formats
      2. Apply BF"s Color Palette
      3. Bullets
      4. Color Cells
      5. Conditional Formats
      1. Validation DropDowms
      2. Validation Standards
      1. Select Excel Function
      2. Array Function Tools
      3. Sort Sheets
      4. Range Value
      5. Named Range Manager
      6. Enforce WorkBook Settings
      7. Monte-Carlo
      8. TimeChart
      1. The ".ini" file
      1. Forum
      2. Online Help
      3. Templates
      1. Conversion of Input Strings to Values
      2. List of Holidays
      3. Acknowledgements and Trademarks
      4. Published Editions Changes in Behaviour
      5. Range Handling And Constraints
      6. Dates in Excel and Business Functions
      7. Old Composite DayCount Format
      8. DayCount in Excels"s Functions
      1. NPV of Annual To Periodic CashFlows - CorrectionM
      2. Interest - Simple, Annual, Continous and Discount Factors
      1. New Functions
      2. Obsolete Functions
      3. Discontinued Functions
      4. Deprecated Functions
    How To Project Rents off a Rental Forecast
    1. Set up a Rental Forecast as follows
    • You may want to do your forecast on a separate sheet from your main financial model.
    • Type the start date of your forecast into a cell. You might call this StartFcst.
    • Type the "base" of the forecast, in months, into another cell. You might call this FcstBase.
    • Create the timebase of the forecast, going either horizontally or vertically away from your start date, using the function "=DpM(StartDate,FcstBase)", substituting cell references for StartDate and Fcst Base.
    • In the adjacent column to the list of dates (or row if you are going horizontally across the page), put in your forecast values for each time period. The forecast value becomes effective at the date it corresponds to.
    • You may want to automate the forecast a little by using another Business Function that will uses a series of growthrates to create the forecast. Try GrowQ which accepts as inputs a StartingValue and series of GrowthDates and GrowthRates .
    • You now have a forecast. The next question is how you want to use it.
    2. Refer to the rental forecast in your main financial model
    • You may be using a specific function that accepts a forecast to do the calculations, in which case you just refer to FcstBase, StartFcst and FcstVals (the values in your forecast). As described elsewhere, it helps if these are named ranges. A function you may well be using in a rental context might be one from the Real Estate category, or a general one such as FStepFcst, which gives stepped rent profile where the steps are read off the forecast.
    • Alternatively, you may just have a date for which you want to read a forecast value against. In this case use Fcst, which basically does a lookup on the date you supply.

Business Functions Ltd, London, UK Website Design: Webpure