This assignment can be viewed here.
Subscribe to:
Post Comments (Atom)
About Me
- Matt Diehl
- I'm a recent UMBC graduate trying to do too many things at once. Currently playing guitar in one band, trying to start others. Started a small web design company - mainly building my portfolio right now while learning new technologies. I also love biking. I try to do long rides three times a week and I'm planning on doing a century in the fall.
There are some style issues with your spreadsheet. First, remove sheet1 from your title. Use commas in your numbers, and don't have the numbers "wrap"--make the columns wide enough so that the numbers fit nicely. Also, you have not done the IPO EV to current EV comparison, divided by number of years since IPO. Try re-formatting and adding that line and re-submitting for next week.
ReplyDeleteMore formatting: don't use cents except in per share numbers. The GOOG IPO price looks incorrect, although the underwriting was non traditional (which you can read about in their IPO document) there was a fixed price per share that was the final IPO price--I believe it was in the $60 to $70 range, not $135. Revise and re-submit for next week. I will not grade this one.
ReplyDelete1. Much better formatting, doesn't that make it easier to read and review?
ReplyDelete2. Change the title.
3. Shares issued for UA IPO EV are incorrect, try using this link for data:
http://idea.sec.gov/Archives/edgar/data/1336917/000104746905027008/a2165246zs-1a.htm
4. You have not included all the calculations, for example, there is no "increase in value" row.
Try adding these for next week. This is the final set of comments.
This is a completed assignment. Grade: B+
ReplyDelete