You have been asked to develop a pro forma statement of cash flow for the coming...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have been asked to develop a pro forma statement of cash flow for the coming year for Autumn Seasons, a 200-unit suburban garden apartment community. This community has a mix of 40 studio, 80 one-, and 80 two-bedroom apartments with current monthly rents of $550, $600, and $800, respectively. Leases with tenants are usually made for 12-month periods. Current rents are expected to remain fixed for the next six months. After that time, monthly rents for each apartment type should increase by $10 per unit and remain at those levels for the remainder of the year. Ten studios were leased three months ago for $500, 20 one-bedroom units were leased two months ago for $580, and 10 two-bedroom units were leased last month for $805. All other units have been leased recently at current rents. All of the previously leased units also are on 12-month leases. When those leases roll over, all are expected to be renewed at market rents upon rollover for an additional 12 months. Presently, 4 studios, 6 one-, and 6 two-bedroom units are vacant. This vacancy pattern should remain the same for the remainder of the year. Autumn Seasons anticipates that during the coming year, it will earn other income from laundry facilities, the awarding of an exclusive cable TV contract, parking, plus fees from net deposits, late fees, and so on of $200,000. Autumn Seasons expect to pay total turnover and operating expenses of $400 per month, per occupied unit during the next year. However, it expects to recover some of these expenses for heating and central cooling that it provides to tenants in an amount totaling $100 per month, per occupied unit. During the next year, it is also anticipated that $100,000 will be required for recurring, make-ready expenses (carpet, paint, drywall repair, etc.), and another $250,000 will be required as an allowance for nonrecurring items including parking lot repairs, and so on. A total of $10,000 in fees will be paid to Apartment Locator Services, a company that provides marketing services and finds new tenants for Autumn. Required: a. Prepare a statement of operating cash flow (NOI) for the coming year. b. Add to the (a) anticipated outlays for nonrecurring items and commissions. What will be net cash flow for the coming year? Complete this question by entering your answers in the tabs below. Required A Required B Prepare a statement of operating cash flow (NOI) for the coming year. Gross potential income (A) Loss to lease (B) Vacancy & collection loss (C) Net rental income Recoveries (D) Other income Total Income Operating expenses (E) NOI You have been asked to develop a pro forma statement of cash flow for the coming year for Autumn Seasons, a 200-unit suburban garden apartment community. This community has a mix of 40 studio, 80 one-, and 80 two-bedroom apartments with current monthly rents of $550, $600, and $800, respectively. Leases with tenants are usually made for 12-month periods. Current rents are expected to remain fixed for the next six months. After that time, monthly rents for each apartment type should increase by $10 per unit and remain at those levels for the remainder of the year. Ten studios were leased three months ago for $500, 20 one-bedroom units were leased two months ago for $580, and 10 two-bedroom units were leased last month for $805. All other units have been leased recently at current rents. All of the previously leased units also are on 12-month leases. When those leases roll over, all are expected to be renewed at market rents upon rollover for an additional 12 months. Presently, 4 studios, 6 one-, and 6 two-bedroom units are vacant. This vacancy pattern should remain the same for the remainder of the year. Autumn Seasons anticipates that during the coming year, it will earn other income from laundry facilities, the awarding of an exclusive cable TV contract, parking, plus fees from net deposits, late fees, and so on of $200,000. Autumn Seasons expect to pay total turnover and operating expenses of $400 per month, per occupied unit during the next year. However, it expects to recover some of these expenses for heating and central cooling that it provides to tenants in an amount totaling $100 per month, per occupied unit. During the next year, it is also anticipated that $100,000 will be required for recurring, make-ready expenses (carpet, paint, drywall repair, etc.), and another $250,000 will be required as an allowance for nonrecurring items including parking lot repairs, and so on. A total of $10,000 in fees will be paid to Apartment Locator Services, a company that provides marketing services and finds new tenants for Autumn. Required: a. Prepare a statement of operating cash flow (NOI) for the coming year. b. Add to the (a) anticipated outlays for nonrecurring items and commissions. What will be net cash flow for the coming year? Complete this question by entering your answers in the tabs below. Required A Required B Prepare a statement of operating cash flow (NOI) for the coming year. Gross potential income (A) Loss to lease (B) Vacancy & collection loss (C) Net rental income Recoveries (D) Other income Total Income Operating expenses (E) NOI
Expert Answer:
Answer rating: 100% (QA)
a Statement of Operating Cash Flow NOI for the Coming Year 1 Gross Potential Income A To calculate the gross potential income we need to account for the rents for the first six months and the increase... View the full answer
Posted Date:
Students also viewed these abstract writing questions
-
Data Set 14 in Appendix B lists highway fuel consumption amounts (mi/gal) for cars categorized by size (small, midsize, large). If we use those highway fuel consumption amounts arranged into the...
-
Rick has a $50,000 basis in the RKS General Partnership on January 1 of the current year, and he owns no other investments. He has a 20% capital interest, a 30% profits interest, and a 40% loss...
-
The monthly rate of return on T-bills is 1%. The market went up this month by 1.5%. In addition, AmbChaser, Inc., which has an equity beta of 2, surprisingly just won a lawsuit that awards it $1...
-
A crossflow extraction system is being used to extract furfural from water into methyl-isobutyl ketone (MIBK) at \(25^{\circ} \mathrm{C}\). The \(9000 \mathrm{~kg} / \mathrm{h}\) of aqueous feed...
-
The Clear View Golf & Country Club details the following accounts in its financial statements. Instructions (a) Classify each of the above accounts as an asset (A), liability (L), stockholders equity...
-
Anima needs to take out a loan to buy a computer that costs $2,375. Friendly Bank can give her the loan at 12% pa interest rate compounded monthly. If she borrows the funds from the Bank and pay $100...
-
The benefit of job specialization is that it improves work efficiency. That said, what are some of the drawbacks to subdividing a job into separate jobs among several people? Use an example from your...
-
A real-life roller coaster has 650 kJ of kinetic energy at the bottom of the first hill, but instead you measure the kinetic energy at 429 kJ. What is the efficiency of the roller coaster? Show MATH,...
-
Assume you borrowed $19,600 to buy a car. The terms of the loan call for monthly payments for five years at an interest rate of 6.25 percent, compounded monthly. What is the amount of each payment?
-
Unicorn Limited manufactures a single product - Magic Pod.' The following information relating to 'Magic Pod' for the month of January: Direct materials Direct labour Overheads Output completed in...
-
What is the approximate change in value of a $1,000 bond when interest rates increase by 1.25% and the duration of the bond is 11 years and the YTM is 3%?
-
How much work is required to stop an electron (m = 9.11 x 10-31 kg) which is moving with a speed of 1.10x106 m/s ? Express your answer to three significant figures and include the appropriate units....
-
Blue Violet is a Rock band planning a tour around the US for the 2024-2025 season. Their option in New Jersey is to make two presentations at the Prudential Center in Newark. Prudential Center is...
-
What is master production scheduling and how is it done?
-
Total revenue for a perfectly competitive firm equals the _________ times the _________.
-
If perfectly competitive producers are currently making economic profits, the market supply curve will shift to the right over time as more firms _________ and existing firms _________.
-
As entry into a profitable industry pushes down the market price, producers will move from a situation where price _________ average total cost to one where price _________ average total cost.
Study smarter with the SolutionInn App