Excel Spreadsheet

The Building Rent Calculator

You must be logged in to download this document
Reviews
Shared by: cindyrella perillo
Stats
views:
761
rating:
not rated
reviews:
0
posted:
2/8/2008
language:
English
pages:
0
Welcome to the Building Rent Calculator Menu Page The Building Rent Calculator will help you estimate the landlords costs of building ownership. These can be used as a basis in the developing of a fair rental price. Developed by Rob Gamble Finance and Business Structures Program Lead OMAF, Guelph email: rob.gamble@omaf.gov.on.ca March 12, 2003 Rent Calculator Menu Page the landlords costs of building ownership. These can be used as a Building Rent Calculator BUILDING FIXED COSTS 1 Current replacement cost 2 Total useful life 3 Average age during lease period 4 Years of life remaining (line 2 - line 3) (adjusted for condition) 5 Average value: (line 1 x line 4 / line 2 ) 6 Amount of financing on the building 7 Interest rate on financing 8 Depreciation Rate per year (1 divided by line 2) x line 1 9 Return on Investment (line 9 x line 5) 10 Insurance and taxes rate ( line 10 x line 5 ) 11 Total Ownership Costs ( lines 7 + 8 + 9 + 10) VARIABLE COSTS (if paid by owner) 12 Repairs (% of replacement cost) ( line 12 x line 1 ) 13 Utilities 14 Total Variable Costs (line 12 + line 13) TOTAL COSTS 15 Total Annual Ownership Costs (line 11 + line 14) 16 Cost per month (line 15 divided by 12 months) 17 Total Cash Costs ( line 15 - line 8 - line 9 ) 18 Cash Costs per month (line 17 divided by 12 months) Calculated Amounts 40,000 20 years 13 years 7 years 14,000 7.0% 5.0% 2,000 4.0% 560 1.0% 140 $ 2,700 2% $ $ $ $ $ 800 0 800 3,500 292 940 78 Tenants Value in Renting a Building 1 Added Income from using the building 2 Reduced costs from not having to own the building 3 Reduced income which could be earned by investment into another asset 4 Added cost from using the building, not including the rent Added Value In Renting ( line 1 + line 2 - line 3 - line 4 ) 1,000 3,920 600 4,320 $ Examples of a hay storage Line 1 – Tenant expects added income because stored hay will result in better quality feed Line 2 - Annual ownership of a building would be $3,920 - see line 15 of ownership chart Line 3 – Income would not be reduced by renting the building Line 4 – Cost of travel to the location to store and retrieve feed Guidelines for Estimating Annual Ownership Costs. Repairs Item Livestock buildings Livestock equipment Grain storage, drying Machinery and hay storage Useful Life (years) 15 -25 5-10 15-20 20-25 (% of new replacement cost) 1-3% 3-5% 3-4% 1-2% Manure Handling Rates - 2000 Custom Rate Survey Unit Loader only Spreading only Loading and spreading Surface irrigated Tanker spreading – surface applied Trucking hr. hr. hr. 1000 gal. hr. 1000 gal. hr. hr. No. of farms reporting 28 19 34 4 3 9 15 3 2000 Provincial Average 15th $44 $48 $82 $7 $167 $8 $98 $110 Percentile 85th $33 $60 $37 $60 $55 $121 $6 $8 $115 $220 $5 $10 $61 $135

Related docs
Rent Calculator
Views: 32  |  Downloads: 0
Rent Calculator
Views: 17  |  Downloads: 0
Biofuels Calculator
Views: 543  |  Downloads: 32
Building Rent Calculator 1
Views: 697  |  Downloads: 36
Building Rent
Views: 9  |  Downloads: 0
Home Mortgage Calculator
Views: 199  |  Downloads: 1
Budget Calculator
Views: 505  |  Downloads: 129
Rent benefit
Views: 8  |  Downloads: 0
Mortgage and Equity Calculator
Views: 367  |  Downloads: 22
Incom Tax Calculator
Views: 168  |  Downloads: 15
premium docs
Other docs by cindyrella per...
processing pears budget calculator
Views: 444  |  Downloads: 27
pears farm bosc enterprise budget calculator
Views: 335  |  Downloads: 4
Computational Corporate Finance Calculations
Views: 682  |  Downloads: 72
wheat ORGANIC ENTERPRISE BUDGET
Views: 459  |  Downloads: 3
vidal grape farm enterprise budget calculator
Views: 354  |  Downloads: 5
swine farm enterprise budget calculator
Views: 552  |  Downloads: 12
sweetcorn farm enterprise budget calculator
Views: 376  |  Downloads: 1
sweet cherry budget calculator
Views: 271  |  Downloads: 2
spring canola farm enterprise budget calculator
Views: 297  |  Downloads: 0
spelt organic enterprise budget calculator
Views: 245  |  Downloads: 1
soybeans roundup budget calculator
Views: 234  |  Downloads: 4
Return on Security Investment Calculator
Views: 304  |  Downloads: 15