Cost Benefit Analysis Template xlsx

Using this Cost Benefit Analysis Template xlsx template guarantees that you will save time, cost and efforts and enables you to reach the next level of success in your project, education, work, and business. Download it now!

Looking for more? Our collection of financial documents, templates, forms, and spreadsheets includes templates designed specifically for small business owners, private individuals, or Finance Staff. Find financial projections to calculate your startup expenses, payroll costs, sales forecast, cash flow, income statement, balance sheet, break-even analysis, financial ratios, cost of goods sold, amortization and depreciation for your company. These financial templates also work with OpenOffice and Google Spreadsheets, so if you are operating your business on a very tight budget, hopefully, you'll be able to make these financial templates work for you as well.

IDEASS: Cost-Benefit Analysis of a Solar PV Installation,,, Key Variables,,, ,Range,Your Scenario,, Square feet of roof space,85680,"7964,00951814396",, Cost of solar panels (including balance of system costs),see table below,"5,6",, Solar insolation (kWh/yr per kw installed),1300-1400,1300,, Current cost of electricity , 0.12 - 0.16,"0,15",, System lifespan (years),25-35,30,, Interest Rate (if loan is needed for capital costs),0 - 8 ,"0,02",, Annual Increase in Cost of Electricity,0 - 2 ,"0,01",, Discount Rate,1 - 7 ,"0,04",, Degradation rate of PV panels,0 - 2 ,"0,01",, California Solar Initiative Incentive ( /watt), 0.25 - 0.60,"0,4",, "Federal Tax Credit (30 of total system cost, after CA incentive)",30 ,"0,3",, ,,, "Panel Types, Efficiency, and Cost",,, ,w/m2,Range ( /w),kw/m2, mono c-Si,"225,6", 5 - 7,"0,2256", multi c-Si,"206,4", 4.50 - 6.50,, R c-Si,156, 3.50 - 5.50,, CdTe,"127,2", 2.50 - 4,, ,,, Your Task: Build an Excel Model to Calculate Net Present Value of the System ,,, "Set up your model with a row for each year - you can use the table below to start you off..