Net Present Value Calculator Lease - Excel

Document Sample
Net Present Value Calculator Lease - Excel Powered By Docstoc
					                                                Calculating your Lease Payments
         Calculating your lease payments in advance will allow you to better identify your future lease commitments and budgetary requirements
         over the lease period. Your calculations will also help your justification of whether to lease or to purchase equipment after all factors
         including the present value of lease payments, ease of and disposal costs, technology refresh and other cost of ownership considerations
         are taken into consideration.


         About the Lease Rate Factor
         At the commencement of each quarter (January, April, July and October) Alleasing Pty Ltd will publish the relevant lease rate factors for
         each equipment type and lease term. The LRF is calculated based on a number of factors including the 90 day bank bill swap rate, risk
         associated with leasing the particular type of equipment and resale or market value at the end of lease.



         Current Lease Rate Factors (1 January 2011 to 31 March 2011)
         The current lease rate factors applicable to all University leases are included in the following Table. To obtain the LRF for items of
         equipment not identified in the Table, you should contact Alltech Finance.


                                                                                      Term         Term         Interim
                    Equipment Type                  Lease Rate Factor (LRF)          (years)     (quarters)    Payment           Payment Cycle
         PC Desktop Computers (Tier 1)                       0.081238                   3            12             1             12 Quarters
         Apple Desktop Computers                             0.081238                   3            12             1             12 Quarters
         Notebook Computers (Tier 1)                         0.081238                   3            12             1             12 Quarters
         Servers (Tier 1) (3 year lease)                     0.082809                   3            12             1             12 Quarters
         Servers (Tier 1) (5 year lease)                     0.060084                   5            20             1             20 Quarters
         Printers (3 year lease)                             0.085261                   3            12             1             12 Quarters
         Printers (4 year lease)                             0.070409                   4            16             1             16 Quarters
         Printers (5 year lease)                             0.060084                   5            20             1             20 Quarters
         Network Equipment (3 year lease)                    0.082812                   3            12             1             12 Quarters
         Network Equipment (5 year lease)                    0.058072                   5            20             1             20 Quarters
         Audio Visual (3 year lease)                         0.085636                   3            12             1             12 Quarters
         Audio Visual (4 year lease)                         0.068427                   4            16             1             16 Quarters
         Scanners                                            0.085261                   3            12             1             12 Quarters
         Photocopiers (3 year lease)                         0.085261                   3            12             1             12 Quarters
         Photocopiers (4 year lease)                         0.070409                   4            16             1             16 Quarters

         The Free Rental Period
         Every lease is subject to a free rental period which could be at a minimum 1 month or at a maximum up to 4 months. Simply calculated for
         leasing purposes, the calendar year from January through to December is divided into 4 equal quarters with any equipment received by
         the University in any quarter, subject to free rental for that quarter plus free rental for the first following month of the next quarter. The
         reason for this is to ensure that leases commence and end at only four times in the calendar year and to allow a smooth transition at end of
         lease cycle, allowing you to replace end of lease equipment with new equipment during the free rental periods meaning that you will not
         pay duplicate rental payments whilst you make the changeover.

         Example 1
         Equipment is received by you on January 15. From January 15 through to March 31 you will not pay any rent on the equipment even
         though you have possession and are using the equipment. You will also not make a rent payment for the first month of the next quarter, in
         this example, April. For this example you have received 3 months and 16 days free rental.

         Example 2
         Equipment is received by you on March 20. From March 20 through to March 31 you will not pay any rent, and will also not pay any rent
         for the first month of the next quarter, again April. For this example you have received 1 month and 11 days free rental.

         Hint:
         There is an obvious benefit to time receipt of new equipment to commence nearer to the start of a new quarter than at the end in order to
         receive the maximum benefit from the free rental period.




