Assume the following for a floor in a multistory office building:

total usable area: 20,000 sq ft;

Total common area: 5,000 sq ft;

total rentable area: 25,000 sq ft;

Tenant As usable area: 4,000 sq ft.

Tenant As annual rental rate is $25 per sq ft.

How much total rent does Tenant A pay per year?

*Please show your work & calculations in an Excel.

*Please also indicate the excel equations used to solve the question.