I need to create an excel model from the below given information:

Please approach the following case study with a blank workbook and use formulas wherever possible hard codes are heavily discouraged. Everything below should be completed on an annual basis to simplify the process. The project is a speculative office development with two leases. The project features the following assumptions

(A) Project Timing:

Analysis Start: 12/31/22

Predevelopment: 12 months

Construction: 24 months

Lease 1: Commencing 12 months after delivery

Lease 2: Commencing 24 months after delivery

Sale Date: Month 72 or 12/31/28

(B) Project Size:

Project GSF: To be determined by applying efficiency below to NRSF

Project NRSF: 190,000 SF

Project Efficiency: 95%

(C) Development Assumptions:

Land Purchase Price: $80 / GSF to be spent at time zero

Soft Costs: $50 / GSF to be spent 100% during the predevelopment period

Hard Costs: $300 / GSF

1/3 to be spent during the first year of construction

2/3 to be spent during the second year of construction

(D) Leasing Assumptions:

Tenant 1

Premises: 125,000 NRSF

Rent: $48 / SF NNN

Free Rent: 12 months

Escalations: 2.5%

Term: 7 years

Tenant Improvement Allowance: $150 / NRSF -Paid 100% in lease commencement year

Leasing Commissions 6% - Paid 100% in lease commencement year

Tenant 2

Premises: 65,000 NRSF

Rent: $60 / SF NNN

Free Rent: 12 months

Escalations: 2.5%

Term: 10 years

Tenant Improvement Allowance: $180 / NRSF - Paid 100% in lease commencement year

Leasing Commissions 6% - Paid 100% in lease commencement year

(E) Operating Assumptions: The numbers below should be reflected at delivery and escalate thereafter

Opex: $12 / SF

Real Estate Taxes: $15 / SF

Escalation: 2.5%

(F) Sale Assumptions:

Residual Cap Rate: 5.25% to be applied to year 7 NOI

Sales Costs: 2.00%

Please display the following on a gross dollar and $ / GSF basis:

Gross Sales Proceeds

Selling Costs

Net Sale Proceeds

Gross Sales Proceeds de-escalated to the commencement date at 2.75% growth rate

(G) Financing Assumptions: Please assume a traditional bank construction loan for this project. That means equity up-front.

Loan to Cost: 65%

Interest Rate: 6.00%

Recordation Tax: 2.50%

Financing Fees: 1.50%

Required: Please include the following as part of your model:

1. Sources and Uses Table

2. Unlevered IRR

3. Levered IRR

4. Equity Multiple

5. Stabilized Yield

6. Stabilized Cash on Cash

Q. Data Tables Measuring IRR at the following:

1. Tenant 1 rents ($1/SF increments) vs cap rates

2. Land purchase price ($5 / SF increments) vs debt interest rate (0.25% increments)

3. Tenant 2 rents ($2 / SF increments) vs TIs ($10 / SF increments)

Q. Please build a waterfall reflecting the following:

1. 5% GP Investment / 95% LP Investment

2. Pari Passu until a 8% return

3. 20% to the GP and 80% to the LP until a 12% return

4. 30% to the GP and 70% to the LP until a 15% return

5. 40% to the GP and 60% to the LP thereafter