,Financial gains from storage,Example /t, /t, /t, /t, A,Harvest logistics/timeliness,Grain price x reduction in value after damage x probability of damage ,"16,2",0,,, B,Local market gain (feed to feedlot),Post harvest grain price - harvest grain price,,,,,0 C,Seasonal trends in market,Post harvest grain price - harvest grain price,,,,,0 D,Freight (peak vs out-of-season rate),Peak rate /t - post harvest rate /t,20,,,, E,Cleaning to improve the grade,Clean grain price - original grain price - cleaning costs - shrinkage,,,,,0 F,Blending to lift average grade,Blended price - ((low grade price x mix) + (high grade price x mix)),,,,, G,Drying for early harvest,Grain price x reduction in value after damage x probability of damage ,,,,, H,Other benefits,,,,, I,Total benefits,Sum of benefits,"36,2",0,0,0, ,,,,,, J,Capital cost,Infrastructure cost / storage capacity,155,,,, ,,,,,, ,Fixed costs,,,,, K,Annualised depreciation cost,Capital cost /t / expected life of storage eg 25yrs,"6,2",,,, L,Opportunity cost on capital,Capital cost /t x opportunity or interest rate eg 8 / 2,"6,2",,,, M,Total fixed costs,Sum of fixed costs,"12,4",0,0,0, ,,,,,, ,Variable costs,,,,, N,Storage hygiene,(Labour rate /hr x time to clean hrs / storage capacity) + structural treatment,"0,23",,,, O,Aeration cooling,Indicatively 23c for the first 8 days then 18c per month /t,"0,91",,,, P,Repairs and maintenance,Estimate eg..
How to create a Cost Benefit Analysis Template example spreadsheet? The best way is by downloading this sample Cost Benefit Analysis Template example Excel template now!
This Excel spreadsheet is an interactive digital worksheet in tabular form and designed to organize information and perform calculations with scalable entries. It's not a matter of being a beginner or professional, from all over the world, are now using spreadsheets to create tables, calculations, comparisons, overviews, etc for any personal or business need.
This useful worksheet in Excel will make the task a little easier and can be used for organization, analysis, accounting and storage of data in order to increase your productivity. This Cost Benefit Analysis Template example gives you a headstart and is useful because it also has the basic formula’s included. If time and quality are of the essence, this worksheet can certainly help you out!
Download this Cost Benefit Analysis Template example Excel spreadsheet directly to your computer, open it, modify it or print it directly. You'll see it is a great way to increase your productivity and to bring your task to a successful ending!