jagomart
digital resources
picture1_Download Xls App 31662 | Buy Lease


 158x       Filetype XLS       File size 0.04 MB       Source: www.fs.fed.us


File: Download Xls App 31662 | Buy Lease
table 1 basic data user completes shaded portions as appropriate project missoula t d center location missoula montana date sep 1 1998 lease period 10 years gross sq ft 53 ...

icon picture XLS Filetype Excel XLS | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
       TABLE 1 -- BASIC DATA
                        User completes shaded portions as appropriate.
       Project:                   MISSOULA  T & D CENTER
       Location:                  MISSOULA MONTANA
       Date:                                      Sep 1, 1998
       Lease Period:              10 years
       Gross Sq. ft.                                   53,150 
       Net Usable sq. ft.(about 80-70% of gross)       43,000 
       Lease Rate sq. ft.                              $15.00 
       Lease Rate Renewal Period 10 years              $16.00 
       Ancillary Costs for lease                    $3,000.00 
       Lease Purchase Rate sq. ft.                     $30.00 
       Lease/Pur Renewal Period                        $30.00 
       Interest Rates:
          Nom U.S. Treasury Rate  20 Yr                 6.00%
             (See OMB A-94, App C)  3 Yr                5.60%
       Analysis Period (in Years)                          20
       Design & Construction period (years)                 3
       Economic Life (Construction)                        50
       Economic Life (Purchase)                            30
       TABLE 2 -- COSTS ASSOCIATED WITH PURCHASE ALTERNATIVE
       Purchase Price- Building     $5,700,000 
                                                                         Page 
        Land                             $200,000 
        Other Imputed Costs
        Ancillary Costs/yr from          $163,000 
        table 4
        TABLE 3 -- CONSTRUCTION AND INTEREST DURING CONSTRUCTION (ESTIMATED)
        LEGEND                       User completes shaded portions as appropriate.
                                                                    Interest Rate         5.60%
        Construction                   $5,700,000 
        Design Costs (6-10% of const     $342,000 
        Contract Supervis.  (4-8% of     $342,000 
                                                                                                                                        Federal
        Land Value or actual cost        $200,000                                   One-Half         Prior         Prior    Amount for Interest
        Total Construction             $6,584,000                     Federal         Annual         Years         Years    Computing During
                                                         Year      Appropriation     Funding       Funding        Interest    InterestConstruction
        All design + land purchased in Yr 1                1           $542,000       $271,000             $0            $0        ### $15,180 
        % Constr & Supv in Yr 2:           60.00%          2         $3,625,200     $1,813,000      $542,000       $15,180         ###       ###
        % Constr & Supv in Yr 3:           40.00%          3         $2,416,800     $1,208,000  $4,167,200        $147,910         ###       ###
                                                              Total  $6,584,000                                                  Total:      ###
                                                                               Page 
       Table 4 -- ANNUAL EXPENDITURES AND REVENUES
       LEGEND                    User completes shaded portions as appropriate.
                                                                           Lease
                                                    LeaseConstruction Purchase        Purchase
       Borrowing Term or
       Lease Term (yrs)                            20            3           20          N/A
       Lease payment                             $797,250                 $1,594,500 
       Renewal Period                            $850,400                 $1,594,500 
       Real Estate Taxes                            *            $5,000       *           $5,000 
       Insurance                                    *          $10,000        *          $10,000 
       Building Maintenance                         *         $114,000        *         $114,000 
       Utilities                                    *          $22,500        *          $22,500 
       Operations Costs                             *          $11,500        *          $11,500 
       Lease Administration                         $1,750      N/A           $1,750     N/A
       Total Annual Costs                        $799,000     $163,000    $1,596,250    $163,000 
       Residual Value                                        $5,000,000   $5,000,000  $5,000,000 
                       * =Included in Lease Contract
                                                                     Page 
       TABLE 5 -- CASH FLOW AND NET PRESENT VALUE
                                 annual payments
             Year        Lease Construction Lease/Pur.       Purchase
              1              ###    ($163,000)  ($1,596,250)   ($163,000)
              2              ###    ($163,000)  ($1,596,250)   ($163,000)
              3              ###    ($163,000)  ($1,596,250)   ($163,000)              SUMMARY 
              4              ###    ($163,000)  ($1,596,250)   ($163,000)
              5              ###    ($163,000)  ($1,596,250)   ($163,000)
              6              ###    ($163,000)  ($1,596,250)   ($163,000)              Net Present Value:
              7              ###    ($163,000)  ($1,596,250)   ($163,000)     Lease                 ($9,260,718)
              8              ###    ($163,000)  ($1,596,250)   ($163,000) Construction              ($6,269,637)
              9              ###    ($163,000)  ($1,596,250)   ($163,000)     Lease   /   Purchase          ###
              10             ###    ($163,000)  ($1,596,250)   ($163,000)    Purchase               ($6,210,574)
              11             ###    ($163,000)  ($1,596,250)   ($163,000)
              12             ###    ($163,000)  ($1,596,250)   ($163,000)              PREFERRED OPTION:
              13             ###    ($163,000)  ($1,596,250)   ($163,000)                         PURCHASE
              14             ###    ($163,000)  ($1,596,250)   ($163,000)
                                                                      Page 
The words contained in this file might help you see if this file matches what you are looking for:

...Table basic data user completes shaded portions as appropriate project missoula t d center location montana date sep lease period years gross sq ft net usable about of rate renewal ancillary costs for purchase leasepur interest rates nom us treasury yr see omb a app c analysis in design construction economic life associated with alternative price building page land other imputed costsyr from and during estimated legend const contract supervis federal value or actual cost onehalf prior amount total annual computing year appropriation funding interestconstruction all purchased constr supv expenditures revenues leaseconstruction borrowing term yrs na payment real estate taxes insurance maintenance utilities operations administration residual included cash flow present payments summary preferred option...

no reviews yet
Please Login to review.