Question

In: Finance

Bay Properties is considering starting a commercial real estate division. It has prepared the following​ four-year...

Bay Properties is considering starting a commercial real estate division. It has prepared the following​ four-year forecast of free cash flows for this​ division:

year 1 year 2 year 3 year 4
Free Cash Flow -132,000 15,000 85,000 239,000

Assume cash flows after year 4 will grow at 5 % per​ year, forever. If the cost of capital for this division is 8 %​,

a. what is the continuation value in year 4 for cash flows after year​ 4?

b. What is the value today of this​ division?

Please answer both questions and show all work!

Solutions

Expert Solution

(a)-The continuation value in year 4 for cash flows after year 4

Free Cash Flow in Year 4 (FCF4) = $239,000

Growth Rate (g) = 5.00% per year

Required Rate of Return (Ke) = 8.00%

Therefore, the Continuation Value in Year 4 = FCF4(1 + g) / (Ke – g)

= $239,000(1 + 0.05) / (0.08 – 0.05)

= $250,950 / 0.03

= $8,365,000

“The continuation value in year 4 for cash flows after year 4 = $8,365,000”

(b)-Value of this division today

Value of this division today is the Present value of the free cash flows plus the present value of the continuation value in year 4

Year

Cash flow ($)

Present Value factor at 8.00%

Present Value of cash flows

($ in Millions)

1

-1,32,000

0.92592593

-1,22,222.22

2

15,000

0.85733882

12,860.08

3

85,000

0.79383224

67,475.74

4

2,39,000

0.73502985

1,75,672.13

4

83,65,000

0.73502985

61,48,524.72

TOTAL

62,82,310.45

“Therefore, the Value of this division today would be $6,282,310.45”

NOTE

The Formula for calculating the Present Value Factor is [1/(1 + r)n], Where “r” is the Discount/Interest Rate and “n” is the number of years.


Related Solutions

Bay Properties is considering starting a commercial real estate division. It has prepared the following​ four-year...
Bay Properties is considering starting a commercial real estate division. It has prepared the following​ four-year forecast of free cash flows for this​ division: Year 1 Year 2 Year 3 Year 4 Free cash flow −$124,000 $11,000 $98,000 $248,000 Assume cash flows after year 4 will grow at 3% per​ year, forever. If the cost of capital for this division is 14%​, what is the continuation value in year 4 for cash flows after year​ 4? What is the value...
Bay Properties is considering starting a commercial real estate division. It has prepared the following? four-year...
Bay Properties is considering starting a commercial real estate division. It has prepared the following? four-year forecast of free cash flows for this? division: Year 1 Year 2 Year 3 Year 4 Free cash flow ?$152,000 $12,000 $84,000 $211,000 Assume cash flows after year 4 will grow at 4% per? year, forever. If the cost of capital for this division is 10%?, what is the continuation value in year 4 for cash flows after year? 4? What is the value...
The commercial division of a real estate firm is conducting a regression analysis of the relationship...
The commercial division of a real estate firm is conducting a regression analysis of the relationship between x, annual gross rents (in thousands of dollars), and y, selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. The regression equation is Y = 20.0 + 7.25 X Predictor Coef SE Coef T Constant 20.000 3.2213 6.21 X   7.250 1.3624 5.29 Analysis of Variance SOURCE DF SS...
The commercial division of a real estate firm is conducting a regression analysis of the relationship...
The commercial division of a real estate firm is conducting a regression analysis of the relationship between x, annual gross rents (in thousands of dollars), and y, selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. Analysis of Variance SOURCE DF Adj SS Regression 1 41587.3 Error 7 Total 8 51984.1 Predictor Coef SE Coef T-Value Constant 20.000 3.2213 6.21 X 7.210 1.3626 5.29 Regression...
The commercial division of a real estate firm is conducting a regression analysis of the relationship...
The commercial division of a real estate firm is conducting a regression analysis of the relationship between x, annual gross rents (in thousands of dollars), and y, selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. Analysis of Variance SOURCE DF Adj SS Regression 1 41587.3 Error 7 Total 8 51984.1 Predictor Coef SE Coef T-Value Constant 20.000 3.2213 6.21 X 7.210 1.3626 5.29 Regression...
The commercial division of a real estate firm is conducting a regression analysis of the relationship...
The commercial division of a real estate firm is conducting a regression analysis of the relationship between , annual gross rents (in thousands of dollars), and , selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. The regression equation is Y= 20.0 +7.25 X Predictor Coef SE Coef T Constant 20.000 3.2213 6.21 X 7.250 1.3625 5.29 Analysis of Variance SOURCE DF SS Regression 1...
The commercial division of a real estate firm conducted a study to determine the extent of...
The commercial division of a real estate firm conducted a study to determine the extent of the relationship between annual gross rents ($1000s) and the selling price ($1000s) for apartment buildings. Data were collected on several properties sold. The data is... df SS MS F Significance F Regression 1 41976.4 Residual 7 Total 8 52373.2 Coefficients Standard Error t Stat P-value Intercept 19 3.2213 6.21 Annual Gross Income 7.75 1.457806668 5.31620562 (a) How many apartments are there? (b) Write the...
The commercial division of a real estate firm is conducting a regression analysis of the relationship...
The commercial division of a real estate firm is conducting a regression analysis of the relationship between x, annual gross rents (in thousands of dollars), and y, selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. Analysis of Variance SOURCE DF Regression 1 Error 7 Total 8 Predictor Coef Constant 20.000 X Adj SS 41587.3 51984.1 SE Coef T-value 3.2213 6.21 1.3626 5.29 (a) How...
1) Real estate investment trusts may invest in I. commercial properties such as shopping malls. II....
1) Real estate investment trusts may invest in I. commercial properties such as shopping malls. II. residential rental properties. III. mortgages. IV. combinations of property and real estate related debt. A. I, II, and III only B. I, II, III and IV C. II and IV only D. I and III only 2) Prices of residential properties tend to weaken when I. unemployment increases. II. interest rates fall. III. interest rates rise. IV. economic levels are high. A. I, II,...
On May 1, Corporate Properties, Inc., a commercial property owner, asks Erik Woodruff, a real estate...
On May 1, Corporate Properties, Inc., a commercial property owner, asks Erik Woodruff, a real estate agent, to help market and sell Corporate Properties’ office building. Under the terms of Corporate Properties’ offer, if a buyer makes a serious offer to buy the building within sixty days, Corporate Properties must pay Erik’s commission. Erik puts signs on the building, ads in real estate pamphlets and a locally focused Web site, features the property in a “walking” tour online, and shows...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT