Answered step by step
Verified Expert Solution
Link Copied!

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%

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered 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

Practicing Statistics Guided Investigations For The Second Course

Authors: Shonda Kuiper, Jeff Sklar

1st Edition

9780321586018

Students also viewed these Finance questions