2. Accounting Systems Flashcards
The purpose of Accounting Systems:
• To make projections about the property’s performance, both short term and long term (see
Analysis of Income and Expenses below)
• To keep track of the property’s actual performance compared to budget (see Reports and Records
below)
• To prepare for building system’s improvements or replacement (see Capital Expenditures and
Escrow Accounts below)
• To understand fully the rental obligations of each tenant as described in their lease (see Lease
Administration below)
• To insure that the funds collected from the tenants are handled properly (see Fiscal
Responsibilities below)
• To assist in creating value for the owner through effective and efficient fiscal management (see
Asset Management below)
The purpose of the Budget is to:
develop a means to both track the property’s performance and to organize the various types of income (such as rent, miscellaneous income, etc.) and expenses (such as utilities, insurance, payroll, etc.) in a meaningful way.
The maximum amount of income that a property can generate from all sources. It represents the total potential income from all units or spaces being fully occupied and all amounts owed by the residents/tenants being collected in full.
Gross Potential Rental Income
In certain types of leases, particularly commercial leases, tenants can also be billed for some or all of the property’s operating expenses, real estate taxes and insurance. This income source is commonly referred to as:
Pass-Through Income, Expense Reimbursements or Recoveries
Since vacant spaces do not produce any income and sometimes residents/tenants do not pay for all of their lease obligations, actual income can be less than the Gross Potential Rental Income
Vacancy and Credit Loss
Income collected from all other sources including income from coin-operated laundry equipment, vending machines, pay phones, and late fees, etc. is commonly referred to as:
Miscellaneous Income
Calculation for Effective Gross Income
Gross Potential Rental Income \+ Expense Reimbursements - Vacancy and Credit Loss \+ Miscellaneous Income \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
If an apartment building has twenty 1 bedroom units which rent for $800 per month and thirty 2 bedroom apartments which rent for $1500 per month, what is the Gross Potential Rental Income per month and per year?
Gross Potential Rental Income per month calculation
($800 x 20) + ($1500 x 30) = $61,000 per month
Gross Potential Rental Income per year calculation
$61,000 x 12 = $732,000 per year
If the Gross Potential Rental Income is $800,000, the Expense Reimbursements are $100,000, the Vacancy and Credit Loss is 10% of the Gross Potential Rental Income and Miscellaneous Income is $25,000, what is the property’s Effective Gross Income?
Gross Potential Rental Income $800,000 \+ Expense Reimbursements + $100,000 - Vacancy and Credit Loss - ($800,000 x 0.1) \+ Miscellaneous Income + $ 25,000 = Effective Gross Income = $845,000
In a 150,000 SF commercial building, the rental rates are $20/SF and it is 5% vacant. What is the property’s Effective Gross Income?
Gross Potential Rental Income calculation
150,000SF x $20/SF = $3,000,000.
Vacancy Loss Calculation
$3,000,000 x 5% = $150,000.
Effective Gross Income Calculation
$3,000,000 - $150,000 = $2,850,000
These are all examples of what:
Utilities, Repairs & Maintenance, Grounds Maintenance, Snow removal, Trash removal, Janitorial, Real Estate Taxes, Insurance, Management Fees, Administration and Payroll
Operating Expenses
If a commercial property is 100,000 SF and its annual electricity costs are $225,000, what is the electricity cost per
square foot?
$225,000/100,000 = $2.25/SF
Building A is 75,000 sf. Its Operating Expenses are $180,000 for electricity, $30,000 for repairs & maintenance
and $150,000 for real estate taxes.
Building B is 200,000 sf. Its Operating Expenses are $400,000 for electricity, $55,000 for repairs & maintenance
and $400,000 for real estate taxes.
Which building has lower Operating Expenses per square foot?
Building A Annual Cost Cost per Square Foot Electricity $180,000 $2.40 Repair & maintenance $30,000 $0.40 Real Estate Taxes $150,000 $2.00 Total $360,000 $4.80
Building B Annual Cost Cost per Square Foot Electricity $400,000 $2.00 Repair & maintenance $55,000 $0.28 Real Estate Taxes $400,000 $2.00 Total $855,000 $4.28
A 200,000 square foot property, with an Effective Gross Income of $4,000,000, has the following expenses per year: Landscaping $50,000 Snow removal $10,000 Trash Removal $5,500 Insurance $0.05/sf Real Estate Taxes $210,000 Management Fee 3% of Effective Gross Income
What are the total annual Operating Expenses and what is the cost per square foot of each individual expense?
Insurance Cost Calculation
200,000 sf x $0.05/sf = $10,000
Management Fee Calculation
$4,000,000 x 3% = $120,000
Landscaping $50,000 $0.25 Snow Removal $10,000 $0.05 Trash Removal $5,500 $0.0275 Insurance $10,000 $0.05 Real Estate Taxes $210,000 $1.05 Management Fee $120,000 $0.60 Totals $405,000 $2.0275
It represents the money that remains after Operating Expenses are subtracted from Effective Gross Income.
Net Operating Income (NOI)
An apartment building as three studio units that rent for $1000 per month, six 1 bedroom units that rent for $1400 per month, and three 2 bedroom units that rent for $2000 per month. For next year’s budget, the property manager is projecting to have 1 studio vacant for 6 months and operating expense are forecast to $125,000.
What is the projected Net Operating Income for the budget?
First calculate the Gross Potential Rental Income per year:
$1000 x 3 units x 12 months = $36,000
$1400 x 6 units x 12 months = $100,800
$2000 x 3 units x 12 months = $72,000
Gross Potential Rental Income = $36,000 + $100,800 + $72,000 = $208,800 per year
Then calculate the Vacancy Loss
$1000 x 1 unit x 6 months = $6,000
Vacancy Loss = $6,000
Gross Potential Rent $208,800 - Vacancy Loss $ 6,000 = Net Effective Rent $202,800 - Operating Expenses $125,000 = Net Operating Income $ 77,800
Since most properties generally are acquired with a mortgage, the ______ ______ also must be accounted for. _____ _______ includes both the interest and principal reduction and is subtracted from Net Operating Income.
Debt Service