They are reported on a per square foot basis, along with the expected growth rate of the expenses:

First step, determine what the projected expenses for the property will be for the next $5$ years.

Make sure to use formulas and cell references.

$\backslash$table$[[$Category$,$Exp$/$SF$,$Annual Growth,,,$],[$Property Taxes,$2\mathrm{.}45,4\%,,,],[$Insurance$,1\mathrm{.}36,8\%,,,],[$Repairs & Maint,$2\mathrm{.}09,5\%,,,],[$All Other,${3\mathrm{.}62}_{?},3\%,,,],[$Total$,9\mathrm{.}52,,,,],[4,,,,,],[$Expenses$,2024,2025,2026,2027,2028],[$Property Taxes,$2\mathrm{.}45,2\mathrm{.}548,2\mathrm{.}650,2\mathrm{.}756,2\mathrm{.}866],[$Insurance$,1\mathrm{.}36,1\mathrm{.}469,1\mathrm{.}586,1\mathrm{.}713,1\mathrm{.}850],[$Repairs & Maint,$2\mathrm{.}09,2\mathrm{.}195,2\mathrm{.}304,2\mathrm{.}419,2\mathrm{.}540],[$All Other,$3\mathrm{.}62,3\mathrm{.}729,3\mathrm{.}729,3\mathrm{.}729,3\mathrm{.}729],[$Total$,9\mathrm{.}52,9\mathrm{.}940,10\mathrm{.}269,10\mathrm{.}617,10\mathrm{.}985]]$

For each of the tenants below, determine the expense amount $($on a per square foot basis$)$ that the tenant must pay and the landlord must pay for each of the next $5$ years. You MUST use formulas and cell references to calculate the answers. Make sure you take into account the type of lease each tenant has!

Tenant A $-$ Tenant has a GROSS lease

Tenant Pays $($psf$)$

Landlord Pays $($psf$)$

$\backslash$table$[[,,,,],[,,,,]]$

Tenant B $-$ Tenant has a Modified Gross lease $($they pay taxes and insurance$)$

Tenant Pays $($psf$)$

Landlord Pays $($psf$)$

$\backslash$table$[[,,,,],[,,,,]]$

Tenant C$-$ Tenant has a Base Year Stop lease, $2024$ is their base year.

$\backslash$table$[[$Tenant Pays $($psf$),,,,,],[$Landlord Pays $($psf$),,,,,]]$