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
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.
How it Works
How It works ?
Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention product code mentioned in end of every Q&A Page. You can also send us your details through our email id firstname.lastname@example.org with product code in the email body. Product code is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.
Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to product code . The date is asked to provide deadline.
Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id email@example.com and firstname.lastname@example.org must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.
Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.
Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.
Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.
Features for Assignment Help
We believe in providing no plagiarism work to the students. All are our works are unique and we provide Free Plagiarism report too on requests.
We believe in providing perfect, relevant and 100% accurate solutions to the student as per questions asked. All our experts are perfect in providing that so as to give unique experience to the students.
We are the only service providers boasting of providing original, relevant and accurate solutions. Our three stage quality process help students to get perfect solutions.
All our works are kept as confidential as we respect the integrity and privacy of our clients.
- Physics Assignment Help
- Chemistry Assignment Help
- Engineering Assignment Help
- Psychology Assignment Help
- Online exam Help
- Marketing Assignment Help
- Arts Assignment Help
- Sociology Assignment Help
- Project Management Assignment
- Case Study Help
- Nursing Assignment Help
- Research Assignment Help
- Operations Management Assignment help
- Accounting Assignment Help
- Biology Assignment Help
- Mathematics Assignment Help
- English Assignment Help
- Business Plan Help
- Essay Writing Help
- Human Resource Assignment Help
- Accounting Homework Help
- Computer Science Assignment Help
- Finance Assignment Help
- Economics Assignment Help
- Statistics Homework Help
- Management Assignment Help
- Strategy Management Assignment Help
- Auditing Assignment Help
- Information Management Assignment Help
- Online Assignment Writing help
- Best Assignment Help
- Humanities Assignment help
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 email@example.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.