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 $572, $622, and $822, 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 $32 per unit and remain at those levels for the remainder of the year. Ten studios were leased three months ago for $522, 20 one-bedroom units were leased two months ago for $602, and 10 two-bedroom units were leased last month for $827. All other units have been leased recently at current rents. All of the previously leased units also are on 12-month leases that do not face the $32 rate increase after the first 6 months. 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 $255,000. Autumn Seasons expect to pay total turnover and operating expenses of $422 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 $122 per month, per occupied unit. During the next year, it is also anticipated that $155,000 will be required for recurring, make-ready expenses (carpet, paint, drywall repair, etc.), and another $305,000 will be required as an allowance for nonrecurring items including parking lot repairs, and so on. A total of $32,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?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

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 $572, $622, and $822, 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 $32 per unit and remain at those levels for the remainder of the year. Ten studios were leased three months ago for $522, 20 one-bedroom units were leased two months ago for $602, and 10 two-bedroom units were leased last month for $827. All other units have been leased recently at current rents. All of the previously leased units also are on 12-month leases that do not face the $32 rate increase after the first 6 months. 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 $255,000. Autumn Seasons expect to pay total turnover and operating expenses of $422 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 $122 per month, per occupied unit. During the next year, it is also anticipated that $155,000 will be required for recurring, make-ready expenses (carpet, paint, drywall repair, etc.), and another $305,000 will be required as an allowance for nonrecurring items including parking lot repairs, and so on. A total of $32,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?

The image shows a form for preparing a statement of operating cash flow (NOI) for the coming year. The form includes the following items to be filled:

1. **Gross potential income (A):** 
   - Input field provided for the amount.

2. **Loss to lease (B):** 
   - Input field provided for the amount.

3. **Vacancy & collection loss (C):**
   - Input field provided for the amount.

4. **Net rental income:**
   - Calculated field, currently showing 0.

5. **Recoveries (D):**
   - Input field provided for the amount.

6. **Other income:**
   - Input field provided for the amount, currently showing 0.

7. **Total income:**
   - Calculated field for total income, currently showing 0.

8. **Operating expenses (E):**
   - Input field provided for the amount.

9. **NOI (Net Operating Income):**
   - Calculated field, currently showing $0.

The form includes navigation buttons labeled "Required A" and "Required B," with "Required B" being currently selected. This form is likely part of an interactive exercise or financial analysis tool on an educational website.
Transcribed Image Text:The image shows a form for preparing a statement of operating cash flow (NOI) for the coming year. The form includes the following items to be filled: 1. **Gross potential income (A):** - Input field provided for the amount. 2. **Loss to lease (B):** - Input field provided for the amount. 3. **Vacancy & collection loss (C):** - Input field provided for the amount. 4. **Net rental income:** - Calculated field, currently showing 0. 5. **Recoveries (D):** - Input field provided for the amount. 6. **Other income:** - Input field provided for the amount, currently showing 0. 7. **Total income:** - Calculated field for total income, currently showing 0. 8. **Operating expenses (E):** - Input field provided for the amount. 9. **NOI (Net Operating Income):** - Calculated field, currently showing $0. The form includes navigation buttons labeled "Required A" and "Required B," with "Required B" being currently selected. This form is likely part of an interactive exercise or financial analysis tool on an educational website.
**Required A:**

Add to the (a) anticipated outlays for nonrecurring items and commissions. What will be net cash flow for the coming year?

*Net Cash Flow:* [Input Field]

**Navigation Buttons:**
- < Required A
- Required B >

This section is part of an educational module that prompts users to input calculations related to net cash flow, taking into account anticipated expenses. It is designed to guide learners through a series of financial planning exercises, with interactive input fields and navigation buttons to facilitate movement between sections. There are no graphs or diagrams present.
Transcribed Image Text:**Required A:** Add to the (a) anticipated outlays for nonrecurring items and commissions. What will be net cash flow for the coming year? *Net Cash Flow:* [Input Field] **Navigation Buttons:** - < Required A - Required B > This section is part of an educational module that prompts users to input calculations related to net cash flow, taking into account anticipated expenses. It is designed to guide learners through a series of financial planning exercises, with interactive input fields and navigation buttons to facilitate movement between sections. There are no graphs or diagrams present.
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Analytical Techniques
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education