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

• total usable area: 33,000 sq ft;
• Total common area: 5,000 sq ft;
• total rentable area: 38,000 sq ft;
• Tenant As usable area: 5,500 sq ft.
• Tenant As annual rental rate is $25 per sq ft.

How much total rent does Tenant A pay per year?

Can you teach me how to do this in excel?