what is the WACC of the data provided

(for the balance sheet, only use first row of data.)

(the parameters are my calculations, if you find them to not be correct, please continue with your corrections)

G Paste C22 Times New Roman 5 Change in NWC 6 Fixed Costs 7 BIU 2 3 Economic life of project in years. 4 Price of New Equipment 8 9 Marginal Tax Rate 10 Generation Variable Costs (% of Revenue Salvage value of New Equipment $ SA Open recovered workbooks? Your recent changes were saved. Do you w X fx A B 1 I. Given the follow data on proposed capital budgeting project. $ SS $ S 11 First Year Capacity factor 12 Capacity Factor Growth Rate 13 Sale Price 14 Cost of Bonds 15 Cost of Stock 16 17 Spreadsheet for determining Cash Flows 18 Timeline: 12 $ $ $ V A A | A V 6 32,000,000.00 5,000,000.00 3,500,000.00 54% V 111 = Year C 5,000,000.00 32.0% 31000 kw per hour 56% 15% 0.155 per kw-hour 990.00 14.00 = (Input Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? 2 puts Expected from you are highlighted in yellow) Rm Parameters Original Debt Original Equity New Debt New Equity Old D/E Ratio New D/E Ratin % Raised via Bonds % Raised via Equity Old Wd Old We $ 460.455.00 R $ 17,598.212.00 B (From Yahoo!) (Unlevered) $ 29,700,000.00 B $ 14,000,000.00 Re 1.2007 Rd 2.1214 New Wd 20.0% New We 80.0% WACC 2.55% ELP Total Liabilities 97.45% ELP Total Stockholder Equity ELP D/E Ratio Note Cells C20 and C21 include the initial (today's) cash flows. Column D through I are the operating cash flows. Cells 138-141 contain the terminal cash flows. 3 G 2.940% 0.920 67.96% 32.04% H BNC (Re-levered) + 5 Total Cash Net Receivables to Tallery 11 Our Cumma, Tel 12 Total Current Assets 14 Property Plant Equipment, Total-Gross 15 Amulated Depreciation. Total 14 Net property, plant and equipment 17 Equity and other invest 18Ingles, Net 19 Oder Long Term Assets, Total 20 Total non-cerent asses 21 Total Assets 23 LIABILITIES 24 Acos Payable 25 Tas payable 26 Acerved liabilin Deferred revenues 28 Other Cummi 29 Total Current Liabilities 31 Long Term Debt Defend uus labies 13 Defiared revenue 14 Other Ing-term labies 35 Tolson-current lublin Tutal Liabitis 38 STOCKHOLDER EQUITY 39 Con Stock sind sing 41 Add to comprehmasive some 41 Tinal sockhollen esity Total Sabaties and stockholders' equity 3300409 3179010 130442 219236 7909196 10684934 10684934 2948301 6332611 1229882 30403354 38312550 1419822 1685250 60132 337044 28508 375395 10152271 293666 85000 15368717 20714338 10000000 4846239 101424 17252414 38312550 2434455 2997268 116285 190876 6677846 20027236 9186573 10840663 2863472 6029097 1343721 29252254 35930100 3297928 141924) 197949 194167 79872 270429 8267510 157400 418437 12898772 1959184 7910000 6422564 914751 16032925 35930100 D 1213025 2882984 110559 167109 5701834 18X19997 9006547 9829450 2977939 6452824 142491 27450543 33162377 2416728 1683577 $6310 192891 150025 475585 7413755 156630 340409 11541960 17651824 7910000 3557843 4400 15207842 33142377 1284471 2282950 130637 4402990 17728910 8294607 8934303 2938343 6439812 1595809 2601219 30414209 2601940 1255639 41454 176679 141712 366774 6235162 176430 376107 9622727 15274763 7910000 5162983 792716 14864165 30434209 2797760 3041999 131018 11166) 4933397 18107001 9414319 8692682 2450730 6145076 1357716 22014260 28947657 1613126 311916 182524 277458 167881 REGALY 6528425 214 231112 9574061 14363179 3413572 744754 14243728 24947657 G H 1 Format Shape O Shadow Reflection Glow Soft Edges 3-D Format 3-D Rotation G Paste C22 Times New Roman 5 Change in NWC 6 Fixed Costs 7 BIU 2 3 Economic life of project in years. 4 Price of New Equipment 8 9 Marginal Tax Rate 10 Generation Variable Costs (% of Revenue Salvage value of New Equipment $ SA Open recovered workbooks? Your recent changes were saved. Do you w X fx A B 1 I. Given the follow data on proposed capital budgeting project. $ SS $ S 11 First Year Capacity factor 12 Capacity Factor Growth Rate 13 Sale Price 14 Cost of Bonds 15 Cost of Stock 16 17 Spreadsheet for determining Cash Flows 18 Timeline: 12 $ $ $ V A A | A V 6 32,000,000.00 5,000,000.00 3,500,000.00 54% V 111 = Year C 5,000,000.00 32.0% 31000 kw per hour 56% 15% 0.155 per kw-hour 990.00 14.00 = (Input Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? 2 puts Expected from you are highlighted in yellow) Rm Parameters Original Debt Original Equity New Debt New Equity Old D/E Ratio New D/E Ratin % Raised via Bonds % Raised via Equity Old Wd Old We $ 460.455.00 R $ 17,598.212.00 B (From Yahoo!) (Unlevered) $ 29,700,000.00 B $ 14,000,000.00 Re 1.2007 Rd 2.1214 New Wd 20.0% New We 80.0% WACC 2.55% ELP Total Liabilities 97.45% ELP Total Stockholder Equity ELP D/E Ratio Note Cells C20 and C21 include the initial (today's) cash flows. Column D through I are the operating cash flows. Cells 138-141 contain the terminal cash flows. 3 G 2.940% 0.920 67.96% 32.04% H BNC (Re-levered) + 5 Total Cash Net Receivables to Tallery 11 Our Cumma, Tel 12 Total Current Assets 14 Property Plant Equipment, Total-Gross 15 Amulated Depreciation. Total 14 Net property, plant and equipment 17 Equity and other invest 18Ingles, Net 19 Oder Long Term Assets, Total 20 Total non-cerent asses 21 Total Assets 23 LIABILITIES 24 Acos Payable 25 Tas payable 26 Acerved liabilin Deferred revenues 28 Other Cummi 29 Total Current Liabilities 31 Long Term Debt Defend uus labies 13 Defiared revenue 14 Other Ing-term labies 35 Tolson-current lublin Tutal Liabitis 38 STOCKHOLDER EQUITY 39 Con Stock sind sing 41 Add to comprehmasive some 41 Tinal sockhollen esity Total Sabaties and stockholders' equity 3300409 3179010 130442 219236 7909196 10684934 10684934 2948301 6332611 1229882 30403354 38312550 1419822 1685250 60132 337044 28508 375395 10152271 293666 85000 15368717 20714338 10000000 4846239 101424 17252414 38312550 2434455 2997268 116285 190876 6677846 20027236 9186573 10840663 2863472 6029097 1343721 29252254 35930100 3297928 141924) 197949 194167 79872 270429 8267510 157400 418437 12898772 1959184 7910000 6422564 914751 16032925 35930100 D 1213025 2882984 110559 167109 5701834 18X19997 9006547 9829450 2977939 6452824 142491 27450543 33162377 2416728 1683577 $6310 192891 150025 475585 7413755 156630 340409 11541960 17651824 7910000 3557843 4400 15207842 33142377 1284471 2282950 130637 4402990 17728910 8294607 8934303 2938343 6439812 1595809 2601219 30414209 2601940 1255639 41454 176679 141712 366774 6235162 176430 376107 9622727 15274763 7910000 5162983 792716 14864165 30434209 2797760 3041999 131018 11166) 4933397 18107001 9414319 8692682 2450730 6145076 1357716 22014260 28947657 1613126 311916 182524 277458 167881 REGALY 6528425 214 231112 9574061 14363179 3413572 744754 14243728 24947657 G H 1 Format Shape O Shadow Reflection Glow Soft Edges 3-D Format 3-D Rotation