Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the pro-forma table below, what is your levered IRR? begin{tabular}{l|r|r|r|r|r} & 0 & 1 & 2 & 3 & hline Purchase Price &

Using the pro-forma table below, what is your levered IRR?

image text in transcribedimage text in transcribed

\begin{tabular}{l|r|r|r|r|r} & 0 & 1 & 2 & 3 & \\ \hline Purchase Price & (1,538,462) & & & & \\ \hline Loan Proceeds & 833,333 & & & & \\ \hline Loan Fees & (16,667) & & & & \\ \hline NOI & & 100,000 & 103,000 & 109,273 & 119,406 \\ \hline -DS & & (50,000) & (50,000) & (50,000) & (50,000 \\ \hline BTCF & & 50,000 & 53,000 & 59,273 & 69,406 \\ \hline NSP & & & & & \\ \hline -Loan Payoff & & & & & \\ \hline BTER & & & & & \\ \hline Lnlevered Discount Rate: & & & & & \\ \hline Levered Discount Rate: & 10% & & & & \\ \hline \end{tabular} \begin{tabular}{l|r|r|r|r|r} & 0 & 1 & 2 & 3 & \\ \hline Purchase Price & (1,538,462) & & & & \\ \hline Loan Proceeds & 833,333 & & & & \\ \hline Loan Fees & (16,667) & & & & \\ \hline NOI & & 100,000 & 103,000 & 109,273 & 119,406 \\ \hline -DS & & (50,000) & (50,000) & (50,000) & (50,000 \\ \hline BTCF & & 50,000 & 53,000 & 59,273 & 69,406 \\ \hline NSP & & & & & \\ \hline -Loan Payoff & & & & & \\ \hline BTER & & & & & \\ \hline Lnlevered Discount Rate: & & & & & \\ \hline Levered Discount Rate: & 10% & & & & \\ \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

Step: 3

blur-text-image

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

Excel For Auditors

Authors: Bill Jelen, Dwayne K. Dowell

1st Edition

1932802169, 978-1932802160

More Books

Students also viewed these Accounting questions