You work as a Finance Manager for Blue Well Inc. The company has a Windows-based network. You are using Excel spreadsheet for maintaining financial budget and other financial calculations. You want…

Question

Options

• ADB function
• BNPV function
• CDDB function
• DFVSCHEDULE function

• A
  81% (21)
• B
  8% (2)
• C
  12% (3)

Explanation

Various financial functions (reference) are as follows: 1. ACCRINT function: It is used to return the accrued interest for a security that pays periodic 2. ACCRINTM function: It is used to return the accrued interest for a security that pays interest at 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 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 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 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 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 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 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

No community discussion yet for this question.