fd12e7ba-7abb-407f-a7aa-9fcc7436bb3e.xls, 4/18/2011                                                                                                       Page 1/4
         Calculating your Interim Payment
         Every lease is subject to an interim payment which will always be 2/3rds of 1 quarterly payment. This is used to allow the leasing cycle to
         be brought back to a quarterly cycle following the application of the free rental periods previously described. There will only ever be 1
         interim payment made for each lease commenced.


         To calculate your interim payment use the following calculator

         1. Copy the Lease Rate Factor for the type of equipment and lease term in the 'Equipment Type LRF column above.
         2. Place the cost of the equipment (ex GST) in the 'Equipment Cost' column. If you have multiple item of equipment, for example 10
         desktop PC's, use the total cost (ex GST).


                                                                       Equipment Cost
                                      Equipment Type        LRF                                   Interim Payment
                                                                         (excl. GST)

                                              0.081238                     $20,780.00                  $1,125.42


         Calculating your Lease Payments
         Once your Interim payment has been made your cycle of lease payments will commence, 12 payments for a 3 year term, 16 payments for
         a 4 year term and 20 payments for a 5 year term. It should be noted that the 4 and 5 year lease options are only being offered for
         photocopiers and for other specialised items of equipment, upon request to Alltech Finance.

         To calculate your lease payments use the following calculator
         1. The Lease Rate Factor for the type of equipment and lease term in the 'Equipment Type LRF column will be copied from the interim
         payment calculator above.
         2. The Equipment Cost will be copied from the interim payment calculator above.
         3. Place the number of payments you expect to make in the 'Lease Term' column, 12 for a 3 year term, 16 for a 4 year term (photocopiers
         or printers) and 20 for a 5 year term (photocopiers or printers).



            Equipment Type           Equipment Cost (excl.                                           Lease Term           Total Quarterly Lease
                                                                       Quarterly Rental
                 LRF                        GST)                                                      (Quarters)                Payments

                0.081238                     $20,780.00                    $1,688.13                       12                    $20,257.51

         Total Lease cost (Interim Payment + Lease Payments)

                           Total Interim and Quarterly
                                                                            Net Present Value                        Benefit
                                   Lease Costs

                                      $21,382.93                                 $19,249.91                         $1,530.09

         Extending your lease term
         Under some circumstances you may choose to extend your lease term. It is not recommended that extensions go beyond 3 months
         because after this the benefits for leasing in the first place will diminish very quickly. You have the option of extending for 1 quarter (3
         months), 2 quarters (6 months), 3 quarter (9 months) or for 4 quarter (12 months). If you wish to take advantage of the less expensive
         rates for 3 and 4 quarter extensions, you must advise Alltech Finance that this is your intention prior to extending the lease.




                                       Length of Extension                Lease Cost per Quarter                Total

                                    1 Quarter Extension                           $1,266.09                  $1,266.09

                                    2 Quarter Extension                           $1,097.28                  $2,194.56

                                    3 Quarter Extension                            $844.06                   $2,532.19

                                    4 Quarter Extension                            $844.06                   $3,376.25




fd12e7ba-7abb-407f-a7aa-9fcc7436bb3e.xls, 4/18/2011                                                                                                     Page 2/4
ts
ommitments and budgetary requirements
  to purchase equipment after all factors
 d other cost of ownership considerations




publish the relevant lease rate factors for
 ding the 90 day bank bill swap rate, risk
ease.




 Table. To obtain the LRF for items of




                     Payment Cycle
                      12 Quarters
                      12 Quarters
                      12 Quarters
                      12 Quarters
                      20 Quarters
                      12 Quarters
                      16 Quarters
                      20 Quarters
                      12 Quarters
                      20 Quarters
                      12 Quarters
                      16 Quarters
                      12 Quarters
                      12 Quarters
                      16 Quarters



um up to 4 months. Simply calculated for
quarters with any equipment received by
ollowing month of the next quarter. The
and to allow a smooth transition at end of
 rental periods meaning that you will not



not pay any rent on the equipment even
t for the first month of the next quarter, in



y any rent, and will also not pay any rent
d 11 days free rental.


a new quarter than at the end in order to




                   fd12e7ba-7abb-407f-a7aa-9fcc7436bb3e.xls, 4/18/2011   Page 3/4
This is used to allow the leasing cycle to
sly described. There will only ever be 1




RF column above.
item of equipment, for example 10




ments for a 3 year term, 16 payments for
ease options are only being offered for




F column will be copied from the interim


 term, 16 for a 4 year term (photocopiers




               Total Quarterly Lease
                     Payments

                      $20,257.51




ed that extensions go beyond 3 months
 the option of extending for 1 quarter (3
to take advantage of the less expensive
or to extending the lease.




                  fd12e7ba-7abb-407f-a7aa-9fcc7436bb3e.xls, 4/18/2011   Page 4/4

				
DOCUMENT INFO
Description: Net Present Value Calculator Lease document sample