How to Calculate a Balloon Payment in Excel with Pictures · For example for a loan amount of $150 000 you would enter 150 000 Excel will assume this is an amount of money no need to enter the dollar sign Enter your balloon amount into cell B4 This should be a negative number as it is a payment For example for a $27 000 balloon payment you would enter 27 000 5 Set up your equation The function that will be used here in the payment function