Financial Functions & Modeling Flashcards

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

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

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

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

Answer: SYD

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

What does the PPMT function calculate in Excel?

Answer: The principal payment for a given period of a loan

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

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

Answer: Scenario Manager

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.

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

Answer: XIRR handles cash flows that occur at irregular time intervals

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.

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

Answer: CUMPRINC

CUMPRINC returns the cumulative principal paid on a loan between a specified start and end period, useful for tracking loan paydown over time.

What does the EFFECT function calculate in Excel?

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

EFFECT converts a nominal annual interest rate to the effective annual rate by accounting for the number of compounding periods per year.