Question: Using excel calculate the net present value: Five Year Discounted Cash Flow Property is 5 , 0 0 0 square feet Rent is $ 2

Using excel calculate the net present value: Five Year Discounted Cash Flow
Property is 5,000 square feet
Rent is $20 per square foot and increases $2 per annum
Vacancy and Collection is 5% of PGI
Real Estate Taxes are $20,000 in year 1 and increase 5% per annum
Operating Expenses are $25,000 in year 1 and increases $1 per square foot per annum
Management is 5% of EGI
Discount Rate is 11%
Capitalization Rate is 9%
Calculate the NPV

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Convert below to Excel as NPV and Pro Forma. Convert the above to Excel as NPV and Pro-Forma. Five Year Discounted Cash Flow Property is 5,000 square feet Rent is S20 per square foot and increases S2...

Q:

Convert below to Excel as NPV and Pro-Forma. Five Year Discounted Cash Flow Property is 5,000 square feet Rent is S20 per square foot and increases $2 per annum Vacancy and Collection is 5% of PGI...

Q:

AND 1. THE USE OF CALCULATORS SPREAASHEETS 2. PLEASE MAKE SURE TO WRITE Stolal ANSWER EXPLANATIONS THAT ARE SUPPORTED BY YOUR CALCULATIONS deep AsE OuESTION 3. PLEASE USE EXCEL TO CALCULATE AND SHOW...

Q:

please answer all the questions with details. a) to F). please with details. thanks in advance Fie Ed View Window Home Tools Help Sample design bas.. 208468464-Produ Process Design PD.. Search tools...

Q:

Can anyone help with this question please?It need to be solved on the same excel and detail mathematical analysis and decision is needed.Thanks NAME COURSE: 5 percent Financial and Managerial...

Q:

The PDA home work # 2 is Chapter 10 question # 12 of the class text as copied below Process Design PDF 4th ed.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools sample design basi......

Q:

MCR 006 Financial Management Assessment 2 Due date 5.00pm 14th July Weight: 15% of marks for subject This assessment consists of two parts. Part A, a research based topic and Part B, a practical...

Q:

Global Testing Geneva Ltd. Background: - The Global Testing Geneva (GTG) was established in Switzerland in 1893, by two brothers who married into a wealthy family organization. The company had...

Q:

XYZ Limited is considering to introduce a new fad product which is envisaged to stay in the market for five years from today. The company requires a return of 15% from the project. The following...

Q:

please show work 4. Using Excel, calculate the combined Present Value of the Rental Stream and Sale (no calculation for construction period) of a property with the following characteristics: Building...

Q:

Write an essay of 700 words in response to one of the following prompts: 1.1 "Changing the Face of Poverty" by Diana George in The Norton Field Guide . How would you characterize Georges's stance?...

Q:

On October 15, 2012, the board of directors of Ensor Materials Corporation approved a stock option plan for key executives. On January 1, 2013, 20 million stock options were granted, exercisable for...

Q:

I am looking for the correct answer to this general accounting question with appropriate explanations. Calculate the firm's asset turnover using DuPont analysis if it has a profit margin of 3.4...

Q:

4 5 7 8 Irish Pub Staffing Total number of servers Revenue @ $600 per server $ 2,400.00 Wages @$96.00 per server $ 384.00 Beverage Cost @ 25% $ 600.00 Revenue remaining after wages and beverage costs...