Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedYou 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 $578, $628, and $828, 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 $38 per unit and remain at those levels for the remainder of the year. Ten studios were leased three months ago for $528, 20 one-bedroom units were leased two months ago for $608, and 10 two-bedroom units were leased last month for $833. 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 $38 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 $270,000. Autumn Seasons expect to pay total turnover and operating expenses of $428 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 $128 per month, per occupied unit. During the next year, it is also anticipated that $170,000 will be required for recurring, make-ready expenses (carpet, paint, drywall repair, etc.), and another $320,000 will be required as an allowance for nonrecurring items including parking lot repairs, and so on. A total of $38,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 belov 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 0 Recoveries (D) Other income 0 Total income 0 Operating expenses (E) NOI 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 Add to the (a) anticipated outlays for nonrecurring items and commissions. What will be net cash flow for the coming year? Net cash flow Complete this question by entering your answers in the tabs belov 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 0 Recoveries (D) Other income 0 Total income 0 Operating expenses (E) NOI 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 Add to the (a) anticipated outlays for nonrecurring items and commissions. What will be net cash flow for the coming year? Net cash flow

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Digital Business And Electronic Commerce

Authors: Bernd W Wirtz

1st Edition

3030634817, 9783030634810

More Books

Students also viewed these Finance questions

Question

What is cultural tourism and why is it growing?

Answered: 1 week ago