An office complex has the following operating expenses in year one

janitorial $12,500

insurance $13,500

maintenance $14,050

property taxes $8,651

landscaping $8,248

The following tenants have agreed to reimburse for CAM expenses according to the following lease terms

Office 1 (4,800 sq ft) Up to $2.55 psf

Office 2 (4,600 sq ft) Up to $2.70 psf

Office 3 (4,300 sq ft) Up to $2.90 psf

Office 4 (3,000 sq ft) Up to $3.15 psf

Deli (1,500 sq ft) Up to $1.50 psf

Please show me your work to answer these questions, highlight your answers.

1. What is the Op Ex for year one?
2. What will each tenant reimburse in year one?
3. At the end of year one, what will be the unreimbursed amount?

Can you teach me how to work this out in excel?