1. Monthly rent at an apartment complex is $500. Operating costs average $15,000

1. Monthly rent at an apartment complex is $500. Operating costs average $15,000 per month regardless of the number of units rented. Construct a spreadsheet model to determine the profit if 35 units are rented. The manager has observed that the number of units rented during any given month varies between 30 and 40. Use your model to evaluate the profit for this range of unit rentals. 2. Think of any retailer that operates many stores throughout the country, such as Old Navy, Hallmark Cards, or Radio Shack, to name just a few. The retailer is often seeking to open new stores and needs to evaluate the profitability of a proposed location that would be leased for five years. An Excel model is provided in the New Store Financial Model spreadsheet. Use Scenario Manager to evaluate the cumulative discounted cash flow for the fifth year under the following scenarios:

You may also like