Question

College is considering building a new student residence. The construction cost of a 125-room residence (excluding...

College is considering building a new student residence. The construction cost of a 125-room residence (excluding furniture) is $5,000,000. The College uses a 15 year planning horizon to evaluate investments of this type. The furnishings for this residence must be replaced every five years, at an estimated cost of $2,000,000 (i.e., at n=0, at n=5, and n=10). The old furniture has no salvage value. Annual operating and maintenance expenses for the new building are estimated to be $125,000. The College can sell the building after 15 years at 20% of the original construction cost.

Rooms at the residence will be rented for $45 per day. On the average the occupancy is expected to be 80% per year. Assume the residence will operate 300 days per year. MARR = 10%

INSTRUCTIONS

  1. Ignoring both income and disposal taxes, use Excel to calculate the Annual Worth, to determine if the project is economically feasible.
  2. Determine the project's break-even points, for the following two factors, considering each one separately. (i.e., calculate the percentage change in each of the following two factors, considered one at a time, that would cause the project NPV to become zero).Hint:Consider using Goal Seek
    • Initial Capital Investment; i.e., building cost only.
    • Occupancy rate; i.e., the average percent of rented rooms per year.
  3. Prepare a table showing the project's Annual Worth, corresponding to changes in each of the two factors specified above, over an interval of plus/minus 20% for each factor from a base of 0%.
  4. What can you conclude from the analysis? i.e., which of the two factors is the project profitability more sensitive to? Why?
Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1
Inputs
1.Initial cap.Inv. -5000000
2.Room occup. Rate 80%
Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
3.Initial cap.Inv. -5000000
4.Cost of Furnishings -2000000 -2000000 -2000000
5.Sale value of Build. 1000000
6.Room rent revenue(125 rooms*Row 2*$ 45/day*300 days) 1350000 1350000 1350000 1350000 1350000 1350000 1350000 1350000 1350000 1350000 1350000 1350000 1350000 1350000 1350000
7.Annual O&M exp. -125000 -125000 -125000 -125000 -125000 -125000 -125000 -125000 -125000 -125000 -125000 -125000 -125000 -125000 -125000
8.Total annual cash flows(sum 3--7) -7000000 1225000 1225000 1225000 1225000 -775000 1225000 1225000 1225000 1225000 -775000 1225000 1225000 1225000 1225000 2225000
9.PV F at 10%(1/1.10^Yr.n) 1 0.909091 0.826446 0.751315 0.683013 0.620921 0.564474 0.513158118 0.466507 0.424098 0.385543 0.350494 0.318631 0.28966 0.26333 0.23939
10.PV at 10%(8*9) -7000000 1113636 1012397 920360.6 836691.5 -481214 691480.6 628618.6948 571471.5 519519.6 -298796 429355 390322.8 354839 322581 532647
11.NPV (sum of Row 10) 543910.22
12.Annual worth=NPV/(Annuity Factor)
ie. 543910.22/((1-1.1^-15)/0.10)=
Annual Worth= 71509.93
Project is economically feasible, as both its NPV & Annual Worth are POSITIVE
Using Goal Seek,foll. Results have been observed:
Base case % Change
BEP- Construction cost 5571261 5000000 (5571261-5000000)/5000000= 11.43%
BEP- Occ. Rate 76% 80% (76%-80%)/80%= -5.00%
Annual worth Const.cost Sensitivity Occ. Rate Sensitivity
Base case 71510 71510
Plus 20% -53669 (-53669-71510)/71510= -175.05% 341510 (341510-71510)/71510= 377.57%
Minus 20% 196689 (196689-71510)/71510= 175.05% -198490 (-198490-71510)/71510= -377.57%
Conclusion:Project profitability is more sensitive to changes in occupancy rate
as rooom rent revenue is dependent on that.
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are considering leasing a hotel for 5 years. The hotel lease will cost you $8...
You are considering leasing a hotel for 5 years. The hotel lease will cost you $8 million dollars up front and yearly maintenance and full-time staff is estimated at $1 million per year. There are additional part-time staff but they are dependent on the number of rooms that are rented. Rooms rent for $200 per night and the marginal cost of providing a night’s stay is $20. The hotel has 100 rooms and you expect an average occupancy rate of...
ABS mall is considering building a new parking lot. The land will cost $25,000 and the...
ABS mall is considering building a new parking lot. The land will cost $25,000 and the construction cost of the lot is estimated to be $150,000. Each year costs associated with the lot are estimated to be $17,500. The income from the lot is estimated to be $18,000 the first year and increase by $3,500 each year for the twelve year expected life of the lot. Determine the B/C ratio if ABS mall uses a cost of money of 4%(Use...
Woolman College is considering the construction of a new women’s dormitory. The dormitory will have 80...
Woolman College is considering the construction of a new women’s dormitory. The dormitory will have 80 rooms and the ability to accommodate three students per room. Woolman estimates the dormitory will cost $1.8 million and will have a useful life of 30 years with no salvage value. Using information from existing dorms, Woolman knows the following about each cost: A linear regression was performed for utility costs (dependent variable) and housing revenue (independent variable), with an adjusted R2 = 0.5....
Wollongong City is considering the construction of a new waste treatment plant. Land acquisition will cost...
Wollongong City is considering the construction of a new waste treatment plant. Land acquisition will cost $120,000. The construction works required for the plant will cost $600,000. Environmental inspection and other expenses will cost $60,000. The plant will be built in Year 0 and will become fully operational in Year 1 for six years (i.e. until Year 6). The annual operating cost for the plant is estimated to be fixed at $120,000 during its anticipated 6-year service life. This waste...
You are considering a luxury apartment building project that requires an investment of $12,500,000. The building...
You are considering a luxury apartment building project that requires an investment of $12,500,000. The building has 35 units. The firm expects that the maintenance cost for the apartment building will be $250,000 in the first year, and to rise to $300,000 in the second year, and to continue to increase by $50,000 in subsequent years. The cost to hire a manager for the building is estimated to be $80,000 per year. After four years of operation, the apartment building...
  ​Emily's Soccer Mania is considering building a new plant. This project would require an initial cash...
  ​Emily's Soccer Mania is considering building a new plant. This project would require an initial cash outlay of ​$8.5 million and would generate annual cash inflows of ​$3.5 million per year for years one through four. In year five the project will require an investment outlay of ​$5.5 million. During years 6 through 10 the project will provide cash inflows of ​$5.5 million per year. Calculate the​ project's MIRR, given a discount rate of 9 percent. Please explain step by...
​(Related to Checkpoint​ 11.1) ​ (Net present value​ calculation)  Dowling Sportswear is considering building a new...
​(Related to Checkpoint​ 11.1) ​ (Net present value​ calculation)  Dowling Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of ​$5,500,000 and would generate annual net cash inflows of $1,100,000 per year for 7 years. Calculate the​ project's NPV using a discount rate of 5 percent. If the discount rate is 5 ​percent, then the​ project's NPV is ​$_______. ​(Round to the nearest​ dollar.)
A company is considering building a new and improved production facility for one of its existing...
A company is considering building a new and improved production facility for one of its existing products. It would be built on a piece of vacant land that the firm owns. This land was acquired four years ago at a cost of $500,000; it has a current market value of $800,000. The building can be erected for $600,000. Machinery (equipment) worth $120,000 needs to be bought. The company will finance the construction of the building and the purchase of the...
Harrisburg Furniture Company started construction of a combination office and warehouse building for its own use...
Harrisburg Furniture Company started construction of a combination office and warehouse building for its own use at an estimated cost of $5,000,000 on January 1, 2017. Harrisburg expected to complete the building by December 31, 2017. Harrisburg has the following debt obligations outstanding during the construction period. Construction loan-12% interest, payable semiannually, issued December 31, 2016 $2,000,000 Short-term loan-10% interest, payable monthly, and principal payable at maturity on May 30, 2018 1,400,000 Long-term loan-11% interest, payable on January 1 of...
James Construction Co. is considering a new inventory system that will cost $1,050,000. The system is...
James Construction Co. is considering a new inventory system that will cost $1,050,000. The system is expected to generate positive cash flows over the next four years in the amounts of $350,000 in year one, $350,000 in year two, $150,000 in year three, and $250,000 in year four. The required rate of return is 8%. What is the Payback Period of this project?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT