All Forum Posts by: Joseph Stapleton

In this instance the seller is a licensed agent that owns rental property and is willing to hold a note for the buyer. The seller would like to defer 25% of the purchase price.

0 Votes

Apologies for the lengthy post. I put together the above worksheet for a 10yr cash flow analysis. My question mainly is surrounding the IRR and whether I calculated it correctly. I used the IRR function and inputted initial cash invested : cumulative cash flow. The negative percentages are throwing me off for year 3-10.

If there is anything else I may have miscalculated please correct me.

0 Votes

Purchase Price - $4,098,720
Projection Based On - 51,234 SF
Income	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
Gross Rent (3% Escalation)	$1,160,962	$1,195,791	$1,231,665	$1,268,615	$1,306,673	$1,345,873	$1,386,249	$1,427,836	$1,470,671	$1,514,791
Less: Vacancy @ 5%	$58,048	$59,790	$61,583	$63,431	$65,334	$67,294	$69,312	$71,392	$73,534	$75,740
Less: Improvements	$307,404	$307,404	$307,404	$307,404	$307,404	$102,468	$102,468	$102,468	$102,468	$102,468
Total Operating Income	$795,510	$828,597	$862,678	$897,780	$933,935	$1,176,111	$1,214,469	$1,253,976	$1,294,669	$1,336,583

Expenses	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
Less: Rent Abatement	$61,481	$61,481	$61,481	$61,481	$61,481	$30,740	$0	$0	$0	$0
Less: Broker Fees	$69,658	$0.00	$0.00	$0.00	$0.00	$52,267	$0.00	$0.00	$0.00	$0.00
Total Operating Exp.	$131,139	$61,481	$61,481	$61,481	$61,481	$83,007	$0.00	$0.00	$0.00	$0.00

Income Analysis	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10	Mortgage Assumptions
NOI	$664,371	$767,116	$801,197	$836,299	$872,454	$1,093,104	$1,214,469	$1,253,976	$1,294,669	$1,336,583	Purchase Price PSF:	$80/PSF	$4,098,720
Less: Mortgage Pmt.	$237,672	$237,672	$237,672	$237,672	$237,672	$237,672	$237,672	$237,672	$237,672	$237,672	Loan to Value (LTV):	75%	$3,074,040
Cash Flow	$426,699	$529,444	$563,525	$598,627	$634,782	$855,432	$976,797	$1,016,304	$1,056,997	$1,098,911		Interest Rate:	6%	$237,672
Purchase Price Cap Rate	16%	18.7%	19.5%	20%	21%	26.6%	29.6%	30.5%	31.5%	32.6%	Amortization (years):	25
COCR	33%	41%	43.8%	46.5%	49%	66.5%	75.9%	79%	82%	85%	Total Cost of Mortgage:	$5,941,825
Return On Equity	33.8%	31%	26%	22.8%	20.5%	23.8%	23.9%	22.1%	20.6%	19.4%	Down Payment:	25%	$1,024,680
	Loan Commitment Fee:	1%	$30,740
Loan Anlysis	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10		Loan Closing Costs:	4.5%	138,332
Market Value (5% Appreciation)	$4,098,720	$4,303,656	$4,518,839	$4,744,781	$4,982,020	$5,231,121	$5,492,677	$5,767,311	$6,055,677	$6,358,461		Acquisition Fees:	3.00%	$92,221
Less: Loan Balance	$2,836,368	$2,598,696	$2,361,024	$2,123,352	$1,885,680	$1,648,008	$1,410,336	$1,172,664	$934,992	$697,320		Initial Cash Invested:	$1,285,973
Equals: Equity	$1,262,352	$1,704,960	$2,157,815	$2,621,429	$3,096,340	$3,583,113	$4,082,341	$4,594,647	$5,120,685	$5,661,141

