Essay about real estate finance analysis sheet

Submitted By nit737
Words: 483
Pages: 2
Open Document
Income and Expense Pro Forma
# of Units
Rental Income
Vacancy & Credit Loss
Effective Gross income

Rent
4 $

Operating Expenses
Maintenance & Repairs:
Insurance:
Property Taxes:
Property Mgmt Fee:
Total Expenses
Net Operating Income:
Forecasted Annual Rent Increases
Forecasted Annual OE Increases
Vacancy Factor

Year 1
1,325 $
63,600
$ 3,180.0
$ 60,420.0

$
$
$
$
$
$

4,550
3,975
11,375
5,520
25,420
35,000

3.5%
3.5%
5.0%

After-Tax Cash Flows from Operations
Gross Potential Income
Vacancy & Credit Loss
Effective Gross income
Operating Expenses
Net Operating Income:
Debt Service:
Before Tax Cash Flow:
- Income Tax
After Tax Cash Flow

Year 1
$
63,600
$
3,180
$
60,420
$
25,420
$
35,000
$
19,002
$
15,998
$
3,598
$
12,400

Year 2
$
65,826
$
3,291
$
62,535
$
26,310
$
36,225
$
19,002
$
17,223
$
3,897
$
13,326

Year 3
$ 68,130
$
3,406
$ 64,723
$ 27,231
$ 37,493
$ 19,002
$ 18,491
$
4,337
$ 14,154

NPV/IRR Cash Flow Analysis
EOY

Initial
Investment
ATCF
0 $
(100,000)
1
$
2
$
3
$
4
$
5
$

Discount Rate:

Net Sales
Proceeds
12,400
13,326
14,154
15,011
15,772

Total Annual
CF
$ (100,000)
$
12,400
$
13,326
$
14,154
$
15,011
$ 185,124 $ 200,895
NPV
$67,912.55
IRR
12.99%

Present
Value
$ (100,000)
$ 11,273
$ 11,013
$ 10,634
$ 10,253
$ 124,740

10%

Supporting Exhibits
Mortgage Data
Purchase Price:
Loan to Value:
Initial Mortgage Balance:

Initial
Year 1
Year 2
Year 3
Year 4
$
400,000
75%
$
300,000
$292,868
$285,446
$277,721
$269,681

Interest Rate
Term (years):
Monthly Debt Service:
Annual Debt Service:
Interest:
Principal:
Tax Calculations
Net Operating Income:
- Interest Expense:
- Cost Recovery Allowance:
Taxable Income:
Ordinary Tax Rate
Income Tax:

$
$

4%
25
(1,584)
(19,002)
$
$

Year 1
$
$
$
$
$

35,000
11,870
10,280
12,850
28%
3,598

Depreciation
Purchase Price:
% of Value attributable to Improvements:
$ Depreciable Value of Improvements:
$ of Value attributable to Land:
Depreciable period in years
Depreciation per annum:
*Cost Recovery Allowance Year One:

After Tax Equity Reversion
Gross Selling Price:
- Selling Expenses:
Net Selling Price:
Mortgage Payoff:
Before Tax Equity Reversion
Capital Gains Tax
Depreciation Recapture Tax:
After Tax Equity Reversion:

Year 2
$
36,225
$
11,580
$
10,727
$
13,918
28%
$
3,897

$

$
$

455,000
64.84%
295,000
160,000
27.5
10,727
Show More

Related Documents: Essay about real estate finance analysis sheet

Staff Accounting

verifying, computing and classifying financial data from property and real estate transactions. Senior staff works closely with property managers or real estate developers to maintain tenant relations and accurate tenant ledgers, which requires them to update monthly bills and lease information. They also reconcile property charges, verify commission calculations and perform monthly account reviews and analyses. Real estate property staff accountants verify cash receipts, account postings and mortgages…

Words 505 - Pages 3

Why I Want To Be A Mentee

