Rental Property Investor · Kennett Sq, PA · Member since 2019 · 14 posts · 4 votes
Hi all!
Im trying to figure out the financial side of a seller finance deal and need some help.
Basically what im trying to figure is a way to make a balloon calculator in excel based of the following criteria I want the payment to be $500 a month, 3% rate, 175,000 purchase price, 5 year balloon. How do I calculate what the balloon payment will be after 5 years and how do I create a amortization schedule?
Rental Property Investor · Gary, IN · Member since 2017 · 35 posts · 32 votes
5y
@Bas DeVries I made a spreadsheet for you.
Based on your criteria it looks like what you have is a 175k loan amortized over 832 months (69.333 years) at 3%. That results in a $500.00 monthly payment and a 5 year balloon amount of $170,959.58.
Link to spreadsheet below if you want to look at how this stuff is calculated. Should answer all your questions in this post, and I'll be happy to try to answer any other questions about it.
It can also serve as a calculator for any other amortizations.
Rental Property Investor · Gary, IN · Member since 2017 · 35 posts · 32 votes
5y
@Bas DeVries I made a spreadsheet for you.
Based on your criteria it looks like what you have is a 175k loan amortized over 832 months (69.333 years) at 3%. That results in a $500.00 monthly payment and a 5 year balloon amount of $170,959.58.
Link to spreadsheet below if you want to look at how this stuff is calculated. Should answer all your questions in this post, and I'll be happy to try to answer any other questions about it.
It can also serve as a calculator for any other amortizations.
Based on your criteria it looks like what you have is a 175k loan amortized over 832 months (69.333 years) at 3%. That results in a $500.00 monthly payment and a 5 year balloon amount of $170,959.58.
Link to spreadsheet below if you want to look at how this stuff is calculated. Should answer all your questions in this post, and I'll be happy to try to answer any other questions about it.
It can also serve as a calculator for any other amortizations.
Based on your criteria it looks like what you have is a 175k loan amortized over 832 months (69.333 years) at 3%. That results in a $500.00 monthly payment and a 5 year balloon amount of $170,959.58.
Link to spreadsheet below if you want to look at how this stuff is calculated. Should answer all your questions in this post, and I'll be happy to try to answer any other questions about it.
It can also serve as a calculator for any other amortizations.
@Caleb Teachout I am new to Bigger Pockets forums (listener of the BP rookies podcast) but found this thread through a google search. Your spread sheet sounds super helpful. Is there a way you could link that to me? I tried to copy and paste but it denied me access. Thanks! Blake
Investor · PHX AZ · Member since 2022 · 4 posts · 3 votes
3y
@Caleb Teachout I was just looking into this and creating my own. I am always learning so much from BP community. Sent a request.You mind sharing with me as well?
Based on your criteria it looks like what you have is a 175k loan amortized over 832 months (69.333 years) at 3%. That results in a $500.00 monthly payment and a 5 year balloon amount of $170,959.58.
Link to spreadsheet below if you want to look at how this stuff is calculated. Should answer all your questions in this post, and I'll be happy to try to answer any other questions about it.
It can also serve as a calculator for any other amortizations.
@Caleb Teachout I was just looking into this and creating my own. I am always learning so much from BP community. Sent a request.You mind sharing with me as well?
Please provide me the access to spreadsheet. Thanks