BCWS Franchise Extension Proposal
Extend Depreciation
Present Value Analysis
Change Change Change Change Total
in Depr. Exp. in Profit in Interest. Exp. in Profit Cash Flow
due to due to due to due to Effect of
Extension of Extension of Extension of Change in Extension of
Depreciable Depreciable Depreciable Interest Depreciable
Fiscal Year Ending: Lives of Assets Lives of Assets Lives of Assets Expense Lives of Assets
June 30, 2004    $    (951,722)    $    (88,411)    $    (21,464)    $  (1,994)    $       (1,063,591)
                     
June 30, 2005   (932,935)   (86,666)   (70,820)   (6,579)   (1,097,000)
                     
June 30, 2006   (771,296)   (71,650)   58,127   5,400   (779,419)
                     
June 30, 2007   (487,084)   (45,248)   80,472   7,476   (444,385)
                     
June 29, 2008   (344,421)   (31,995)   146,850   13,642   (215,925)
                     
June 30, 2009   (301,202)   (27,980)   (268,043)   (24,900)   (622,126)
                     
June 30, 2010   (263,824)   (24,508)   (199,615)   (18,543)   (506,490)
                     
June 30, 2011   (170,266)   (15,817)   (97,507)   (9,058)   (292,647)
                     
Net Present Value at 5.86% Discount Rate    $      (4,124,526)
                     
NPV to City of 2004-2011 Savings (@50%)      (2,062,262.76)
                     
June 29, 2012   (476,432)   (44,259)   407,894   37,892   (74,905)
                     
June 30, 2013   (864,111)   (80,273)   487,436   45,281   (411,666)
                     
June 30, 2014   (877,341)   (81,502)   461,939   42,912   (453,992)
                     
June 30, 2015   (916,378)   (85,128)   386,664   35,920   (578,923)
                     
June 29, 2016   (1,304,431)   (121,177)   (59,333)   (5,512)   (1,490,452)
                     
June 30, 2017   (1,232,707)   (114,514)   (54,191)   (5,034)   (1,406,446)
                     
June 30, 2018   (814,116)   (75,628)   50,319   4,674   (834,751)
                     
Total 2004-2018   ($10,708,265)   ($994,757)   $1,308,728   $121,576    $     (10,272,718)
                     
Net Present Value at 5.86% Discount Rate  $       (2,512,630)
                     
NPV to City of 2012-2018 Savings (@100%)    $      (2,512,630)
                     
Net Present Value to City of Total Savings (@50%/100%)   (4,574,893)
                     
Net Present Value to City of Total Savings (@100%/100%)   (6,637,156)