From the BiggerPockets Blog

 BiggerPockets Blog »

Jump to Forum View All

Click a category below to view different forum categories.

BiggerPockets

General Info

BiggerPockets Q&A, Site Questions, & Announcements

1518 topics, 14423 posts — Last Post 04/20/14, 12:35PM

BiggerPockets Exclusive PRO Area

118 topics, 841 posts — Last Post 04/20/14, 12:30PM

New Member Introductions

10901 topics, 85744 posts — Last Post 04/20/14, 01:46PM

Real Estate Success Stories

396 topics, 6162 posts — Last Post 04/20/14, 01:05PM

General Real Estate

General Real Estate

Buying & Selling Real Estate

5945 topics, 46881 posts — Last Post 04/20/14, 01:42PM

Renters

644 topics, 5822 posts — Last Post 04/20/14, 10:45AM

Get Foreclosure Help - Help Stop Foreclosure Forum

316 topics, 2557 posts — Last Post 04/16/14, 03:58AM

Home Owner Association (HOA) Issues & Problems Forum

237 topics, 1609 posts — Last Post 04/17/14, 08:53AM

Do it Yourself

657 topics, 6285 posts — Last Post 04/20/14, 01:45PM

Reviews & Feedback

Real Estate Deal Analysis and Advice

3684 topics, 29539 posts — Last Post 04/20/14, 01:49PM

Real Estate Guru, Book & Course Reviews and Discussions

1134 topics, 11564 posts — Last Post 04/20/14, 08:34AM

Ask About A Real Estate Company

741 topics, 7325 posts — Last Post 04/20/14, 01:13PM

Real Estate Investing

Real Estate Strategies

Wholesaling

5606 topics, 43766 posts — Last Post 04/20/14, 01:19PM

Rehabbing and House Flipping

3335 topics, 31015 posts — Last Post 04/20/14, 01:37PM

Real Estate Development & New Home Construction

553 topics, 4686 posts — Last Post 04/20/14, 12:11PM

Innovative Strategies

704 topics, 6030 posts — Last Post 04/20/14, 10:54AM

Tax Liens, Notes, Paper, & Cash Flows Discussion

866 topics, 6678 posts — Last Post 04/19/14, 06:06AM

Rent to Own a.k.a. Lease Purchase, Lease Options

694 topics, 4905 posts — Last Post 04/20/14, 12:33PM

1031 Exchanges

143 topics, 1054 posts — Last Post 04/18/14, 08:41AM

Foreclosure Investing

General Foreclosure & Pre-Foreclosure Forums

1688 topics, 11297 posts — Last Post 04/20/14, 01:52PM

HUD, VA, and Tax Sales

415 topics, 3097 posts — Last Post 04/19/14, 10:19PM

REOs

1214 topics, 10578 posts — Last Post 04/20/14, 12:34AM

Short Sales

1534 topics, 13120 posts — Last Post 04/17/14, 04:44PM

Landlord & Tenant Forums

Landlord & Rental Property Questions

7209 topics, 70794 posts — Last Post 04/20/14, 11:46AM

Mobile Homes & Mobile Home Park Investing

638 topics, 5141 posts — Last Post 04/19/14, 09:49AM

Investor Basics

Starting Out

7710 topics, 60515 posts — Last Post 04/20/14, 01:26PM

Investor Psychology

431 topics, 6107 posts — Last Post 04/20/14, 06:04AM

General Real Estate Investing

4719 topics, 37221 posts — Last Post 04/20/14, 12:07PM

Real Estate Investor Marketing

1731 topics, 14096 posts — Last Post 04/20/14, 01:34PM

Commercial Real Estate

Commercial Real Estate Investing Forum

1410 topics, 8994 posts — Last Post 04/19/14, 04:34PM

Multi-Family and Apartment Investing

1110 topics, 9242 posts — Last Post 04/20/14, 12:21PM

The Business of Real Estate

Real Estate Technology and the Internet

Real Estate Technology, Social Media & Blogging

641 topics, 4897 posts — Last Post 04/20/14, 08:43AM

Business Basics

Goals, Business Plans & Entities

831 topics, 7562 posts — Last Post 04/18/14, 04:25PM

Real Estate Finance & Legal

Financial, Tax, and Legal

Tax, Legal Issues, Contracts, Self-Directed IRA

2789 topics, 20031 posts — Last Post 04/20/14, 01:42PM

Property Insurance

309 topics, 2045 posts — Last Post 04/17/14, 07:41PM

Personal Finance Discussion

328 topics, 2732 posts — Last Post 04/19/14, 06:57PM

Loans, Mortgages, Credit Lines

Private & Conventional Lending Discussion

2836 topics, 19714 posts — Last Post 04/20/14, 12:58PM

Creative Real Estate Financing

1210 topics, 8772 posts — Last Post 04/20/14, 06:59AM

Crowdfunding Real Estate

