Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. Financing 'For Sale' Property 2. Lee Waters of Oilers' Development Co. has found a site that it believes will support 75 home sites. The
2. Financing 'For Sale' Property 2. Lee Waters of Oilers' Development Co. has found a site that it believes will support 75 home sites. The company also believes that the land can be purchased for $12,000,000 while direct development costs will run an additional $12,000,000. The Bitumen Capital Partnerswill underwrite 42% of the purchase price of the land plus 100 percent of the improvements plusthe interest carry. Theloan would be madeat 12% interest with a 3 percent loan originationfee. Lee believes that the development will sell faster with three types of parcels: Cluster, Standard and Creekside. The total number of parcels in the subdivision would be 180 comprised of 54 Cluster (rowhouse), 90 Standard (single family) and 36 Creekside (sf beside an environmental zone) parcels. Oilers' marketing staff believes that the pricing is as follows: Cluster at $100,000, Standard at $200,000 and Creekside at $250,000. These lots would be sold to at least four different homebuilders with whom Oilers' have an existing relationship. The commission (sales expense) paid on sales is 5% and is paid quarterly. Lee estimates that there will be six direct cost draws following the initial draw for the land purchase. The draw for the land purchase would occur at t=0 and would be for 42% of the $12,000,000 land price. Following that, at t=1, there would be a draw of $3,000,000 followed by another identical draw at t=2 then followed by four monthly draws of $1,500,000 totalling $12,000,000 in direct costs over six months. Again, the draw for the land purchase would occur at t=0 and would be for 42% of Bitumen want their money out of the project early and want Oilers 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). Annual administrative costs are $150,000 paid quarterly and annual property taxes are $300,000 paid semi-annually. None of these latter items are to be funded by the loan. Use the Grayson model to develop a total monthly sales schedule for Oilers. a How many months will it take Oilers' to fully repay the loan? In what month is the balance =0 ? b. What will bethetotal interest carryfunded intheloan amount? c. What will bethe release price for a Creekside lot? d. What is the maximum outstanding loan amount? e. What will Lee'stotal equity requirement be? f. Should Lee undertake this project if its required return on equity (equityIRR) is 20 percent? (Hint: Doa cash flow analysis on a quarterly basis for the life of the project.) Page 2 of 3 You can use the Grayson model. Simply make changes to that model to reflect the assumptions here. Note that I have posted a slightly revised Grayson model that (I think) indicates in light yellow, all of the cells where information is entered
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started