|loan calculator with balloon payment option||0.33||0.5||9746||96|
We can use the below formula to calculate the future value of the balloon payment to be made at the end of 5 years: FV = PV x (1+r) n – P x [ (1+r) n – 1 / r ] The rate of interest per annum is 8.00%, and monthly it shall be 8.00%/12, which is 0.67%. = 270,000 x (1+0.67%) 60 – 2,922.62 x [ (1+0.67%) 60 – 1 / 0.67% ] = 187,513.27How do you calculate a balloon loan?
Calculating a Balloon Payment in Excel Gather the details of your proposed balloon payment loan. Open a new worksheet in Excel. Create labels for your variables. Enter the variables for your loan. Set up your equation. Enter your variables. Press enter to solve your equation. Review your answer.