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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started