<div>
Here are 2 ways to calculate a balloon payment using Excel.<br />
<br />
<a href="http://www.wikihow.com/Calculate-a-Balloon-Payment-in-Excel" rel="ugc">http://www.wikihow.com/Calculate-a-Balloon-Payment-in-Excel</a>
</div>


Here are 2 ways to calculate a balloon payment using Excel.

http://www.wikihow.com/Calculate-a-Balloon-Payment-in-Excel [http://www.wikihow.com/Calculate-a-Balloon-Payment-in-Excel]

<div>
Thank you Scott. &nbsp;I checked out the website. &nbsp;However, it requires that I enter a monthly payment amount. &nbsp;I will no payments, until after the 30th year.
</div>


Thank you Scott.  I checked out the website.  However, it requires that I enter a monthly payment amount.  I will no payments, until after the 30th year.

<div>
So you want to calculate a loan for 30 years making no payments until after 30 years?<br />
<br />
I'm not sure how that would be done as I can't think of any real-world practical application for that.<br />
<br />
I would assume there would be penalties, etc. involved.<br />
<br />
If no penalties, I would think you would take the principal * 3.5% add that to the principal to come up with the next amount and then do that for 360 months.
</div>


So you want to calculate a loan for 30 years making no payments until after 30 years?

I'm not sure how that would be done as I can't think of any real-world practical application for that.

I would assume there would be penalties, etc. involved.

If no penalties, I would think you would take the principal * 3.5% add that to the principal to come up with the next amount and then do that for 360 months.

<div>
Thank you Rob. &nbsp;The Future Value formula is exactly what I needed, and works perfectly in my excel spreadsheet.
</div>


Thank you Rob.  The Future Value formula is exactly what I needed, and works perfectly in my excel spreadsheet.

<div>
<div class="content wysiwyg-content">
Loan amount = $61,000<br />
Annual interest rate = 3.5%<br />
Period of load = 30 years<br />
Monthly payment = $0.00<br />
Balloon payment amount at the end of 30 years = ?<br />
<br />
I am trying to develop a schedule in Excel that will show all 360 payments, and the final balloon payment amount.<br />
<br />
Thanks for your help.
</div>
</div>


Loan amount = $61,000
Annual interest rate = 3.5%
Period of load = 30 years
Monthly payment = $0.00
Balloon payment amount at the end of 30 years = ?

I am trying to develop a schedule in Excel that will show all 360 payments, and the final balloon payment amount.

Thanks for your help.

How can I calculate a balloon payment in Excel?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.