Question: please help with this question below, thanks! I know you can do it!!! please help me out Revenues Note: The format for all answers do

please help with this question below, thanks! I know you can do it!!! please help me outplease help with this question below, thanks! I know you can doit!!! please help me out Revenues Note: The format for all answersdo not include $ signs or decimals, but do include commas. Forexample: $1234.00 (incorrect) 1,234 (correct) 313,916 Total Revenue Expenses Question 4 0/Net Operating Income Question 5 0 / Net Income About Crimson CougarSenior Living: Crimson Cougar senior living is a senior living community locatedin your favorite town. It has a total of 80 apartments, offeringboth assisted living and memory care services. Residents of the Crimson Cougar

Revenues Note: The format for all answers do not include $ signs or decimals, but do include commas. For example: $1234.00 (incorrect) 1,234 (correct) 313,916 Total Revenue Expenses Question 4 0/ Net Operating Income Question 5 0 / Net Income About Crimson Cougar Senior Living: Crimson Cougar senior living is a senior living community located in your favorite town. It has a total of 80 apartments, offering both assisted living and memory care services. Residents of the Crimson Cougar receive three meals a day, weekly housekeeping, scheduled transportation and a wide variety of activities included in their base monthly rent. In addition to the monthly rent, residents pay a fee for the care they receive. This fee is based on the type of services and amount of support they need each month. Key information about the Crimson Cougar is included below. This information is important for calculating and understanding the financial performance of the community. Community Information Number of Apartments Monthly Move-Ins 2 Assisted Living 60 Memory Care 20 Monthly Move-Outs 2 Current Occupancy Assisted Living 90% Memory Care 90% Revenue Information Average Rent (Base) Average Care (Per Resident/Mo) Assisted Living $ 3,500 Assisted Living $ 840 Memory Care $ 4,392 Memory Care $ 1,000 Other Revenue Concessions & Discounts Community Fee $ 3,000 per move-in Rent Discounts $ 5,000 per month Other Ancillary* $ 4,500 per month Concessions $ 3,000 per move-in *Ancillary revenues include guest meals, salon lease, second occupancy fees, and fees for special events *Ancillary revenues include guest meals, salon lease, second occupancy fees, and fees for special events Expense Information Monthly Operating Expenses Other Expenses Labor $ 140,363 Interest Expense 11,000 Other $ 77,330 Management Fee 5% of Revenue about Occupied Apts 54 18 72 = Rental Revenue 189,000 79,056 268,056 imson cougar Senior Living Into the Green Cens 1. Calculate Occupied Apartments % Occupancy Total Apts Assisted Living 90% 60 Memory Care 90% 20 Total Occupied Apartments 2. Calculate Monthly Rental Revenue Rent/Apt Occ Apts Assisted Living 3,500 54 Memory Care 4,392 18 Total Rental Revenue 3. Calculate Monthly Care Fees Care Fees/Apt Occ Apts Assisted Living 840 54 Memory Care 1,000 18 Total Care Fees 4. Calculate Ancillary Revenue Fee per MI # of MIS Community Fee 3,000 0 Other Ancillary Total Ancillary Revenue 5. Calculate Revenue Adjustments (these are subtracted from all other revenue) Per MI # of Mis Concessions 3,000 2 Rent Discounts Total Revenue Adjustments Rental Revenue 45,360 18,000 63,360 Total Comm Fee 4,500 4,500 = Total Concessions 6,000 5,000 11,000 lal Neve lue Hujus 5. Calculate Gross Revenue Total Rental Revenue Total Care Fees Total Ancillary Revenue Total Adjustments Total Revenue + + 268,056 63,360 4,500 11,000 324,916 Crimson Cougar Community Simplified Income Statement (Using the Information About Crimson Cougar Senior Living, Complete the following Income Statement) Revenues Less Adjustments Total Revenue Less Expenses Net Operating Income (NOI) Less Interest, Taxes, Depreciation, Amortization, Rent Net Income

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!