I have a case study for DTH, All the information has been provided and I need to take that

| October 3, 2018

I have a case study for DTH, All the information has been provided and I need to take that information in the tabs provided complete financial reports, Such as a balance sheet, a profit and loss statement, a cashflow and a discounted cash flow.Revenue AssumptionsSubscribersDTH Subscription RevenuesARPURegistration FeesSubscribersDTT Subscription RevenuesARPURegistration FeesVirginWholesaleBT Vision1,000,000 subscribers at end of FYE 2008Increase of 20% in FY2009Increase of 15% in FY2010Increase of 5% thereafter£12.99 per month through to Q3 2009 with uplift to £13.99 at that time£1.00 uplift in Q3 of each year thereafter5.0% average discount on subscriptions3.0% Luxembourg VAT applied to discounted subscription priceBased on average subscribers over the period£10.00 per new subscriberAssume 60% of new subscibers pay registration fees250,000 subscribers at end of FYE 2008Increase of 22.5% in FY2009Increase of 20% in FY2010Increase of 7.5% thereafterIncrease each year phased in 25% in Q1, 0% in Q2, 50% in Q3, 25% in Q4£9.99 per month through to Q3 2009 with uplift to £10.99 at that time£1.00 uplift in Q3 of every other year thereafter3.0% average discount on subscriptions3.0% Luxembourg VAT applied to discounted subscription priceBased on average subscribers over the period£10.00 per new subscriberAssume 60% of new subscibers pay registration feesMonthly ARPU of £1.50 per subscriber, increasing to £1.75 in Q3 20101.6m subscribers rising by 2% annuallyBased on average subscribers over the periodMonthly ARPU of £1.25 per subscriber, increasing to £1.50 in Q3 2010150,000 subscribers rising by 20% per yearMinimum guarantee payable on 200,000 subscribersBased on average subscribers over the period£3m in FY2008Increase of 75% in FY2009Increase of 50% in FY2010Increase of 10% thereafterIPTV and BroadbandGross Cost AssumptionsRights CostsPremier LeagueFAScottish Premier LeagueAll other rights£140m per year through to Q3 2010, 5% decrease thereafter£50m per year through too Q3 2012, 5% increase thereafter£30m per year through to Q3 2010, 15% increase thereafter£35m in FY2009, rising by 3% thereafterTransmissionProductionDirect StaffAll rights payments charged in equal monthly instalments each year though the P&LCash payments on three major contracts made bi-annually in Q1 and Q3 each year(forward payment)£1.40 per month per DTH subscriber£1.00 per month per DTT subscriber£1.00 per month per DTH and DTT subscriber£0.75 on sign up of each new subscriber£15m in FY2008 throughout forecast period£25m in FY2008 rising by average increase in rights costs annually£7m in FY2008 rising by 3% annuallySG&A AssumptionsMarketingIndirect Staff£25m annually throughout forecast period£5m in FY2008 rising by 3% annuallyDepreciation & Amortisation AssumptionsAmortisationDepreciationNot applicable£2m annuallyConditional AccessCustomer Management ChargeTax AssumptionsCorporate taxCorporate tax at 30%Tax losses carried forwardCash Flow AssumptionsRights CostsCapital ExpenditureWorking CapitalBalance Sheet AssumptionsPIK NotesBank DebtRevolverCashDividendsAll rights payments charged equally each year though the P&LCash payments on three major contracts made bi-annually in Q1 and Q3 each year(forward payment)£2.5m per year£20m in flow in Q1 and Q3, £20m out flow in Q2 and Q4Neutral on an annual basis12.5% non cash pay notes, redeemable in 2015LIBOR + 2.00% cash interestLIBOR + 2.50% cash interestInterest on cash balances at LIBOR + 0.5%Zero payable over forecast period

Get a 20 % discount on an order above $ 40
Use the following coupon code:
LOBSTER
Positive SSL