Question
Please calculate the 10-year Return on Investment (ROI) for your Business, in Excel, given the following assumptions: a. Office space of 3,800 square meters (sqm)
Please calculate the 10-year Return on Investment (ROI) for your Business, in Excel, given the following assumptions:
a. Office space of 3,800 square meters (sqm) is required 500 $ / sqm / month rental expense. Assume this rental cost is capitalized as a single upfront payment to the landlord at Year 0 at a rate of 5%
b. Assume there is no other expenses or investments are required for the business
c. There are three ventures included in your business with the following annual revenue projections:
Revenues ($ in mil)
d. The Living Lab provides a rent-free environment to each venture in exchange for 10% revenue sharing, and a 25% equity stake. Assuming that the Living Lab eventually fully divests its equity stake as per the following:
e. After divestment, the living lab does not receive any further benefits or revenue sharing from the three ventures
Year 1 Year 2 Year 3 Year 4 Years 5-10 Revenues (Baht in mil) Venture A Venture B Venture C 10 20 5 0 0 21 10% y-o-y growth 20% y-o-y growth 100% y-o-y growth Divestment (Baht in mil) Venture A Venture B Venture C Amount 37.0 59.0 40.0 When End of year 7 End of year 8 End of year 6 Year 1 Year 2 Year 3 Year 4 Years 5-10 Revenues (Baht in mil) Venture A Venture B Venture C 10 20 5 0 0 21 10% y-o-y growth 20% y-o-y growth 100% y-o-y growth Divestment (Baht in mil) Venture A Venture B Venture C Amount 37.0 59.0 40.0 When End of year 7 End of year 8 End of year 6Step 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