Description:
We are looking for a highly skilled financial modeling expert with experience in commercial real estate, specifically in the office sector. The main task is to build out a custom Excel-based financial calculator for an office broker. This calculator will be used to analyze potential office leases, purchase opportunities, and investment returns.
Key Requirements:
Proven experience in commercial real estate financial modeling, with a focus on office properties.
Strong proficiency in Excel, including advanced formulas, financial projections, and sensitivity analyses.
Familiarity with lease structures, including Triple Net (NNN), Gross, and Modified Gross leases.
Understanding of Percentage Rent calculations and how to incorporate them into financial models.
Expertise in key financial metrics such as Net Present Value (NPV), Internal Rate of Return (IRR), and Cap Rates.
Experience with Tenant Improvement (TI) Allowances, lease concessions, and build-out costs.
Ability to analyze lease terms, rent escalations, operating expenses, and pass-throughs.
Attention to detail and a strong analytical mindset.
Scope of Work:
Design and build a custom Excel calculator tailored to the needs of an office broker.
Incorporate inputs for various lease types (NNN, Gross, Modified Gross) and rent structures (Percentage Rent, rent escalations).
Integrate key financial metrics and assumptions to analyze lease and investment opportunities.
Include sensitivity analysis to evaluate different scenarios and optimize financial returns.
Ensure the model accounts for TI Allowances, operating expense reimbursements, and other lease-related costs.
Deliver a final, polished model that is easy to use and provides actionable insights.
Ideal Candidate:
Has completed similar financial modeling projects in the commercial real estate space, particularly with office assets.
Can demonstrate a deep understanding of lease structures, cash flow analysis, and investment returns specific to the office sector.
Is comfortable with incorporating advanced financial concepts, such as NPV, TI allowances, and cap rates, into modeling frameworks.
Can provide examples of past work, particularly models built for office deals, leases, or acquisition analyses.
Is responsive, communicative, and able to meet deadlines.
Budget: Open to discussion based on experience and project scope.
If you have the relevant experience and skills, please apply with a brief overview of your background in commercial real estate financial modeling, particularly in the office sector, along with any relevant samples of your previous work.
We look forward to reviewing your application!
