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, reread 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 DullesGreenway.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 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 How much of this cost will be financed by equity and how much will be financed by debt? points When you click on cell E what appears in the formula bar window? points How are the values in cells O to O 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 FBGH points How are the values in cells R to R determined? Do not provide a mechanistic response; in other words, AGAIN, DO NOT ANSWER: They are determined by the formula FBGHJKL points What is the difference between the values calculated in cells O to O and the values in cells R to R points How is the value in cell Q calculated? How is the value in cell Q calculated in this case it is okay to explain the formula used to calculate the value in cell Q points How does the Project NPV change if the discount rate is and Try to use Excels Table tool inside the Data menu to calculate these values. points How does the Project NPV change if the starting traffic volume is ; ; ; ; ; Again, try to use Excels Table tool inside the Data menu to calculate these values. points
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
