Please let me know how you come up with the 15% agent fee residuals and if you have excel screenshots that would help so much!

Please provide a monthly financial model in excel format to evaluate the gross profit, EBITDA, unlevered IRR, and payback period associated with the potential investment of provisioning a 50 kW, 300 square foot solution under the following assumptions.

Monthly recurring revenue: $13,750 monthly escalating by 3% per annum (60-month term)

Non recurring revenue: $50k

COGS:

Space- $4.15/SF

Power- $87.50/kW

SG&A expenses:

Agent Fees- 15% monthly residual

Other SG&A (sunk facility costs that include insurance, outside services, payroll, property taxes, and repair/maintenance- generally allocated on the basis of rented SF)- $4.15/SF

CAPEX to deploy solution: $165k