Sale Analysis	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10		Financial Metrics
Equity	$1,262,352	$1,704,960	$2,157,815	$2,621,429	$3,096,340	$3,583,113	$4,082,341	$4,594,647	$5,120,685	$5,661,141		Cap Rate (Purchase Price):	16%
Less: Selling Costs @ 4.5%	$56,806	$76,723	$97,102	$117,964	$139,335	$161,240	$183,705	$206,759	$230,430	$254,751		Cash On Cash Return (Year 1):	33%
Equals: Proceeds After Sale	$1,205,546	$1,628,237	$2,060,713	$2,482,094	$2,957,005	$3,421,873	$3,898,636	$4,387,888	$4,890,255	$5,406,390		Internal Rate Of Return (Year 10):	-83.42%
Plus: Cum. Cash Flow	$426,699	$956,143	$1,519,668	$2,118,295	$2,753,077	$3,608,509	$4,585,306	$5,601,610	$6,658,607	$7,757,518		Sale Price (Year 10):	16,707,288
Less: Initial Cash Inv.	-$1,285,973	-$1,285,973	-$1,285,973	-$1,285,973	-$1,285,073	-$1,285,973	-$1,285,973	-$1,285,973	-$1,285,973	-$1,285,973
Equals: Net Profit	$346,272	$1,298,407	$2,294,408	$3,314,416	$4,424,109	$5,744,409	$7,197,969	$8,703,525	$10,262,889	$11,877,935
Internal Rate of Return	201.38%	34%	-15%	-39.29%	-53.32%	-64.36%	-71.95%	-77.04%	-80.69%	-83.42%

0 Votes

@Sean Richway Do you lend in NY State? Sending you an email.

0 Votes

*1.3M Assumable mortgage (with permission) 4.58% 20 year term $13,500 per month includes principal, interest and property taxes. Owner also willing to hold 2nd mortgage for $1-200K. The proeprty is currently master leased to Catholic Charities for 3-4yrs. Option to terminate the lease with Catholic Charities upon purchase.

I am a licensed agent in NY state. In this transaction I will be representing the buyer. Commission negotiable. Please PM or email me at [email protected] to discuss further.

0 Votes

Syracuse NY - 58 efficiencies Apartments spread between 4 two story buildings with 23,000 sf of leasable space. There is an onsite laundry. Each apartment is approximately 400 sf and consists of a large main room, kitchen area, and full bathroom. Each kitchen is equipped with full sized refrigerator, electric stove/oven, sink and a dining area. All apartments feature new replacement windows, newer appliances, windows shades and are cable ready. In addition the building was wired for Verizon FIOS.

Ask - $1.95M

Gross Income: $312,480

Expenses:

Taxes: $55,840.48

Insurance: $10,366.44

Utilities: $42,000

Water: $17,800

Garbage: $3,500

Snow: $1,944

Pest Control: $1,627.68

Maintenance: $18,000

Total Expenses: $151,078.60 NOI: $161,401.40

0 Votes

I have a few multi family portfolio and hotel deals available under $2.5M, with $100K+ NOI, 8-12% CAP. Sites are located primarily in Upstate NY. A few of these deals fell through due to seller financing condition, which can complicate the deal structure sometimes. So I'm primarily looking to work with cash Buyers. However, I will consider working with qualified investors that require seller financing condition.

Please feel free to PM me or shoot me an email with your criteria.

0 Votes

Seeking down payment/closing cost funding in return for equity. I'm proposing 20% equity in the property / 20% of the net cash flow. The property is in Upstate NY, college rented duplex. Rented through Spring 17'.

My goal is to acquire conventional funding from a local credit union.

Structure - Lender that is willing to take 2nd lien position to the credit union.

Exit Strategy - Refinance after 24 months. Lender get's original investment back + 20% of cash flow over 24 months.

Investment - $80k

Net Cash Flow (20%) - $2,794/yr

0 Votes

@Paris Wilson I just sent you an email. Definitely interested in this property as well as others you may have in the DMV area. Thank you!

0 Votes

@Andrew Nevins I mentioned the Deanwood neighborhood in my previous post.

Just looking for opinions of renting to Veterans and if anyone has experience collecting rent from the VA voucher program.

0 Votes

All Forum Posts by: Joseph Stapleton

Joseph Stapleton has started 9 posts and replied 19 times.

Post: Real Estate Agent Deferring Capital Gains

Post: Calculating Internal Rate of Return - NN Lease

Post: Calculating Internal Rate of Return - NN Lease

Post: New Direct Lending Programs‏

Post: 4 Apartment buildings - Syracuse NY 8% CAP

Post: 4 Apartment buildings - Syracuse NY 8% CAP

Post: Buyers Agent in NY State - Large mult-fam portfolios & Hotels

Post: Seeking Gap Funding In Return for 20% Equity

Post: Rare 3 Level Building: The Charles Village & Remington Area

Post: 3 Multi-Unit Buildings / NE DC DEAL ANALYSIS?