Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Build a onedimensional Data Table that recalculates APV for various blade loan rates (10 rates above 8%) 2. Add a conditional formatting to highlight

image text in transcribed

1. Build a onedimensional Data Table that recalculates APV for various blade loan rates (10 rates above 8%)

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 WHEN CREATING 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Bond Portfolio Management

Authors: Frank J. Fabozzi, Lionel Martellini, Philippe Priaulet

1st Edition

0471678902, 9780471678908

More Books

Students also viewed these Finance questions