Iridum Case Study Exercise (1).xls

Iridum Case Study Exercise (1).xls - Sheet Tab 1 2 3 4 5 6...

This preview shows 1 out of 6 pages.

Sheet Tab Description 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 File Name: C:\A Files\Courses\3. Case Studies\1. Main Colour Codes Date 8-Apr-10 Contents Layout of Workbook Model Cap Exp and Op Exp Debt Details Equity Financing Revenue Forecasts Market Analysis Capacity Numbers from Harvard Case Data from Financial Statements Data from Prospectus Pricing Suscriber Actual vs Est Projected vs Act Chart Alternative Revenue Buildup Long Distance Pricing Telecom Prices Actual and Est Subscr Chart Analyst Revenue Forecasts Iridium versus Industry Harvard Case Clip Time Line Comment Macro
Image of page 1

Subscribe to view the full document.

Author n Case Studies\11. Telecom Case\Iriduim\Iridum.xls
Image of page 2
This sheet is organized as follows: The initial sheet has a base case model that is developed from acutal financial All of the instructions are associated with this sheet -- named the model sheet 1. Fill in the cells coloured in grey 2. Work on the Risk Analysis and make graphs etc. 3. Use the model to evaluate the cost structure of the technology Subsequent sheets document sources of information for developing the model Sheets at the end compare actuals to forecast and general information about the industry Contents
Image of page 3

Subscribe to view the full document.

Senior Debt Outstanding Sub Debt Outstanding Average Cost to Retail Consumers Year General Assumptions Initial Year of Opeations 1998 Number of Satellites in Initial Launch Construction Assumptions Construction Cost and Timing Assumptions Payments Under Space System Contract Payments Under Terrestial Contract Other Construction Expenditures Pre-Operating Expenses Percent of Construction in Progress Placed in Service Financing Assumptions Equity Financing Guaranteed Bank Facility Senior Bank Facility Senior Notes Subordinated Notes Financing Details Shares Guaranteed Notes Senior Notes Senior Debt A Senior Debt B Senior Debt C Senior Debt D Subordinated Notes Interest Income Rate 3% Default Interest Rate 15% Prospective Capital Expeditures and Depreciation Contents Comments
Image of page 4
Replacement of Satellites Satellite Life 5.00 Distribution of Losses 33.0% General Inflation Rate Base Cost of Satellite and Launch 20,000,000 Maintenance Capital Expenditures 150,000,000 Life of Terrestial Equipment 5.00 Life of Other Equipment 15.00 Capacity of Satellites -- Maximum Hours of Use per Satellite Maximum Calls per Satellite 1,100 Coincidence Factor -- Potential for Overlapping Calls 1 Capacity per Satellite 1,100 Diversity Factor 20% Revenue Assumptions - Subscribers Subscriber Assumptions - World Business Travellers Base Estimate of Worldwide Business Travellers 33,400,000 Growth Rate in Business Travellers Satellite Penetrateion of World Business Travellers Base Case 5% Maximum Penetration Case 0% Penetration case Subscriber Assumptions - Corporate Customers Base Estimate of Corporate Customers 7,200 Number of Subscribers per Corporate Customer 500 Growth Rate in Corporate Customers Growth Rate in Subscribers per Corporate Customer Satellite Penetrateion of World Corporate Customers Iridium Market Share Subscriber Sensitivity Assumptions Total Subscriber Sensitivity 100% Revenue Assumptions -- Pricing
Image of page 5

Subscribe to view the full document.

Image of page 6
You've reached the end of this preview.
  • Spring '15
  • Han Ozsoylev
  • Depreciation, Case Study, Expense, Operating expense

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern