skip navigation
Geography Department Banner.  Click to link to Geography Department Website
California State University, Northridge Logo.  Click to link to the C.S.U.N. home page.

Geography 340

Economic Geography - Lab 1: Net Present Value

Image: Flag of California

Cost-Benefit Analysis Using Net Present Value

The objective of this exercise is two fold.  First, it is intended to introduce students to formula construction in the spreadsheet software package Microsoft Excel. Secondly, this exercise introduces students to a simple cost benefit analysis formula that forms the basis of some site location analyses.  

Geographers may evaluate the feasibility of a location for a potential business or industry.  One of the simplest measures of economic feasibility is called Net Present Value represented by the formula below:

Background Reading (see moodle)

Net Present Value Formula

Where:

Essentially this translates thus: The Net Present Value is equal to the sum of the differences between benefits and costs for each year, divided by 1 plus the discount rate for each year.

No year zero. Startup costs should be added to year one costs.

Task

You are to evaluate the feasibility of two potential store locations for your company.  You learn from your boss that the remodeling and furnishing a building shell and the associated start up costs of a store averages $125,000 for mall locations. For non mall locations, you have to spend an extra $25,000 for the exterior and parking lot.  There are no benefits ($0) during start up. 

Your accountants tell you that on average, stores have labor costs totaling $120,000 yearly.  In the mall, you have found that rent and security will cost an additional $35,000 per year.  At location Y, across the street from the mall, rent and security will total $20,000 a year. 

Your accountants also tell you that most mall based stores make $160,000 during the first year and increase their income (benefits) by $13,000 annually for about six years if they are in a mall.  In other locations, stores make only $145,000 a year and increase their income $16,000 annually over the first six years.  

Your boss wants you to evaluate the Net Present Value of both of these locations using the data provided by her and the accountants for six years.  She also fears an inflationary spike, so she wants you to figure out if the project would still be feasible if the discount rate moves from 5% to 10%.   

To do this exercise, I would like you to try to set up the formulas yourself (or with your partner or team member) in Microsoft Excel.  If you run into trouble, the link below allows you to download a Microsoft Excel file with all the calculations you need.  You’ll have to figure out the logical steps that I’ve used, but if you examine closely the formulas in this spreadsheet, you can add your own data and eventually get the answers you need.  Good Luck.  Don’t be afraid to fail at this, but make sure you learn something.

Download the formulas in Microsoft Excel if you get stuck.

Answers

You are to provide the following data to your boss by your next meeting. Don't use dollar signs or commas, just numbers or letters.

Questions and Answers Table
Question
Number
Answer Question
1 What is the simple profit rate (B-C) at the mall store over six years? (no discount rate)
2 What is the simple profit rate (B-C) at non-mall store over six years? (no discount rate)
3 At the mall store , will the project be feasible in a six-year period with a 5% discount rate?
4 In what year of operation does the mall store, project become feasible assuming a 5% discount rate? (Net present value is greater than zero).
5 At the non-mall store, will the project be feasible in a six-year period with a 5% discount rate?
6 Is this statement true or false? After five years at a 5% discount rate the mall store will be more profitable than the non-mall store.
7 What is the Net Present Value (in dollars) the store at the mall location over a six-year life span with a 5% discount rate?
8 What is the Net Present Value (in dollars) the store at the mall location over a six-year life span with a 10% discount rate?
9 What is the Net Present Value (in dollars) the store at the non-mall location over a six-year life span with a 5% discount rate?
10 What is the Net Present Value (in dollars) the store at the non-mall location over a six-year life span with a 10% discount rate?
11 At what discount rate does the mall location fail to be a viable option in year six?
12

 

One accountant suggests that your company invest instead in oil, because according to his calculations at the government projected discount rate of .04, your company would make $70,000 profit on the same investment over six years. Should your company invest in:
A: Oil
B: A mall store
C: The store across the street from the mall

Use just the letter to answer.





When you click the button below, you will be directed to a web page that shows your answers. The instructor will get a copy of this email as well, but you may want to keep a copy for your records. If you are curious about the correct answers, please bring your questions to class.

 

 

C.S.U.N. Seal About Dr. Graves | Site Map | Contact Dr. Graves | ©2003 Steven M. Graves - Geography Department, California State University - Northridge