(12C Platinum) Property Value by Income and Reversion Method - Printable Version +- HP Forums (https://www.hpmuseum.org/forum) +-- Forum: HP Software Libraries (/forum-10.html) +--- Forum: General Software Library (/forum-13.html) +--- Thread: (12C Platinum) Property Value by Income and Reversion Method (/thread-19739.html) |
(12C Platinum) Property Value by Income and Reversion Method - Eddie W. Shore - 03-29-2023 12:51 PM Source: California Board of Equalization "Lesson 4 - Time Value of Money (The Income Approach to Value)" California State Board of Equalization. Accessed March 27, 2023. https://www.boe.ca.gov/info/iav/lesson4.htm "Lesson 18 - Property Reversion: Annuity plus Reversion Method (The Income Approach to Value" California State Board of Equalization. Accessed March 27, 2023. https://www.boe.ca.gov/info/iav/lesson18.htm One way to calculate the value of property is by its income and reversion value. In this case, the income is the estimated annual net income before taxes which is assumed to be "paid out" at the end of each year. This income stream is sometimes known as an Inwood annuity cash flow. The reversion value of a property is its future value based on factors like inflation, anticipated selling price at the end of the project, and the current market value. The economic life of the property is not necessarily the remaining physical life of the property. In a time value of money timeline, the reversion value would be received at the end of the project. Calculating the value of the property using this income method uses three steps, as illustrated by the Board of Equalization (see the Source section below): 1. Calculate the value of the income stream, called the net income before taxes (NBIT): PV_income = NBIT ÷ (SFF + yield% + tax_rate%) where: SFF = yield% ÷ ((1 + yield%)^n - 1) yield% and tax_rate% are expressed in decimal form (Example: 0.05 for 5%) We can use the TVM keys to calculate ((1 + yield%)^n - 1) by setting the following values: n, yield → I/YR%, -1 → PV, 0 → PMT, solve for FV. Then: SFF = yield% ÷ FV 2. Value of the reversion value. PV_reversion = reversion_value × (1 + (yield% + tax_rate%))^(-n) We can use the TVM keys to calculate (1 + (yield% + tax_rate%))^(-n) by setting the following values: n, yield + tax_rate → I/YR%, 0 → PMT, -1 → FV, solve for PV. 3. Calculate the total property value. Property Value = PV_reversion + PV_income HP 12C Platinum Program: Property Value by Reversion Method Store before running the program: n = number of years of remaining economical life of the property i = yield interest rate R7 = property tax rate R8 = net income before taxes (NBIT) R9 = expected revision value of the property (the value of the property at the end of it's economic life) Code: Code:
Examples Example 1 NBIT: $7,588 (store in R8) Reversion Value: $236,000 (store in R9) Tax Rate: 1.3% (store 1.3 in R7) Annual Rate: 8% (store in i) Years of Economical Life Remaining: 5 (store in n) Property Value: $180,092.06 Example 2 NBIT: $12,000 Reversion Value: $185,000 Tax Rate: 1.6% Annual Rate: 7.34% Years of Economic Life Remaining: 10 Property Value: $153,286.39 |