80.2K

Verified Solution

Link Copied!

can someone help me to answer question number 6,10, 13, and 14. thankyou so much

AutoSave OFF 5 0 HW5 - Saved to my M Insert Draw Design Layout References >> Footnotes Captions Index Smart Researcher Lookup Citations & Bibliography office Update To keep up-to-date with security updates, fixes, and improvements,... sklin School of Business Baruch Colleg Homework #5 RES 3200: Commercial Real Estate Instructions: 1. Round all final dollar amounts to the nearest cent and don't enter the dollar sign. E.g. If the answer is $1,022.912, enter it as 1,022.91. Commas don't matter, hence you can also enter 1022.91. 2. Round all final percentages to the nearest basis point and don't enter the percent sign. E.g. if the answer is 17.238%, enter it as 17.24. If the answer is 0.52%, enter it as 0.52. You want to purchase an office building in Brooklyn. The property contains 112.000 square feet of rentable space and is currently occupied by multiple tenants each with differing maturities on their respective leases. No lease is currently shorter than 1 year. The annual rent in the 15 year of ownership is $55.50/sq ft. The vacancy rate is 3.5% You expect to incur collection losses (from tenant default) of 1.5% 1. What is the Potential Gross Income (PGI) for the first year? 2. What is the Effective Gross income (EGI) for the first year? 2. W operating expenses are expected to be 40% of EOL what the Net Operating income (NOU) gented by the property in the year of ownership? 15 000 view Test Sub. AutoSave OFF S U S H W5 - Saved to my Mac ne Insert Draw Design Layout References >> Share ble of mtents Footnotes Smart Researcher Lookup Citations & Bibliography Captions Index Table Authori Office Update To keep up-to-date with security updates, fixes, and improvements.... Che 1. What is the potential Gross Income (PGI) for the first year? 2. What is the Effective Gross Income (EGI) for the first year? 3. If operating expenses are expected to be 40% of EGI, what is the Net Operating Income (NOI) generated by the property in the 1st year of ownership? 4. You decide you want to take out a loan to finance the purchase of this property. It will be a 10 yr balloon at an interest rate of 4.25% amortizing over a 30 year period with monthly payments and monthly compounding. The lender will provide financing up to a minimum Debt Service Coverage Ratio (DSCR) of 1.2 based off the 1" year NOI. What is the largest annual loan payment the lender will allow you to make based on the DSCR? in 5. If you get a loan that corresponds to the largest annual loan payment the lender will allow you to make based on the DSCR (computed in part 4), what will be your net income (Cash flow after debt service) in the first year? 6. What is the largest loan lender is willing to provide you with based on question 47 (Use the terms and loan payment from question 4.) 7. The seller's asking price for the property is 555.000.000 (assume this is the value). If the lender has a maximum 70% LTV requirement, what is the most the bank will end you? (Only 35,000.... . .LT G roent).... . Review Test Sub... + AutoSave OFF u e. HW5 - Saved to my Mac ome Insert Draw Design Layout References Share 11 Table of Contents Footnotes Smart Researcher Lookup Captions Citations & Bibliography Index Table of Authorities > Office Update To keep up-to-date with security updates, fixes, and improvements.... Check for 5. If you get a loan that corresponds to the largest annual loan payment the lender will allow you to make based on the DSCR (computed in part 4), what will be your net income (Cash flow after debt service) in the first year? 6. What is the largest loan a lender is willing to provide you with based on question 47 (Use the terms and loan payment from question 4.) 7. The seller's asking price for the property is $55.000.000 (assume this is the value). If the lender has a maximum 70% LTV requirement, what is the most the bank will lend you? (Only based on the.LTY sequirement)............. 8. The loan must satisfy both the minimum DSCR of 1.2 and maximum LTV of 70%. What is the biggest loan the borrower can get? 9. If you buy the property at the asking price of $55,000,000 using the biggest loan you can get (from question 8) and purchase costs are 5% of the purchase price, what will your down payment be? nin 10. What is the annual mortgage payment on the loan in question 87 Y 11. If you buy the property at the asking price of $55,000,000, what is your going in Cap Rate? 15.000 12. If the annual does this imply arwin Dernetu for this property is 3.5% then based on the captain question 11. what expected Not growth rate for the property about the formula for a wiew Test Sub.. + AutoSave O osu HW5 - Saved to my Mac e h Insert Draw ab 1 Footnotes Design Layout 0 Smart Researcher References A Citations & Bibliography Share OC ] Table of Authorities le of Captions Index tents Lookup Office Update To keep up-to-date with security updates, fixes, and improvements,... Check for Up 9. If you buy the property at the asking price of $55,000,000 using the biggest loan you can get (from question 8) and purchase costs are 5% of the purchase price, what will your down payment be? 10. What is the annual mortgage payment on the loan in question 8? 11. If you buy the property at the asking price of $55,000,000, what is your going in Cap Rate? 12. If the annual in for this property is 8.5%, then based on the cap rate in question 11. what does this imply is expected NOI growth rate for this property? (think about the formula for a growing perpetuity) 13. You do research and find that similar properties are selling at an 8% cap rate. Using an 8% cap rate, what price would you offer for this property? 14. Suppose you buy the property at the asking price of $55,000,000 and own for exactly 3 years You make the down payment in part (9) You collect the NOI in part (3) You make the annual mortgage payment in part (10) The NOI expected to grow any You sell the property at the end of year 3 based on proforma year 4 NOI), at a cap rate of 6.5% (roughly equal to the capre in part (11) and Day of the loan balance when you se this a m orting principal) iew Test Sub... + AutoSave OFF S US H W5 -Saved to my Mac e insert Draw Design Layout References Share C - ab 0 le of Footnotes Smart Researcher Citations & Captions Index Table of tents Lookup Bibliography Authorities Office Update To keep up-to-date with security updates, fixes, and improvements.... Check fc growing perpetuity) B A - - - 13. You do research and find that similar properties are selling at an 8% cap rate. Using an 8% cap rate, what price would you offer for this property? 14. Suppose you buy the property at the asking price of $55,000,000 and own it for exactly 3 years You make the down payment in part (9). You collect the NOI in part (3). You make the annual mortgage payment in part (10) The NOI is expected to grow 3% annually. You sell the property at the end of year 3 (based on proforma year 4 NOI), at a cap rate of 6.5% (roughly equal to the cap rate in part (11) and pay off the loan balance when you sell (this loan is amortizing principal). Sale costs are 3% of the sales price. Compute the IRR on this investment AutoSave OFF 5 0 HW5 - Saved to my M Insert Draw Design Layout References >> Footnotes Captions Index Smart Researcher Lookup Citations & Bibliography office Update To keep up-to-date with security updates, fixes, and improvements,... sklin School of Business Baruch Colleg Homework #5 RES 3200: Commercial Real Estate Instructions: 1. Round all final dollar amounts to the nearest cent and don't enter the dollar sign. E.g. If the answer is $1,022.912, enter it as 1,022.91. Commas don't matter, hence you can also enter 1022.91. 2. Round all final percentages to the nearest basis point and don't enter the percent sign. E.g. if the answer is 17.238%, enter it as 17.24. If the answer is 0.52%, enter it as 0.52. You want to purchase an office building in Brooklyn. The property contains 112.000 square feet of rentable space and is currently occupied by multiple tenants each with differing maturities on their respective leases. No lease is currently shorter than 1 year. The annual rent in the 15 year of ownership is $55.50/sq ft. The vacancy rate is 3.5% You expect to incur collection losses (from tenant default) of 1.5% 1. What is the Potential Gross Income (PGI) for the first year? 2. What is the Effective Gross income (EGI) for the first year? 2. W operating expenses are expected to be 40% of EOL what the Net Operating income (NOU) gented by the property in the year of ownership? 15 000 view Test Sub. AutoSave OFF S U S H W5 - Saved to my Mac ne Insert Draw Design Layout References >> Share ble of mtents Footnotes Smart Researcher Lookup Citations & Bibliography Captions Index Table Authori Office Update To keep up-to-date with security updates, fixes, and improvements.... Che 1. What is the potential Gross Income (PGI) for the first year? 2. What is the Effective Gross Income (EGI) for the first year? 3. If operating expenses are expected to be 40% of EGI, what is the Net Operating Income (NOI) generated by the property in the 1st year of ownership? 4. You decide you want to take out a loan to finance the purchase of this property. It will be a 10 yr balloon at an interest rate of 4.25% amortizing over a 30 year period with monthly payments and monthly compounding. The lender will provide financing up to a minimum Debt Service Coverage Ratio (DSCR) of 1.2 based off the 1" year NOI. What is the largest annual loan payment the lender will allow you to make based on the DSCR? in 5. If you get a loan that corresponds to the largest annual loan payment the lender will allow you to make based on the DSCR (computed in part 4), what will be your net income (Cash flow after debt service) in the first year? 6. What is the largest loan lender is willing to provide you with based on question 47 (Use the terms and loan payment from question 4.) 7. The seller's asking price for the property is 555.000.000 (assume this is the value). If the lender has a maximum 70% LTV requirement, what is the most the bank will end you? (Only 35,000.... . .LT G roent).... . Review Test Sub... + AutoSave OFF u e. HW5 - Saved to my Mac ome Insert Draw Design Layout References Share 11 Table of Contents Footnotes Smart Researcher Lookup Captions Citations & Bibliography Index Table of Authorities > Office Update To keep up-to-date with security updates, fixes, and improvements.... Check for 5. If you get a loan that corresponds to the largest annual loan payment the lender will allow you to make based on the DSCR (computed in part 4), what will be your net income (Cash flow after debt service) in the first year? 6. What is the largest loan a lender is willing to provide you with based on question 47 (Use the terms and loan payment from question 4.) 7. The seller's asking price for the property is $55.000.000 (assume this is the value). If the lender has a maximum 70% LTV requirement, what is the most the bank will lend you? (Only based on the.LTY sequirement)............. 8. The loan must satisfy both the minimum DSCR of 1.2 and maximum LTV of 70%. What is the biggest loan the borrower can get? 9. If you buy the property at the asking price of $55,000,000 using the biggest loan you can get (from question 8) and purchase costs are 5% of the purchase price, what will your down payment be? nin 10. What is the annual mortgage payment on the loan in question 87 Y 11. If you buy the property at the asking price of $55,000,000, what is your going in Cap Rate? 15.000 12. If the annual does this imply arwin Dernetu for this property is 3.5% then based on the captain question 11. what expected Not growth rate for the property about the formula for a wiew Test Sub.. + AutoSave O osu HW5 - Saved to my Mac e h Insert Draw ab 1 Footnotes Design Layout 0 Smart Researcher References A Citations & Bibliography Share OC ] Table of Authorities le of Captions Index tents Lookup Office Update To keep up-to-date with security updates, fixes, and improvements,... Check for Up 9. If you buy the property at the asking price of $55,000,000 using the biggest loan you can get (from question 8) and purchase costs are 5% of the purchase price, what will your down payment be? 10. What is the annual mortgage payment on the loan in question 8? 11. If you buy the property at the asking price of $55,000,000, what is your going in Cap Rate? 12. If the annual in for this property is 8.5%, then based on the cap rate in question 11. what does this imply is expected NOI growth rate for this property? (think about the formula for a growing perpetuity) 13. You do research and find that similar properties are selling at an 8% cap rate. Using an 8% cap rate, what price would you offer for this property? 14. Suppose you buy the property at the asking price of $55,000,000 and own for exactly 3 years You make the down payment in part (9) You collect the NOI in part (3) You make the annual mortgage payment in part (10) The NOI expected to grow any You sell the property at the end of year 3 based on proforma year 4 NOI), at a cap rate of 6.5% (roughly equal to the capre in part (11) and Day of the loan balance when you se this a m orting principal) iew Test Sub... + AutoSave OFF S US H W5 -Saved to my Mac e insert Draw Design Layout References Share C - ab 0 le of Footnotes Smart Researcher Citations & Captions Index Table of tents Lookup Bibliography Authorities Office Update To keep up-to-date with security updates, fixes, and improvements.... Check fc growing perpetuity) B A - - - 13. You do research and find that similar properties are selling at an 8% cap rate. Using an 8% cap rate, what price would you offer for this property? 14. Suppose you buy the property at the asking price of $55,000,000 and own it for exactly 3 years You make the down payment in part (9). You collect the NOI in part (3). You make the annual mortgage payment in part (10) The NOI is expected to grow 3% annually. You sell the property at the end of year 3 (based on proforma year 4 NOI), at a cap rate of 6.5% (roughly equal to the cap rate in part (11) and pay off the loan balance when you sell (this loan is amortizing principal). Sale costs are 3% of the sales price. Compute the IRR on this investment

Answer & Explanation Solved by verified expert

See Answer