CES Financial Functions & Modeling 2 — Questions and Answers
Question 1: How does the XNPV function differ from the standard NPV function?
- XNPV uses different discount rates for each period
- XNPV handles cash flows that occur at irregular time intervals (Correct answer)
- XNPV only works with positive cash flows
- XNPV calculates net present value in foreign currencies
Correct answer: XNPV handles cash flows that occur at irregular time intervals
XNPV allows cash flows to occur at irregular intervals by requiring specific dates for each cash flow, unlike NPV which assumes equally spaced periods.
Question 2: Which Excel function calculates straight-line depreciation of an asset for one period?
- DB
- DDB
- SLN (Correct answer)
- SYD
Correct answer: SLN
SLN calculates the straight-line depreciation of an asset for one period, spreading the cost evenly over the asset's useful life.
Question 3: What does the RATE function calculate in Excel?
- The rating score of an investment portfolio
- The interest rate per period of an annuity (Correct answer)
- The ratio of payments to principal over time
- The rate of return on equity-only investments
Correct answer: The interest rate per period of an annuity
RATE calculates the interest rate per period of an annuity when given the number of periods, payment amount, and present value.
Question 4: Which Excel function calculates the Modified Internal Rate of Return?
- IRR
- XIRR
- MIRR (Correct answer)
- RATE
Correct answer: MIRR
MIRR (Modified Internal Rate of Return) accounts for both the cost of investment and the interest rate earned on reinvested cash flows, correcting a key flaw in standard IRR.
Question 5: What is the purpose of the IPMT function in Excel?
- Calculate the investment payment multiplied by time periods
- Calculate the interest portion of a specific loan payment (Correct answer)
- Calculate the initial principal of a mortgage transaction
- Calculate the implied payment margin on a treasury bond
Correct answer: Calculate the interest portion of a specific loan payment
IPMT returns the interest payment for a given period of a loan, allowing you to see exactly how much of each payment goes toward interest.
Question 6: Which Excel function calculates the cumulative interest paid on a loan between two specified periods?
- IPMT
- PPMT
- CUMIPMT (Correct answer)
- CUMPRINC
Correct answer: CUMIPMT
CUMIPMT returns the cumulative interest paid on a loan between a specified start and end period, useful for tax deductions and accounting reports.
Question 7: Which Excel function calculates asset depreciation using the fixed-declining balance method?
- SLN
- SYD
- DB (Correct answer)
- AMORT
Correct answer: DB
DB calculates the depreciation of an asset for a specified period using the fixed-declining balance method, which front-loads depreciation in early years.
CES Financial Functions & Modeling 2
How does the XNPV function differ from the standard NPV function?