Quiz 17: Financing Land Development Projects

Business

Refer to Concept Box 17.1. A revised market study indicates the following: pricing for standard interior lots will probably be $103,000 each, premium interior lots $118,000, and corner lots $125,000; the average development cost per lot has been revised up to $71,000; administrative costs, etc., remain at 12.5 percent of gross revenue. a. Can the same 18 percent return on total cost continue to be maintained b. Suppose the developer wants a 21 percent return on cost. How much can be paid for the land (For Reference Concept Box 17.1)

Free

Essay

Land development Activity Refer to concept box 17.1 which shows the preliminary feasibility analysis of land development. The developer acquire 20 acre (871,200 feet) of land and pan to develop residential apartment on the land. There are three type of apartment the developer is planned on the land and price and number of all type of apartment is different. According to developer plan there is 32 lot of Standard interior apartment whose cost is now $103,000, 32 lot of premium interior apartment whose cost is now $118,000, and 16 corner lot whose price is $125,000. a. Financial feasibility of land development is calculated below: The result will be as follows: Thus, return on total cost is now which is lesser than return on total cost calculated in the book. This is because cost is increases and price of apartments is decreases. b. Total net profit = $1,258,000 Total cost = $7,814,000 Price of land = $1,000,000 Total cost of project without considering land price = $6,814,000 If the developer wants 21% of return on the cost the value of cost is calculated below: Suppose value of land is X. Therefore, the ask price should not be more than $683,520 Thus, If the developer wants 21 percent return on the cost then the value of land will be

Q 2

How might land development activities be specialized Why is this activity different from project development discussed in the preceding chapter

Free

Essay

Land development Activities Land development activities are the first step in developing and creating the real estate property. Land development activities have the price focus to the end user of the real estate, like residential apartment holder, office, and commercial building. So Land development activities is performing mainly based on the end consumer need and wants. Land development activities are start which acquires the land for the future development. Project development activities is based on purchase of specific land and create office or residential apartment but Land development activities is mainly consider development and land and source of financing to acquire the land. Project development activities are first step before land development activities. Project development is mainly a creating a plant o develop particular residential or official land for future use. Land development activities are ground level activity is formulated based on project development activities.

Q 3

Treetop Associated Group (TAG) is seeking financing for acquisition and development of 147 homesites. The land will cost $1.5 million, and TAG estimates direct development costs to be an additional $2.7 million. City Federal Bank will make a loan covering 40 percent of the land acquisition cost, 100 percent of direct improvement cost, and interest carry at 11 percent interest with a 3 percent loan origination fee. TAG has decided to split the development into two parcel types, standard and deluxe, with the standard parcels comprising 87 of the 147 total homesites. Also, TAG thinks that the deluxe sites will be priced at a $2,000 premium over the standard parcel price of $36,000. Total project revenue will be $5,412,000. After making a 60 percent down payment for the land and incurring closing costs of $50,000, TAG believes that the remaining development costs will be drawn down at $600,000 a month for the first three months and $300,000 a month for the next three months. Parcel sales are expected to begin during the fourth month after closing. TAG estimates that they will sell three standard parcels and four deluxe parcels a month for the remainder of the first year, and five standard parcels and two deluxe parcels per month for the second year. The company and the bank have agreed to a repayment schedule calling for the loan to be repaid at a rate 20 percent faster than the receipt of sales revenues; that is, the loan plus interest carry per parcel will be repaid when approximately 83.33 percent of all revenues are realized. Other costs to consider include sales expense (paid quarterly at a rate of 5 percent on parcels sold during the quarter), administrative costs of $7,500 per quarter, and property taxes of $19,000 at the end of each year. a. What will be the release price for each type of lot b. Estimate the total loan amount including interest carry for TAG. c. Prepare a schedule based on (b) and the pattern of loan draws, showing when TAG will have the loan fully repaid. What will be the total cash payments on the project loan d. What will total project costs be What percentage of total project costs are being financed e. What will be the NPV and IRR of this project if TAG's before-tax required rate of return is 15 percent ( Hint: Prepare a cash flow analysis on a quarterly basis over the life of the project.)

Free

Essay

