What Is the Excel Formula to Compute the Internal Rate

question 14

Multiple Choice

What is the Excel formula to compute the internal rate of return for a $32,000 investment and cash inflows of $10,000 per year for years 1 through 4?

• A) =IRR(33000,−10000,−10000,−10000,−10000)
• B) =IRR(−33000,10000,10000,10000,10000)
• C) =IRR(−10000,−10000,−10000,−10000,−33000)
• D) =IRR(10000,10000,10000,10000,−33000)

---

Definitions:

Park Funding

Financial resources allocated for the maintenance, operation, and development of public parks.

Taxpayers

Individuals or entities that are obligated to make payments to government authorities based on earned income, property ownership, or other taxable activities.

Visitors

Individuals who visit a place other than their usual environment for leisure, business, or other purposes without the intention of settling there.

Property Rights

Legal rights to use, control, and benefit from a property, including the ability to transfer it to others.