Need answer ASAP. Please provide excel sheet if used.
Note: Given values for Madera: MWh/day= 799,540, MW=140,005
A solar power company plans to invest in a 200 MWp PV type of system at a sunny location. The site under consideration is located in Madera County in California. Use the figure provided for this problem. The company will minimize the system degradation such that it is about 0.50% per year by aggressive maintenance and repairs. The company expects that the system will be down for 20 days/year for maintenance or repair. The total initial costs of the system are expected to be $350,000 Million, and the average annual maintenance/repair costs are expected to be 5% of the initial costs. The company plans to invest 40% equity and finance 60% of the capital costs as debt at 10%/year. The company expects to get feed-in tariff of $0.15/kWhe for 20 years in Madera County, where this rate will increase by 6% each year. Suppose the interest rate (discount rate) is equal to 10% and the inflation rate is 1% each year, which will be used for the calculation of the present value factor. The rate for the calculation of CRF for the capital and debt payments is 10%/year. A. What is the payback period using Method 1 (9 points) B. What is the payback period using Method 2 (9 points) C. Suppose the homeowner gets a rebate of 1.25/W from the power company and a 20% federal income tax credit, what are the predicted payback periods using Method 1 and Method 2? (9 points) D. What is LCOE for the system? (5 points) MW County ALAMEDA ALPINE MWhiday 558 952 280.655 214 149 439,566 378.300 317045 AMADOR BUTTE CALAVERAS COLUSA CONTRA COSTA DEL NORTE EL DORADO FRESNO GLENN HUMBOLDT MWhday 811245 439755 397814 7811,691 814573 822419 25.338.276 3.561,589 38,977 513.946 2450572 251470 490,774 91916 373.289 1821.160 144.772 80 747 71625 1253,372 147.775 150.238 3.981405 605.526 7410 91,113 418.263 47,153 297,137 158,437 29,776 MPERIAL INYO KERN KINGS MW County 103.745 ORANGE 46.905 PLACER 38 754 PLUMAS 80610 RIVERSDE 67 423 SACRAMENTO 58227 SAN BENITO 91,151 SAN BERNARDINO 20329 SANDEGO 67 805 SAN FRANCISCO 317 692 SAN JOAQUIN 99508 SAN LUIS OBISPO 88.340 SAN MATEO 745 887 SANTA BARBARA 1.599 946 SANTA CLARA 1,043,071 SANTA CRUZ 86687 SHASTA 98.033 SIERRA 492.190 SISKIYOU 662.486 SOLANO 140.005 SONOMA 46458 STANISLAUS S6897 SUTTER 124.389 TEHAMA 183.450 TRINITY 422 331 TULARE 349 025 TUOLUMNE 517123 397 805 4.698 212 10,047 177 6.300 316 502002 1690,109 861,570 157,033 885.789 LAKE LASSEN 529442 2.754941 3,912346 799540 LOS ANGELES MADERA 193,077 1.345,762 453,150 576.430 796435 90.023 246.566 548 329 MARIN MARIPOSA MENDOCNO MERCED 164584 34,794 261,615 83,335 106.940 140,965 16,717 239,196 64,027 217 308 117463 198,073 866,493 1,034 145 2.237536 MODOC 1316,667 331254 1251,596 658,573 1,138,750 MONO 2036 627 MONTEREY INAPA NEVADA 1,875.717 330271 330 488 VENTURA 60 168 YOLO 35 236 YUBA Suite Tous 316,907 202,601 100,139,175 57,518 37,602 194.567 16.822 184 A solar power company plans to invest in a 200 MWp PV type of system at a sunny location. The site under consideration is located in Madera County in California. Use the figure provided for this problem. The company will minimize the system degradation such that it is about 0.50% per year by aggressive maintenance and repairs. The company expects that the system will be down for 20 days/year for maintenance or repair. The total initial costs of the system are expected to be $350,000 Million, and the average annual maintenance/repair costs are expected to be 5% of the initial costs. The company plans to invest 40% equity and finance 60% of the capital costs as debt at 10%/year. The company expects to get feed-in tariff of $0.15/kWhe for 20 years in Madera County, where this rate will increase by 6% each year. Suppose the interest rate (discount rate) is equal to 10% and the inflation rate is 1% each year, which will be used for the calculation of the present value factor. The rate for the calculation of CRF for the capital and debt payments is 10%/year. A. What is the payback period using Method 1 (9 points) B. What is the payback period using Method 2 (9 points) C. Suppose the homeowner gets a rebate of 1.25/W from the power company and a 20% federal income tax credit, what are the predicted payback periods using Method 1 and Method 2? (9 points) D. What is LCOE for the system? (5 points) MW County ALAMEDA ALPINE MWhiday 558 952 280.655 214 149 439,566 378.300 317045 AMADOR BUTTE CALAVERAS COLUSA CONTRA COSTA DEL NORTE EL DORADO FRESNO GLENN HUMBOLDT MWhday 811245 439755 397814 7811,691 814573 822419 25.338.276 3.561,589 38,977 513.946 2450572 251470 490,774 91916 373.289 1821.160 144.772 80 747 71625 1253,372 147.775 150.238 3.981405 605.526 7410 91,113 418.263 47,153 297,137 158,437 29,776 MPERIAL INYO KERN KINGS MW County 103.745 ORANGE 46.905 PLACER 38 754 PLUMAS 80610 RIVERSDE 67 423 SACRAMENTO 58227 SAN BENITO 91,151 SAN BERNARDINO 20329 SANDEGO 67 805 SAN FRANCISCO 317 692 SAN JOAQUIN 99508 SAN LUIS OBISPO 88.340 SAN MATEO 745 887 SANTA BARBARA 1.599 946 SANTA CLARA 1,043,071 SANTA CRUZ 86687 SHASTA 98.033 SIERRA 492.190 SISKIYOU 662.486 SOLANO 140.005 SONOMA 46458 STANISLAUS S6897 SUTTER 124.389 TEHAMA 183.450 TRINITY 422 331 TULARE 349 025 TUOLUMNE 517123 397 805 4.698 212 10,047 177 6.300 316 502002 1690,109 861,570 157,033 885.789 LAKE LASSEN 529442 2.754941 3,912346 799540 LOS ANGELES MADERA 193,077 1.345,762 453,150 576.430 796435 90.023 246.566 548 329 MARIN MARIPOSA MENDOCNO MERCED 164584 34,794 261,615 83,335 106.940 140,965 16,717 239,196 64,027 217 308 117463 198,073 866,493 1,034 145 2.237536 MODOC 1316,667 331254 1251,596 658,573 1,138,750 MONO 2036 627 MONTEREY INAPA NEVADA 1,875.717 330271 330 488 VENTURA 60 168 YOLO 35 236 YUBA Suite Tous 316,907 202,601 100,139,175 57,518 37,602 194.567 16.822 184
