Question: Instruction First, re - read the Dulles Greenway case before completing this assignment. It will make this assignment much more productive if you do so

Instruction First, re-read the Dulles Greenway case before completing this assignment. It will make this assignment much more productive if you do so. The assignment builds on our earlier discussion of cash flow models and project capital structure. Download the Excel spreadsheet entitled Dulles_Greenway.xls from the Courseworks. Spend some time exploring how the spreadsheet is structured, how the calculations are made, what Excel functions are used, etc. After doing so, answer the following questions. Questions 1. Looking at the spreadsheet how much will it cost to develop the Dulles Greenway? (Hint: The total cost includes capital costs, interest costs during construction, and planning, acquisition and administrative costs that are captured by the equity contribution in Year 0. How much of this cost will be financed by equity and how much will be financed by debt? (6 points)2. When you click on cell E21, what appears in the formula bar window? (2 points)3. How are the values in cells O21 to O61 determined? Your response should be in terms of annual net revenues and debt service payments. Do not provide a mechanistic response; in other words, DO NOT ANSWER: They are determined by the formula F21-B21-G21-H21.(2 points)4. How are the values in cells R21 to R61 determined? Do not provide a mechanistic response; in other words, AGAIN, DO NOT ANSWER: They are determined by the formula F21-B21-G21-H21-J21-K21-L21.(2 points)5. What is the difference between the values calculated in cells O21 to O61 and the values in cells R21 to R61?(4 points)6. How is the value in cell Q12 calculated? How is the value in cell Q15 calculated (in this case it is okay to explain the formula used to calculate the value in cell Q15)?(4 points)7. How does the Project NPV change if the discount rate is 6%,8%,10%,12%,14% and 16%? Try to use Excels Table tool inside the Data menu to calculate these values. (6 points)8. How does the Project NPV change if the starting traffic volume is 10,000; 15,000; 20,000; 25,000; 30,000; 35,000. Again, try to use Excels Table tool inside the Data menu to calculate these values. (6 points)
 Instruction First, re-read the Dulles Greenway case before completing this assignment.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!