Financial Model, Financial Services, General Excel Financial Models

10-year Financial Projections, 5-year Financial Projections, Accounting, Cap Rate (Capitalization Rate), Consolidation, Financial Analysis, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Reporting, Financial Statements, Income Statement, Project Finance, Property Valuation, Real Estate Valuation

– When building a financial model, rent cost is one major component in your financial projections.

– With the introduction of IFRS-16, projected income statements have shown a different split in expenses between rent, depreciation, and interest costs.

– With the adaptation of the standard in financial statements, even retroactively in many cases, it has become a requirement that financial models incorporate and apply IFRS-16 in all projections.

– This module allows for a transition to use IFRS-16 in both accounting records and business planning on the corporate level. This will allow measurement of the impact of IFRS-16 implementation retroactively and going forward on a company’s financials.

TIMELINE:
Monthly Periodicity for 180 months (15 years)
Annual Summary Output
Flexibility for financial year-end

CAPACITY
Model periodicity is monthly
Model timeline spans up to 15 years (180 months)
Up to 40 properties can be incorporated

CALCULATIONS
Timeline Flags and applicable discount factors
Present Value calculations for each property
Right-of-use Assets calculation [for balance sheet]
Right-of-use Liability calculations [for balance sheet]
Split of Short-term vs. Long-term ROU liabilities
Interest component calculation [for income statement]
Rent component calculation [for income statement]
Depreciation calculation [for income statement]
Consolidated Annual Summary

AUDIT
Full amortization of ROU Assets/Liabilities over the lifespan of the property.

You must log in to submit a review.