Skip to main content

Posts

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)
Post a Comment
Read more
Recent posts

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 ==>
Post a Comment
Read more

Java Tutorial Part 5

Keywords Keywords are the predefined words in a program,we can't alter the meaning of keywords. Ex:- for,do,if,class,public. There are almost 62 keywords are in java Identifiers Which is used to give name for a variable or class or methods. Rules for a valid identifier are, *identifiers name must need to begin with an alphabet not by a number.(i.e. 1name is invalid name1 is valid) *Keywords will not be an identifier *Case sensitive, upper case and lower case are treated differently (if you have a variable HELLO and hello, system will treat both in differently)
Post a Comment
Read more

Java tutorial Part 4

i mport java.io.*; class   example {      public   static   void  main(String  args [])   {            System.out.println ("Hello Java");      }    }   Let's look at how to save the file, compile and run the program. Please follow the steps given below:   Open notepad and add the code as above.   Save the file as: example.java .   Open a command prompt window and go o the directory where you saved the class. Assume it's C :\.   Set the path   Type ' javac example .java ' and press enter to compile your code. If there are no errors in your code, the command prompt will take you to the next line (Assumption : The path variable is set).   Now, type ' java example ' to run your program.   You will be able to see ' Hello Java ' printed on the window.   Understanding first java ...
Post a Comment
Read more

Java Tutorial Part 3 (Features of Java)

Simple: Java is designed to be easy to learn. syntax is based on C++ Object Oriented:   In Java, everything is an Object. Java can be easily extended since it is based on the Object model Platform independent:   Java code can be run on multiple platforms  Unlike many other programming languages including C and C++, when Java is compiled, it is not compiled into platform specific machine, rather into platform independent byte code. This byte code is distributed over the web and interpreted by virtual Machine (JVM) on whichever platform it is being run.   Secure:   With Java's secure feature it enables to develop virus-free, tamper-free systems.  Java program cannot harm other system thus making it secure Java provides secure way to access web applications Java provides secure means of creating internet applications Robust Java encourages error free programming by being strictly typed and performing compile time and ru...
Post a Comment
Read more

Java Tutorial Part 2

Tools required to create Java program. Before creating a program, understood what are requirement to create a java program Java Development Kit(JDK) You have to install java development kit (JDK) in your machine. JDK contains the resource to create a program ,which contains java compiler ,java interpreter, jar, javdoc etc. A Text Editor -Earlier we have used notepad ,this is the best for a beginner to learn but in professional approach we have to use an Integrated Development Environment(IDE) like Netbeans or Eclipse An integrated development environment ( IDE ) is a software application that provides comprehensive facilities to computer programmers for software development. An  IDE  normally consists of a source code editor, build automation tools and a debugger.  
Post a Comment
Read more

JAVA Tutorial Part 1

Part 1 ,we are discussing about basic programming concepts. Java is a general purpose object oriented programming language. There are few technical terms in the first sentence, it might be difficult to understand for a beginner's ,right  here I can explain the basic terms. Program -Series of instructions (Code) to perform a particular task. And Collection of program's are referred to a Software Language's you know it very well, which using for communication. Here computer Language's are classified into 2 category's, they are Machine Language or Low level language and High Level Language Machine Language - Which is the one and only language, a computer can understood directly and this is binary itself either 0 or 1.Simply we can say computer could understood binary language only. Programming instructions written by using a natural language(English) is termed as High level language . Example for the high level language's are Java,C,C++,PHP,ASP...
Post a Comment
Read more