Property Accounting Assignment Help With Solution

Property Accounting Assignment Help With Solution

 
The purpose of the term project is to provide the student with the experience of preparing a comprehensive financial package, detailing a potential real estate development. Project data should be prepared in standard industry format, as is typically required by lenders and investors.

You have decided to buy land with a building shell (fire gutted). The property is located at 850 East 55th Street, New York, New York, and you plan to demolish the existing building and construct a new building. Assume you may build a maximum of 500,000 rentable square feet.

The development will consist of 400 rental apartments, 200 one-bedroom, 250 two-bedroom, and 3 retail stores.

Retail space comprises no more than 20% of gross rentable square feet.

The cost of the land and shell is $50,000,000, and upon signing the contract you most provide a 10% deposit. The Construction Loan will be equal to 50% of the total construction costs and investors will provide the balance in the form of equity. The permanent loan amount will be calculated at 60% of the property’s value at the end of construction. The method for valuing the property will be the 2017 NOI capped at 5.0%.

The timetable is as follows:
You have located the property in September 2014.
 
You reported to your equity investors in early October 2014. Soon thereafter you entered into a contract to purchase the land. You purchased the land by November 15, 2014. You arranged for construction financing and permanent loan commitments over the next 45 days and closed with the construction lender on December 31, 2014, and plan to close on the permanent loan on December 31, 2015.
 
The critical dates are as follows:
2015 is construction year
2016 is lease-up year
2017 is stabilization year
2018-2020 are operational years
 
The property is expected to be sold on December 31, 2020 at a 4.5% cap rate, with costs of sales at 3.0% of gross sales price.

You have met with a few potential investors and creditors who are interested in this development opportunity. They have requested that you provide them with the following information:

A) A description of the project including financial analysis and the proposed deal terms offered to both the investors and the creditors. Be specific as to how much initial equity and financing is required and be sure equity is available to fund the acquisition of land, securing permanent loan commitment, construction financing and predevelopment costs. Include a schedule of investor returns and rates of return.

B) A detailed project budget. In spread sheet format, please detail all costs including land acquisition price and costs, pre-development costs, construction costs (hard & soft), construction period interest (carry), construction period taxes, construction loan fees, permanent loan fees, rent up costs, and shortfall reserve. Please provide a time frame for the development. Show all costs in total and per square foot amounts.

C) A pro-forma income and expense analysis for the holding period (after substantial completion). Your analysis should be both pre-tax and after-tax.

D) A discussion of your choice of entity, its tax advantages to investors.

E) The returns (pre-tax and after-tax) that the developer and investors can expect through the end of the deal. Specifically, Cash-on-Cash, IRR and NPV, to be detailed within your spread sheet work. Use a discount rate of 10% to calculate NPV.

F) Please list all assumptions to pro-forma and construction draw schedule.

G) Please provide a detailed income statement, balance sheet, and statement of partner’s equity for each year.

The following assumptions should be incorporated into your project:

1) Closing costs connected with the land purchase will be 2.0% of the purchase price. Land closing will be prior to the closing of the construction loan. Remember that the total cost of land & capitalized costs represents your equity contributions and should be included in your budget.
 
2) Total hard construction costs will be $400 per buildable foot (120% of rentable residential square feet), excluding tenant improvements, -retail- that will be done by commercial tenants. Additional demolition costs are $450,000. Soft costs (not including construction interest) are calculated at 6.5% of hard costs.  

 
The pre-development costs which are in addition to all other square foot costs will include:

Engineering, design, architects, fees & costs​$45,000

NYC plumbing, water, steam connection permits​ 3,500

Land, soil tests, environmental testing​ 13,000

​Total​$61,500

3) Construction period interest must be calculated on a separate draw schedule and shown as part of the budget. Please use an annual rate of 8.0%. Allow 12 months total for closing through substantial completion of the project. Assume construction costs will be paid, 50% over the first 4 months and 50% ratably over the next 7 months, and 10% of construction mortgage retained and paid on final draw.
 
4) You may assume that the permanent loan will take out the construction loan at the end of the 12-month period. For the permanent loan, please use the following information: rate 6.0%, term 25 years, amortized over 25 years.
 
5) You may assume a strong rental market, with pre-leasing activity of residential and retail space. Please present a separate schedule for year one, detailing by month, phase-in of units, show # of units occupied and prorate rents accordingly. By the end of the first year all units should be occupied. Incorporate year one into your pro-forma income and expense analysis for the entire holding period.
 
6) Rent-up charges consist primarily of leasing commissions and are estimated at 5% of gross income in 2016 the lease-up year. Stabilization will be in year 2017. Please note that leasing commissions are paid out when due. You may assume that all residential leases are for a 3-year period, and retail leases will be for a 5-year period residential and retail leases will remain in place during the holding period and that no further lease commissions will be paid for purposes of your calculations.
 
7) Fees connected with the permanent mortgage commitment letter will include a charge for issuing the commitment letter of 0.15% of total permanent mortgage; a legal fee of $30,000 and other costs (credit search, title exam, etc.) of $15,000. Borrower’s costs including legal fees are $40,000.

8) Fees connected with the construction loan to be paid by the investors will be $30,000 for points, $15,000 for lender legal fee, $5,000 for an engineering review and $10,000 for borrower’s legal fees.

9) Permanent loan closing fees will include: loan points at .001 of permanent loan; borrower’s legal fees of $25,000; lender’s legal fees of $15,000; and other fees to lender (such as inspecting architect, appraisal, engineering, audit, lender’s package fee, etc.) of $28,000.

10) Current market rates for rentals are:

One-bedroom​$4,000 per month​*See note on Real Estate Property*

Two-bedroom​$7,700per month​ Tax page

Commercial/retail space for this location will rent at $25,000 per month, per unit, plus escalations and expenses.

Residential rents escalate at 3% annually.

Commercial base rent escalates at 5% annually.

11) Operating expenses, excluding property taxes, will be 15% of gross income during the lease-up year and 10% in the stabilized year. All expenses, excluding real estate taxes, escalate at 3% per annum, after stabilized year.

12) Real estate taxes on land and building are $27,500 per year. They will remain the same during construction, and the lease-up year. You should calculate yearly real estate taxes based upon available NYC formulas, see attached.

13) Lenders require a 4% vacancy and credit loss on retail space, and 3% on residential. These costs escalate 2% and 3.5% respectively after stabilization year.

14) If your chosen entity will involve taxation of the individual, it will be at the maximum applicable rate of 35%. Capital gains rates will be 25% on gain attributable to tax depreciation deductions and 20% on all other capital gain.

15) Assume that a cost segregation study is done and it is determined that 8% of the depreciable property is considered to be personal property. Upon sale, the value of the personal property is considered to be equal to its adjusted tax basis.
 

Product Code :Acc19

To get answer for this question, kindly click here (Note: Don’t forget to write the product code in comment section)

You can also email us at assignmentconsultancy.help@gmail.com but please mentioned product code in the mail body while sending emails.You can browse more questions to get answer in our Q&A sections here.