35 topics, 463 posts — Last Post 04/19/14, 06:24PM

Real Estate Professionals

Real Estate Professionals

Real Estate Agents

1211 topics, 7998 posts — Last Post 04/20/14, 11:41AM

Bankers, Lenders, and Mortgage Brokers

441 topics, 1922 posts — Last Post 04/20/14, 07:09AM

Contractors

270 topics, 1684 posts — Last Post 04/20/14, 09:21AM

Local Real Estate

Local Real Estate

Local Real Estate Networking & Recommendations

1992 topics, 11621 posts — Last Post 04/20/14, 12:46PM

Americans & International Real Estate

161 topics, 566 posts — Last Post 04/14/14, 11:19AM

Foreigners Buying in the USA

62 topics, 409 posts — Last Post 04/10/14, 06:27AM

Canadian Real Estate

64 topics, 429 posts — Last Post 04/20/14, 08:33AM

Marketplace

Real Estate Marketplace

Real Estate Marketplace

15024 topics, 53968 posts — Last Post 04/20/14, 12:27PM

Real Estate Events and Happenings

165 topics, 2519 posts — Last Post 04/20/14, 01:56PM

Off-Topic

Off Topic

Off-Topic

2905 topics, 32411 posts — Last Post 04/19/14, 08:03AM

Housing News & Real Estate Market

914 topics, 8351 posts — Last Post 04/17/14, 08:41AM

BiggerPockets Real Estate Investing Summit

97 topics, 1751 posts — Last Post 04/10/14, 02:27PM

BiggerPockets Resources

Forums » Tax Liens, Notes, Paper, & Cash Flows Discussion » How to calculate a promissory note with a balloon payment

How to calculate a promissory note with a balloon payment

8 posts by 3 users

Signup

Real Estate Investor · Savannah, Georgia


I have a property that I intend to carry the mortgage for. My exit strategy is to sell this note to a note buyer, so I am trying to write this in a way that they will appreciate.

Here are the numbers. Please tell me if you know how to calculate it?

100,000 purchase price
20,000 down payment
80,000 loan amount
10% interest rate amortized over
30 years
30,000 balloon payment in five years

What is the payment amount for this (not including taxes and insurance)?

Thank you!!!



SFR Investor · Wheat Ridge, Colorado


Payment on $80K at 10% for 30 years is $702.06. You can calculate that with a financial calculator or in Excel. In Excel, the formula is: -PMT(10%/12,30*12,80000)

After five years, the balance on the loan will be $77,259.46. You calculate that with the FV function:
=-FV(10%/12,5*12,-702.06,80000)

Not quite sure what your intention is after the $30K payment. Typically a balloon payment would mean the entire loan must be paid at that time. So a "five year balloon" would mean the loan is to be paid off after five years.

So, maybe you mean the payments continue at the same $702.06 payment after the $30K payment. If so, the question is how many payments remain. You would calculate that with the NPER (number of periods) function:
=NPER(10%/12,-702.06,47259.46)

The answer is 99 payments plus a partial payment would still need to be make.

If instead you meant you want the loan to only have $30K remaining balance after five years, then you need to use a shorter amortization than 30 years. In that case you would calculate the payment using the PMT function and a future value of $30K after five years. That payment is $1,312.35, which equates to a 85.5 month amortization period.


Jon Holdman, Flying Phoenix LLC


Real Estate Investor · Savannah, Georgia


Jon,

Thank you so much for the math lesson. Learned a lot about Excels functions.

I guess a better way to ask the question would be:

80,000 loan amount
10% int amortized over 30 years
with a balloon in 5 years.
Whatever that balloon balance might be at that point.

Thanks again, for the help!



SFR Investor · Wheat Ridge, Colorado


So, then its easy. Its just the $702.06 payment. The balloon payment doesn't change the monthly payment. The payment is determined only by the rate, loan amount and the amortization period. The balance after five years is $77,259.46.


Jon Holdman, Flying Phoenix LLC


Real Estate Investor · Savannah, Georgia


Thanks again.

So 702.06 per month for 60 months and the last payment of 77,259.46 as a balloon. Does this sound attractive for a note buyer?



Note Investor · Pasadena, California


Angela,

The appeal of this particular note would depend on the payor's credit score and his/her actual potential to come up with that balloon payment.


Loc R., Individual/Private Note Buyer
E-Mail: [email protected]
Telephone: 626-590-6828
I buy individual notes - all states, shapes & sizes.


Real Estate Investor · Savannah, Georgia


Would it make a difference if the borrower told the note buyer that they would be refinancing to pay off the loan by time the balloon is due?



Note Investor · Pasadena, California


No. If the payor refis, the investor still gets his/her balloon.


Loc R., Individual/Private Note Buyer
E-Mail: [email protected]
Telephone: 626-590-6828
I buy individual notes - all states, shapes & sizes.




Sign up