sampa equity

Upload: nibaronchokkotti

Post on 09-Mar-2016

224 views

Category:

Documents


0 download

DESCRIPTION

Solution

TRANSCRIPT

  • Sampa Video, Inc.Harvard Business School Case #201-094Case Software XLS-123

    Copyright 2010 President and Fellows of Harvard College. No part of this product may be reproduced, stored in a retrieval system or transmitted in any form or by any meanselectronic, mechanical, photocopying, recording or otherwisewithout the permission of Harvard Business School.

  • All Equity 1228.49WACC 1469.97APV 1528.49CCF #VALUE!ECF 1,469.97

  • CCF(Debt to Value =25%)0 1 2 3 4 5

    FCF -1500 -112 6 151 314 495TV 5135.86957

    -112 6 151 314 5630.86957WACC 15.12%g 5%PV of FCF 2,970 3,531 4,059 4,522 4,891Debt Value (25%) Value 742.49 882.76 1,014.73 1,130.41 1,222.83 1,283.97ITS 20.20 24.01 27.60 30.75 33.26Debt Payments -109.97 -95.96 -74.28 -46.30 -11.25ECF -2.03 101.96 225.28 360.30 506.25TV 3851.90217PV of ECF 599.71PV TV 1627.77002Ve 2,227.48Firm Value 1,469.97Re 18.80%g 5%

    CopyrightComparisonFTE