Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel work please Correct answer: 21.5 A firm is undertaking a project with the following details provided. - The project costs $1.8 million and has
Excel work please
Correct answer: 21.5
"A firm is undertaking a project with the following details provided. - The project costs $1.8 million and has a 7-year service life. - It generates revenues of $520,000 annually. - The project is classified as a 7-year property under the MACRS rule. - At the end of year 7, any assets for the project will be sold. The expected salvage will be 16% of the initial $1.8M project cost. - The firm will finance 26% of the project money from an outside source with an interest rate of 12%. The firm is required to repay the loan with 5 equal annual payments. - The firm's tax rate is 21%. - MARR is 19%. Given this information, compute the IRR for this project. Enter your answer as percentage rounded to the nearest tenth of a percent (i.e., 8.3% is entered as 8.3)." "A firm is undertaking a project with the following details provided. - The project costs $1.8 million and has a 7-year service life. - It generates revenues of $520,000 annually. - The project is classified as a 7-year property under the MACRS rule. - At the end of year 7, any assets for the project will be sold. The expected salvage will be 16% of the initial $1.8M project cost. - The firm will finance 26% of the project money from an outside source with an interest rate of 12%. The firm is required to repay the loan with 5 equal annual payments. - The firm's tax rate is 21%. - MARR is 19%. Given this information, compute the IRR for this project. Enter your answer as percentage rounded to the nearest tenth of a percent (i.e., 8.3% is entered as 8.3)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