Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!