FIN 432 Topic 4 holding period cash flow projection example

Real Estate Grand Canyon University Free custom sample in 24 to 48h

This FIN 432 Topic 4 sample paper projects five years of cash flow for a composite 3,000,000-dollar office building and compares the result with the seller's projection. It forms part of GCU FIN 432, Real Estate, catalog code FIN-432, in the Grand Canyon University BS in Finance and Economics. First-year net operating income of 188,500 is a 6.28 percent entry yield. Income grows 3 percent, an 80,000 roof and boiler replacement hits year three, and the year-five sale capitalizes year-six income of about 218,523 at 6.5 percent less 4 percent costs. The unlevered return is about 7.4 percent; the seller's version shows about 11.5.

CourseFIN 432 Real Estate
TopicTopic 4
Paper typeCash flow projection paper
LengthAbout 950 words, 6 pages
FormatAPA 7 student paper
SchoolGrand Canyon University (GCU)
ProgramBS in Finance and Economics
UpdatedOctober 2026

Free sample paper for FIN 432 Topic 4

1

About 7.4 Percent, Not 11.5: A Five-Year Cash Flow Projection for a Multitenant Office Building and What the Seller's Version Leaves Out

[Author Name]

Colangelo College of Business, Grand Canyon University

FIN-432: Real Estate

Topic 4 Assignment

[Instructor Name]

[Date]

The organization, setting and figures below are a composite written as a model document. No real employer, client, colleague or patient is described.

What this page is doingThe title sets the projection's return beside the seller's and promises to explain the gap. The building and every figure are an illustrative composite; the sources are real.
2

About 7.4 Percent, Not 11.5: A Five-Year Cash Flow Projection for a Multitenant Office Building and What the Seller's Version Leaves Out

The Building and the Assumptions

Table 1

Projection Assumptions, Illustrative

AssumptionValue
Price$3,000,000
Potential gross income, year 1$330,000
Vacancy and credit loss5% of potential gross income
Operating expenses, year 1$125,000
Growth in rents and expenses3% a year
Capital expenditure$80,000 roof and boiler replacement in year 3
Exit capitalization rate6.5% on year-6 income
Selling costs4% of sale price

Larkspur Center, a composite two-story office building with eight tenants, is offered for 3,000,000 dollars. An investor considering an all-cash purchase wants to know what return the building is likely to earn over a five-year hold. This paper projects its cash flows year by year, estimates its sale price at the end of year five and computes the unlevered internal rate of return, then compares the result with the seller's marketing projection. All figures are illustrative.

What this page is doingEvery assumption is listed before the projection, including the capital expenditure and the exit rate the seller's version omits.
3

Year-One Income

Potential gross income of 330,000 dollars, less 5 percent vacancy and credit loss, gives effective gross income of 313,500. Subtracting 125,000 dollars of operating expenses leaves net operating income of 188,500 dollars, an entry yield, or going-in capitalization rate, of about 6.28 percent on the 3,000,000-dollar price.

The Projection

Table 2

Five-Year Cash Flow Projection, Illustrative

YearNet operating incomeCapital expenditureSale proceedsCash flow
0|| -$3,000,000
1$188,500|$188,500
2About $194,155|About $194,155
3About $199,980-$80,000| About $119,980
4About $205,979|About $205,979
5About $212,158| About $3,227,400About $3,439,600

Rents and expenses each grow 3 percent a year, so net operating income grows from 188,500 dollars in year one to about 212,158 in year five. The building's roof and boiler, both near the end of their lives according to the property condition report, need replacement in year three at a cost of about 80,000 dollars, which cuts that year's cash flow to about 119,980.

The sale at the end of year five is priced on the income the next buyer will receive, year-six net operating income of about 218,523 dollars, capitalized at 6.5 percent. That gives a gross price of about 3,361,900, and deducting 4 percent selling costs leaves net proceeds of about 3,227,400.

What this page is doingEach year's cash flow is built from income, capital spending and sale proceeds, so the return can be traced to its sources.
4

The Return

