answersLogoWhite

0


Best Answer

Excel has a group of financial functions, some of which would do those things. There are functions for working out rates of interest, payments you would need to make, the future value of investments, how much you would have to invest to get a certain return and many other things relating to loans and investments. You could also build your own formulas to calculate these things using other functions.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What functions are used to analyze loans and investments?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you calculate interst rates on Mircosoft Excel 2003?

It depends on what you are trying to calculate, like interest on investments or loans for example. The INTRATE function and the RATE function can be used. There are other specialised financial functions too.


What is the purpose of amortization calculators?

An Amortization Calculator is used for calculating mortgage rates and it is also used to calculate to analyze other debit such as short term loans and student loans.


Where Can Working Capital Loans Be Used For?

Working capital loans are regularly used to fund many aspects of a small business. Preceding customers have used their loans for many functions, consisting of funding payroll or taxes, marketing, business expansion, or even buying new stock.


What is the Function of Microsoft excel?

There are many functions of Excel but this can be generalised by saying it is used for numerical analysis and manipulation. So you are mainly dealing with working on calculations on numbers for a huge amount of potential reasons. Just about anything you want to do with numbers you can do in a spreadsheet. There is a lot more that you can do too, like graphs and diagrams.


What do mean by cma data in banking terms?

Credit Monitoring Arrangement Data, or CMA Data, is a financial report used by lending institutions to assess and analyze a company's financial status prior to financing. For project loans, term loans, and working capital constraints, CMA data is necessary.


What spectra are used to analyze stars?

The spectra of the stars you want to analyze.


What is net property income?

Net operating income (NOI) is a calculation used to analyze real estate investments that generate income. Net operating income equals all revenue from the property minus all reasonably necessary operating expenses.


What are adjustable rate loans commonly used for?

Adjustable-rate loans are commonly used for mortgages. These loans are also referred to as "variable-rate loans" because the interest rate for the loan can change.


What is military lending used for?

Military lending can be used for a multitude of things such as: the basic military loans, personal loans, and P2P military loans. These loans can be administered and applied for by those where are and previously were in the military.


Money used for investments?

capital


When used by sociologists the term wealth refers to?

The term wealth, when used by sociologists, refers to the total assets and resources (such as property, investments, or income) owned by an individual or a group. It is often used to analyze patterns of economic inequality and social stratification within societies.


Why are budget loans getting such a bad press?

Budget loans are getting bad press because the loans are not being used for the purposes intended. Budget loans are used to balance the budget but instead, these loans are being used to pay for other liabilities that should have been used by another bucket of money. Budget loans should be used to balance the budget and if it is used in other ways that are not conducive to good business ethics, then the likelihood of bad press comes into the picture.