The coffee shop has a $35-$year lease, so we will assume that it will be in business for $35$ years. It produced cash flows of $$278,796$ after all expenses this year, and the discount rate used by similar businesses is $13\mathrm{.}9$ percent. You estimate that, over the long term, cash flows will grow at $2\mathrm{.}2$ percent per year because of inflation. Your boss wants to know how much it is worth now.Using excel formula finance formula