317x 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.