Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Computational Techniques In Economics And Finance

Authors: Constantin Zopounidis

1st Edition

1613245580, 978-1613245583

More Books

Students also viewed these Finance questions