Compound interest exel template

No problem, you can still follow the exact same steps. Chapter 4: How to calculate compound interest in Excel. If you have tried searching the internet for formulas on compound interest, you probably scratched your head due to the complexity of the formulas. To compute the compound interest in Excel for different time periods, all you have to do is convert the formula above into a relatable formula in Excel. The easiest to compute out of all time periods is the annual compound interest.

Because the formula we presented to you earlier is set for annual. Therefore, no adjustments are needed. Looks familiar? To calculate the balance, all we have to do is input the formula and fill it out with the correct cell references:. Just enter a few data and the template will calculate the compound interest for a particular investment.

Additionally, the template also provides a schedule of payments and accumulated interests in each period. The basic calculator consists of 2 sections: Input and Output. Those cells having light-blue color is the input section and cells with dark blue are the output section.

The Output section is auto-populated based on the above-entered data. It consists of the following heads:. The input section is the same as the above. Compounding frequency and deposit frequency both have a drop-down list.

Select the desired option fro the list where:. Total Additional Payments: It is the total additional payments made. Payments multiplied by pay periods. The template creates a payment and interest schedule based on the data input in the Advanced Compound Interest Calculator. No entry is to be made on this sheet. It is auto-populated. Vardhan is looking to buy a new brand car on loan.

The model which he has liked will cost him the on-road price of 25,37, He can make an initial down payment of 10,00, and the rest of the amount he wants to be in the form of a loan. Bajaj finance is ready to provide him with a loan at a rate of interest of Vardhan wants the loan period to be of 5 years as he would be receiving equivalent payment in the future. So, he asks the banker to keep OD overdraft only for 5 years. Vardhan has asked the banker to compute what excess amount he would be paying for the loan.

You are required to calculate compound interest for 5 years. We are given all the variables here that is P is 15,37, 25,37, ,00, , Rate of interest is The excess amount would be interested, and that would be around 12 lakhs as he is paying out a loan and principal payment only at the end of 5 years. Shankar is interested in a new investment product which has been recently launched by Invest Corp.

The scheme asks to invest initially 50,, and that will be matured after 15 years, and the guaranteed rate of interest will be 9.