1. Build a onedimensional Data Table that recalculates APV for various percentages of variable costs (10 rates above 10%)

2. Add a conditional formatting to highlight scenarios where the project becomes unprofitable, if any.

3. Provide a brief comment below the Data Table

PLEASE USE THE WHAT IF ANALYSIS TO CREATE THE DATA TABLE

NEED HELP URGENTLY !!!

Value drivers: Operations Fixed cost (annual) Fixed cost annual increase Energy generated (MW/H per year) Sale price (per KW/H) Cost of operation (% of sales) ONWC requirement (% of sales) Income tax rate WACC Cost of equity Model: Unlevered Operating FCFs Table 2 - Time line 12/31/23 12/31/29 Contractual Sales 2,400,000,000 Variable costs 12/31/32 2,400,000,000 240,000,000 32,810,558 240,000,000 30,000,000 1,233,750,000 12/31/24 12/31/25 2,400,000,000 2,400,000,000 240,000,000 240,000,000 30,300,000 30,603,000 1,233,750,000 1,233,750,000 895,950,000 895,647,000 188,149,500 188,085,870 707,800,500 707,561,130 1,233,750,000 1,233,750,000 12/31/30 2,400,000,000 240,000,000 32,164,061 1,233,750,000 Fixed costs Depreciation 12/31/26 2,400,000,000 240,000,000 30,909,030 1,233,750,000 895,340,970 188,021,604 707.319.366 1,233,750,000 12/31/31 2,400,000,000 240,000,000 32,485,701 1,233,750,000 1,233,750,000 EBIT 12/31/27 2,400,000,000 240,000,000 31,218,120. 1,233,750,000 895,031,880 187,956,695 707,075,185 1,233,750,000 (3,815,000,000) 120,000,000 2,400,000,000 240,000,000 31.845.605 1,233,750,000 894,404,395 187,824,923 706,579,472 1,233,750,000 12/31/28 2,400,000,000 240,000,000 31,530,302 1,233,750,000 894,719,698 187,891,137 706,828,562 1,233,750,000 120,000,000 893,439,442 896,250,000 188,212,500 708,037,500 1,233,750,000 taxes 187,622,283 894,085,939 893,764,299 187,758,047 187,690,503 706,327,892 706,073,796 1,233,750,000 Net operating Income 705,817.159 Depreciation 1,233,750,000 1,233,750,000 - (10,500,000,000) 2,935,375,000 Capital Expenditure ONWC 120,000,000 120,000,000 120,000,000 120,000,000 120,000,000 120,000,000 120,000,000 120,000,000 120,000,000 Change in ONWC (120,000,000) FCF NPV of Operating NPV of Financing (10,620,000,000) 1,941,787,500 1,941,550,500 1,941,311,130 1,941,069,366 (1,874,174,815) 1,940,578,562 1,940,329,472 1,940,077,892 1,939,823,796 4,994,942,159 (358,919,822) 900,478,428 541,558,606 APV 541,558,606 30,000,000 1.00% 15,000,000 0.16 10.00% 5.00% 21.00% 10.00% 11.00% 5/27/22 - 12/31/22 Value drivers: Operations Fixed cost (annual) Fixed cost annual increase Energy generated (MW/H per year) Sale price (per KW/H) Cost of operation (% of sales) ONWC requirement (% of sales) Income tax rate WACC Cost of equity Model: Unlevered Operating FCFs Table 2 - Time line 12/31/23 12/31/29 Contractual Sales 2,400,000,000 Variable costs 12/31/32 2,400,000,000 240,000,000 32,810,558 240,000,000 30,000,000 1,233,750,000 12/31/24 12/31/25 2,400,000,000 2,400,000,000 240,000,000 240,000,000 30,300,000 30,603,000 1,233,750,000 1,233,750,000 895,950,000 895,647,000 188,149,500 188,085,870 707,800,500 707,561,130 1,233,750,000 1,233,750,000 12/31/30 2,400,000,000 240,000,000 32,164,061 1,233,750,000 Fixed costs Depreciation 12/31/26 2,400,000,000 240,000,000 30,909,030 1,233,750,000 895,340,970 188,021,604 707.319.366 1,233,750,000 12/31/31 2,400,000,000 240,000,000 32,485,701 1,233,750,000 1,233,750,000 EBIT 12/31/27 2,400,000,000 240,000,000 31,218,120. 1,233,750,000 895,031,880 187,956,695 707,075,185 1,233,750,000 (3,815,000,000) 120,000,000 2,400,000,000 240,000,000 31.845.605 1,233,750,000 894,404,395 187,824,923 706,579,472 1,233,750,000 12/31/28 2,400,000,000 240,000,000 31,530,302 1,233,750,000 894,719,698 187,891,137 706,828,562 1,233,750,000 120,000,000 893,439,442 896,250,000 188,212,500 708,037,500 1,233,750,000 taxes 187,622,283 894,085,939 893,764,299 187,758,047 187,690,503 706,327,892 706,073,796 1,233,750,000 Net operating Income 705,817.159 Depreciation 1,233,750,000 1,233,750,000 - (10,500,000,000) 2,935,375,000 Capital Expenditure ONWC 120,000,000 120,000,000 120,000,000 120,000,000 120,000,000 120,000,000 120,000,000 120,000,000 120,000,000 Change in ONWC (120,000,000) FCF NPV of Operating NPV of Financing (10,620,000,000) 1,941,787,500 1,941,550,500 1,941,311,130 1,941,069,366 (1,874,174,815) 1,940,578,562 1,940,329,472 1,940,077,892 1,939,823,796 4,994,942,159 (358,919,822) 900,478,428 541,558,606 APV 541,558,606 30,000,000 1.00% 15,000,000 0.16 10.00% 5.00% 21.00% 10.00% 11.00% 5/27/22 - 12/31/22