GENERAL DATA Purchase Price Loan % Loan Amount Interest rate Term/years Term/months Monthly PMT Annual DS Before Tax Cash Flows: Potential Gross Income Vacancy & Credit Losses Other Income Effective Gross Income Operating Expenses Net Operating Income Debt Service Before Tax Cash Flow $10,200,000 75.00% $7,650,000 7.875% $58,412 $700,943 25 300 Year 1 $2,340,000 $234,000 $10,000 Year 2 $2,433,600 $219,024 $10,000 $2,116,000 $2,224,576 $1,100,000 $1,144,000 $1,016,000 $1,080.576 -$700,943 -$700,943 $315,057 $379,633 What is the Unlevered IRR (IRRO)? What is the Levered IRR (IRRe)?__ BUILDING DATA Bldg RSF OE/RSF Rents PSF Year 3 $2,535,811 $202,865 $10,000 90,000 $12.22 $26.00 Year 4 $2,644,851 $211,588 $10,000 Year 5 $2,761,225 $193,286 $10,000 What is the Investment Value of the equity (GPVe) at the stated discount rate? Reversion Data Going Out Cap Rate 10.00% Investors Discount Rate 12.00% Year 6 $2,899,286 $202,950 $10,000 $2,706,336 $2,342,946 $2,443,263 $2,577,939 $1,189,760 $1,237,350 $1,286,844 $1,338,318 $1,153,186 $1,205,913 $1,291,094 $1,368,018 -$700,943 -$700,943 -$700,943 $452,244 $504,970 $590,152
GENERAL DATA Purchase Price Loan % Loan Amount Interest rate Term/years Term/months Monthly PMT Annual DS Before Tax Cash Flows: Potential Gross Income Vacancy & Credit Losses Other Income Effective Gross Income Operating Expenses Net Operating Income Debt Service Before Tax Cash Flow $10,200,000 75.00% $7,650,000 7.875% $58,412 $700,943 25 300 Year 1 $2,340,000 $234,000 $10,000 Year 2 $2,433,600 $219,024 $10,000 $2,116,000 $2,224,576 $1,100,000 $1,144,000 $1,016,000 $1,080.576 -$700,943 -$700,943 $315,057 $379,633 What is the Unlevered IRR (IRRO)? What is the Levered IRR (IRRe)?__ BUILDING DATA Bldg RSF OE/RSF Rents PSF Year 3 $2,535,811 $202,865 $10,000 90,000 $12.22 $26.00 Year 4 $2,644,851 $211,588 $10,000 Year 5 $2,761,225 $193,286 $10,000 What is the Investment Value of the equity (GPVe) at the stated discount rate? Reversion Data Going Out Cap Rate 10.00% Investors Discount Rate 12.00% Year 6 $2,899,286 $202,950 $10,000 $2,706,336 $2,342,946 $2,443,263 $2,577,939 $1,189,760 $1,237,350 $1,286,844 $1,338,318 $1,153,186 $1,205,913 $1,291,094 $1,368,018 -$700,943 -$700,943 -$700,943 $452,244 $504,970 $590,152
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
Ex.18.
Transcribed Image Text:GENERAL DATA
Purchase Price
Loan %
Loan Amount
Interest rate
Term/years
Term/months
Monthly PMT
Annual DS
Before Tax Cash Flows:
Potential Gross Income
Vacancy & Credit Losses
Other Income
Effective Gross Income
Operating Expenses
Net Operating Income
Debt Service
Before Tax Cash Flow
$10,200,000
75.00%
$7,650,000
7.875%
25
300
$58,412
$700,943
Year 1
$2,340,000
$234,000
$219,024
$10,000 $10,000
$2,116,000 $2,224,576
$1,100,000 $1,144,000
$1,016,000 $1,080,576
-$700,943 -$700,943
$315,057 $379,633
What is the Unlevered IRR (IRRO)?__
What is the Levered IRR (IRRe)?_
Year 2
$2,433,600
BUILDING DATA
What is the NPV of the equity investment (NPVe)?
Bldg RSF
OE/RSF
Rents PSF
Year 3
$2,535,811
$202,865
$10,000
90,000
$12.22
$26.00
Year 4
$2,644,851
$211,588
$10,000
What is the Investment Value of the equity (GPVe) at the stated discount rate?
Year 5
$2,761,225
$193,286
$10,000
Reversion Data
Going Out
Cap Rate
Investors Discount Rate
12.00%
Year 6
$2,899,286
$202,950
$10,000
$2,706,336
$2,342,946 $2,443,263 $2,577,939
$1,189,760 $1,237,350 $1,286,844
$1,338,318
$1,153,186 $1,205,913 $1,291,094 $1,368,018
-$700,943 -$700,943
-$700,943
$452,244 $504,970
$590,152
10.00%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 6 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education