<?php
//	session_start();
//	require('../createdata.php');
?>
<html>
	<head>
 		<script src="https://code.jquery.com/jquery-1.12.4.js"></script>
 		<script type="text/javascript" charset="utf8" src="../DataTables/DataTables-1.10.16/js/jquery.dataTables.min.js"></script>
		<script type="text/javascript" charset="utf8" src="../DataTables/datatables.min.js"></script>
		<script type="text/javascript" charset="utf8" src="../DataTables/Buttons-1.5.1/js/dataTables.buttons.js"></script>
		<script type="text/javascript" charset="utf8" src="../DataTables/Buttons-1.5.1/js/buttons.colVis.js"></script>
		<link rel="stylesheet" type="text/css" href="../DataTables/datatables.min.css">
		<link rel="stylesheet" type="text/css" href="../DataTables/DataTables-1.10.16/css/jquery.dataTables.min.css">
		<link rel="stylesheet" type="text/css" href="../DataTables/Buttons-1.5.1/css/buttons.dataTables.css">
		<script>
			$(document).ready( function () {
				var list =[6,3,8,3,10,5,0.5,'2000-01-01'];
	    		
				var table = $('#trans').DataTable({
					dom: 'Brtip',
					buttons: [
						{ //show monthly
							extend: 'colvisGroup',
							text: 'Monthly Only',
							show: [0,1,2,3,5,6,7,9,10,11,13,14,15,
								   18,19,20,22,23,24,26,27,28,30,31,32,
								   35,36,37,39,40,41,43,44,45,47,48,49,
								   52,53,54,56,57,58,60,61,62,64,65,66,
								   69,70,71,73,74,75,77,78,79,81,82,83,
								   86,87,88,90,91,92,94,95,96,98,99,100,
								   103,104,105,107,108,109,111,112,113,115,116,117,120],
							hide: [4,8,12,16,
								   21,25,29,33,
								   38,42,46,50,
								   55,59,63,67,
								   72,76,80,84,
								   89,93,97,101,
								   106,110,114,118,
								   17,34,51,68,85,102,119]
						},
						{
							extend: 'colvisGroup',
							text: 'Quarterly Only',
							show: [0,4,8,12,16,
								   21,25,29,33,
								   38,42,46,50,
								   55,59,63,67,
								   72,76,80,84,
								   89,93,97,101,
								   106,110,114,118],
							hide: [1,2,3,5,6,7,9,10,11,13,14,15,
								   18,19,20,22,23,24,26,27,28,30,31,32,
								   35,36,37,39,40,41,43,44,45,47,48,49,
								   52,53,54,56,57,58,60,61,62,64,65,66,
								   69,70,71,73,74,75,77,78,79,81,82,83,
								   86,87,88,90,91,92,94,95,96,98,99,100,
								   103,104,105,107,108,109,111,112,113,115,116,117,120,
								   17,34,51,68,85,102,119]
						},
						{
							extend: 'colvisGroup',
							text: 'Quarterly Yearly',
							show: [0,4,8,12,16,
								   21,25,29,33,
								   38,42,46,50,
								   55,59,63,67,
								   72,76,80,84,
								   89,93,97,101,
								   106,110,114,118,
								   17,34,51,68,85,102,119],
							hide: [1,2,3,5,6,7,9,10,11,13,14,15,
								   18,19,20,22,23,24,26,27,28,30,31,32,
								   35,36,37,39,40,41,43,44,45,47,48,49,
								   52,53,54,56,57,58,60,61,62,64,65,66,
								   69,70,71,73,74,75,77,78,79,81,82,83,
								   86,87,88,90,91,92,94,95,96,98,99,100,
								   103,104,105,107,108,109,111,112,113,115,116,117,120]
						},
						{
							extend: 'colvisGroup',
							text: 'Show all',
							show: ':hidden'
						}
					],
	    			processing: true,
	    			paging: false,
	    			scrollX: true,
	    			scrollY: 500,
	    			scrollCollapse: true,
	    			ordering: false,
					columnDefs:[{targets:[0],width:120},
								{targets:[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120],className:"dt-right"},
								{targets:[0],class:"wrapok"},
								{targets:[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120],
								createdCell: function(td,cellData,rowData, row,col){
									if(cellData<0)
										$(td).css('color','red');
									}
								}
					],
					fixedColumns: true,
					fixedColumns:{leftColumns: 1},
					serverSide: true,
	    			ajax: {
	    				url: "../server_side/server_processing.php",
	    				type: "POST",
	    				data: {
	    					//list: list,
							prop: '514Creek'
	    				}
	    			},
	    			createdRow: function ( row, data, index ) {
	    				if(data[0] == "Operating Expenses")
							$(row).css("background-color","lemonchiffon");
						if(data[0] == "Net Operating Income")
							$(row).css("background-color","powderblue");
						if(data[0] == "Unlevered Cash Flow")
							$(row).css("background-color","lightgray");
						if(data[0] == "Levered Cash Flow")
							$(row).css("background-color","plum");
						if(data[0] == "Before Tax Cash Flow")
							$(row).css("background-color","palegreen");
						if(data[0] == "Maket Value")
							$(row).css("background-color","moccassin");
						if(data[0] == "(-) Vacancy"){
							$('td',row).eq(0).css("color","red");
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(+) Other Income"){
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(-) Property Tax"){
							$('td',row).eq(0).css("color","red");
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(-) Acquisition"){
							$('td',row).eq(0).css("color","red");
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(+) Loan Draw"){
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(+) Cost"){
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(-) Insurance"){
							$('td',row).eq(0).css("color","red");
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(-) HOA"){
							$('td',row).eq(0).css("color","red");
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(-) Property Management"){
							$('td',row).eq(0).css("color","red");
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(-) Utilities"){
							$('td',row).eq(0).css("color","red");
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(-) Maintenance and Repair"){
							$('td',row).eq(0).css("color","red");
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(-) Tenant Improvements"){
							$('td',row).eq(0).css("color","red");
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(-) Leasing Commissions"){
							$('td',row).eq(0).css("color","red");
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(-) Reserves"){
							$('td',row).eq(0).css("color","red");
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(-) Principal"){
							$('td',row).eq(0).css("color","red");
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(-) Interest"){
							$('td',row).eq(0).css("color","red");
							$('td',row).eq(0).css("padding-left","30px");
						}
						if(data[0] == "(-) Capital Improvements"){
							$('td',row).eq(0).css("color","red");
							$('td',row).eq(0).css("padding-left","30px");
						}
					}
	    		});
			});
			
			function edit_row(){
				var list =[6,3,8,3,10,5,0.5,200000,'2000-01-01'];
				list[0] = document.getElementById("t_app").value;
				list[1] = document.getElementById("t_exp").value;
				list[2] = document.getElementById("t_vac").value;
				list[3] = document.getElementById("t_rent").value;
				list[4] = document.getElementById("t_tax").value;
				list[5] = document.getElementById("t_salesdate").value;
				list[6] = document.getElementById("t_lc").value;
				list[7] = document.getElementById("t_mgmt").value;
				
				$.ajax({
					type:'post',
					url:'future.php',
					data:{
						edit_row:'edit_row',
						list:list
					},
					success:function(response) {
						if(response=="success") {
							document.write("success");
						}
					}
				});
				$('#trans').DataTable().ajax.reload();
			}

			function createdata(){
				$.ajax({
					type:'post',
					url:'../createdata.php',
					data:{
						function2call: 'setup',
						prop:'514Creek'
					},
					success:function(response) {
						if(response=="success") {
							document.write("success");
						}
					}
				});
				$('#trans').DataTable().ajax.reload();
			}
		</script>
		<style>
    		td.wrapok{
    			white-space:normal
    		}
    	</style>
	</head>
	<body>
		<?php 
	/*	$purchprice = $_SESSION['fullarray'][1][34]+$_SESSION['fullarray'][1][32]+$_SESSION['fullarray'][1][31];

		echo "<h1>".$_SESSION['fullarray'][1][1]."</h1>";
		echo "<table id=\"details\" width=1200px border=1 style='border-collapse:collapse;'>";
		echo 	"<tr align=left>";
		echo		"<th>Address</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][1]."</td>";
		echo		"<th>City</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][2]."</td>";
		echo		"<th>State</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][3]."</td>";
		echo		"<th>Zip</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][4]."</td>";
		echo		"<th>Subdivision</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][8]."</td>";
		echo	"</tr><tr align=left>";
		echo		"<th>Purchase Date</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][17]."</td>";
		echo		"<th>Sq Ft</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][6]."</td>";
		echo		"<th>Yr Built</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][5]."</td>";
		echo		"<th>Bd-Ba-Ga</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][7]."</td>";
		echo		"<th>ZPID</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][14]."</td>";
		echo	"</tr><tr align=left>";
		echo		"<th>HOA</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][10]."</td>";
		echo		"<th>HOA Mgmt</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][11]."</td>";
		echo		"<th>HOA Acct</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][12]."</td>";
		echo		"<th>Ins Acct</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][13]."</td>";
		echo		"<th>RFID</th>";
		echo		"<td style='padding: 0px 0px 0px 10px;'>".$_SESSION['fullarray'][1][15]."</td>";
		echo	"</tr><tr align=left>";
		echo		"<th>Purchase Price</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($purchprice,2)."</td>";
		echo		"<th>Credits</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][33],2)."</td>";
		echo		"<th>Broker Commission</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][36],2)."</td>";
		echo		"<th>Survey</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][26],2)."</td>";
		echo		"<th>Wire Fees</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][29],2)."</td>";
		echo	"</tr><tr align=left>";
		echo		"<th>Total Price w/out Renovation</th>";
		$noreno = $purchprice+$_SESSION['fullarray'][1][33]+$_SESSION['fullarray'][1][23]+$_SESSION['fullarray'][1][24]+$_SESSION['fullarray'][1][25]+$_SESSION['fullarray'][1][26]+$_SESSION['fullarray'][1][27]+$_SESSION['fullarray'][1][28]+$_SESSION['fullarray'][1][29]+$_SESSION['fullarray'][1][30]+$_SESSION['fullarray'][1][35]+$_SESSION['fullarray'][1][36]+$_SESSION['fullarray'][1][37];
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($noreno,2)."</td>";
		echo		"<th>Deposit</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][32],2)."</td>";
		echo		"<th>Recording Fees</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][25],2)."</td>";
		echo		"<th>Attorney</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][23],2)."</td>";
		echo		"<th>Title Insurance</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][24],2)."</td>";
		echo	"</tr><tr align=left>";
		echo		"<th>Total Price w/ Renovation</th>";
		$reno = $purchprice+$_SESSION['fullarray'][1][33]+$_SESSION['fullarray'][1][23]+$_SESSION['fullarray'][1][24]+$_SESSION['fullarray'][1][25]+$_SESSION['fullarray'][1][26]+$_SESSION['fullarray'][1][27]+$_SESSION['fullarray'][1][28]+$_SESSION['fullarray'][1][29]+$_SESSION['fullarray'][1][30]+$_SESSION['fullarray'][1][35]+$_SESSION['fullarray'][1][36]+$_SESSION['fullarray'][1][37]+$_SESSION['fullarray'][1][38];
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($reno,2)."</td>";
		echo		"<th>Option Money</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][34],2)."</td>";
		echo		"<th>Title Company</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][37],2)."</td>";
		echo		"<th>HOA</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][27],2)."</td>";
		echo		"<th>Inspection</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][28],2)."</td>";
		echo	"</tr><tr align=left>
					<th>Renovation</th>";
		echo		"<td align='right'style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][38],2)."</td>";
		echo		"<th></th><td></td>";
		echo		"<th>Property Tax</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][35],2)."</td>";
		echo	"<td align=right style='border-right:none;'>Negative -</td><td style='border-left:none;'>seller prepay</td>";
		echo		"<th>Other</th>";
		echo		"<td align='right' style='padding: 0px 30px 0px 0px;'>".number_format($_SESSION['fullarray'][1][30],2)."</td>";
		echo "</tr></table>";
		*/
		?>
		<br>
		<input id="createdata" type='button' value="Setup" onclick="createdata();">
		<table>
			<form id="paramform">
				<tr>
					<td>Appreciation (%)</td>
					<td><input id="t_app" style="width:25px;" type="number" value="6"></td>
					<td>Expense (%)</td>
					<td><input id="t_exp" style="width:25px;" type="number" value="3"></td>
					<td>Vacancy (%)</td>
					<td><input id="t_vac" style="width:25px;" type="number" value="8"></td>
					<td>Rent (%)</td>
					<td><input id="t_rent" style="width:25px;" type="number" value="3"></td>
					<td>Property Tax (%)</td>
					<td><input id="t_tax" style="width:33px;" type="number" value="10"></td>
					<td>Management (%)</td>
					<td><input id="t_mgmt" style="width:25px;" type="number" value="5"></td>
					<td>Lease-Up (month)</td>
					<td><input id="t_lc" style="width:35px;" type="number" step=".1" value="0.5"></td>
					<td>Sales Date</td>
					<td><input id="t_salesdate" style="width:120px;" type="date" min = "2018-01-01" max="2022-01-01" value="2022-01-01"></td>
					<td><input id="paramclick" type='button' value="update" onclick="edit_row();"></td>
				</tr>
			</form>
		</table>
		<br>
		<table id="trans" class="hover row-border cell-border">
			<thead>
				<tr>
					<th> </th>
					<th style="border-left: 1px solid black" colspan="17">2015</th>
					<th style="border-left: 1px solid black" colspan="17">2016</th>
					<th style="border-left: 1px solid black" colspan="17">2017</th>
					<th style="border-left: 1px solid black" colspan="17">2018</th>
					<th style="border-left: 1px solid black" colspan="17">2019</th>
					<th style="border-left: 1px solid black" colspan="17">2020</th>
					<th style="border-left: 1px solid black" colspan="17">2021</th>
					<th style="border-left: 1px solid black">2022</th>
				<tr>
					<th> </th>
					<th class="month" style="border-left: 1px solid black">Jan</th>
					<th class="month">Feb</th>
					<th class="month">Mar</th>
					<th class="quarter">Q1</th>
					<th class="month">Apr</th>
					<th class="month">May</th>
					<th class="month">Jun</th>
					<th class="quarter">Q2</th>
					<th class="month">Jul</th>
					<th class="month">Aug</th>
					<th class="month">Sep</th>
					<th class="quarter">Q3</th>
					<th class="month">Oct</th>
					<th class="month">Nov</th>
					<th class="month">Dec</th>
					<th class="quarter">Q4</th>
					<th class="year">Yr</th>
					<th class="month" style="border-left: 1px solid black">Jan</th>
					<th class="month">Feb</th>
					<th class="month">Mar</th>
					<th class="quarter">Q1</th>
					<th class="month">Apr</th>
					<th class="month">May</th>
					<th class="month">Jun</th>
					<th class="quarter">Q2</th>
					<th class="month">Jul</th>
					<th class="month">Aug</th>
					<th class="month">Sep</th>
					<th class="quarter">Q3</th>
					<th class="month">Oct</th>
					<th class="month">Nov</th>
					<th class="month">Dec</th>
					<th class="quarter">Q4</th>
					<th class="year">Yr</th>
					<th class="month" style="border-left: 1px solid black">Jan</th>
					<th class="month">Feb</th>
					<th class="month">Mar</th>
					<th class="quarter">Q1</th>
					<th class="month">Apr</th>
					<th class="month">May</th>
					<th class="month">Jun</th>
					<th class="quarter">Q2</th>
					<th class="month">Jul</th>
					<th class="month">Aug</th>
					<th class="month">Sep</th>
					<th class="quarter">Q3</th>
					<th class="month">Oct</th>
					<th class="month">Nov</th>
					<th class="month">Dec</th>
					<th class="quarter">Q4</th>
					<th class="year">Yr</th>
					<th class="month" style="border-left: 1px solid black">Jan</th>
					<th class="month">Feb</th>
					<th class="month">Mar</th>
					<th class="quarter">Q1</th>
					<th class="month">Apr</th>
					<th class="month">May</th>
					<th class="month">Jun</th>
					<th class="quarter">Q2</th>
					<th class="month">Jul</th>
					<th class="month">Aug</th>
					<th class="month">Sep</th>
					<th class="quarter">Q3</th>
					<th class="month">Oct</th>
					<th class="month">Nov</th>
					<th class="month">Dec</th>
					<th class="quarter">Q4</th>
					<th class="year">Yr</th>
					<th class="month" style="border-left: 1px solid black">Jan</th>
					<th class="month">Feb</th>
					<th class="month">Mar</th>
					<th class="quarter">Q1</th>
					<th class="month">Apr</th>
					<th class="month">May</th>
					<th class="month">Jun</th>
					<th class="quarter">Q2</th>
					<th class="month">Jul</th>
					<th class="month">Aug</th>
					<th class="month">Sep</th>
					<th class="quarter">Q3</th>
					<th class="month">Oct</th>
					<th class="month">Nov</th>
					<th class="month">Dec</th>
					<th class="quarter">Q4</th>
					<th class="year">Yr</th>
					<th class="month" style="border-left: 1px solid black">Jan</th>
					<th class="month">Feb</th>
					<th class="month">Mar</th>
					<th class="quarter">Q1</th>
					<th class="month">Apr</th>
					<th class="month">May</th>
					<th class="month">Jun</th>
					<th class="quarter">Q2</th>
					<th class="month">Jul</th>
					<th class="month">Aug</th>
					<th class="month">Sep</th>
					<th class="quarter">Q3</th>
					<th class="month">Oct</th>
					<th class="month">Nov</th>
					<th class="month">Dec</th>
					<th class="quarter">Q4</th>
					<th class="year">Yr</th>
					<th class="month" style="border-left: 1px solid black">Jan</th>
					<th class="month">Feb</th>
					<th class="month">Mar</th>
					<th class="quarter">Q1</th>
					<th class="month">Apr</th>
					<th class="month">May</th>
					<th class="month">Jun</th>
					<th class="quarter">Q2</th>
					<th class="month">Jul</th>
					<th class="month">Aug</th>
					<th class="month">Sep</th>
					<th class="quarter">Q3</th>
					<th class="month">Oct</th>
					<th class="month">Nov</th>
					<th class="month">Dec</th>
					<th class="quarter">Q4</th>
					<th class="year">Yr</th>
					<th class="month" style="border-left: 1px solid black">Jan</th>
				</tr>
			</thead>
		</table>
		<br><br>
		<table id="analysis" style="border:1px solid black;border-collapse:collapse;">
			<tr>
				<th align = left style="padding: 5px 10px 5px 5px;border:1px solid black;">Gross Rent</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][2],2)."</td>";
					echo "<td></td>";
					echo "<td style='border-right:1px solid black;'></td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;color:red;border:1px solid black;">&emsp;(-) Vacancy</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][3],2)."</td>";
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format(-($_SESSION['fullarray'][1][39][3]/$_SESSION['fullarray'][1][39][2])*100,2)."%</td>";
					//echo "<td align=left style='padding: 5px 5px 5px 10px;border:1px solid black;'>Vac / <br>Gross</td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;border:1px solid black;">Effective Rent</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][4],2)."</td>";
					//echo "<td></td>";
					//echo "<td style='border-right:1px solid black;'></td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;border:1px solid black;">&emsp;(+) Other Income</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][5],2)."</td>";
					//echo "<td></td>";
					//echo "<td style='border-right:1px solid black;'></td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;color:red;border:1px solid black;">&emsp;(-) Opex</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][6],2)."</td>";
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format((-($_SESSION['fullarray'][1][39][6]/($_SESSION['fullarray'][1][39][5]+$_SESSION['fullarray'][1][39][4]))*100),2)."%</td>";
					//echo "<td align=left style='padding: 5px 5px 5px 10px;border:1px solid black;'>Opex / <br>(Rent+OI)</td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;border:1px solid black;">NOI</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][13],2)."</td>";
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format((($_SESSION['fullarray'][1][39][13]/$purchprice)*100),2)."%</td>";
					//echo "<td align=left style='padding: 5px 5px 5px 10px;border:1px solid black;'>NOI / <br>Purchase Price</td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;color:red;border:1px solid black;">&emsp;(-) TI</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][14],2)."</td>";
					//echo "<td></td>";
					//echo "<td style='border-right:1px solid black;'></td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;color:red;border:1px solid black;">&emsp;(-) LC</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][15],2)."</td>";
					//echo "<td></td>";
					//echo "<td></td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;color:red;border:1px solid black;">&emsp;(-) Res</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][16],2)."</td>";
					//echo "<td></td>";
					//echo "<td style='border-right:1px solid black;'></td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;border:1px solid black;">Unlevered C-o-C</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format(($_SESSION['fullarray'][1][39][18]-$_SESSION['fullarray'][1][39][17]),2)."</td>";
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format((($_SESSION['fullarray'][1][39][18]-$_SESSION['fullarray'][1][39][17])/$purchprice)*100,2)."%</td>";
					//echo "<td align=left style='padding: 5px 5px 5px 10px;border:1px solid black;'>Unlevered / <br>Purchase Price</td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;border:1px solid black;">&emsp;(+) Loan Draw</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][19],2)."</td>";
					//echo "<td></td>";
					//echo "<td style='border-right:1px solid black;'></td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;border:1px solid black;">&emsp;(+) Loan Cost</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][20],2)."</td>";
					//echo "<td></td>";
					//echo "<td style='border-right:1px solid black;'></td>";
				?>
			</tr>
			<tr>
			<th align=left style="padding: 5px 10px 5px 5px;color:red;border:1px solid black;">&emsp;(-) Loan Principal</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][21],2)."</td>";
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format(-($_SESSION['fullarray'][1][39][21]/$purchprice),2)."</td>";
					//echo "<td align=left style='padding: 5px 5px 5px 10px;border:1px solid black;'>DSCR</td>"
				?>
			</tr>
			<th align=left style="padding: 5px 10px 5px 5px;color:red;border:1px solid black;">&emsp;(-) Loan Interest</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][22],2)."</td>";
					//echo "<td></td>";
					//echo "<td></td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;border:1px solid black;">Levered C-o-C</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format(($_SESSION['fullarray'][1][39][24]-$_SESSION['fullarray'][1][39][17]),2)."</td>";
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format((($_SESSION['fullarray'][1][39][24]-$_SESSION['fullarray'][1][39][17])/$purchprice)*100,2)."%</td>";
					//echo "<td align=left style='padding: 5px 5px 5px 10px;border:1px solid black;'>Unlevered / <br>Purchase Price</td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;color:red;border:1px solid black;">&emsp;(-) Capital Improv</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][25],2)."</td>";
					//echo "<td></td>";
					//echo "<td style='border-right:1px solid black;'></td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;border:1px solid black;">BTCF</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format(($_SESSION['fullarray'][1][39][26]-$_SESSION['fullarray'][1][39][17]),2)."</td>";
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format((($_SESSION['fullarray'][1][39][26]-$_SESSION['fullarray'][1][39][17])/$purchprice)*100,2)."%</td>";
					//echo "<td align=left style='padding: 5px 5px 5px 10px;border:1px solid black;'>BTCF / <br>Purchase Price</td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;border:1px solid black;">Depreciation</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][27],2)."</td>";
					//echo "<td></td>";
					//echo "<td></td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;border:1px solid black;">Tax Basis</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][28],2)."</td>";
					//echo "<td></td>";
					//echo "<td></td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;border:1px solid black;">Mkt Value</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][29],2)."</td>";
					//echo "<td></td>";
					//echo "<td></td>";
				?>
			</tr>
			<!--
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;border:1px solid black;">Unlev</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][18],2)."</td>";
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format((($_SESSION['fullarray'][1][39][18]/$purchprice)*100),2)."%</td>";
					//echo "<td align=left style='padding: 5px 5px 5px 10px;border:1px solid black;'>Unlev / <br>Purchase Price</td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;color:red;border:1px solid black;">&emsp;(-) Principal</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][20],2)."</td>";
					//echo "<td></td>";
					//echo "<td style='border-right:1px solid black;'></td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;color:red;border:1px solid black;">&emsp;(-) Interest</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][21],2)."</td>";
					//echo "<td></td>";
					//echo "<td style='border-right:1px solid black;'></td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;border:1px solid black;">Lev</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][22],2)."</td>";
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format(($_SESSION['fullarray'][1][39][22]/$_SESSION['fullarray'][1][39][17]),2)."</td>";
					//echo "<td align=left style='padding: 5px 5px 5px 10px;border:1px solid black;'>DSCR</td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;color:red;border:1px solid black;">&emsp;(-) CI</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][23],2)."</td>";
					//echo "<td></td>";
					//echo "<td style='border-right:1px solid black;'></td>";
				?>
			</tr>
			<tr>
				<th align=left style="padding: 5px 10px 5px 5px;border:1px solid black;">BTCF</th>
				<?php
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format($_SESSION['fullarray'][1][39][24],2)."</td>";
					//echo "<td align=right style='padding: 5px 5px 5px 10px;border:1px solid black;'>".number_format(($_SESSION['fullarray'][1][39][24]/$purchprice)*100,2)."%</td>";
					//echo "<td align=left style='padding: 5px 5px 5px 10px;border:1px solid black;'>BTCF / <br>Purchase Price</td>";
				?>
			</tr>-->
		</table>
	</body>
</html>