Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Instructions: Prepare two, 11-year cash flow projections in Excel for a 1M sf industrial property: 1. Part 1- Create a detailed cash flow model assuming

Instructions:
Prepare two, 11-year cash flow projections in Excel for a 1M sf industrial property:
1. Part 1- Create a detailed cash flow model assuming Tenant A renews at the end of their term
2. Part 2 -Create a detailed cash flow model assuming Tenant A vacates at the end of their initial term
*Ensure format is professional and presentable. Numbers can be in whole dollars ($ sign optional) and
use commas where appropriate; it should look very similar to the format presented in class
*Review the Rent Roll/Occupancy Summary for lease terms for the current tenant - these are contractual terms
*The items not addressed in the lease require projections. Refer to the Underwriting Assumptions and Projections data

image text in transcribedimage text in transcribed

image text in transcribed
image text in transcribed
ase Study Assumptions.pdf (36.2 KB) / A Attemative formats ase Study Assumptions.pdf (36.2KB) A Alternative formats PROPEATY INFO ANDTENNCY ase Study Assumptions.pdf (36.2 KB) / A Attemative formats ase Study Assumptions.pdf (36.2KB) A Alternative formats PROPEATY INFO ANDTENNCY

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

The Outsourcing Dilemma Whats Best For Internal Auditing

Authors: Larry E. Rittenberg, Institute Of Internal Auditors Research Foundation, Lee A. Campbell

1st Edition

0894133845, 978-0894133848

More Books

Students also viewed these Accounting questions