Solving for the rate that makes the discounted cash flows exactly repay the 3,000,000-dollar price gives an unlevered internal rate of return of about 7.4 percent. About three quarters of the present value at that rate comes from the sale at the end of year five, and only a quarter from the five years of operating cash flow. That concentration is typical of real estate projections and is the reason the exit capitalization rate matters so much: Geltner et al. (2014) caution that the resale assumption often drives a projection's result more than any operating assumption.

Why the Exit Rate Is Above the Entry Yield

The projection assumes an exit capitalization rate of 6.5 percent, above the 6.28 percent entry yield. A buyer five years from now will be acquiring a building five years older, with more wear and a shorter remaining economic life, and market capitalization rates may not stay as low as they are today. Brueggeman and Fisher (2018) note that analysts commonly assume a terminal capitalization rate somewhat above the going-in rate for these reasons.

How Sensitive the Return Is

Table 3

Unlevered IRR Under Different Exit Rates and Vacancy, Illustrative

Exit capitalization rateVacancy 5%Vacancy 10%
6.0%About 8.9%About 6.6%
6.5% (base)About 7.4%About 5.2%
7.0%About 6.1%About 3.9%

Because the sale dominates the result, the exit capitalization rate and the vacancy rate deserve a test. Table 3 recomputes the internal rate of return for exit rates of 6.0, 6.5 and 7.0 percent and for vacancy of 5 and 10 percent, holding everything else constant.

What this page is doingHalf a point on the exit rate moves the return by about 1.3 to 1.5 points, more than any operating assumption.
5

Reading the Sensitivity

Each half-point change in the exit rate moves the return by roughly 1.3 to 1.5 percentage points, and doubling vacancy to 10 percent costs about 2.2 points. Across the reasonable range, the return runs from about 4 to about 9 percent, which is a wide band for a building that looks stable. The seller's 11.5 percent lies outside every cell, which is itself a signal: it depends on assumptions more favorable than any the evidence supports.

The Seller's Version

The seller's marketing package projects about 11.5 percent from the same building. Three assumptions account for the difference. It assumes full occupancy throughout, with no vacancy or credit loss. It omits the year-three roof and boiler replacement. And it prices the sale at a 6.0 percent capitalization rate, below the current entry yield, as if the building would become more valuable per dollar of income as it ages. Each assumption is optimistic on its own; together they add about four percentage points to the return. The Appraisal Institute (2020) stresses that projections must be supported by market evidence for vacancy, expenses and capitalization rates rather than by the most favorable possible case.

What this page is doingThe seller's 11.5 percent is decomposed into three optimistic assumptions, each of which can be checked against evidence.
6

Conclusion

On realistic assumptions, Larkspur Center offers about 7.4 percent unlevered over five years, most of it from the eventual sale. Whether that is enough depends on the investor's required return for an office building of this risk. If she requires 8 percent or more, she should not pay 3,000,000 dollars; if 7 percent is acceptable, the price may be reasonable. Either way, the decision should rest on her projection, not the seller's, and she should test it further by varying the exit rate and vacancy, the two assumptions with the largest effect. If she plans to finance the purchase, the same projection should be rerun with the loan, since debt will raise the expected return on her equity only if the building earns more than the loan costs, and on these figures that margin is thin.

References

Appraisal Institute. (2020). The appraisal of real estate (15th ed.). Appraisal Institute.

Brueggeman, W. B., & Fisher, J. D. (2018). Real estate finance and investments (16th ed.). McGraw-Hill Education.

Geltner, D. M., Miller, N. G., Clayton, J., & Eichholtz, P. (2014). Commercial real estate analysis and investments (3rd ed.). OnCourse Learning.

The FIN-432 Topic 4 assignment instructions

In Topic 4, FIN-432 asks students to build a multiyear cash flow projection for an income property and compute its internal rate of return. Students should list every assumption before the projection, build each year's net operating income, include capital expenditures in the year they occur, and price the sale on the following year's income at an exit capitalization rate that reflects the building's age. Strong work explains how much of the return comes from the sale, tests the result against changes in the exit rate and vacancy, and identifies the specific assumptions behind any more optimistic projection, such as a seller's marketing package.

