{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Intro","Costs"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":1,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Intro","index":0,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[45,1,45,3],[51,1,51,11],[28,1,30,11],[32,1,34,11],[38,10,38,11],[40,1,41,4],[40,6,41,10],[44,15,44,16],[4,1,5,9],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13],[27,1,27,4]]}
[]
[]
[null,"KSU-Building Cost-Rent"]
[]
[null,"An Excel spreadsheet to estimate the annual cost of owning and maintaining agricultural storage buildings to aid in determining estimates for building rent."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 6.30.16"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"In the Costs tab all blue numbers are inputs and all other numbers are calculated from these inputs.  The spreadsheet automatically recalculates every time an additional input is entered.  Thus, it is important to wait until all data have been entered and reviewed before interpreting any of the calculated results (i.e., black numbers)."]
[]
[]
[]
[null,"In the Costs tab several of the cells have \"mouse over\" cell comments explaining what that cell or line represents.  Cells with a red triangle in the upper right corner include cell comments.  By \"hovering\" the mouse over these cells, the cell comment should appear."]
[]
[]
[]
[]
[null,"FOR MORE INFORMATION:"]
[null,"For explanation of the inputs used in this spreadsheet see the supporting paper:",null,null,null,null,null,null,null,null,"Farm Building Leases"]
[]
[null,"With Questions contact:",null,null,null,null,"Originally Developed by:"]
[]
[null,"Rich Llewelyn",null,null,null,null,"Kevin C. Dhuyvetter, Ph.D."]
[null,"Extension Assistant",null,null,null,null,"Former Agricultural Economist"]
[null,"Kansas State University",null,null,null,null,"Kansas State University"]
[null,"rvl@ksu.edu"]
[null,"785-532-1504",null,null,null,null,"Troy J Dumler"]
[null,null,null,null,null,null,"Former Agricultural Economist"]
[null,null,null,null,null,null,"Kansas State University"]
[]
[]
[null,"Copyright 2016 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Costs","index":1,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,32,4],[1,1,1,4]]}
[]
[null,"KSU-Building Cost-Rent.xls"]
[null,"  Spreadsheet to estimate the annual cost of owning a building"]
[]
[null,"Inputs",null,"Total","Per sq ft"]
[null,"Building Size"]
[null,"  Width, ft",null,40]
[null,"  Length, ft",null,80]
[null,"  Total area, sq ft",null,{"$f":"D7*D8","v":3200},{"$f":"D9/D$9","v":1}]
[]
[null,"Total cost of materials",null,25000,{"$f":"D11/D$9","v":7.8125}]
[null,"Cost of dirt work, erection, % of materials",null,0.33]
[null,"Total cost of building",null,{"$f":"D11*(1+D12)","v":33250},{"$f":"D13/D$9","v":10.390625}]
[null,"Useful life",null,30]
[null,"Salvage value",null,0.1]
[null,"Interest rate",null,0.05]
[null,"Repair factor",null,0.01]
[null,"Taxes & insurance factor",null,0.01]
[null,"Annual variable costs",null,0]
[]
[null,"Annual Costs"]
[null,"Depreciation and interest1",null,{"$f":"-PMT(D16,D14,D13+PV(D16,D14,0,D13*D15))","v":2112.9141947772764},{"$f":"D22/D$9","v":0.66028568586789893}]
[null,"Repairs",null,{"$f":"D11*D17","v":250},{"$f":"D23/D$9","v":7.8125E-2}]
[null,"Taxes & insurance",null,{"$f":"D11*D18","v":250},{"$f":"D24/D$9","v":7.8125E-2}]
[null,"Variable costs",null,{"$f":"D19","v":0},{"$f":"D25/D$9","v":0}]
[null,"Total Annual Costs",null,{"$f":"SUM(D22:D25)","v":2612.9141947772764},{"$f":"D26/D$9","v":0.81653568586789893}]
[]
[null,"Quality Adjustment"]
[null,"Adjustment factor",null,0.75]
[null,"Adjusted Total Annual Costs",null,{"$f":"D26*D29","v":1959.6856460829572},{"$f":"D30/D$9","v":0.61240176440092409}]
[null,"1 Depreciation and interest is proxied as ammortized loan payment"]
[]
[null,"Developed by Dhuyvetter and Dumler, KSU Agricultural Economics"]