Microsoft Exam 77-427 Topic 3 Question 4 Discussion

Various financial functions (reference) are as follows:

1. ACCRINT function: It is used to return the accrued interest for a security that pays periodic interest.

2. ACCRINTM function: It is used to return the accrued interest for a security that pays interest at maturity.

3. AMORDEGRC function: It is used to return the depreciation for each accounting period by using a depreciation coefficient.

4. COUPDAYBS function: It is used to return the number of days from the beginning of the coupon period to the settlement date.

5. AMORLINC function: It is used to return the depreciation for each accounting period.

6. COUPDAYS function: It is used to return the number of days in the coupon period containing the settlement date.

7. COUPDAYSNC function: It is used to return the number of days from the settlement date to the next coupon date.

8. COUPNCD function: It is used to return the next coupon date after the settlement date.

9. COUPNUM function: It is used to return the number of coupons payable between the settlement date and maturity date.

10. COUPPCD function: It is used to return the previous coupon date before the settlement date.

11. CUMIPMT function: It is used to return the cumulative interest paid between two periods.

12. CUMPRINC function: It is used to return the cumulative principal paid on a loan between two periods.

13. DB function: It is used to return the depreciation of an asset for a specified period by using the fixed-declining balance method.

14. DDB function: It is used to return the depreciation of an asset for a particular period by using the double-declining balance method.

15. DISC function: It is used to return the discount rate for a security.

16. DOLLARDE function: It is used to convert a dollar price that is expressed as a fraction into a dollar price that is expressed as a decimal number.

17. DOLLARFR function: It is used to convert a dollar price that is expressed as a decimal number into a dollar price that is expressed as a fraction.

18. DURATION function: It is used to return the annual duration of a security with periodic interest payments.

19. EFFECT function: It is used to return the effective annual interest rate.

20. FV function: It is used to return the future value of an investment.

21. FVSCHEDULE function: It is used to return the future value of a starting principal after applying a series of compound interest rates.

22. INTRATE function: It is used to return the interest rate for a fully invested security.

23. IPMT function: It is used to return the interest payment for an investment for a specified period.

24. IRR function: It is used to return the internal rate of return for a series of cash flows.

25. ISPMT function: It is used to calculate the interest paid during a particular period of an investment.

26. MDURATION function: It is used to return the Macauley modified duration for a security with an assumed par value of $100.

27. MIRR function: It is used to return the internal rate of return in which positive and negative cash flows are financed at different rates.

28. NOMINAL function: It is used to return the annual nominal interest rate.

29. NPER function: It is used to return the number of periods for an investment.

30. NPV function: It is used to return the net present value of an investment on the basis of a series of periodic cash flows and a discount rate.

31. ODDFPRICE function: It is used to return the price per $100 face value of a security with an odd first period.

32. ODDFYIELD function: It is used to return the yield of a security with an odd first period.

33. ODDLPRICE function: It is used to return the price per $100 face value of a security with an odd last period.

34. ODDLYIELD function: It is used to return the yield of a security with an odd last period.

35. PMT function: It is used to return the periodic payment for an annuity.

36. PPMT function: It is used to return the payment on the principal for an investment for a particular defined period.

37. PRICE function: It is used to return the price per $100 face value of a security that pays Periodic interest.

38. PRICEDISC function: It is used to return the price per $100 face value of a discounted security.

39. PRICEMAT function: It is used to return the price per $100 face value of a security that pays interest at maturity.

40. PV function: It is used to return the current value of an investment.

41. RATE function: It is use d to return the interest rate per period of an annuity.

42. RECEIVED function: It is used to return the amount received at maturity for a fully invested security.

43. SLN function: It is used to return the straight-line depreciation of an asset for one period.

44. SYD function: It is used to return the sum-of-years' digits depreciation of an asset for a particular period.

45. TBILLEQ function: It is used to return the bond-equivalent yield for a Treasury bill.

46. TBILLPRICE function: It is used to return the price per $100 face value for a Treasury bill.

47. TBILLYIELD function: It is used to return the yield for a Treasury bill.

48. VDB function: It is used to return the depreciation of an asset for a specified or partial period by using a declining balance method.

49. XIRR function: It is used to return the internal rate of return for a schedule of cash flows that is not necessarily periodic.

50. XNPV function: It is used to return the net present value for a schedule of cash flows that is not necessarily periodic.

51. YIELD function: It is used to return the yield on a security that pays periodic interest.

52. YIELDDISC function: It is used to return the annual yield for a discounted security.

53. YIELDMAT function: It is used to return the annual yield of a security that pays interest at maturity.