Answered step by step
Verified Expert Solution
Question
1 Approved Answer
GENERAL DATA BUILDING DATA Purchase Price $10,200,000 90,000 Reversion Data Going Out Cap Rate 10.00% Loan % Loan Amount Bldg, RSF OE/RSF Rents PSF 75.00%
GENERAL DATA BUILDING DATA Purchase Price $10,200,000 90,000 Reversion Data Going Out Cap Rate 10.00% Loan % Loan Amount Bldg, RSF OE/RSF Rents PSF 75.00% $7,650,000 $12.22 $26.00 Interest rate 7.875% Investors Discount Rate 25 12.00% 300 Term/years Term/months Monthly PMT Annual DS $58,412 $700,943 Before Tax Cash Flows: Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 $2,340,000 $2,433,600 $2,535,811 $2,644,851 $2,761,225 $2,899,286 $202,865 $211,588 $193,286 $202,950 $234,000 $10,000 $219,024 $10,000 $10,000 $10,000 $10,000 $10,000 Potential Gross Income Vacancy & Credit Losses Other Income Effective Gross Income Operating Expenses Net Operating Income Debt Service $2,443,263 $1,237,350 $2,116,000 $1,100,000 $1,016,000 -$700,943 $2,224,576 $1,144,000 $1,080,576 -$700,943 $379,633 $2,342,946 $1,189,760 $1,153,186 -$700,943 $2,577,939 $1,286,844 $1,291,094 -$700,943 $2,706,336 $1,338,318 $1,368,018 $1,205,913 $700,943 Before Tax Cash Flow $315,057 $452,244 $504,970 $590,152 1 What is Initial Equity (CFO)? What will the property sell for at EOY 5? 2. 3. What will the loan balance be at EOY 5? 4 What is the IRRO? What is the Re? 5. 6. What is the Neve? GENERAL DATA BUILDING DATA Purchase Price $10,200,000 90,000 Reversion Data Going Out Cap Rate 10.00% Loan % Loan Amount Bldg, RSF OE/RSF Rents PSF 75.00% $7,650,000 $12.22 $26.00 Interest rate 7.875% Investors Discount Rate 25 12.00% 300 Term/years Term/months Monthly PMT Annual DS $58,412 $700,943 Before Tax Cash Flows: Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 $2,340,000 $2,433,600 $2,535,811 $2,644,851 $2,761,225 $2,899,286 $202,865 $211,588 $193,286 $202,950 $234,000 $10,000 $219,024 $10,000 $10,000 $10,000 $10,000 $10,000 Potential Gross Income Vacancy & Credit Losses Other Income Effective Gross Income Operating Expenses Net Operating Income Debt Service $2,443,263 $1,237,350 $2,116,000 $1,100,000 $1,016,000 -$700,943 $2,224,576 $1,144,000 $1,080,576 -$700,943 $379,633 $2,342,946 $1,189,760 $1,153,186 -$700,943 $2,577,939 $1,286,844 $1,291,094 -$700,943 $2,706,336 $1,338,318 $1,368,018 $1,205,913 $700,943 Before Tax Cash Flow $315,057 $452,244 $504,970 $590,152 1 What is Initial Equity (CFO)? What will the property sell for at EOY 5? 2. 3. What will the loan balance be at EOY 5? 4 What is the IRRO? What is the Re? 5. 6. What is the Neve
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