APPENDIX C

EXCEL FORMULAS: SIMPLIFYING THE CALCULATIONS

Accelerated Depreciation

A1:

basis of asset

B1:

period (in years)

C1:

acceleration percentage

D1:

=SUM(A1/B1)*C1

Accumulated Value of 1

A1:

principal amount

A2:

interest rate

A3:

number of periods per year

A4:

number of years

B4:

=FV(r/n,1*r,,-1000)

Accumulated Value of 1 per Period

FV(r/n,y*d)

where:

r

= interest rate

n

= number of periods per year

y

= number of years

d

= amount of periodic deposits

Adjusted Basis in Property

A1:

purchase price

B1:

closing costs

C1:

deferred gain

D1:

= SUM(A1+B1-C1)

Adjusted Purchase Price

A1:

purchase price

B1:

closing costs

C1:

=SUM(A1+B1)

Adjusted Sales Price

A1:

sales price ...

Get The Real Estate Investor's Pocket Calculator, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.