Estimate the value of the property using a dcf model

Assignment Help Mathematics
Reference no: EM13297331

A property is rented with rents collected at the end of each year.  The rent for the coming year will be $23,500 to be collected in twelve month's time. The rent is expected to escalate at 3% per annum.  The property is expected to be worth $533,043 at the end of 5 years.

Estimate the value of the property using a DCF model with a discount rate of 13%.

What is the value of the property to the nearest whole dollar?

This question is to be worked out on excel spreadsheet. Can you help please.

Reference no: EM13297331

Questions Cloud

Explain concentrations of both reactants and products : Which statement is true for a reaction with Kc equal to 2.43 × 10-12? A) Increasing the temperature will not change the value of Kc. B) There are appreciable concentrations of both reactants and products.
What was its charge for depreciation and amortization : Pearson Brothers recently reported an EBITDA of $6.5 million and net income of $1.95 million. It had $2.21 million of interest expense, and its corporate tax rate was 35%. What was its charge for depreciation and amortization?
Develop 95 percent confidence interval for population mean : a simple random sample of 20 items from a normal population resulted in a sample mean of 17.25 and a sample standard devation of 3.3 a. develop a 90% confidence interval for the population mean. b. develop a 95% confidence interval for the populatio..
Explain the equilibrium constant for a forward reaction : If Kc is the equilibrium constant for a forward reaction, 2 A? B, what is Kc´ for the reaction 4 A? 2B? A) Kc B) Kc C) 2 Kc D) (Kc)2
Estimate the value of the property using a dcf model : Estimate the value of the property using a DCF model with a discount rate and what is the value of the property to the nearest whole dollar?
Describe the greatest lattice energy : Predict which of the following compounds has the greatest lattice energy. A. SCl6 B. AlCl3 C. NaCl D. MgCl2 E. PCl5
Design a portland cement concrete mix for a loading clock : Design a Portland cement concrete mix for a loading dock driveway slab. The concrete will be exposed to deicing chemicals and subjected to freezing and thawing in a moist condition. This is severe environmental exposure.
Determine the change in length of the steel bar : A steel bar of length 30 inches and circular cross section whose diameter varies linearly from 0.50 inches at one end to 0.75 inches at the other is subjected to an axial tensile force of 4.5 kip. Find the change in length of the bar.
State what is the equilibrium concentration of hi : The decomposition of HI(g) is represented by the equation 2HI(g) H2(g) + I2(g) Kc= 64 at 25°C. If the equilibrium concentrations of H2 and I2 at 400°C are found to be [H2] = 5.0x10-4 M and [I2] = 1.4x10-3 M, what is the equilibrium concentration o..

Reviews

Write a Review

Mathematics Questions & Answers

  What two variables have the strongest positive strength

What two variables have the strongest positive strength of relationship?

  Determine the coefficient of restitution

Determine the coefficient of restitution for each of the following objects dropped from a height of 2 meters onto a wooden floor.

  Triangle inequality theorem

Write a compound inequality to describe tha range of possible measures for side c in terms of a and b.

  Write the equation in the slope-intercept form

Write the equation in the slope-intercept form and then find the slope and y-intercept of the corresponding line. 5x-6y-12=0

  How mnay loose cans will remain

a soft drink distributor has 166 loose cans of cola. the distributor wishes to form as many 24-can cases as possible and then, with any remaining cans, as many six-packs as possible. how many cases will be filled? how many six-packs?how mnay loose..

  How should ticket prices be set so as to maximize revenue

the average attendance rose to 33,000. Find the demand function, assuming that it is linear. How should ticket prices be set so as to maximize revenue?

  Sketch of the graph over 24 hour period

If the tide edd and flow over time in a periodic manner, use cosine function a) to make a sketch a sketch of the graph over 24 hour period. b) find a trig equation that models the depth of the water t hours after midnight.

  Solve the quadratic equation

Find explicitly f(x) = H(x) / g(x), as it would be a quadratic equation and then solve for the roots of f(x) for in terms of  for which it would have real roots

  What are the dimensions of the silo

what are the dimensions of the silo (radius and height of cylindrical tower) that minimize the cost of the material? Assume the silo has no floor and no flat ceiling under the dome.

  Find the dimensions of the can which requires

A closed cylindrical can is to be designed so that the can will hold 170cm^3 of oil. Find the dimensions of the can which requires the least amount of metal.

  Explain a car is traveling on a straight road with velocity

A car is traveling on a straight road with velocity 55 ft/sec at time t = 0. For 0 ≤ t ≤ 18 seconds, the car's acceleration a(t) , in ft/sec2, is the piecewise linear function defined by the graph above.

  What is the probability that a similar study

Recent study of television viewing, 73% of first year college students stated that university well off financially is a very important personal goal. What is the probability that a similar study would have the same sample mean or higher?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd