Answered step by step
Verified Expert Solution
Link Copied!

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?

image text in transcribedimage text in transcribed

\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

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

Renewable Energy Finance Theory And Practice

Authors: Santosh Raikar, Seabron Adamson

1st Edition

0128164417, 9780128164419

More Books

Students also viewed these Finance questions

Question

Recognize and describe the steps in the recruiting process

Answered: 1 week ago

Question

Appreciate the contribution made by a positions incumbent

Answered: 1 week ago

Question

Know how to conduct a position analysis

Answered: 1 week ago