Question: On excel please with good format and structure thank you Property 1 Capital Yield - $770(Rent is compared with other properties in the same area

On excel please with good format and structure thank you

Property 1

Capital Yield - $770(Rent is compared with other properties in the same area and features)(rent/week) x 52 = $40,040 (annual rent)

$40,040 $1,555,626(Price of Property) = 2.57% +3.9%(GDP growth) = 6.47%(Discount Rate)

-Management fees = 6%

Property 2

Capital Yield - $750(Rent is compared with other properties in the same area and features)(rent/week) x 52 = $39,000 (annual rent)

$39,000 $1,084,900(Price of Property) = 3.59% + 3.9%(GDP growth) = 7.49%(Discount Rate)

-Management fees = 6%

PLEASE FIND, Discounted cash flow for 6 years, NPV AND IRR

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:

Identify all of the functional groups in each of the following compounds: (a) (b) (c) (d) (e) (f) (g) Vitamin D3 HO OMe Aspartame O NH2 NH2 Amphetamine Me Cholesterol HO OCH2CH3 Demerol CH A...

Q:

On excel please with good format and structure thank you Property 1 Capital Yield - $770(Rent is compared with other properties in the same area and features)(rent/week) x 52 = $40,040 (annual rent)...

Q:

USE EXCEL PLEASE Property 1 Capital Yield - $770(Rent is compared with other properties in the same area and features)(rent/week) x 52 = $40,040 (annual rent) $40,040 $1,555,626(Price of Property) =...

Q:

Please find the discounted cash flow, NPV and IRR of these Property 1 Capital Yield - $770(Rent is compared with other properties in the same area and features)(rent/week) x 52 = $40,040 (annual...

Q:

Property 1 Capital Yield - $770(Rent is compared with other properties in the same area and features)(rent/week) x 52 = $40,040 (annual rent) $40,040 $1,555,626(Price of Property) = 2.57% +3.9%(GDP...

Q:

Hello tutor Please find the attached instruction file and use the template for solving this question. If you have any question about the problem please contact me. Thanks Your Course Project...

Q:

Body: This section will provide a brief evaluation of the profitability, liquidity, asset efficiency and gearing of the company. Reflect on the group discussions to assist in your analysis. Due to...

Q:

(Questions from Lecture and Article) - Discussion Board Activity I need to read the following Lecture Note and the ?Wall Street Journal? articles that I uploaded, and writeanswers for theDiscussion...

Q:

I need help with this project. I have attached all of the instructions and relevant information. The final draft is due August 20th. Course Project: A Financial Statement Analysis A Comparative...

Q:

Please complete the following reports for "kohl's 2017 financial statement" note that the suggested reports have numbers filled in but they do not relate. (Ignore where it says JCPenney on top of the...

Q:

I am having troubles doing this comparison of two companies. Im over thinking the work and need to get it simplified. I did most of the work just need you to check it over. Go to the Course Resources...

Q:

2 (* pm) Let Let (k) k=2,3,- (K) a) Fincd Il x . Do nut take any Speci fic values 1 k. (k) b) Find lim k

Q:

a. Write the mechanism for the following reactions: 1. The acid-catalyzed hydrolysis of an imine to a carbonyl compound and a primary amine 2. The acid-catalyzed hydrolysis of an enamine to a...

Q:

Current Attempt in Progress In reviewing the monthly sales activity for the year, the auditor noted significant and unusual fluctuations from month to month. When queried, management responded that...

Q:

The initial margin required for futures trading can be put up by either party, whoever initiates the transaction. must be put up by both the buyer and the seller. is only put up by the buyer. O is...