Inside the FIN 432 Topic 4 example

The finished projection starts from illustrative first-year figures: potential gross income of 330,000, 5 percent vacancy and 125,000 of operating expenses, for net operating income of 188,500, a 6.28 percent entry yield on the price. Rents and expenses both grow 3 percent a year. An 80,000 roof and boiler replacement lands in year three, cutting that year's cash flow to about 119,980. The sale at the end of year five capitalizes year-six income of about 218,523 at 6.5 percent and deducts 4 percent selling costs, netting about 3,227,000. The unlevered internal rate of return is about 7.4 percent, and the sale supplies about three quarters of the present value. The seller's version, full occupancy, no capital outlay and a 6.0 percent exit, shows about 11.5 percent from the same building.

FIN 432 Topic 4 rubric: what Excellent looks like

Graders award an Excellent projection for transparent assumptions and a return that can be traced. The rubric rewards a separate assumptions table, year-by-year cash flows including the capital expenditure, and a sale priced on next year's income less selling costs. Credit goes to reporting the share of value from the sale and to explaining why the exit rate sits above the entry yield. Faculty look for a sensitivity table on exit rate and vacancy. Strong papers decompose the seller's higher return into its optimistic assumptions. Top marks go to a conclusion that ties the decision to the investor's required return and her own projection.

FIN 432 Topic 4 help before you submit

A five-year projection with every unit let and nothing ever replaced is the first thing marked down, because no aging apartment building behaves that way. An exit capitalization rate set equal to or below the entry yield, with no argument for it, assumes the market will pay as much for an older building, and here the exit supplies most of the value. Capitalizing the sale on year-five income instead of the year ahead mismatches the income with the buyer. A one-time replacement deducted above net operating income distorts that year's income and any value capitalized from it. Papers that report an internal rate of return without saying how much of it comes from the sale hide the projection's dependence on one input. A projection with no sensitivity on the exit rate presents a single guess as the answer.

Get a FIN-432 Topic 4 example written to your instructions

Send the FIN-432 Topic 4 instructions and the rubric listed in your classroom, with the property figures or case your section assigns. We write a custom example to them, with assumptions gathered in one block, vacancy and capital spending in the projection, the sale priced on forward income and the exit rate tested, in 24 to 48 hours. The first one is free.

More FIN 432 papers and BS in Finance and Economics samples

FIN 432 Topic 4 questions, answered

Why price the sale on the following year's income?

Because the buyer at the end of the hold is paying for income still to come, not income the seller has already collected. Capitalizing year-six net operating income at the exit rate matches the price with what the new owner will receive first. Using year-five income understates the reversion slightly and mismatches the rate, which was drawn from sales priced the same forward-looking way.

Why set the exit rate above the entry yield?

Because the building will be five years older at sale, with more wear and a shorter remaining life, and because no one can know where market rates will stand then. An exit rate somewhat above the entry yield is a common conservative convention. In the example, moving it from 6.5 to 7.0 percent cuts the return from about 7.4 to 6.1 percent, which shows how much rides on that one figure.

Can this projection tell me whether a property is a good buy?

No. The building, rents, growth rates and exit assumptions are illustrative, and a projection is only as sound as inputs that nobody can verify in advance. A real decision needs actual operating statements, inspections, local market evidence and financing terms, reviewed by qualified professionals. The example demonstrates the holding-period discipline FIN-432 marks and is not investment advice.

Where can I find a free FIN 432 Topic 4 sample paper?

The full office building projection is here: the assumptions, year-one income, the five-year table, the return, the sensitivity table, the exit rate reasoning, the seller's version and the conclusion. Assumptions vary by prompt; pass yours along and the five-year model can be rerun at no cost.

Why is the seller's return higher in FIN 432 Topic 4?

It assumes full occupancy, omits the 80,000-dollar roof and boiler replacement and prices the sale at a 6.0 percent capitalization rate, below the entry yield. Together those add about four points to the return.