Enter a formula using pv in cell b6 to calculate the present value needed for this pension fund. Cell b3 is the expected annual interest rate. Cell b4 is the total number of monthly payments that will be made. Cell b2 is the amount of each monthly payment. Payments will be made at the beginning of every period. Remember to express the pmt argument as a negative.

Read the overview below and complete the activities that follow.apartment complexes often look for ways to recruit new tenants and retain current tenants. although apartment complexes offer the tangible benefit of shelter to their tenants, many apartment complexes also offer additional services to tenants to encourage tenants to stay or to support the rent prices. the following scenario identifies the several service gaps of a company that runs an apartment complex as well as solutions for reducing these service gaps.concept review: customers have certain expectations about how a service should be delivered. a service gap occurs when the delivery of a service fails to meet customer expectations. there are four types of service gaps: knowledge gap, standards gap, delivery gap, and the communications gap. it is important for marketers to identify these gaps and develop strategies for minimizing them.match the example or solution to the appropriate service gap category.1. wait for repairs 5. train employees well2. understand expectations 6. incentives for tenants3. do not overpromise 7. family movie night4. empower employees 8. delayed lawn careservice gap example solutionknowledge gap standards gap delivery gap communication gap