Below we present a Excel Data Table. The Excel Data Table functionality permits users to identify a set of potential value for two independent variables. The functionality automatically analyzes a formula that is dependent on these two variables and presents the results of all combinations of the two independent variables. The 'EXCEL Financial Functions' Sheet presents how to create a Data Table, but the output is presented here for those that do not want to dive any deeper. 19,120 200,000 250,000 300,000 350,000 Investment Required Percent Debt Financed 25% 50% 78,863 89,856 40,747 54,488 2,630 19,120 (35,486) (16,249) 0% 67,870 27,006 (13,859) (54,724) 75% 100,849 68,229 35,609 2,989 100% 111,842 81,970 52,098 22,226 Which would generate a higher NPV $350,000 with 25% debt financed $250,000 with 50% debt financed