Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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)

image text in transcribed

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: image text in transcribed

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 6

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

Handbook Of Blockchain Digital Finance And Inclusion

Authors: David Lee, Robert H. Deng

1st Edition

012812282X, 978-0128122822

More Books

Students also viewed these Finance questions

Question

What is the relationship between humans and nature?

Answered: 1 week ago