Financial Modeling and Investment Analysis for Real Estate Development at CBRE

Requirements:

1. Develop a financial model for CBRE to evaluate investment opportunities in commercial real estate development projects.

Investment Project	Initial Investment ($)	Projected Cash Flows ($)	Discount Rate (%)
Office Tower Development	200,000,000	50,000,000	10
Retail Complex Expansion	150,000,000	30,000,000	8

2. Calculate the net present value (NPV), internal rate of return (IRR), and payback period for each real estate project.
3. Perform sensitivity analysis to assess the impact of occupancy rates and rental income fluctuations on investment returns.
4. Recommend investment decisions based on financial modeling outcomes and market analysis.