How to prepare loan amortization schedule by using Balloon Payment Method in Excel spreadsheet
Hi guys, in this video, I've shown the calculation and preparation of loan amortization by using a balloon payment method. Under the balloon payment method, the actual total payment is greater than the interest amount but less than the required total payment over the period while remaining outstanding and its interest amounts will be paid on the maturity period.
Time Stamps:
00:00 Introduction
00:32 Starting Note
00:51 Putting data for calculation
01:09 For Compounding Methods, No. of Periods and Periodic Interest Rate
01:27 Calculation of Required Total Payment
02:37 Calculation of Actual Total Payment
04:54 Calculation of Future Value
05:07 Preparation of Loan Amortization Schedule
09:44 Applying Conditional Formatting
11:12 Calculation of Total Interest
12:39 Result Analysis
Reducing Balance Method of Loan Amortization: [ Ссылка ]
Straight Line Balance Method of Loan Amortization: [ Ссылка ]
Bullet Payment Method of Loan Amortization: [ Ссылка ]
Negative Loan Amortization Method: [ Ссылка ]
Reducing Balance with Extra Payment Method: [ Ссылка ]
Flat Rate Method of Loan Amortization: [ Ссылка ]
To get theoretical knowledge about it please visit the blog by clicking on the link below: [ Ссылка ]
#LoanAmortizationSchedule #BalloonPaymentMethod #Loan
For Excel File Download: [ Ссылка ]
To get in touch please follow on:
▶Facebook: [ Ссылка ]
▶ Twitter: [ Ссылка ]
▶ Instagram: [ Ссылка ]
▶ YouTube: [ Ссылка ]...
▶ Blogger: [ Ссылка ]
▶ G-Mail: myefinancesheet@gmail.com
Thank you for watching this video. If you find it useful please hit the like button and don't forget to subscribe to this channel and press the bell icon for more updates.
Ещё видео!