158x Filetype XLS File size 0.04 MB Source: www.fs.fed.us
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
no reviews yet
Please Login to review.