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

Goal Seek works backward from a desired result, finding what input value is needed to produce that outcome — ideal for 'what-if' financial analysis.

Question 2

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

Accepted Answer

SYD

Answer

SYD calculates depreciation using the sum-of-years-digits method, an accelerated approach that results in higher depreciation in early years.

Question 3

What does the PPMT function calculate in Excel?

Accepted Answer

The principal payment for a given period of a loan

Answer

PPMT returns the amount of a loan payment applied to principal for a given period, showing how much the outstanding balance decreases each period.

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

Scenario Manager allows you to save multiple named sets of changing cell values so you can quickly switch between and compare best-case, worst-case, and base-case scenarios.

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 calculates the internal rate of return for cash flows that occur at non-periodic (irregular) dates, while IRR assumes all cash flows are equally spaced in time.

CES - Certified Excel Specialists Practice Test

CES - Certified Excel Specialists Practice Test

CES Financial Functions & Modeling 3