Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need all the yellow boxes answered. I have attempted some but am not sure if they are correct. Income and Expense Table Year 1

image text in transcribed

I need all the yellow boxes answered. I have attempted some but am not sure if they are correct.

Income and Expense Table Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 0.25 $ $ Information Construction Cost Space Plan Construction Documents PSF Tenant Improvements PSF Lease Commissions/Base Rent from Year 1-5 Total Legal Fees Construction Start Construction Finish 0.45 24 5% 1,500.00 11/1/2020 10/31/2021 Space Plan Construction Documents Tenant Improvements Legal Fees Lease Commissions $ 5,000.00 $ 9,000.00 $ 480,000.00 $ 1,500.00 $ 110,000.00 $ $ 400,000.00 $ 420,000.00 $ 440,000.00 $ 460,000.00 $ 480,000.00 Contract Information Base Rent Additional Rent (to Compensate Expense Increase) Operating Expenses Tenant Area Commencement Expiration Term (# Months) Term (# Years) Average Market Tenant 20,000 11/1/2021 10/31/2025 60 Net Operating Income Reversion Income Net Income 5 Analysis IRR (without reversion) IRR (with reversion) Base Rent Year 2 PSF Base Rent Year 3 PSF Base Rent Year 4 PSF Base Rent Year 5 PSF Base Rent Year 6 PSF $ $ $ $ 20.00 21.00 22.00 23.00 24.00 Estimated Project Value Now with Reversion S Year 2 Expenses PSF Expense Stop $ $ 10.00 10.00 Rates Expense Growth Rate Per Year Expected Capitalization Rate in Year 6 Discount Rate for All 6 Years 2% 8.0% 6% Income and Expense Table Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 0.25 $ $ Information Construction Cost Space Plan Construction Documents PSF Tenant Improvements PSF Lease Commissions/Base Rent from Year 1-5 Total Legal Fees Construction Start Construction Finish 0.45 24 5% 1,500.00 11/1/2020 10/31/2021 Space Plan Construction Documents Tenant Improvements Legal Fees Lease Commissions $ 5,000.00 $ 9,000.00 $ 480,000.00 $ 1,500.00 $ 110,000.00 $ $ 400,000.00 $ 420,000.00 $ 440,000.00 $ 460,000.00 $ 480,000.00 Contract Information Base Rent Additional Rent (to Compensate Expense Increase) Operating Expenses Tenant Area Commencement Expiration Term (# Months) Term (# Years) Average Market Tenant 20,000 11/1/2021 10/31/2025 60 Net Operating Income Reversion Income Net Income 5 Analysis IRR (without reversion) IRR (with reversion) Base Rent Year 2 PSF Base Rent Year 3 PSF Base Rent Year 4 PSF Base Rent Year 5 PSF Base Rent Year 6 PSF $ $ $ $ 20.00 21.00 22.00 23.00 24.00 Estimated Project Value Now with Reversion S Year 2 Expenses PSF Expense Stop $ $ 10.00 10.00 Rates Expense Growth Rate Per Year Expected Capitalization Rate in Year 6 Discount Rate for All 6 Years 2% 8.0% 6%

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

Commercial Banks And Industrial Finance In England And Wales 1860-1913

Authors: Michael Collins, Mae Baker

1st Edition

0199249865, 9780199249862

More Books

Students also viewed these Finance questions

Question

What are the advantages of the illogical?

Answered: 1 week ago