Question
A B 1 Year Cash Flow 2 0 $(5,000) 3 1 $4,000 4 2 $3,000 Given a spreadsheet similar to the one shown in Table
| A | B | |
| 1 | Year | Cash Flow |
| 2 | 0 | $(5,000) |
| 3 | 1 | $4,000 |
| 4 | 2 | $3,000 |
Given a spreadsheet similar to the one shown in Table 1, the command to compute the internal rate of return would be
A) =RATE(3,B3,B4,B2).
B) =IRR(B2:B4).
C) =IRR(B3:B4)-B2.
D) =TVM(A2:B4).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Public Finance Administration
Authors: B. J. Reed, John W. Swain
2nd Edition
0803974051, 978-0803974050
