151 lines
7.8 KiB
Python
151 lines
7.8 KiB
Python
# Create your views here.
|
|
from django.http import HttpResponse, HttpResponseRedirect
|
|
from django.shortcuts import get_object_or_404, render, reverse
|
|
from django.template import loader
|
|
import pandas as pd
|
|
import numpy as np
|
|
from .forms import *
|
|
import io
|
|
import numpy_financial as npf
|
|
|
|
def PrC(units_consumed):
|
|
cutoff = 500
|
|
price_data1 = pd.DataFrame(np.array([[100, 0], [200, 2.25], [400, 4.5],
|
|
[500, 6]]),
|
|
columns=['Unit_Ceiling', 'Rate'])
|
|
|
|
price_data2 = pd.DataFrame(np.array([[100, 0], [400, 4.5], [500, 6],
|
|
[600, 8], [800, 9], [1000, 10],
|
|
[np.inf, 11]]),
|
|
columns=['Unit_Ceiling', 'Rate'])
|
|
|
|
if units_consumed < 0:
|
|
return 0
|
|
elif units_consumed > cutoff:
|
|
DB = price_data2
|
|
else:
|
|
DB = price_data1
|
|
|
|
DB['prev_slab'] = DB['Unit_Ceiling'].shift(1).fillna(0)
|
|
DB['cutoff'] = units_consumed - DB['prev_slab']
|
|
DB = DB.loc[DB['cutoff'] > 0, :].drop(['cutoff'], axis=1).reset_index(drop=True)
|
|
DB.at[DB.index[-1], 'Unit_Ceiling'] = units_consumed
|
|
|
|
bill = np.sum((DB['Unit_Ceiling'] - DB['prev_slab']) * DB['Rate'])
|
|
return bill
|
|
|
|
|
|
def SolarCalculatorView(request):
|
|
if request.method == 'GET':
|
|
form = SolarForm()
|
|
|
|
return render(request, 'Input.html', {
|
|
'form': form,
|
|
'Title': 'TNEB Solar Returns Calculator'
|
|
})
|
|
else:
|
|
# A POST request: Handle Form Upload
|
|
form = SolarForm(request.POST) # Bind data from request.POST into a PostForm
|
|
|
|
name = request.POST.get('name', '')
|
|
kw_installed = float(request.POST.get('kw_installed', ''))
|
|
initial_cost = int(request.POST.get('initial_cost', ''))
|
|
amc = int(request.POST.get('amc', ''))
|
|
units1 = int(request.POST.get('units1', ''))
|
|
units2 = int(request.POST.get('units2', ''))
|
|
units3 = int(request.POST.get('units3', ''))
|
|
units4 = int(request.POST.get('units4', ''))
|
|
units5 = int(request.POST.get('units5', ''))
|
|
units6 = int(request.POST.get('units6', ''))
|
|
|
|
# Savings Calculator
|
|
SolarSavings = pd.DataFrame([units1 + units2 + units3 + units4 + units5 + units6]
|
|
, columns=['Units Consumed'])
|
|
SolarSavings['Solar Units Generated'] = kw_installed * (4 * 6 + 3.5 * 4 + 3 * 2) * 30
|
|
SolarSavings['Bill Without Solar'] = PrC(units1) + PrC(units2) + PrC(units3) + PrC(units4) + PrC(units5) + PrC(
|
|
units6)
|
|
SolarSavings['Gross Bill With Solar'] = PrC(units1 - kw_installed * 3.5 * 60) + \
|
|
PrC(units2 - kw_installed * 4 * 60) + \
|
|
PrC(units3 - kw_installed * 4 * 60) + \
|
|
PrC(units4 - kw_installed * 4 * 60) + \
|
|
PrC(units5 - kw_installed * 3.5 * 60) + \
|
|
PrC(units6 - kw_installed * 3 * 60)
|
|
SolarSavings['Network Charges'] = SolarSavings['Solar Units Generated'] * .6 * .85
|
|
SolarSavings['Net Bill With Solar'] = SolarSavings['Gross Bill With Solar'] + SolarSavings['Network Charges']
|
|
SolarSavings['Annual Savings'] = SolarSavings['Bill Without Solar'] - SolarSavings['Net Bill With Solar']
|
|
|
|
# Cashflow at Inflation 4%, 6%, 8%
|
|
Cashflow = pd.DataFrame(list(range(1, 26)), columns=['Year'])
|
|
Cashflow['Investment & Charges'] = amc*1.0
|
|
# Initial Charges
|
|
Cashflow.loc[-1] = [0, initial_cost]
|
|
Cashflow.index = Cashflow.index + 1 # shifting index
|
|
Cashflow.sort_index(inplace=True)
|
|
|
|
Cashflow['Annual Savings'] = SolarSavings['Annual Savings'][0]
|
|
Cashflow.loc[0, 'Annual Savings'] = 0
|
|
Cashflow['Net Cashflow'] = Cashflow['Annual Savings'] - Cashflow['Investment & Charges']
|
|
Cashflow['4% Inflation'] = Cashflow['Annual Savings']*(1.04 ** Cashflow['Year']) - \
|
|
Cashflow['Investment & Charges']*(1.04 ** Cashflow['Year'])
|
|
Cashflow['6% Inflation'] = Cashflow['Annual Savings']*(1.06 ** Cashflow['Year']) - \
|
|
Cashflow['Investment & Charges']*(1.06 ** Cashflow['Year'])
|
|
Cashflow['8% Inflation'] = Cashflow['Annual Savings']*(1.08 ** Cashflow['Year']) - \
|
|
Cashflow['Investment & Charges']*(1.08 ** Cashflow['Year'])
|
|
|
|
P4Inf = pd.DataFrame(['4% Inflation'], columns=['Scenario'])
|
|
P4Inf['25 Year Return'] = "{0:.2%}".format(round(npf.irr(Cashflow['4% Inflation']), 4))
|
|
P4Inf['20 Year Return'] = "{0:.2%}".format(round(npf.irr(Cashflow['4% Inflation'][:21]), 4))
|
|
P4Inf['15 Year Return'] = "{0:.2%}".format(round(npf.irr(Cashflow['4% Inflation'][:16]), 4))
|
|
P4Inf['10 Year Return'] = "{0:.2%}".format(round(npf.irr(Cashflow['4% Inflation'][:11]), 4))
|
|
P4Inf['Payback Period'] = '{0} years'.format(len(np.cumsum(Cashflow['4% Inflation']
|
|
[np.cumsum(Cashflow['4% Inflation']) < 0])))
|
|
P4Inf['NPV @ 7% FD'] = "{:,.0f}".format(round(npf.npv(.07, Cashflow['4% Inflation']), 4))
|
|
|
|
P6Inf = pd.DataFrame(['6% Inflation'], columns=['Scenario'])
|
|
P6Inf['25 Year Return'] = "{0:.2%}".format(round(npf.irr(Cashflow['6% Inflation']), 4))
|
|
P6Inf['20 Year Return'] = "{0:.2%}".format(round(npf.irr(Cashflow['6% Inflation'][:21]), 4))
|
|
P6Inf['15 Year Return'] = "{0:.2%}".format(round(npf.irr(Cashflow['6% Inflation'][:16]), 4))
|
|
P6Inf['10 Year Return'] = "{0:.2%}".format(round(npf.irr(Cashflow['6% Inflation'][:11]), 4))
|
|
P6Inf['Payback Period'] = '{0} years'.format(len(np.cumsum(Cashflow['6% Inflation']
|
|
[np.cumsum(Cashflow['6% Inflation']) < 0])))
|
|
P6Inf['NPV @ 7% FD'] = "{:,.0f}".format(round(npf.npv(.07, Cashflow['6% Inflation']), 4))
|
|
|
|
P8Inf = pd.DataFrame(['8% Inflation'], columns=['Scenario'])
|
|
P8Inf['25 Year Return'] = "{0:.2%}".format(round(npf.irr(Cashflow['8% Inflation']), 4))
|
|
P8Inf['20 Year Return'] = "{0:.2%}".format(round(npf.irr(Cashflow['8% Inflation'][:21]), 4))
|
|
P8Inf['15 Year Return'] = "{0:.2%}".format(round(npf.irr(Cashflow['8% Inflation'][:16]), 4))
|
|
P8Inf['10 Year Return'] = "{0:.2%}".format(round(npf.irr(Cashflow['8% Inflation'][:11]), 4))
|
|
P8Inf['Payback Period'] = '{0} years'.format(len(np.cumsum(Cashflow['8% Inflation']
|
|
[np.cumsum(Cashflow['8% Inflation']) < 0])))
|
|
P8Inf['NPV @ 7% FD'] = "{:,.0f}".format(round(npf.npv(.07, Cashflow['8% Inflation']), 4))
|
|
|
|
Metric = pd.concat([P4Inf, P6Inf, P8Inf], axis=0, ignore_index=True)
|
|
|
|
# , '20 YEAR IRR', '15 YEAR IRR', '10 YEAR IRR', 'Payback Period',
|
|
# 'Discounted Payback'
|
|
# round(np.irr(Cashflow['Net Cashflow']), 2)
|
|
pd.options.display.float_format = '{:,.0f}'.format
|
|
|
|
buf = io.StringIO()
|
|
Metric.to_html(buf, escape=False, index=False, classes='" id = "table0')
|
|
Metric_HTML = buf.getvalue()
|
|
|
|
buf = io.StringIO()
|
|
Cashflow.to_html(buf, escape=False, index=False, classes='" id = "table1')
|
|
Cashflow_HTML = buf.getvalue()
|
|
|
|
buf = io.StringIO()
|
|
SolarSavings.to_html(buf, escape=False, index=False, classes='" id = "table2')
|
|
SolarSavings_HTML = buf.getvalue()
|
|
|
|
# IRR at 25, 20, 15, 10 Years
|
|
|
|
# Discounted Payback Period & Payback Period
|
|
return render(request, 'Output.html', {
|
|
'form': form,
|
|
'Title': f'Analysis of Investment in Solar Installation for {name}',
|
|
'DF_0': Metric_HTML,
|
|
'DF_1': Cashflow_HTML,
|
|
'DF_2': SolarSavings_HTML,
|
|
})
|