Please help with this. I was unable to do this assignment. could someone help me understand this?

Thank you

File Tools Vien westwood publics case - Word e Case: Westwood Publix Plaza The Property: square foot annually, with no rental increases over the life of the lease. Under Eckerd's lease, they must pay 23% of the property's total common area mainte- nance costs. The expiration date on the Eckerd lease is December 2012. They have the right to void the lease if Publix either goes dark or leaves the center. The Eckerd chain has experienced a decline in the quality of their credit, which now stands at BB.I The property in question is a 100,000 square foot strip mall "Westwood Plaza" located in a suburb in Central Florida (Tampa). The 31-year-old center is de cently located within the town. You purchased the property 8 years ago for $7,000,000 (current time/year is 2003). Based on IRS filings, 30% of the pur- chase price was attributable to land costs. There are two primary retail anchors and 11 smaller local tenants. Other Tenants: The remaining 40,000 square feet is presently fully leased and occupied by 11 smaller local tenants. Although there are no credit ratings avail- able for these tenants, it can be assumed that they are generally a significant credit risk. Your rental revenues from these tenants are based not only upon a base rent amount, but also include a percentage rent component of 1.5% of each tenant's gross sales figures (excluding the good doctor). The basic terms of the 11 local tenant's leases are as follows. Tenants: : Description Term of leave .an-01- OOT Publix Supermarket: The first anchor tenant is a 35,000 square foot Publix su- permarket which has been a tenant in the center since 1980. The Publix chain as a whole is financially solvent and has good quality credit. The terms of the Publix lease dictate that it pay $10 per square foot annually with no provisions for increase. Moreover, they are responsible for paying 29% of the property's total common area maintenance costs. They have an option to renew their lease for an additional 10 year period upon expiration of their current lease at a rental rate of $13 per square foot. Publix has the absolute right to go dark at any time. The current lease expires in December of 2009. Tenants Ross Travel AUTA Trew's News Super T Kalis by Duste Travel Agency Food Uue Store Hair Salon alon Ophthalmologist Video Real Dry Cleaners Food WESTWOOD PLAZA IN-LINE TENANT LIST Base Bear Square feet CAMALOeion Gross Sales Per 2012 2,500 2.SN 51149 5502,00 7.50 319 $11 5554.000 1,000 105 51269 SA 2.500 S1400 $410,000 2.500 2.5% . 513 68 5309,000 5.000 BA 51600 4,000 51425 5565,000 2.500 2.5% 51074 SIT 100 6,000 5.C 511 33 5545,000 7,000 515 96 5669,000 1.500 SIG G75288,000 Dr. Linneman DESV de Srain Gone Wa's Diner Forude Dund Shoes 1-02-12-19 .-90-Dec-04 .an-97-Dec-04 .an-00-Dec 05 .. 20 Dec 06 31-01-Dec-09 an-00-Dec-03 01 .and-c06 en O OB -05-000 Women's Shoes Eckerd Drugstore: The second anchor tenant is a 25,000 square foot Eckerd drugstore. Eckerd has been in the center since 1980 and is paying $8 per Screens 1-2 of 10 1409 ENG IN 21:42 18-11-2021 File Tools Vien westwood publics case - Word In addition to rental payments, all leases include terms requiring tenants to pay their designated share of common area costs, which includes operating costs and all applicable insurance premiums. The landlord pays for all of these ex- penses directly and then is reimbursed by the tenants. Total CAM and insur- ance costs to the tenants totaled $540,650 in 2002, The landlord is responsible for paying property taxes for Westwood Plaza, However, each lease requires the tenants to pay their CAM share of property taxes above the level that existed when they signed the lease. Last year the property tax rate was reassessed at $1.375 per square foot. This was an in- crease of 10%. Additionally, in light of frequent tenant turnover and wear re- sulting from high customer traffic, the landlord typically holds 4% of gross rent in a replacement reserve to be used for capital expenditures. The property also generates revenue from two additional sources: a cell tower and a billboard. Each earns $2500/month and incurs no additional costs to your mother. Market: Below is an excerpt from the financials of Westwood Plaza over the last 3 years of operation. WESTWOOD PLAZA FINANCIALS 300D 2003 2001 $1,220,811 Gius Rond $1,223645 $1,45 $5970 $1,205,225 $123 545 115 51,178 SGD Vacancy Net Det CAMHR Total Revenue CAM Destande wa Real Estate Taxes Tow Operating Custo The Central Florida market where Westwood Plaza is located has experienced i tremendous growth over the last 10 years. The population of the surrounding region is rapidly growing and the city has made substantial improvements to the local infrastructure. With the burgeoning market for residential space, retail rents have enjoyed an upward trend, which your mom currently estimates at 3% -4% per year. Typical cap rates for retail space in the surrounding areas have generally been 9% to 11% (based on a few recent sales). The surrounding area is typically composed of upper-middle class residents, who have an annual median household income of $55,000. Approximately 75,000 residents occupy the area within a 5-mile radius of the strip center. Also, as is typical of Central Florida the area surrounding the local region has a disproportionate number of retirees. As a result the majority of the employment for working area residents is in the service sector. 51,035,041 $490,840 51,552,730 5514,905 5125,000 5632,905 5919,876 525,000 511.068 $40.152 5834,975 51,634 8.5 SAVUS S125.000 S615 50 51,019,429 555.000 517100 550.585 SEG 742 NO S DE 51,687 157 S:40 513750D S5/8 153 / 51.609.007 555 00 528933 548945 5575.129 Terst impreens Lessing Commissions Cape Nola ligte Issues: Screens 3-4 of 10 1409 ENG IN 21:43 16-11-2021 File Tools Vien westwood publics case - Word rate, amortized over 30 years, and contains a payment at time of closing of 1.5 points. With these proceeds she could repay (without penalty) her maturing $5 million loan including fees and points, and pocket close to $1 million. Alternatively, she has received a $7.5 million all cash offer to sell to an oppor- tunity fund. If she sells she will have to pay the applicable local fees and taxes of 3% of the sale price, as well as repay the $5 million loan. Over the past few years, things have gotten a bit complicated for Westwood Plaza. Two years ago, a new 220,000 square foot Wal-Mart super-center, com- plete with supermarket, opened just a little over 2 miles away. In addition, roughly 300,000 square feet of new retail space was constructed in the area surrounding Wal-Mart. Since that time, the Publix and Eckerd stores in the strip-center have each experienced nearly 25% drops in sales, Current sales at these stores appear to have stabilized after this initial decline. However, current sales levels are generating little profit if any to either Publix or Eckerd at the Westwood locations. Moreover, Publix has recently increased their preferred store size o a minimum of 50,000 square feet and are seeking to convert all of their locations to this model. Current market rents for retail tenants in the area are estimated to be roughly $12 per square foot. Furthermore, in the cur- rent retail market, it typically takes 3-9 months of aggressive leasing to fill va- cant space in well located strip centers. However finding larger tenants to as- sume "anchor" positions can take upwards of one year, and can involve sub- stantial effort without guaranteed results. She can alternatively refinance with a 10-year, $7.5 Million, participating non- recourse loan. The lender would receive 10% of the annual pre-tax profits, as well as receive 4% interest payments on the loan. The loan is amortized over thirty years. Financing Alternatives: When she purchased the center, your mother took out a full recourse, interest only loan for $5 million. This loan is now maturing and she is deciding what to do. As such, she has the option of either selling the plaza or refinancing the loan. Her alternatives are outlined below. Finally, she could redevelop the center and expand the Publix space in 2008 (the redevelopment must be completed before their current lease expires). This can only be accomplished by warehousing the local tenant space that ex- pires over the next 5 years and expanding Publix into this space in 2008. If this alternative is chosen, Publix has agreed to sign a lease that pays $9 per square foot from now through 2008, and $11 per square foot through 2020. The new lease would prohibit them from going dark prior to 2008. If she pursues this path she can refinance her currently maturing $5 million loan with a 5-year, $5 million non-recourse floating rate loan (interest rate reset annually), at an initial interest rate of 4.0%, with no amortization and no prepayment penalty after 1 year (Note: this reduced loan amount takes into account the lost income on the expiring local tenant space required for the expansion). Your mother estimates that the interest rate on the loan will increase by 50 basis points per year Based upon an appraised value of $10 million, a local bank has offered your mother a 5 year, non-recourse note of $6 million. The loan is at a 6% interest Screens 5-0 of 10 1409 ENG IN D 21:42 18-11-2021 File Tools View westwood publics case - Word through 2007 and stabilize thereafter. The re-development will necessitate an additional construction loan. Your mother believes that in 2005 she should be able to get a 3-year construction loan for $1.5 million at a 9% interest rate. This loan would be interest only and take effect in 2005. The prevailing ordinary income tax rate is 35%. The capital gains tax is 15%. The tax rate on accumulated depreciation is 25%. Moreover, in the current market one could reasonably expect to obtain a 10 year interest only loan at an interest rate of 6.5%. These terms could be ex- pected for financing a project with high quality credit tenants, a maximum loan to value ratio of 70%, and a debt service coverage ratio of at least 1.3. Given the nature of the site, space for the redevelopment must be made availa- ble through the warehousing of existing retail space. Once space has been warehoused it can no longer generate income to your mother. The cost of pre- paring existing retail space for the grocery store space is projected to be $100 per square foot. The actual redevelopment process will take approximately one year to finish and must be completed by 2008. All of the space for the expan- sion must be completely warehoused by the time construction commences. Your Task: Profile of Mother: For the first time in your life, your Mom has asked for your opinion. Thus, the purpose of the case is twofold. First, this is a numbers-crunching exercise de- signed to push up the learning curve in the use of real estate finance tools. Once you have completed the numbers, the second task is to grapple with what they tell you (or don't tell you) about risk and return for the property. After running all applicable numbers for the case and generating projected return fig- ures, analyze key assumptions of the case and consider various "what-if" sce- narios, testing the risk/return sensitivity of alternatives. Pool these analyses into an articulate recommendation to your mother, taking a specific position and explaining your rationale. Your mother has experience in strip retail development and possesses the ex- pertise necessary for undertaking the redevelopment option. Moreover, she has adequate income streams from other assets so she has no immediate need to liquidate her equity position in Westwood Plaza. Her other assets include another strip center in a nearby town that is both stable and profitable, as well as a substantial portfolio of moderate risk stocks and bonds. If she elects not to sell the center immediately, it can be assumed that she has an 8-year holding period after which time she will sell the center. Your recommendation should be no longer than 3 pages, single-spaced with 1" margins and font of at least 11 point. Spreadsheets for each alternative must be attached with thumbnails of your assumptions. In addition, you must have a cover page with the author name and an introductory set of bullet points sum- marizing your findings. The cover page should be no longer than one. The next General Information: Screens 7-8 of 10 1409 ENG IN 21:42 18-11-2021 File Tools Vien westwood publics case - Word 3 pages should describe the important features of your decision. Remember, you are writing to your mother who owns the place so as you draft your memo be sure not to waste text space telling her what she already knows. You should conclude with your recommendations for your mother along with your reason- ing. In addition, you may include up to 3 additional pages of exhibits, charts, figures, etc. Note that these are supplementary to the mandatory spread- sheets. This is a long assignment and ample time must be allowed. For this case, decisiveness and rational thinking will be rewarded. There is no correct answer to this case. There are some answers that are better than oth- ers, but well-articulated and supported conclusion, that outlines assumptions, but is less optimal is better than an uncertain answer that is most profitable. Current photo Screens 9-10 of 10 1409 ENG IN 21:42 18-11-2021 File Tools Vien westwood publics case - Word e Case: Westwood Publix Plaza The Property: square foot annually, with no rental increases over the life of the lease. Under Eckerd's lease, they must pay 23% of the property's total common area mainte- nance costs. The expiration date on the Eckerd lease is December 2012. They have the right to void the lease if Publix either goes dark or leaves the center. The Eckerd chain has experienced a decline in the quality of their credit, which now stands at BB.I The property in question is a 100,000 square foot strip mall "Westwood Plaza" located in a suburb in Central Florida (Tampa). The 31-year-old center is de cently located within the town. You purchased the property 8 years ago for $7,000,000 (current time/year is 2003). Based on IRS filings, 30% of the pur- chase price was attributable to land costs. There are two primary retail anchors and 11 smaller local tenants. Other Tenants: The remaining 40,000 square feet is presently fully leased and occupied by 11 smaller local tenants. Although there are no credit ratings avail- able for these tenants, it can be assumed that they are generally a significant credit risk. Your rental revenues from these tenants are based not only upon a base rent amount, but also include a percentage rent component of 1.5% of each tenant's gross sales figures (excluding the good doctor). The basic terms of the 11 local tenant's leases are as follows. Tenants: : Description Term of leave .an-01- OOT Publix Supermarket: The first anchor tenant is a 35,000 square foot Publix su- permarket which has been a tenant in the center since 1980. The Publix chain as a whole is financially solvent and has good quality credit. The terms of the Publix lease dictate that it pay $10 per square foot annually with no provisions for increase. Moreover, they are responsible for paying 29% of the property's total common area maintenance costs. They have an option to renew their lease for an additional 10 year period upon expiration of their current lease at a rental rate of $13 per square foot. Publix has the absolute right to go dark at any time. The current lease expires in December of 2009. Tenants Ross Travel AUTA Trew's News Super T Kalis by Duste Travel Agency Food Uue Store Hair Salon alon Ophthalmologist Video Real Dry Cleaners Food WESTWOOD PLAZA IN-LINE TENANT LIST Base Bear Square feet CAMALOeion Gross Sales Per 2012 2,500 2.SN 51149 5502,00 7.50 319 $11 5554.000 1,000 105 51269 SA 2.500 S1400 $410,000 2.500 2.5% . 513 68 5309,000 5.000 BA 51600 4,000 51425 5565,000 2.500 2.5% 51074 SIT 100 6,000 5.C 511 33 5545,000 7,000 515 96 5669,000 1.500 SIG G75288,000 Dr. Linneman DESV de Srain Gone Wa's Diner Forude Dund Shoes 1-02-12-19 .-90-Dec-04 .an-97-Dec-04 .an-00-Dec 05 .. 20 Dec 06 31-01-Dec-09 an-00-Dec-03 01 .and-c06 en O OB -05-000 Women's Shoes Eckerd Drugstore: The second anchor tenant is a 25,000 square foot Eckerd drugstore. Eckerd has been in the center since 1980 and is paying $8 per Screens 1-2 of 10 1409 ENG IN 21:42 18-11-2021 File Tools Vien westwood publics case - Word In addition to rental payments, all leases include terms requiring tenants to pay their designated share of common area costs, which includes operating costs and all applicable insurance premiums. The landlord pays for all of these ex- penses directly and then is reimbursed by the tenants. Total CAM and insur- ance costs to the tenants totaled $540,650 in 2002, The landlord is responsible for paying property taxes for Westwood Plaza, However, each lease requires the tenants to pay their CAM share of property taxes above the level that existed when they signed the lease. Last year the property tax rate was reassessed at $1.375 per square foot. This was an in- crease of 10%. Additionally, in light of frequent tenant turnover and wear re- sulting from high customer traffic, the landlord typically holds 4% of gross rent in a replacement reserve to be used for capital expenditures. The property also generates revenue from two additional sources: a cell tower and a billboard. Each earns $2500/month and incurs no additional costs to your mother. Market: Below is an excerpt from the financials of Westwood Plaza over the last 3 years of operation. WESTWOOD PLAZA FINANCIALS 300D 2003 2001 $1,220,811 Gius Rond $1,223645 $1,45 $5970 $1,205,225 $123 545 115 51,178 SGD Vacancy Net Det CAMHR Total Revenue CAM Destande wa Real Estate Taxes Tow Operating Custo The Central Florida market where Westwood Plaza is located has experienced i tremendous growth over the last 10 years. The population of the surrounding region is rapidly growing and the city has made substantial improvements to the local infrastructure. With the burgeoning market for residential space, retail rents have enjoyed an upward trend, which your mom currently estimates at 3% -4% per year. Typical cap rates for retail space in the surrounding areas have generally been 9% to 11% (based on a few recent sales). The surrounding area is typically composed of upper-middle class residents, who have an annual median household income of $55,000. Approximately 75,000 residents occupy the area within a 5-mile radius of the strip center. Also, as is typical of Central Florida the area surrounding the local region has a disproportionate number of retirees. As a result the majority of the employment for working area residents is in the service sector. 51,035,041 $490,840 51,552,730 5514,905 5125,000 5632,905 5919,876 525,000 511.068 $40.152 5834,975 51,634 8.5 SAVUS S125.000 S615 50 51,019,429 555.000 517100 550.585 SEG 742 NO S DE 51,687 157 S:40 513750D S5/8 153 / 51.609.007 555 00 528933 548945 5575.129 Terst impreens Lessing Commissions Cape Nola ligte Issues: Screens 3-4 of 10 1409 ENG IN 21:43 16-11-2021 File Tools Vien westwood publics case - Word rate, amortized over 30 years, and contains a payment at time of closing of 1.5 points. With these proceeds she could repay (without penalty) her maturing $5 million loan including fees and points, and pocket close to $1 million. Alternatively, she has received a $7.5 million all cash offer to sell to an oppor- tunity fund. If she sells she will have to pay the applicable local fees and taxes of 3% of the sale price, as well as repay the $5 million loan. Over the past few years, things have gotten a bit complicated for Westwood Plaza. Two years ago, a new 220,000 square foot Wal-Mart super-center, com- plete with supermarket, opened just a little over 2 miles away. In addition, roughly 300,000 square feet of new retail space was constructed in the area surrounding Wal-Mart. Since that time, the Publix and Eckerd stores in the strip-center have each experienced nearly 25% drops in sales, Current sales at these stores appear to have stabilized after this initial decline. However, current sales levels are generating little profit if any to either Publix or Eckerd at the Westwood locations. Moreover, Publix has recently increased their preferred store size o a minimum of 50,000 square feet and are seeking to convert all of their locations to this model. Current market rents for retail tenants in the area are estimated to be roughly $12 per square foot. Furthermore, in the cur- rent retail market, it typically takes 3-9 months of aggressive leasing to fill va- cant space in well located strip centers. However finding larger tenants to as- sume "anchor" positions can take upwards of one year, and can involve sub- stantial effort without guaranteed results. She can alternatively refinance with a 10-year, $7.5 Million, participating non- recourse loan. The lender would receive 10% of the annual pre-tax profits, as well as receive 4% interest payments on the loan. The loan is amortized over thirty years. Financing Alternatives: When she purchased the center, your mother took out a full recourse, interest only loan for $5 million. This loan is now maturing and she is deciding what to do. As such, she has the option of either selling the plaza or refinancing the loan. Her alternatives are outlined below. Finally, she could redevelop the center and expand the Publix space in 2008 (the redevelopment must be completed before their current lease expires). This can only be accomplished by warehousing the local tenant space that ex- pires over the next 5 years and expanding Publix into this space in 2008. If this alternative is chosen, Publix has agreed to sign a lease that pays $9 per square foot from now through 2008, and $11 per square foot through 2020. The new lease would prohibit them from going dark prior to 2008. If she pursues this path she can refinance her currently maturing $5 million loan with a 5-year, $5 million non-recourse floating rate loan (interest rate reset annually), at an initial interest rate of 4.0%, with no amortization and no prepayment penalty after 1 year (Note: this reduced loan amount takes into account the lost income on the expiring local tenant space required for the expansion). Your mother estimates that the interest rate on the loan will increase by 50 basis points per year Based upon an appraised value of $10 million, a local bank has offered your mother a 5 year, non-recourse note of $6 million. The loan is at a 6% interest Screens 5-0 of 10 1409 ENG IN D 21:42 18-11-2021 File Tools View westwood publics case - Word through 2007 and stabilize thereafter. The re-development will necessitate an additional construction loan. Your mother believes that in 2005 she should be able to get a 3-year construction loan for $1.5 million at a 9% interest rate. This loan would be interest only and take effect in 2005. The prevailing ordinary income tax rate is 35%. The capital gains tax is 15%. The tax rate on accumulated depreciation is 25%. Moreover, in the current market one could reasonably expect to obtain a 10 year interest only loan at an interest rate of 6.5%. These terms could be ex- pected for financing a project with high quality credit tenants, a maximum loan to value ratio of 70%, and a debt service coverage ratio of at least 1.3. Given the nature of the site, space for the redevelopment must be made availa- ble through the warehousing of existing retail space. Once space has been warehoused it can no longer generate income to your mother. The cost of pre- paring existing retail space for the grocery store space is projected to be $100 per square foot. The actual redevelopment process will take approximately one year to finish and must be completed by 2008. All of the space for the expan- sion must be completely warehoused by the time construction commences. Your Task: Profile of Mother: For the first time in your life, your Mom has asked for your opinion. Thus, the purpose of the case is twofold. First, this is a numbers-crunching exercise de- signed to push up the learning curve in the use of real estate finance tools. Once you have completed the numbers, the second task is to grapple with what they tell you (or don't tell you) about risk and return for the property. After running all applicable numbers for the case and generating projected return fig- ures, analyze key assumptions of the case and consider various "what-if" sce- narios, testing the risk/return sensitivity of alternatives. Pool these analyses into an articulate recommendation to your mother, taking a specific position and explaining your rationale. Your mother has experience in strip retail development and possesses the ex- pertise necessary for undertaking the redevelopment option. Moreover, she has adequate income streams from other assets so she has no immediate need to liquidate her equity position in Westwood Plaza. Her other assets include another strip center in a nearby town that is both stable and profitable, as well as a substantial portfolio of moderate risk stocks and bonds. If she elects not to sell the center immediately, it can be assumed that she has an 8-year holding period after which time she will sell the center. Your recommendation should be no longer than 3 pages, single-spaced with 1" margins and font of at least 11 point. Spreadsheets for each alternative must be attached with thumbnails of your assumptions. In addition, you must have a cover page with the author name and an introductory set of bullet points sum- marizing your findings. The cover page should be no longer than one. The next General Information: Screens 7-8 of 10 1409 ENG IN 21:42 18-11-2021 File Tools Vien westwood publics case - Word 3 pages should describe the important features of your decision. Remember, you are writing to your mother who owns the place so as you draft your memo be sure not to waste text space telling her what she already knows. You should conclude with your recommendations for your mother along with your reason- ing. In addition, you may include up to 3 additional pages of exhibits, charts, figures, etc. Note that these are supplementary to the mandatory spread- sheets. This is a long assignment and ample time must be allowed. For this case, decisiveness and rational thinking will be rewarded. There is no correct answer to this case. There are some answers that are better than oth- ers, but well-articulated and supported conclusion, that outlines assumptions, but is less optimal is better than an uncertain answer that is most profitable. Current photo Screens 9-10 of 10 1409 ENG IN 21:42 18-11-2021