Please register (it's free!) or login to view the remaining preview.

If you are logged in, your referral link [?] is automatically included below.

EMBED CODE (Copy and Paste)

BENEFITS OF DOCUMENT

For Revenue calculation, Gross Developed Area is assumed to be Leased or Sold. User can switch between the scenarios from Dashboard Sheet and correspondingly see its impact on the Financials and Key KPI's.
Project IRR & NPV
Equity IRR & NPV

DOCUMENT DESCRIPTION

Commercial Real Estate - Lease or Sell Quarterly Excel Model with 3 Statements, Valuation and Development & Operations Phase

Project finance is the financing of long-term infrastructure and industrial projects based upon a complex financial structure. Both project debt and equity are used to finance the project. Debt is repaid using the cash flow generated by the operation of the project, rather than other resources of the project owners.

Project Finance Model is built for a proposal to construct a commercial space in the Middle East with a Gross Leasable Area of half a million sq.f. The financial model is built with a quarterly timeline considering construction for 2 years and the operations period for 8 years.

This model includes the Following scenarios:

1. For Revenue calculation, Gross Developed Area is assumed to be Leased or Sold. User can switch between the scenarios from Dashboard Sheet and correspondingly see its impact on the Financials and Key KPI's.

2. For Cost calculation, a maintenance contract for Gross Developed Area can be assumed to be given to a single contractor with a bucket rate or specialized service providers to control cost. User can switch between the scenarios from Dashboard Sheet and correspondingly see its impact on the Financials and Key KPI's.

3. Project Output includes:

3.1 Project IRR & NPV
3.2 Equity IRR & NPV
3.3 Minimum and Average DSCR
3.4 Equity Payback Period
3.5 Cash Waterfall
3.6 Debt Service Profile

This model will help you in understanding and Modeling of:

1. Flexible capital structuring
2. Construction standby facilities
3. DSRA reserve provisions
4. Lender covenants
5. Complex cash waterfalls
6. Project finance ratios: DSCR
7. Project and Equity IRR

The model is ideal for those looking to achieve the following:

1. Refresh their financial modeling skills
2. Gain an understanding of leading approaches towards financial modeling, in order to build models that are robust and user-friendly in nature.
3. Extend their toolkit for modeling more complex areas of a project finance model in an efficient and flexible manner
4. Understand the very basics of Project Finance

Note:

This model contains Macros to break circularity which arises from the calculation of Interest During Construction, Bank Fees during the construction phase, and Overdraft drawdown (during operations phase). The objective behind macro is to run the exact calculation for loan drawdown in a project finance model as these are critical calculations and are followed closely by banks and financial institutions during negotiations. The macro can be run using the Optimization button available on the Dashboard. The Macro is stored in Module 1 of the VBA Project under VBA Basic Editor.

Important Technical Specifications:

The following are important technical specifications that you need to keep in mind before purchasing this model template:

1. Model uses Macros (VBA). To run model optimally, keep macros enabled. In case you do not like Macros, you could manually disable or remove the Macros and will have to rework the model's logic to be used without Macros but it is not recommended by the author.

2. Model is built using Microsoft Excel 2010 version.

3. We advise not to delete or insert rows and columns into the model if you are not aware of the model structure as it can distort model functioning. If you need assistance with customizing the model template, the author is more than willing to help you.
4. Model uses Cell Styles

5. File type is .xlsx

Got a question about the product? Email us at [email protected] or ask the author directly by using the form to the right. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Commercial Real Estate - Lease or Sell Quarterly Excel Model Excel document

Commercial Real Estate - Lease or Sell Quarterly Excel Model

Sold by Fin-Wiser Advisory (this author has 35 documents)

$99.00

ALL FEES INCLUDED

Add to Cart

This business document is categorized under the function(s):

Corporate Finance Strategy, Marketing, & Sales

It applies to Real Estate

File Type: Excel (xlsm)

File Size: 1.7 MB

Related Topic(s): Integrated Financial Model Real Estate

Purchase includes lifetime product updates. After your purchase, you will receive an email to download this document.

This product contains a supplemental DOCX document.

Initial upload date (first version): Nov 3, 2020
Most recent version published: Nov 4, 2020

Ask the Author a Question

Must be logged in Click here to log in

CUSTOMER TESTIMONIALS

"I like your product. I'm frequently designing PowerPoint presentations for my company and your product has given me so many great ideas on the use of charts, layouts, tools, and frameworks. I really think the templates are a valuable asset to the job."

– Roberto Fuentes Martinez, Manager at Technology Transformation Advisory

"The wide selection of frameworks is very useful to me as an independent consultant. In fact, it rivals what I had at my disposal at Big 4 Consulting firms in terms of efficacy and organization."

– Julia T., Consulting Firm Owner (Former Manager at Deloitte and Capgemini)

"As a niche strategic consulting firm, Flevy and FlevyPro frameworks and documents are an on-going reference to help us structure our findings and recommendations to our clients as well as improve their clarity, strength, and visual power. For us, it is an invaluable resource to increase our impact and value."

– David Coloma, Consulting Area Manager at Cynertia Consulting

"Flevy is our 'go to' resource for management material, at an affordable cost. The Flevy library is comprehensive and the content deep, and typically provides a great foundation for us to further develop and tailor our own service offer."

– Chris McCann, Founder at Resilient.World

"FlevyPro provides business frameworks from many of the global giants in management consulting that allow you to provide best in class solutions for your clients."

– David Harris, Managing Director at Futures Strategy

"As a young consulting firm, requests for input from clients vary and it's sometimes impossible to provide expert solutions across a broad spectrum of requirements. That was before I discovered Flevy.com.

Through subscription to this invaluable site of a plethora of topics that are key and crucial to consulting, I have been able to exceed expectations and deliver quality advice and solutions to my clients. The quality and expertise of the authors are exemplary and gives me great confidence to use as part of my service offerings.

I highly recommend this company for any consultant wanting to apply international best practice standards in their service offerings. "

– Nishi Singh, Strategist and MD at NSP Consultants

"I have used FlevyPro for several business applications. It is a great complement to working with expensive consultants. The quality and effectiveness of the tools are of the highest standards."

– Moritz Bernhoerster, Global Sourcing Director at Fortune 500

"Flevy is now a part of my business routine. I visit Flevy at least 3 times each month.

Flevy has become my preferred learning source, because what it provides is practical, current, and useful in this era where the business world is being rewritten.

In today's environment where there are so many challenges and there is the need to make the right decisions in a short time, with so much scattered information, we are fortunate to have Flevy. Flevy investigates, selects, and puts at our disposal the best of the best to help us be successful in our work."

– Omar Hernán Montes Parra, CEO at Quantum SFE

"As an Independent Management Consultant, I find Flevy to add great value as a source of best practices, templates and information on new trends. Flevy has matured and the quality and quantity of the library is excellent. Lastly the price charged is reasonable, creating a win-win value for the customer, Flevy and the various authors. This is truly a service that benefits the consulting industry and associated clients. Thanks for providing this service. "

– Jim Schoen, Principal at FRC Group

"As a consulting firm, we had been creating subject matter training materials for our people and found the excellent materials on Flevy, which saved us 100's of hours of re-creating what already exists on the Flevy materials we purchased."

– Michael Evans, Managing Director at Newport LLC

SELECT CUSTOMERS

Since 2012, we have provided best practices to over 5,000 businesses and organizations of all sizes across the world—in over 130 countries. Below is just a very small sample of our customer base.

Did you know?

The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.

CUSTOMERS ALSO BOUGHT THESE DOCUMENTS

Business Plan Template (Financial Model) Excel workbook $109.99 Author: Documents & Files Integrated Financial Model	Integrated Financial Model - Auto Generate Projected Financial Statements Excel workbook $39.00 Author: Ganesh Rajagopalan Integrated Financial Model Profit and Loss	World's First Research Report-cum-Financial Model (Customizable) Excel workbook $99.00 Author: Nitiin Khandkar Integrated Financial Model	Online Coaching Marketplace - Business Plan Financial Model Excel workbook $99.00 Author: Fin-Wiser Advisory Integrated Financial Model Coaching
Integrated Financial Model - Business Performance Excel workbook $24.95 Author: prozaro Integrated Financial Model	Business Plan for Real Estate Company 47-page Word document $35.00 Author: Safwan Khan Business Plan Example Real Estate	Real Estate Option to Purchase Agreement 4-page Word document $30.00 Author: Safwan Khan Contract Real Estate	Integrated Financial Model Excel workbook $20.00 Author: Documents & Files Integrated Financial Model
Integrated Real Estate Strategy 24-slide PowerPoint deck $20.00 This is a FlevyPro [?] document. Subscribe and save with FlevyPro! Real Estate	Real Estate Cancellation of Contract 1-page Word document $30.00 Author: Safwan Khan Contract Real Estate	Pizzeria - 3 Statement Financial Model with 5-Year Monthly Projection Excel workbook $49.00 Author: Fin-Wiser Advisory Integrated Financial Model	Real Estate Sell Side Contract 7-page Word document and supporting PDF $30.00 Author: Safwan Khan Contract Real Estate