Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the pro-forma table below, what is your unlevered IRR? begin{tabular}{|c|c|c|c|c|c|c|} hline & 0 & 1 & 2 & 3 & 4 & hline
Using the pro-forma table below, what is your unlevered IRR?
\begin{tabular}{|c|c|c|c|c|c|c|} \hline & 0 & 1 & 2 & 3 & 4 & \\ \hline urchase Price & (1,538,462) & & & & & \\ \hline oan Proceeds & 833,333 & & & & & \\ \hline .oan Fees & (16,667) & & & & & \\ \hline NOI & & 100,000 & 103,000 & 109,273 & 119,406 & 134,393 \\ \hline DS & & (50,000) & (50,000) & (50,000) & (50,000) & (50,000) \\ \hline BTCF & & 50,000 & 53,000 & 59,273 & 69,406 & 84,393 \\ \hline NSP & & & & & & 2,110,000 \\ \hline Loan Payoff & & & & & & (830,000) \\ \hline BTER & & & & & & 1,280,000 \\ \hline Unlevered Discount Rate: & 10% & & & & & \\ \hline evered Discount Rat & 12% & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|} \hline 6 \\ \hline \\ \hline \\ \hline 155,798 \\ \hline(50,000) \\ \hline 105,798 \\ \hline \\ \hline \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline & 0 & 1 & 2 & 3 & 4 & \\ \hline urchase Price & (1,538,462) & & & & & \\ \hline oan Proceeds & 833,333 & & & & & \\ \hline .oan Fees & (16,667) & & & & & \\ \hline NOI & & 100,000 & 103,000 & 109,273 & 119,406 & 134,393 \\ \hline DS & & (50,000) & (50,000) & (50,000) & (50,000) & (50,000) \\ \hline BTCF & & 50,000 & 53,000 & 59,273 & 69,406 & 84,393 \\ \hline NSP & & & & & & 2,110,000 \\ \hline Loan Payoff & & & & & & (830,000) \\ \hline BTER & & & & & & 1,280,000 \\ \hline Unlevered Discount Rate: & 10% & & & & & \\ \hline evered Discount Rat & 12% & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|} \hline 6 \\ \hline \\ \hline \\ \hline 155,798 \\ \hline(50,000) \\ \hline 105,798 \\ \hline \\ \hline \\ \hline \end{tabular}
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