Financial Land Development Project TSG Corporation is planning to develop a new project of land development. Total land cost in project is $1.5 million and direct development cost is $2.7 million. CF bank agrees to finance 40% of the value of land and 100 percent of value of direct development cost. Total interest rate is 11%. Basic Information of the project is shown below in Form of Excel screen shot: Total cost in term of Land Development and direct development cost is shown below in Form of Excel screen shot: TSG wants to develop 147 apartments out of which 87 are Standard apartment and 60 deluxe apartments. Cost and number of both type of apartment is shown below in Form of Excel screen shot: a. Release price is that amount of the sales that is goes to the lender. Release price is the amount that borrower pays to the lender. Here borrower agrees to pay 83.33% of sales to the lender until full amount is repaid. Release price is calculated by following formula: Price of standard apartment is $36,000. SO, release price for Standard apartment is calculated below: Similarly, Price of standard apartment is $38,000. SO, release price for Standard apartment is calculated below: Thus, Release price for Standard apartment is and release price for deluxe apartment is . b. Total land cost in project is $1.5 million and direct development cost is $2.7 million. CF bank agrees to finance 40% of the value of land and 100 percent of value of direct development cost. Total interest rate is 11%. Total loan financed is calculated below in following table: Thus, Total loan amount including interest carry cost is . Calculation of interest carry is shown in part (C) of this solution. c. in the beginning TAG drawn 40% of land value from the bank which is $600,000. After that in first three month TAG has drawn $600,000 per month for next three month and $300,000 for next three month. Loan drawn pattern is shown below in excel screen shot format. TAG has to pay interest based on total outstanding loan company has that in the beginning of first month there is only $600,000 loan then TAG has to pay interest on $600,000 only. In the next month TAG has to pay interest on the summation of two month loan plus interest carry. Same thing happen for all six months until TAG drawn fully from the bank. Interest of first month is calculated in the excel sheet and screen shot is provided below: So, total interest in first month is $5,500. Now in beginning of zero month total value of loan is last month loan amount and interest carry. So total value of loan in beginning of first month is calculated in excel and screen shot is provided below: First month TAG drawn another $600,000 from the bank, then total till first month loan drawn is calculated in excel and screen shot is provided below: Total value of loan at end of first month is $1,205,500 Similarly loan is drawn for all six month and loan drawn interest carry is added. From the month 4 bank started sales and according to agreement bank stated repaying the interest and principle to the bank. Loan repayment and interest carry is calculated in excel and screen shot is provided below: From the excel calculation it is found that total value of interest that TAG pays to bank is $291,527. d. Total project cost is calculated in excel and screen shot is provided below: First of all calculate direct cost. Screen shot of calculation of direct cost is show below: Thus Total Direct cost is $4,649,273. Now Calculation of indirect cost which included operating expense, administrative cost is calculated in the excel and screen shot is provided below: Total indirect cost of project is $297,100. So, total cost of project will be summation of direct cost and indirect cost. Total cost of project is calculated in excel and screen shot is provided below: Total cost of project is $4,946,373. Thus, total cost of project is Total value of loan is $3,591,527 and total project cost is $4,946,373. So percentage of total project cost financed through bank is calculated in excel and screen shot is provided below: Total percentage of total project cost financed through bank is 72.61%. Thus, Total percentage of total project cost financed through bank is . e. Life of project is 2 year that is total 8 Quarter. TAG corporation drawn loan for first two quarter and sale the project from second quarter to 8th quarter. From the interest carry calculation it is fund that TAG has able to repay all the cash principle and interest carry in 20 months. TAG Corporation has cash inflow in term of Sales, loan drawn and interest carry. Total cash inflow for TAG corporation is calculated in the excel sheet and screen shot is provided below: Total cash flow for TAG are in term of interest and principle payment, down payment for land, and other operating expenses. Cash outflow for TAG is calculated in the excel sheet and screen shot is provided below: Net cash flow for TAG is the total cash inflow minus total cash out flow. Net cash flow for TAG is calculated in excels and screen shot is provided below: NPV of the project at rate of 15% is calculated in the excel and screen shot is provided below: NOV of the project at rate of 15% discount rate is -$151,305. IRR of the project is calculated in excel and screen shot is provided below: IRR of the project is 6.10%. Thus, NPV of project at discount rate of 15% is and IRR of the project is

Q 4

What is an option contract How is it used in land acquisition What should developers be concerned with when using such options What contingencies may be included in a land option

Essay

Q 5

