BLW-Master-Deal-Analyzer.xlsx

	A	C	D	E	G	J	K	L	M	N	P
1	DEAL ANALYZER SOFTWARE					LOAN P&L
2	Property Address					Loan Origination Fee	3.00%				$4,200.00
3	City					Loan Processing Fee					$0.00
4	State					Appraisal Fee					$0.00
5	Zip					Attorney Fees					$0.00
6						Inspection Fee for Draws	0		$175.00		$0.00
7	After Repaired Value (ARV)		$200,000.00			Survey					$0.00
8	Purchase Price		$150,000.00			Title Insurance (1%)	1.00%				$1,400.00
9	Estimated Repairs		$2,860.00			Insurance					$0.00
10						Misc. Fees					$0.00
11						Total Closing Cost		$5,600.00
12	REHAB CALCULATOR					Loan Amount	70.00%				$140,000.00
13	APPLIANCES					Out of Pocket Cost (Down Pay)					$12,860.00
14	Dishwasher	1	unit	$450.00	$450.00	Closing Cost on Purchase					$5,600.00
15	Disposal	0	unit	$185.00	$0.00	TOTAL CASH OUT OF POCKET					$18,460.00
16	Stove	5	unit	$475.00	$2,375.00	Gross Profti					$41,540.00
17	Water Heater	0	unit	$675.00	$0.00	Moths To Sell	5
18	Vent Hood	0	unit	$85.00	$0.00	Mortgage Payment	10.00%				$5,833.33
19	BASEBOARDS					Taxes					$0.00
20	Basic	20	linear foot	$1.75	$35.00	Operating utilities					$0.00
21	BLINDS					Listing Fee					$0.00
22	Basch Aluminum 1"	0	blind	$25.00	$0.00	Sales Commission	3.00%				$6,000.00
23	Vertical Blinds	0	blind	$110.00	$0.00	Closing Cost on the Sale	3.00%				$6,000.00
24	CABINETS
25		0	per foot	$65.00	$0.00	Net Profit			$23,706.67
26	CABINET KNOBS & HANDLES					Net Profit			$23,706.67
27	Knobs	0	knob	$1.47	$0.00
28	Handles (3")	0	handle	$2.47	$0.00	CASH P&L
29	CLEANING					CASH P&L
30		0		$175.00	$0.00	After Repaired Value (ARV)					$200,000.00
31	COUNTERTOPS					Purchase Price					$150,000.00
32	Formica	0	linear feet	$25.00	$0.00	Estimated Repairs					$2,860.00
33	Granite	0	sq feet	$29.00	$0.00	Operating Utilities					$0.00
34	DOOR BELL					Listing Fee					$0.00
35		0	unit	$25.00	$0.00	Sales Commission				3.00%	$6,000.00
36	DOORS					Closing Cost On The Sale				3.00%	$6,000.00
37	Interior	0	unit	$39.00	$0.00
38	Exterior	0	unit	$175.00	$0.00	Net Profit			$47,140.00
39	DOOR KNOBS					Net Profit			$47,140.00
40	Interior	0	knob	$15.00	$0.00
41	Extrior	0	knob	$30.00	$0.00
42	ELECTRICAL
43	Standard Plug	0	unit	$9.00	$0.00
44	GFCI	0	unit	$16.00	$0.00
45	FENCING
46	Chain Link Fencing replacement	0	linear foot	$8.00	$0.00
47	Wood Fence Install	0	linear foot	$17.00	$0.00
48	FIRE ALARMS
49		0	unit	$17.00	$0.00
50	FLOORING
51	Carpet (Rental)	0	sq ft	$1.10	$0.00
52	Carpet (Upgrade)	0	sq ft	$1.30	$0.00
53	Laminate	0	sq ft	$3.00	$0.00
54	Tile	0	sq ft	$3.00	$0.00
55	Wood	0	sq ft	$5.00	$0.00
56	FOUNDATION
57		0		$125.00	$0.00
58	GARAGE DOOR
59	Garage Door Opener	0	unit	$275.00	$0.00
60	Garage Door (panel)	0	panel	$175.00	$0.00
61	Garage Door (single)	0	door	$350.00	$0.00
62	Garage Door (double)	0	door	$550.00	$0.00
63	HVAC
64	Condenser	0	unit	$1,400.00	$0.00
65	Furnance	0	unit	$1,000.00	$0.00
66	Full System	0	unit	$4,500.00	$0.00
67	LANDSCAPING
68	Basic	0		$300.00	$0.00
69	Medium	0		$500.00	$0.00
70	Upgrade	0		$1,000.00	$0.00
71	LIGHTING
72	Bathroom (mirror light)	0		$60.00	$0.00
73	Ceiling Fan	0		$100.00	$0.00
74	Flushmount	0		$22.00	$0.00
75	Hanging Table Light	0		$90.00	$0.00
76	Recessed Lighting	0		$45.00	$0.00
77	MIRROR
78	24x36	0		$40.00	$0.00
79	36x36	0		$65.00	$0.00
80	PAINTING
81	Interior Paint	0	sq ft	$1.25	$0.00
82	Exterior Paint	0	sq ft	$0.85	$0.00
83	PLUMBING
84	Bath Tub	0		$275.00	$0.00
85	Bath Faucet	0		$95.00	$0.00
86	Kitchen Faucet	0		$125.00	$0.00
87	Shower Kit	0		$145.00	$0.00
88	Valve Stops	0		$23.00	$0.00
89	PRESSURE WASHING
90		0		$275.00	$0.00
91	ROOF
92		0		$150.00	$0.00
93	SHEETROCK
94		0		$40.00	$0.00
95	SINK
96	Bathroom	0		$65.00	$0.00
97	Kitchen	0		$135.00	$0.00
98	SURROUNDS
99	Bath Tub Surround	0		$600.00	$0.00
100	Shower Surround	0		$800.00	$0.00