Real Estate Pro Forma I just need to see the work for the answer above. All of
Fantastic news! We've Found the answer you've been seeking!
Question:
Real Estate Pro Forma
I just need to see the work for the answer above. All of thedata I was given is above "Check answers"
Transcribed Image Text:
PRACTICE WORK - FIN 3070 Inputs Financial Info Interest Rate Term Percent Financed Price Tax and rates Info + Ordinary Income Tax Rate Depreciation Recapture Tax Rate Capital Gains Tax Rate Land Value Discount Rate Amortization Schedule Balance 1 2 3 Monthly payments 5 NOI Taxes ATCF $2,240,000 Principal 2,192,654 2,141,378 2,085,846 2,025,706 1,960,573 277,200 12,683 39,682 $47,346 51,276 55,532 60,141 65,132 Basis Taxable Gain Ass. Dspr Tax Capital Gain Tax Taxes on Sale ATER IRR NPV @16% 2 8% 20 years 70% S 3,200,000 285,516 16,356 44,325 $ 960,000 16.0% Gross SP $ 4,016,885 2,912,821 742,545 71,795 Interest 30% 25% 15% 68,305 140,100 $1,554,692 14.3% (63,539) $177,489 173,559 169,303 164,694 159,703 The property is an industrial warehouse. Using the given information, find the cash flows, NPV and IRR for a five-year holding period. The year 5 selling price will be the forecast year 6 NOI capitalized at the terminal cap rate. Check answers: 3 Income/Expense Info 294,081 20,203 49,044 Square Footage Rent per square foot (annual) Rent Growth 0 Vacancy Allowance Oner. Exp. Ratio (% of EGI) Reversion Info Terminal Cap Rate Selling Expenses 4 302,904 24,232 53,837 5 25,000 $18 311,991 28,456 58,700 3% 12% 30% 8% 9% 6 321,351 PRACTICE WORK - FIN 3070 Inputs Financial Info Interest Rate Term Percent Financed Price Tax and rates Info + Ordinary Income Tax Rate Depreciation Recapture Tax Rate Capital Gains Tax Rate Land Value Discount Rate Amortization Schedule Balance 1 2 3 Monthly payments 5 NOI Taxes ATCF $2,240,000 Principal 2,192,654 2,141,378 2,085,846 2,025,706 1,960,573 277,200 12,683 39,682 $47,346 51,276 55,532 60,141 65,132 Basis Taxable Gain Ass. Dspr Tax Capital Gain Tax Taxes on Sale ATER IRR NPV @16% 2 8% 20 years 70% S 3,200,000 285,516 16,356 44,325 $ 960,000 16.0% Gross SP $ 4,016,885 2,912,821 742,545 71,795 Interest 30% 25% 15% 68,305 140,100 $1,554,692 14.3% (63,539) $177,489 173,559 169,303 164,694 159,703 The property is an industrial warehouse. Using the given information, find the cash flows, NPV and IRR for a five-year holding period. The year 5 selling price will be the forecast year 6 NOI capitalized at the terminal cap rate. Check answers: 3 Income/Expense Info 294,081 20,203 49,044 Square Footage Rent per square foot (annual) Rent Growth 0 Vacancy Allowance Oner. Exp. Ratio (% of EGI) Reversion Info Terminal Cap Rate Selling Expenses 4 302,904 24,232 53,837 5 25,000 $18 311,991 28,456 58,700 3% 12% 30% 8% 9% 6 321,351
Expert Answer:
Answer rating: 100% (QA)
The image youve shared seems to be a real estate pro forma sheet for an industrial warehouse which includes several components to consider when evaluating a real estate investment The pro forma sheet ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Which type of Organizational Model put the MOST emphasis on establishing MORALE and AUTONOMY O a. Hierarchical style Model b. O c. O d. Flat Management (Holocracy) Model Multi-divisional style Model...
-
Refer to the financial statements for Richardson Socks Company in Problem 12-89B and the data below. Data from problem 12-89B, Richardson Socks Company Consolidated Income Statement s (In thousands...
-
The following financial statements and additional information are reported. (1) Prepare a statement of cash flows using the indirect method for the year ended June 30, 2019. (2) Compute the companys...
-
On January 2, 2018, The Register, a science and technology news site based in Britain, published an article revealing the existence of two major bugs leaving virtually all computers and smartphones...
-
Sebolt Wire Company heats copper ingots to very high temperatures by placing the ingots in a large heat coil. The heated ingots are then run through a shaping machine that shapes the soft ingot into...
-
Flag Faber Manufacturing inc of st paul purchases 9,649 top of the line semiconductor; the maximum backordering quantity in units 502; lead time = 1.5 month ( the firm operates 12 months per year)....
-
You are owner of a 15-person advertising agency in a major market. You've been invited to pitch the Girl Powerz account, the largest female-only fitness center chain in the region, one that could...
-
A taxpayer is expensing $1,500,000 in equipment and wants to maximize the amount of expensing under Section 179 on her return. What is the total amount of Section 179 expensing that she can claim on...
-
A taxpayer incurs the following rental expenses: $15,000 to rebuild and replace a roof on one of their properties $2,000 to make spot corrections and paint small rooms on several properties $4,000 to...
-
The town of Escalon is issuing 10-year savings bonds so that they can build a new hospital. When the bonds mature the town will owe $3,250,000 to the bondholders. How much will the town need to...
-
North, Incorporated (C corporation) owns 25% of East, Incorporated's common stock. This year, North generated $50,000 net operating income excluding dividends and received $20,000 dividends from...
-
A minor dependent taxpayer earns $4,000 during the year as a grocery bagger and has $1,000 in investment income from holdings gifted at birth by their grandparents. What is the value of their...
-
Find the quotient and remainder using long division for 4 x 3 2 x 2 6 x + 7 2 x 2 5 4 x 3 - 2 x 2 - 6 x + 7 2 x 2 - 5 The quotient is The remainder is
-
For the following exercises, find the area of the triangle. Round to the nearest hundredth. 22 50 36
-
In June of 2012, Maureen's house is vandalized during a long-term power failure after a hurricane hit the city. The president of the United States declares Maureen's city a disaster area as a result...
-
Jason and Mary are married taxpayers in 2012. They are both under age 65 and in good health. For this tax year, they have a total of $41,000 in wages and $500 in interest income. Jason and Mary's...
-
Ray and Maria Gomez have been married 3 years. They live at 1610 Quince Ave., McAllen, TX 78701. Ray works for Palm Oil Corporation and Maria works for the City of McAllen. Maria's Social Security...
-
Macquarie Manufacturing Ltd prepared the following planned production data for the forthcoming year ending 30 June 2019. Required (a) Prepare a table showing the predetermined factory overhead rate...
-
Beautiful Bottles Pty Ltd, bottle manufacturer for the food industry, has just installed a job order costing system. The company uses machine hours to apply its overhead to work in process. On 1 May...
-
Green Consultants Pty Ltd specialise in consulting on landscape design. The company developed a predetermined charge-out rate based on hours for each of its consultants on 1 July 2019 to assign the...
Study smarter with the SolutionInn App