Taxation -AW-Q411 Online Services
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.
You can read more about our case study assignment help services here.
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 Case Id mentioned in end of every Q&A Page. You can also send us your details through our email id firstname.lastname@example.org with Case Id in the email body. Case Id 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 Case Id . 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.
We use best scientific approach to solve case study as recommended and designed by best professors and experts in the World. The approach followed by our experts are given below:
The first step in solving any case study analysis is to define its problem carefully. In order to do this step, our experts read the case two three times so as to define problem carefully and accurately. This step acts as a base and help in building the structure in next steps.
The second step is to define structure to solve the case. Different cases has different requirements and so as the structure. Our experts understand this and follow student;s university guidelines to come out with best structure so that student will receive best mark for the same.
Research and Analysis
This is the most important step which actually defines the strength of any case analysis. In order to provide best case analysis, our experts not only refer case materials but also outside materials if required to come out with best analysis for the case.
Conclusion & Recommendations
A weak conclusion or recommendations spoil the entire case analysis. Our expert know this and always provide good chunks of volume for this part so that instructors will see the effort put by students in arriving at solution so as to provide best mark.
- 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
- Humanities Assignment help
- Taxation Homework Help
- Corporate Finance Assignment Help
- Financial Management Assignment Help
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.
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.
All givens and assumptions must be stated in a separate “Assumptions” section.
Along with your pro-forma, please detail: (1) amortization schedule for mortgage balance, (2) reversion year sale, (3) depreciation. Please be spcific about all applicable taxes and rates; please show derivative calculations of all key taxes upon sale (end of holding period).
With the exception of entity discussion, your work must be done on a computerized spreadsheet. Any project submitted in a scanned format will not be accepted.
Although each student must hand in his/her own project, please feel free to confer with your classmates. This project requires skills and knowledge that will be fundamental to your success in the balance of the Masters Degree Program.
REAL ESTATE PROPERTY TAX
Calculation for STABILIZED YEAR real estate taxes on the land and building based on NYC formulas
ASSESSED VALUATION = Land & (Total Construction Cost x 50%)
REAL PROPERTY TAX = (ASSESSED VALUE) x 5.911% (Tax Rate)
The development project has qualified under a local law granting partial real estate tax exemption for newly constructed multiple dwellings. In order to qualify the Developer agreed to reserve 50% of the one-bedroom apartments for low income qualifying tenants who will pay 40% of the market rent.
The Real Estate Tax Exemption is as follows
The exemption will continue to decrease by 5% each year until year 10 in which there will be no further exemptions and the landlord will need to continue to lease to low income qualifying tenants who will pay 40% of the market rent. To the extent a low income qualifying tenant moves out after year 10, the landlord can rent the unit at market rent.
Product Code-Taxation -AW-Q411
Looking for best Taxation -AW-Q411 online ,please click here