Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In applying the =irr( function to the scenario in this table, you should use the figures in which row? 10% Interest Year 0 1 2
In applying the =irr( function to the scenario in this table, you should use the figures in which row? 10% Interest Year 0 1 2 3 4 5 Principal ($1,000.0000) $163.7975 $180.1772 $198.1950 $218.0144 $239.8159 Interest $100.0000 $82.6203 $65.6025 $45.7831 $23.9816 Total CF ($1,000.0000) $263.7975 $263.7975 $263.7975 $263.7975 $263.7975 (outflow) inflow inflow inflow inflow Inflow =irr( In applying the =irr( function to the scenario in this table, you should use the figures in which row? 10% Interest Year 0 1 2 3 4 5 Principal ($1,000.0000) $163.7975 $180.1772 $198.1950 $218.0144 $239.8159 Interest $100.0000 $82.6203 $65.6025 $45.7831 $23.9816 Total CF ($1,000.0000) $263.7975 $263.7975 $263.7975 $263.7975 $263.7975 (outflow) inflow inflow inflow inflow Inflow =irr( Principal Interest Year Total CF (Total Cash Flow)
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
Accounting
Authors: Carl S. Warren, James M. Reeve, Jonathan E. Duchac
22nd Edition
324401841, 978-0-324-6250, 0-324-62509-X, 978-0324401844
