Skip to main content

Posts

Showing posts from 2016

How to calculate monthly payment( installment) for a Loan Amount in Excel

In Excel there is built in function PMT() to calculate the payment for a loan amount. For example - our loan amount is $50000 ,interest rate is 10.5% and period is 48 months *Get PMT function from Financial formula's *Enter the data properly on fiels Rate is the interest rate which is divided by 12 (to convert to monthly) As per our example 10.5% divided by 12 (Cell reference can select instead of direct value) Nper is the terms or number of months(48) (Cell reference can select instead of direct value) Pv is the present value or Loan Amount ($50000)  (Cell reference can select instead of direct value)

C++ program to implement Fibanocci series by recursion (Example for function recursion)

#include<iostream.h> #include<conio.h> int fib(int); int main() {     int n;     int f=0,s=1;     cout<<"Enter the range";     cin>>n;     cout<<"fibanocci series... ";     cout<<f<<"\t"<<s;     for (int i=2;i<n;i++)     cout<<"\t"<<fib(i);     getch(); } int fib(int n) {     if(n==1 || n==0)     {             return n;     }     else     {         return (fib(n-1)+fib(n-2));     }         } Output ==>