Answered step by step
Verified Expert Solution
Question
1 Approved Answer
17. You are an employee of a consultant company and have been given the following information to do an investment analysis of a new small
17. You are an employee of a consultant company and have been given the following information to do an investment analysis of a new small income-producing property for sale to a potential investor. What is the investors after tax IRR? (round your final answer to 2 decimals) The above information results in the following investment analysis. \begin{tabular}{|c|c|c|c|} \hline Equity & $600,000 & & \\ \hline Loan & $1,400,000 & & \\ \hline Annual Loan Payment & $80,206 & & \\ \hline Mortgage Balance & $1,322,982 & year & 3 \\ \hline \multicolumn{4}{|c|}{ Summary Loan Information } \\ \hline End of Year & 1 & 2 & 3 \\ \hline Payment & $80,206 & $80,206 & $80,206 \\ \hline Mortgage Balance & $1,375,345 & $1,349,687 & $1,322,982 \\ \hline Interest & $55,551 & $54,547 & $53,501 \\ \hline Principal & $24,655 & $25,659 & $26,704 \\ \hline Year & 1 & 2 & 3 \\ \hline PGI & $300,000 & $309,000 & $318,270 \\ \hline VCL & $30,000 & $30,900 & $31,827 \\ \hline EGI & ? & ? & ? \\ \hline Expenses & $81,000 & $83,430 & $85,933 \\ \hline NOI & $189,000 & $194,670 & $200,510 \\ \hline Debt Service & $80,206 & $80,206 & $80,206 \\ \hline BTCF & ? & ? & ? \\ \hline NOI & $189,000 & $194,670 & $200,510 \\ \hline Less: Interest & $55,551 & $54,547 & $53,501 \\ \hline \end{tabular} What is the investors after tax IRR? (round your final answer to 2 decimals)
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