Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing and Accounting Cases Investigating Issues of Fraud and Professional Ethics

Authors: Jay Thibodeau, Deborah Freier

4th edition

78025567, 978-0078025563

More Books

Students also viewed these Accounting questions

Question

05 Techniques to promote creativity and in novation.

Answered: 1 week ago

Question

=+5. Which persons umbrella is this?

Answered: 1 week ago