Quick Links
Home
. . Introduction
. . Why Business Functions
. . Whats New
. . For Property People
. . . . Why For Property
. . . . PCS Seminar
. . Why Free
. . Awards
. . Key Users
. . Forum
. . Excel 12
Products
. . Overview
. . Business Functions
. . . . Summary
. . . . Function Selector
. . . . Function Finder
. . . . Trace
. . . . Help
. . . . Function Examples
. . . . Tutorials
. . . . Monte Carlo
. . . . GoalSeek
. . . . Utilities
. . . . Callable from VBA
. . . . Array Functions
. . . . CashFlow Administrator
. . . . Select Function
. . . . Number Formats
. . . . Functions Overview
. . CashFlow Administrator
. . SelectFunction
. . NumberFormats
Services
. . Services Overview
. . Bespoke Model Development
. . Implementation Assistance
. . Custom Editions
Download
Reference
. . Rent From family
. . . . FStepRent
. . . . FStepRentGrow
. . . . FStepRentFcst
. . . . FStepRentFcstCollar
. . Function Categories
. . Function Families
. . Data Types
. . Variables
. . Topics
. . Features
. . Version History
. . Technical
Forum
Templates
. . Templates Home
. . Loans
. . Interest Rates
. . Finance
. . Budgeting
. . Math and Stats
. . Dates
. . Accounting
. . Real Estate
. . Real Estate (UK Specific)
. . Petroleum Economics
. . Techniques
. . Non Business Functions
Resources
. . Resources
. . Bookshop
. . Support
. . Tips & Articles
. . . . Tips
. . . . Business Functions
. . . . Excel
Company
. . Company
:: Reference
:: Rent From family
:: FStepRent
Home
Introduction
Why Business Functions
Whats New
For Property People
Why Free
Awards
Key Users
Forum
Excel 12
Products
Overview
Business Functions
CashFlow Administrator
SelectFunction
NumberFormats
Services
Services Overview
Bespoke Model Development
Implementation Assistance
Custom Editions
Download
Reference
Rent From family
Function Categories
Function Families
Data Types
Variables
Topics
Features
Version History
Technical
Forum
Templates
Templates Home
Loans
Interest Rates
Finance
Budgeting
Math and Stats
Dates
Accounting
Real Estate
Real Estate (UK Specific)
Petroleum Economics
Techniques
Non Business Functions
Resources
Resources
Bookshop
Support
Tips & Articles
Forum
Company
Rent From family
Summary
FStepRent
FStepRentGrow
FStepRentFcst
FStepRentFcstCollar
[Categories]
[Families]
[Data Types]
[Variables]
[Topics]
FStepRent
(
Time
,
Base
,
BrksOrExp
,
FromDates
,
AnnRents
, [
DayCount
], [
Periods
], [
ProjMode
], [
Brk
])
Stepped Rent using review dates that specify when rents change, where the dates are
FromDates
rather than "up until" dates
Pro
Auto Array Function
Features
F...
Rates pertain to the time
after
each corresponding
from
date
Step...
Has a stepped rate profile
Example
FStepRent.xls
Templates
This function features in the following downloadable spreadsheet template(s):
loan_property.xls
Any comments on this documentation? Send us your suggestions below.
Your Email Address (required)
Subject
Message
500