. A ten unit apartment building has an annual $60,000 cash flow (similar to dividend when looking at stocks). The investor thinks the end of year one cash flow will equal $60,000 times 1.025. The investor thinks these cash flows may grow at 2.5% per year. The investor wants to earn a 9% interest rate on this investment. Compute the possible apartment building value today. how to calculate in excel