Capital and Operating Lease Schedule

Document Sample
Capital and Operating Lease Schedule Powered By Docstoc
					CAPITAL AND OPERATING LEASE SCHEDULE
Capital leases are leases that transfer all benefits and risks of ownership to the lessee. If, at its inception, a lease
meets one or more of the following four criteria, the lease should be classified as a capital lease by the lessee:

-- The lease transfers ownership of the property to the lessee by the end of the lease term;
-- The lease contains an option to purchase the leased property at a bargain price;
-- The lease term is equal to or greater than 75 percent of the estimated economic life of the leased property; or
-- The present value of rental and other minimum lease payments, excluding that portion of the payments
representing executory cost, equals or exceeds 90 percent of the fair value of the leased property.

The last two criteria are not applicable when the beginning of the lease term falls within the last 25 percent of the
total estimated economic life of the leased property.

If a lease does not meet at least one of the above criteria it should be classified as an operating lease.



Note : Only Cells marked in yellow require your input




© Copyright 2013 Docstoc Inc.                                                                                              1
INPUT LEASE DETAILS

Non-cancellable Lease term (years)                                                  15.00
Cost to purchase asset at end of lease                                           5,000.00

Information about the asset:
Estimated total useful life of the asset (years)                                     16.0
Age of asset at lease inception (years)                                               -
Value of leased asset at lease inception ($) (What is the asset worth today?)   1,000,000
Present Value of Cost to purchase asset at the end of lease                         2,405

Other information:
Interest Rate (annual)                                                             5.00%

Total Lease Value                                                                997,595
Annual Lease Payment ($)                                                          96,111

Note: only cells marked in yellow require your input.




© Copyright 2013 Docstoc Inc.                                                               2
LEASE SCHEDULE

Total Lease                    997,595
Year           Yearly Lease Payment    Interest   Principal Repaid      Net Pending Lease Obligation
           (2)                     -       49,880              (49,880)                       1,047,475
           (1)                     -       52,374              (52,374)                       1,099,848
         -                         -       54,992              (54,992)                       1,154,841
            1                   96,111     57,742               38,369                        1,116,472
            2                   96,111     55,824               40,287                        1,076,185
            3                   96,111     53,809               42,301                        1,033,884
            4                   96,111     51,694               44,416                          989,468
            5                   96,111     49,473               46,637                          942,830
            6                   96,111     47,142               48,969                          893,861
            7                   96,111     44,693               51,418                          842,444
            8                   96,111     42,122               53,988                          788,455
            9                   96,111     39,423               56,688                          731,768
          10                    96,111     36,588               59,522                          672,245
          11                    96,111     33,612               62,498                          609,747
          12                    96,111     30,487               65,623                          544,124
          13                    96,111     27,206               68,904                          475,220
          14                    96,111     23,761               72,350                          402,870
          15                    96,111     20,144               75,967                          326,903
         -                         -       16,345              (16,345)                         343,248
         -                         -       17,162              (17,162)                         360,410
         -                         -       18,021              (18,021)                         378,431
         -                         -       18,922              (18,922)                         397,353
         -                         -       19,868              (19,868)                         417,220
         -                         -       20,861              (20,861)                         438,081
         -                         -       21,904              (21,904)                         459,985
         -                         -       22,999              (22,999)                         482,985
         -                         -       24,149              (24,149)                         507,134
         -                         -       25,357              (25,357)                         532,490
         -                         -       26,625              (26,625)                         559,115
         -                         -       27,956              (27,956)                         587,071
         -                         -       29,354              (29,354)                         616,424
         -                         -       30,821              (30,821)                         647,245
         -                         -       32,362              (32,362)                         679,608
         -                         -       33,980              (33,980)                         713,588
         -                         -       35,679              (35,679)                         749,268
         -                         -       37,463              (37,463)                         786,731
         -                         -       39,337              (39,337)                         826,067
         -                         -       41,303              (41,303)                         867,371
         -                         -       43,369              (43,369)                         910,739
         -                         -       45,537              (45,537)                         956,276
         -                         -       47,814              (47,814)                       1,004,090
         -                         -       50,205              (50,205)                       1,054,295
         -                         -       52,715              (52,715)                       1,107,009
         -                         -       55,350              (55,350)                       1,162,360


