CES Financial Functions & Modeling 3

Question 1

What is the primary purpose of Goal Seek in Excel financial modeling?

Accepted Answer

To find the input value needed to achieve a desired formula result

Answer

To automatically generate strategic financial goals for a business

Answer

To search for financial goals stored across multiple worksheets

Answer

To calculate the optimal number of payment periods automatically

Question 2

Which Excel function calculates depreciation using the sum-of-years-digits method?

Accepted Answer

SYD

Answer

SLN

Answer

DB

Answer

DDB

Question 3

What does the PPMT function calculate in Excel?

Accepted Answer

The principal payment for a given period of a loan

Answer

The present payment of a primary mortgage transaction

Answer

The projected payment amount multiplied by the time period

Answer

The percentage of each payment applied to principal

Question 4

Which Excel What-If Analysis tool allows you to save and compare multiple named sets of input values in a financial model?

Accepted Answer

Scenario Manager

Answer

Goal Seek

Answer

Solver

Answer

Data Table

Question 5

What key advantage does XIRR have over the standard IRR function?

Accepted Answer

XIRR handles cash flows that occur at irregular time intervals

Answer

XIRR can handle negative discount rates that IRR cannot

Answer

XIRR provides more decimal precision for regular-interval returns

Answer

XIRR can calculate returns across multiple currencies simultaneously

Question 6

Which Excel function calculates the cumulative principal paid on a loan between two periods?

Accepted Answer

CUMPRINC

Answer

PPMT

Answer

CUMIPMT

Answer

IPMT

Question 7

What does the EFFECT function calculate in Excel?

Accepted Answer

The effective annual interest rate given a nominal rate and compounding periods

Answer

The effective tax rate applied to investment income

Answer

The effect of inflation on long-term purchasing power

Answer

The effectiveness ratio of a bond compared to a benchmark