Mar 12, 2011

Excel Functions for Financial Analysis

Excel Functions for Financial Analysis for Finance Manager:
AMORDEGRC (cost, date purchased, first period, salvage, period, rate, basis)
If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account.

AMORLINC (cost, date purchased, first period, salvage, period, rate, basis)
Returns the depreciation for each accounting period. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account.

CUMIPMT
Returns the cumulative interest paid between two periods.

CUMPRINC
Returns the cumulative principal paid on a loan between two periods

DB (cost, salvage, life, period, month)
Returns the depreciation of an asset for a specified period using the fixed-declining balance method.

DDB (cost, salvage, life, period, factor)
Returns the depreciation of an asset for a specified period using the double declining balance method or some other method you specify

MIRR (values, finance rate reinvest rate)
Returns the modified internal rate of return for a series of periodic cash flows. MIRR considers both the cost of the investment and the interest received on reinvestment of cash.

IRR (values, guess)
Returns the internal rate of return for a series of cash flows

PV (rate, nper pmt, fv, type)
Returns the present value of an investment

NPV (rate, value1, value2,)
Returns the net present value of an investment based on a series of periodic cash flows and a discount rate

XNPV (rate, values, dates)
Returns the net present value for a schedule of cash flows that is not necessarily periodic.

SLN (cost, salvage, life)
Returns the straight-line depreciation of an asset for one period

SYD (cost, salvage, life, per)
Returns the sum-of-years' digits depreciation of an asset for a specified period
        SYD = (cost-salvage) x (life – per + 1) x 2
                (Life)(Life + 1)

VDB (cost, salvage, life, start period, end period, factor, no switch)
Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. VDB stands for variable declining balance.

XIRR (values, dates, guess)
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.

No comments:

Post a Comment

Tags

accredited distance education Ambush Marketing Benchmarking Benefits of MBA Books Branding Business Communication Business Negotiation Career Guide Case Studies CMAT Consumer Adoption Process Corporate Social Responsibility CRM CV Writing Debentures Depreciation Distance Learning Economics topics EMBA Entrepreneurship Finance your MBA Financial Analysis Financial Management Financial Planning Financial statement Formal Report Fund Flow Statement Gmat GRI Group Discussion Hotel Management HR notes International Marketing Leadership Letter of Intent london business school Management Notes Manager of Sales Managerial Decisions Marketing Concepts Marketing Management Marketing Mix Marketing Tips MBA Assignment MBA Careers mba courses MBA Definitions mba degree MBA Dissertation Topics MBA Economics Project MBA Finance Topics MBA Glossary MBA Guide MBA in Australia mba in canada MBA in International Business MBA in IT mba in malaysia MBA in public relations MBA in UK mba in usa MBA Interview MBA Jobs MBA Jobs In Australia MBA Loan MBA Notes MBA Outsourcing MBA Presentations MBA Prjoject Reports MBA Programs MBA Ranking MBA Salary MBA Scholarships MBA Sponsorships MBA Student MBA without GMAT MBO Media Planning Process Mini MBA Motivation Online Accredited MBA online mba Online MBA and Correspondence MBA Opportunity Cost Overseas Education Consultants Part Time MBA PEST analysis PLC Popular Business Schools Porter's 5 Forces Profit Maximization and Wealth Maximization Project Management Project Report Projects Tips Resume Writing Scientific Management Segmentation Strategic management Study Abroad Study in Germany Supply Chain Management SWOT Team Management Skills Theories top mba TQM Trade Discounts Training & Development Trend Analysis Types Of MBA Views of Management viral marketing Women In MBA