Evaluate compound return on overall portfolio of investment

Assignment Help Financial Management

Reference no: EM131310151

Spatial Technology Case:

Part 1

1. Evaluate the compound return on investments made at "Start up," Round A, Round B, Round C and Round D if the acquired shares eventually sell at $10 and $5. This will be one number per round per price. (Hint: Use the XIRR function in Excel's Analysis Toolpack.)

2. Evaluate the compound return on the overall portfolio of investments for each existing investor. This will be one number per investor. (Hint: Use the XIRR function in Excel's Analysis Toolpack.)

3. Compare the $5 and $10 IPO prices for Spatial to "comparable firms" and their multiples. (There are some glimpses of multiples in the case materials, but you may wish to use some outside reference material - please state your sources, if any.)

4. In a single page, display legible tables for: (i) round prices, investor cash flows and exit payoffs with their associated compound annualized returns at both $5 and $10; (ii) any "comparable firm" valuation data you deem relevant. This single page of two tables will be the only portion of "Part 1" carried into the final report submitted in "Part 2."

Part 2

5. Using the case-provided financial statements as a starting point:

i) Prepare a DCF valuation based on projected financials (IS, BS and SCF) with 5 years of explicit forecasts using an overall revenue growth rate consistent with recent history (say 2-3 years) at Spatial. For the terminal value use a reasonable perpetual growth rate.

ii) Engineer DCF valuations and pro forma financial statements (5-year explicit period) that justify a $10 and a $5 share price at the IPO. Make sure the ratios embedded in your projections conform to reasonable operating ratio assumptions. (Hint: don't just change sales growth - vary other parameters of your projections!)

iii) Prepare your $5 scenario, complete with IS, BS, SCF and DCF valuation, for presentation in the final submission.

iv) Prepare a summary comparison (without financial statements) of the drivers and results for all 3 scenarios (recent growth rate, $5 engineer and $10 engineer). Display the $5 financials, valuation and summary comparison legibly in no more than 2 pages of exhibits. With the IRR and comparables summary from Part 1, this completes the 3 pages of exhibits for your final submission.

v) Prepare a one-page Executive Summary (as per the instructions in the syllabus) discussing the events and decisions (technological and financial) leading to Spatial's current situation, the options it currently has and your recommendations for its near future. Would (could) you have done anything differently? Take a position on whether you would recommend the $5 IPO to investors. Take a position on whether, as an investor, you would have purchased shares in the $5 IPO. Discuss what you believe will be the strategic (product lines, licensing, competitors, etc.) outlook for Spatial and what you believe will be the financial market's view of a publicly-traded Spatial. Make sure your executive summary references the exhibits.

Attachment:- Capstone case.rar

Attachment:- SpatialQuestion.rar

Reference no: EM131310151

Questions Cloud

How could chances of such an attack succeeding be minimimise : What should be done instead to alert the staff to the attempted intrusion, and how could the chances of such an attack succeeding be minimized?

Create a job description for a retail sales associate : Create a job description for a retail sales associate, which includes the most significant components necessary to describe the job both internally and externally

Create a linked list of self referential structures : CS1325 - F16 Assignment: Create a linked list of self referential structures (each self referential structures is called Student) and initialize the list to empty. Take the strings from String[] and the GPA from GPA[] one by one.

How issue creates a performance problem for the organization : Describe a performance issue which resulted from a motivational problem (what, why, who).Use a content theory of motivation (e.g., Maslow, Alderfer, Herzberg, or McClelland) or a process theory (i.e., Adams, Locke, or Heider and Kelley) to explain..

Evaluate compound return on overall portfolio of investment : Evaluate the compound return on the overall portfolio of investments for each existing investor. This will be one number per investor.

Examine two major hr ethical issues : Examine two (2) of the major HR ethical issues multinational corporations face when operating globally. Recommend two (2) preventative actions that HR departments can take in order to lessen the occurrence of these ethical issues. Provide a rationale..

Convertible bond is currently selling : A bond with a coupon rate of 6.5%, maturing in 10 years at a value of $1,000 and current market price of $695 will have a current yield of. A convertible bond is currently selling for $1,125. It is convertible into 20 shares of common which presently..

Determine if a vulnerability is malicious or nonmalicious : In the NRL classification scheme for the "genesis" axis, can the classes "Trojan horse" and "covert channel" overlap? Justify your answer. If your answer is yes, describe a Trojan horse that is also a covert channel or vice versa.

Why do you think the award points system is successful : Why do you think the award points system is successful ?What other incentives would assist the company in motivating the sales staff ?

User Account

All Pages