position. This past summer, I was an Investment Associate at FRB Realty Capital. FRB is an integrated financial intermediary and advisory firm specializing in structuring balance sheet…

Words 624 - Pages 3

Macys Swot Analysis

department store has an annual Macy’s Thanksgiving Parade in New York City since 1924. As of beginning of 2017, Macy’s has cut more than 1,000 jobs and closed around 70 stores due to their decrease in store sales. Environmental Analysis/SWOT In terms of Macy’s SWOT analysis, Macy's has many strengths. Being one of the largest chain retailer worldwide, a solid market share and an excellent brand name recognition. Another strength is that the company has a high variety of merchandise and ships products…

Words 1877 - Pages 8

Final Paper Peterson

MILLICAN COUNTRY CLUB Table of Contents Executive Summary (Pg. 3) Who We Are (Pg. 5) Property Description (Pg. 6) Product Development (Pg. 9) Market Analysis (Pg. 16) Marketing Strategy (Pg. 21) Financial Analysis (Pg. 23) Executive Summary Millican Reserve is a proposed 2,489 acre master development south of College Station that will encompass everything from residential to institutional developments. Our goal is to provide Millican Reserve with Millican Country Club, a focal point for the…

Words 2399 - Pages 10

Essay about Financial Analysis of Walgreens vs. Cvs

Executive Summary The initial intent of this analysis was to identify changes in accounting methods within the financial statements of Walgreens and CVS, as well as to compare and contrast their financial statements, in order to draw conclusions about which company had better earnings. However, in the process of this analysis, with the exception of a minor change to lease accounting by Walgreens, there were no major changes in accounting methods identified. In examining the financial statements…

Words 7290 - Pages 30

Essay on Walgreen Versus Cvs

Executive Summary The initial intent of this analysis was to identify changes in accounting methods within the financial statements of Walgreens and CVS Caremark, as well as to compare and contrast their financial statements, in order to draw conclusions about which company had also have better earnings. However, in the process of this analysis, with the exception of a minor change to lease accounting by Walgreens, there were no major changes in accounting methods identified. In examining the financial…

Words 6558 - Pages 27

What Are The Importance Of Accounting Theory

A balance sheet is often described as a "snapshot" of the company's financial condition on a given date. Of the four basic financial statements, the balance sheet is the only statement which applies to a single point in time, instead of a period of time. A simple business operating entirely in cash could measure its profits by simply withdrawing the entire bank balance at the end of the period, plus any cash in hand. However, real businesses are not paid immediately; they…

Words 1882 - Pages 8

Alliance Concrete Essay

Alliance Concrete Case Analysis Executive Summary: This report provides an analysis and evaluation of the current and forecasted profitability, liquidity and financial stability of Alliance Concrete. Methods of analysis include forecasting the income statement and balance sheet to calculate financial ratios and profitability ratios. The key drivers for the income statement was management’s assumption about the sales environment surrounding Alliance Concrete. All calculations can be found on the…

Words 1309 - Pages 6

Final Final Essay

investment firm, which was forced to file for bankruptcy protection on September 2002. It was the largest investment bank to collapse since 1990, and based on assets, Lehman also far surpasses WorldCom as the largest U.S. bankruptcy ever. In order to analysis this company, we selected the mission statement of Lehman Brothers: “Our mission is to build unrivaled partnerships with and value for our clients, through the knowledge, creativity, and dedication of our people, leading to superior results for…

Words 4503 - Pages 19

FIN 303 analysis paper

Finance Analysis Paper Yahoo! Finance Yahoo! Finance is a service from Yahoo that provides financial information in various ways including stock quotes, corporate press releases, financial reports, stock exchange rates as well as popular message boards for discussing a company's forecasts and stock valuations. It holds the title for the top financial news and research website in the United States, with an astounding 23 million visitors in February 2010. It also offers tools for personal finance…

Words 2311 - Pages 10