Lee Development Co. has found a site that it believes will support 75 homesites. The company also believes that the land can be purchased for $225,000 while direct development costs will run an additional $775,000. The Last National Bank of Texas will underwrite 100 percent of the improvements plus the interest carry. The loan would be made at 13 percent interest with a 3 percent loan origination fee. Lee believes that the development will sell faster with two types of parcels, standard and deluxe, with the standard parcel comprising 57 of the total parcels. Lee's marketing staff believes that the deluxe sites can be sold for $24,000 while the standard sites should bring $13,500. Lee estimates that the direct cost draws will be taken down in four equal amounts during months 1 to 4. Other up-front fees include closing costs of $10,000 and a 3 percent loan fee (not covered by the loan). Lee's sales staff supervisor assures him that she can generate sales activity starting in the fourth month that will result in the sale of five standard parcels per month and four deluxe parcels per month for three months. For the next six months, activity should be seven standard parcels per month and only one deluxe parcel per month. The Last National Bank wants its money out of the project early and wants Lee to agree to a release price per parcel that will result in the loan being repaid at a rate 25 percent faster than sales revenue is expected to be earned. Other costs to consider include sales expense (paid quarterly on 5 percent of the sales price of parcels sold during the quarter), administrative costs of $11,000 per quarter, and property taxes of $7,000. None of these latter items are to be funded in the loan. a. Develop a total monthly sales schedule for Lee. What will be Lee's total revenue How many months will it take Lee to fully repay the loan b. What will be the total interest carry funded in the loan amount What will be the release price for each type of lot Compute the loan repayment schedule. What will be Lee's total cash payments to the Last National Bank c. What will Lee's total equity requirement be Should Lee undertake this project if its required return on equity is 18 percent (Hint: Do a cash flow analysis on a quarterly basis for the life of the project.) What will be the IRR on the project

Essay

Q 6

What are some of the physical considerations that a developer should be concerned with when purchasing land How should such considerations be taken into account when determining the price that should be paid

Essay

Q 7

Excel. Refer to problem 3. Refer to the "Ch 17 Land Dev" tab in the Excel Workbook provided on the Web site. Change the assumptions in the file to solve problem 3. Then answer the following questions. a. Determine the release price based on a repayment schedule calling for the loan to be repaid at the following rates: 0 percent, 10 percent, and 30 percent faster than the receipt of sales revenues. ( Note: the original problem assumes a rate 25 percent faster.) b. Develop a loan schedule to demonstrate that with 0 percent acceleration the loan is paid off exactly when the last lot is sold. c. Calculate the lender's IRR (effective cost of the loan) for each of the rates in part ( a ). e x cel www.mhhe.com/bf14e (For Reference Problem 3) Lee Development Co. has found a site that it believes will support 75 homesites. The company also believes that the land can be purchased for $225,000 while direct development costs will run an additional $775,000. The Last National Bank of Texas will underwrite 100 percent of the improvements plus the interest carry. The loan would be made at 13 percent interest with a 3 percent loan origination fee. Lee believes that the development will sell faster with two types of parcels, standard and deluxe, with the standard parcel comprising 57 of the total parcels. Lee's marketing staff believes that the deluxe sites can be sold for $24,000 while the standard sites should bring $13,500. Lee estimates that the direct cost draws will be taken down in four equal amounts during months 1 to 4. Other up-front fees include closing costs of $10,000 and a 3 percent loan fee (not covered by the loan). Lee's sales staff supervisor assures him that she can generate sales activity starting in the fourth month that will result in the sale of five standard parcels per month and four deluxe parcels per month for three months. For the next six months, activity should be seven standard parcels per month and only one deluxe parcel per month. The Last National Bank wants its money out of the project early and wants Lee to agree to a release price per parcel that will result in the loan being repaid at a rate 25 percent faster than sales revenue is expected to be earned. Other costs to consider include sales expense (paid quarterly on 5 percent of the sales price of parcels sold during the quarter), administrative costs of $11,000 per quarter, and property taxes of $7,000. None of these latter items are to be funded in the loan. a. Develop a total monthly sales schedule for Lee. What will be Lee's total revenue How many months will it take Lee to fully repay the loan b. What will be the total interest carry funded in the loan amount What will be the release price for each type of lot Compute the loan repayment schedule. What will be Lee's total cash payments to the Last National Bank c. What will Lee's total equity requirement be Should Lee undertake this project if its required return on equity is 18 percent (Hint: Do a cash flow analysis on a quarterly basis for the life of the project.) What will be the IRR on the project

Essay

Q 8

In land development projects, why do lenders insist on loan repayment rates in excess of sales revenue What is a release price

Essay

Q 9

What are the unique risks of land development projects from the developer's and lender's point of view

Essay

Related Quizzes

Quiz 17: Financing Land Development Projects

QuizPlus

Links

Contact Us