A Project has a cost of $11,455,074 and it's NOI $494,299 per year for 15 years. The
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Primary Loan Loan by LTV Interest Rate Amortization Loan Constant Loan per LTV Ratio Concluded Loan Selected Loan Annual Payment Land Lease Long Term Ground Lease Annual Payment Required Equity Incentives Cash Flow After Debt Service Investor Equity Cash-on-Cash Return Pro Forma Duplex Units 1-31 Duplex Units 32-62 Sub-Total Vacancy Loss Effective Gross Income Non Recoverable Expenses-Total Reserves Net Operating Income Debt Service Cash Flow After Debt Service Reversion Value Leveraged IRR Terminal Cap Rate NOI Reversion Less Cost of Sale Net Reversion Less Debt Balance EOY 10 Net Proceeds 65.00% LTV Ratio $ 6,600,564 5.50% 30.00 years 6.81% 2.00% increase per yr 1.00% increase per yr $ $ 6,600,564 $ 6,600,564 4.00% $ $ $ $ $ 3,136,248 $ 1,718,261 $ 44,572 '$ $ $ $ $ (3,136,248) S $ -17.29% $6,600,564 449,727 10,000 10,000 1.42% Year 6 Year 1 Year 2 Year 3 Year 4 Year 5 Year 7 Year 8 Year 9 Year 10 292,764 $ 292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $ 292,764 292,764 292,764 292,764 292,764 292,764 292,764 292,764 292,764 292,764 585,528 $ 585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $ 5.855 5.855 5.855 5.855 5.855 5.855 5.855 5.855 5.855 5.855 579,673 $ 579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $ 79,577 81,169 82,792 84,448 86,137 87,860 89,617 91,409 93,237 95,102 5,797 5.855 5.913 5,972 6,032 6,092 6,153 6,215 6,277 6,340 494,299 $492,649 $490,967 $489,253 $487,504 $485,721 $483,903 $482,049 $480,158 $478,231 $ 459.727 $459.727 $459.727 $459.727 $459.727 $459.727 $449.727 $449,727 $449.727 $449,727 S 34,572 $32,922 $ 31,240 $ 29,525 $ 27,777 $25,993 $34,175 $ 32,321 $ 30,431 $ 28,504 $ 34,572 $ 32,922 $ 31,240 $ 29,525 $ 27,777 $25,993 $34,175 $ 32,321 $ 30,431 $ 28,504 $ $ 478,231 $ 11,955,773 6,00% $ 717,346 $ 11,238,427 s 6.526.809 $ 4,711,618. Year 11 Year 12 Year 13 Year 14 Year 15 Year 16 292,764 $292,764 $292,764 $292,764 $292,764 $292,764 292,764 292,764 292,764 292,764 292,764 292,764 585,528 $585,528 $585,528 $585,528 $585,528 $585,528 0 Q 2 Q 2 0 585,528 $585,528 $585,528 $585,528 $585,528 $585,528 97,004 98,944 100,923 102,941 105,000 107,100 6,403 6,467 6.532 6,597 6.663 6,730 482,121 $480,117 $478,073 $475,989 $473,865 $471,698 449.727 $449.727 $449.727 $449.727 $449.727 $449.727 32,393 $30,389 $28,346 $26,262 $24,137 $ 21,971 32,393 $30,389 $28,346 $26,262 $24,137 $ 21,971 Primary Loan Loan by LTV Interest Rate Amortization Loan Constant Loan per LTV Ratio Concluded Loan Selected Loan Annual Payment Land Lease Long Term Ground Lease Annual Payment Required Equity Incentives Cash Flow After Debt Service Investor Equity Cash-on-Cash Return Pro Forma Duplex Units 1-31 Duplex Units 32-62 Sub-Total Vacancy Loss Effective Gross Income Non Recoverable Expenses-Total Reserves Net Operating Income Debt Service Cash Flow After Debt Service Reversion Value Leveraged IRR Terminal Cap Rate NOI Reversion Less Cost of Sale Net Reversion Less Debt Balance EOY 10 Net Proceeds 65.00% LTV Ratio $ 6,600,564 5.50% 30.00 years 6.81% 2.00% increase per yr 1.00% increase per yr $ $ 6,600,564 $ 6,600,564 4.00% $ $ $ $ $ 3,136,248 $ 1,718,261 $ 44,572 '$ $ $ $ $ (3,136,248) S $ -17.29% $6,600,564 449,727 10,000 10,000 1.42% Year 6 Year 1 Year 2 Year 3 Year 4 Year 5 Year 7 Year 8 Year 9 Year 10 292,764 $ 292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $ 292,764 292,764 292,764 292,764 292,764 292,764 292,764 292,764 292,764 292,764 585,528 $ 585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $ 5.855 5.855 5.855 5.855 5.855 5.855 5.855 5.855 5.855 5.855 579,673 $ 579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $ 79,577 81,169 82,792 84,448 86,137 87,860 89,617 91,409 93,237 95,102 5,797 5.855 5.913 5,972 6,032 6,092 6,153 6,215 6,277 6,340 494,299 $492,649 $490,967 $489,253 $487,504 $485,721 $483,903 $482,049 $480,158 $478,231 $ 459.727 $459.727 $459.727 $459.727 $459.727 $459.727 $449.727 $449,727 $449.727 $449,727 S 34,572 $32,922 $ 31,240 $ 29,525 $ 27,777 $25,993 $34,175 $ 32,321 $ 30,431 $ 28,504 $ 34,572 $ 32,922 $ 31,240 $ 29,525 $ 27,777 $25,993 $34,175 $ 32,321 $ 30,431 $ 28,504 $ $ 478,231 $ 11,955,773 6,00% $ 717,346 $ 11,238,427 s 6.526.809 $ 4,711,618. Year 11 Year 12 Year 13 Year 14 Year 15 Year 16 292,764 $292,764 $292,764 $292,764 $292,764 $292,764 292,764 292,764 292,764 292,764 292,764 292,764 585,528 $585,528 $585,528 $585,528 $585,528 $585,528 0 Q 2 Q 2 0 585,528 $585,528 $585,528 $585,528 $585,528 $585,528 97,004 98,944 100,923 102,941 105,000 107,100 6,403 6,467 6.532 6,597 6.663 6,730 482,121 $480,117 $478,073 $475,989 $473,865 $471,698 449.727 $449.727 $449.727 $449.727 $449.727 $449.727 32,393 $30,389 $28,346 $26,262 $24,137 $ 21,971 32,393 $30,389 $28,346 $26,262 $24,137 $ 21,971
Expert Answer:
Answer rating: 100% (QA)
Project Cost 11455074 Loan Amount 6600564 Interest Rate 55 Loan Term 15 years Required Equity 114550... View the full answer
Related Book For
Real Estate Finance and Investments
ISBN: 978-0073377339
14th edition
Authors: William Brueggeman, Jeffrey Fisher
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
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...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Distance between Cars (Refer to Example 6.) At 9:00 A.M. car A is traveling north at 50 miles per hour and is located 50 miles south of car B. Car B is travel- ing west at 20 miles per hour. (a) Let...
-
In the relation L = aL0, should L0 be the initial length, the final length, or does it matter? Explain.
-
Use a recursion tree to give an asymptotically tight solution to the recurrence T(n) = T(n) + T((1 - )n) + cn, where is a constant in the range 0 < < 1 and c > 0 is also a constant.
-
An organization with a mission to build is in rapid expansion and growth. An organization with a mission to harvest is in a mature market. Assuming compensation is based on each of the factors listed...
-
The following stockholders equity accounts arranged alphabetically are in the ledger of Westin Corporation at December 31, 2014. Common Stock ($10 stated value) .............. $1,500,000 Paid-in...
-
At Chico's school, 60% of the students are boys, and 40% are girls. 10% of the boys play soccer, and 20% of the girls play soccer. Chico is making a diagram to represent the probability that a...
-
Following is the trial balance of Stopa Manufacturing Corporation as of December 31 of this year. You are given the following information for the adjustments: a. f. Year- end inventories: raw...
-
Required Prepare the statement of cash flow for the year ended 31 December 2019 in accordance with the IFRS and the requirements of the Companies Act.
-
. Assume that over the past 88 years, U.S. Treasury bills had an average return of 3.5% as compared to 6.1% on long-term government bonds. What was the average risk premium on the long-term...
-
The following symbol represents a four-digit up-counter, with synchronous loading function. Complete the schematic for a modulo-12 counter, with this counter and a few gates (AND, OR NOT). The...
-
A particle confined to motion along the x axis moves with constant acceleration from x = 2.0 m to x = 8.0 m during a 2.5-s time interval. The velocity of the particle at x = 8.0 m is 2.8 m/s. What is...
-
Shown in the table is the income of an individual with corresponding unit of good the person can purchase. Fill in the blanks and solve for the income elasticity and to indicate the classification of...
-
Requirement 1. What is the expected net cash inflow per year from purchasing a second shrink-wrap machine (i.e., how much cost could be saved each year by ell The expected net cash inflow (cost...
-
What are the key mechanistic insights gained from operando spectroscopic techniques, such as in situ X-ray absorption spectroscopy and ambient pressure X-ray photoelectron spectroscopy, in...
-
Per Bag Direct materials: 25 pounds of CWhiz-2000 @ $0.08/lb. = $ 2.00 Direct labor: 0.05 hour @ $32.00/hr. = $ 1.60 The company manufactured 100,000 bags of Cheese-Be-Good in December and used...
-
What would your answer be in Problem 5 if Mr. Nelligans mortgage was not recorded? Data from problem 5 Mort owns a property. Jessica Rosen holds a first mortgage against it, and Alex Nelligan holds a...
-
ABC Fund has decided to enter into a joint venture with Newtown Development Inc. to develop and operate an office building that will require an initial investment of $100 million to cover all the...
-
Suppose you deposit $2,500 at the end of year 1, nothing at the end of year 2, $750 at the end of year 3, and $1,300 at the end of year 4. Assuming that these amounts will be compounded at an annual...
-
Prove that if a quasi-connected, directed graph with root \(v_{0}\) and positive costs is input to Dijkstra's algorithm (see Exercise 14), then for each \(v eq v_{0}\), a shortest path from \(v_{0}\)...
-
A reservoir at vertex 1 in the diagram below is to supply water to several pumping stations. The edge weights are costs of laying pipe from one station to another. How should the pipe be laid so that...
-
Identify which internal control concept is being violated and explain how this may cause an opportunity for fraud to occur within a business: 1. The supervisor for the purchasing department has not...
Study smarter with the SolutionInn App