© Copyright 2013 Docstoc Inc.                                                                             3
          -                     -    58,118    (58,118)    1,220,478
          -                     -    61,024    (61,024)    1,281,502
          -                     -    64,075    (64,075)    1,345,577
          -                     -    67,279    (67,279)    1,412,856
          -                     -    70,643    (70,643)    1,483,498
          -                     -    74,175    (74,175)    1,557,673
          -                     -    77,884    (77,884)    1,635,557
          -                     -    81,778    (81,778)    1,717,335
          -                     -    85,867    (85,867)    1,803,202
          -                     -    90,160    (90,160)    1,893,362
          -                     -    94,668    (94,668)    1,988,030
          -                     -    99,401    (99,401)    2,087,431
          -                     -   104,372   (104,372)    2,191,803
          -                     -   109,590   (109,590)    2,301,393
          -                     -   115,070   (115,070)    2,416,463
          -                     -   120,823   (120,823)    2,537,286
          -                     -   126,864   (126,864)    2,664,150
          -                     -   133,207   (133,207)    2,797,357
          -                     -   139,868   (139,868)    2,937,225
          -                     -   146,861   (146,861)    3,084,087
          -                     -   154,204   (154,204)    3,238,291
          -                     -   161,915   (161,915)    3,400,206
          -                     -   170,010   (170,010)    3,570,216
          -                     -   178,511   (178,511)    3,748,727
          -                     -   187,436   (187,436)    3,936,163
          -                     -   196,808   (196,808)    4,132,971
          -                     -   206,649   (206,649)    4,339,620
          -                     -   216,981   (216,981)    4,556,601
          -                     -   227,830   (227,830)    4,784,431
          -                     -   239,222   (239,222)    5,023,652
          -                     -   251,183   (251,183)    5,274,835
          -                     -   263,742   (263,742)    5,538,576
          -                     -   276,929   (276,929)    5,815,505
          -                     -   290,775   (290,775)    6,106,281
          -                     -   305,314   (305,314)    6,411,595
          -                     -   320,580   (320,580)    6,732,174
          -                     -   336,609   (336,609)    7,068,783
          -                     -   353,439   (353,439)    7,422,222
          -                     -   371,111   (371,111)    7,793,333
          -                     -   389,667   (389,667)    8,183,000
          -                     -   409,150   (409,150)    8,592,150
          -                     -   429,607   (429,607)    9,021,757
          -                     -   451,088   (451,088)    9,472,845
          -                     -   473,642   (473,642)    9,946,488
          -                     -   497,324   (497,324)   10,443,812
          -                     -   522,191   (522,191)   10,966,003
          -                     -   548,300   (548,300)   11,514,303
          -                     -   575,715   (575,715)   12,090,018


© Copyright 2013 Docstoc Inc.                                          4
          -                     -     604,501     (604,501)    12,694,519
          -                     -     634,726     (634,726)    13,329,245
          -                     -     666,462     (666,462)    13,995,707
          -                     -     699,785     (699,785)    14,695,492
          -                     -     734,775     (734,775)    15,430,267
          -                     -     771,513     (771,513)    16,201,780
          -                     -     810,089     (810,089)    17,011,869
          -                     -     850,593     (850,593)    17,862,463
          -                     -     893,123     (893,123)    18,755,586
          -                     -     937,779     (937,779)    19,693,365
          -                     -     984,668     (984,668)    20,678,033
          -                     -   1,033,902   (1,033,902)    21,711,935
          -                     -   1,085,597   (1,085,597)    22,797,532
          -                     -   1,139,877   (1,139,877)    23,937,408
          -                     -   1,196,870   (1,196,870)    25,134,279
          -                     -   1,256,714   (1,256,714)    26,390,993
          -                     -   1,319,550   (1,319,550)    27,710,542
          -                     -   1,385,527   (1,385,527)    29,096,070
          -                     -   1,454,803   (1,454,803)    30,550,873
          -                     -   1,527,544   (1,527,544)    32,078,417
          -                     -   1,603,921   (1,603,921)    33,682,338
          -                     -   1,684,117   (1,684,117)    35,366,454
          -                     -   1,768,323   (1,768,323)    37,134,777
          -                     -   1,856,739   (1,856,739)    38,991,516
          -                     -   1,949,576   (1,949,576)    40,941,092
          -                     -   2,047,055   (2,047,055)    42,988,146
          -                     -   2,149,407   (2,149,407)    45,137,554
          -                     -   2,256,878   (2,256,878)    47,394,431
          -                     -   2,369,722   (2,369,722)    49,764,153
          -                     -   2,488,208   (2,488,208)    52,252,361
          -                     -   2,612,618   (2,612,618)    54,864,979
          -                     -   2,743,249   (2,743,249)    57,608,228
          -                     -   2,880,411   (2,880,411)    60,488,639
          -                     -   3,024,432   (3,024,432)    63,513,071
          -                     -   3,175,654   (3,175,654)    66,688,724
          -                     -   3,334,436   (3,334,436)    70,023,161
          -                     -   3,501,158   (3,501,158)    73,524,319
          -                     -   3,676,216   (3,676,216)    77,200,535
          -                     -   3,860,027   (3,860,027)    81,060,561
          -                     -   4,053,028   (4,053,028)    85,113,589
          -                     -   4,255,679   (4,255,679)    89,369,269
          -                     -   4,468,463   (4,468,463)    93,837,732
          -                     -   4,691,887   (4,691,887)    98,529,619
          -                     -   4,926,481   (4,926,481)   103,456,100
          -                     -   5,172,805   (5,172,805)   108,628,905
          -                     -   5,431,445   (5,431,445)   114,060,350
          -                     -   5,703,018   (5,703,018)   119,763,368




© Copyright 2013 Docstoc Inc.                                               5
				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:372
posted:12/21/2011
language:simple
pages:5
Description: The Capital and Operating Lease Schedule is a spreadsheet that calculates a lease payment schedule. The user must input certain lease details, including the lease term, cost to purchase the asset at the end of the lease, estimated total useful life of the asset, age of asset, value of the leased asset, present value of cost to purchase the asset at the end of the lease, and interest rate. The spreadsheet will then calculate yearly lease payments, interest payments, principal repaid, and the net pending lease obligation. This document is useful to any company seeking to calculate a lease schedule for a capital or operating lease.