Please help...answer using Excel Functions if able...thanks.

a. State the company that you chose. Find out the company's ticker symbol, create hyperlinks to the web pages that you will need to find all of the information necessary to calculate the cost of equity. Use a market risk premium of seven percent when using CAPM. Ticker symbol: AAPL V Stock quote link Stock price: Dividend: LAADINLARDAwIc JLNAGINGHADDNUUTTOMTOTO minco $150.00 0.22 $ httpeut cuacOUTES Key statistics link Beta: Shares outstanding: 1.21 16.41 B Bond center link: Risk-free rate: 1.95% Market risk premium: 7.00% Market value of equity: 252372300 D11*016 7 7 o Cost of equity CAPM: Capital Asset Pricing Model 33.407% with a .22 Div. 150 Shgare price and a Growth rare o 33.26% gives a 33.407% Cost of Equity Price YTM 59.000% 280.400% 95.900% 2.802 43.100% 116.400% 274.800% 32.900% 122.100% 279.700% 40.800% 2.344% 2.790% 1.393% 144.000% 278.200% 26.100% 84.000% 1.586% 2.780% Maturity 5/3/23 5/4/43 5/6/24 5/6/44 2/9/22 2/9/25 2/9/45 5/13/22 5/13/25 5/13/45 2/23/23 2/23/36 2/23/46 2/23/26 8/4/26 8/4/46 2/9/22 N/A 2/9/22 2/9/24 2/9/27 2/9/47 5/11/22 N/A 5/11/22 5/11/24 5/11/27 6/20/27 9/12/27 9/12/47 9/12/22 1/13/23 1/13/25 11/13/27 11/13/47 9/11/22 9/11/24 9/11/26 9/11/29 9/11/49 5/11/23 5/11/25 5/11/30 5/11/50 8/20/25 8/20/30 8/20/50 8/20/60 2/8/26 2/8/28 2/8/31 2/8/41 2/8/51 2/8/61 8/5/28 8/5/31 8/5/51 8/5/61 31.200% 91.300% 164.000% 156.400% 169.300% 276.100% % 49.200% 40.700% 1.072% 168.000% 277.300% 22.400% 94.200% 148.700% 192.700% 280.100% 44.000% 118.200% 194.900% 272.700% 112.700% 197.700% 269.700% 282.300% 126.200% 173.400% 203.700% 253.900% 272.400% 286.400% 177.100% 204.000% 272.700% 285.900% Quoted Book Value 102.600 $5,500,000.00 116.769 $3,000,000.00 106.024 $2,500,000.00 127.322 $1,000,000.00 100.362 $1,250,000.00 104.198 $1,500,000.00 111.982 $2,000,000.00 101.118 $1,250,000.00 106.708 $2,000,000.00 127.022 $2,000,000.00 102.637 $1,500,000.00 125.209 $1,250,000.00 132.130 $2,500,000.00 107.202 ### ### ### 104.333 $1,500,000.00 118.713 $2,000,000.00 100.030 $1,000,000.00 100.286 $1,500,000.00 104.370 $1,750,000.00 108.388 $2,250,000.00 126.125 $1,000,000.00 100.114 $750,000.00 100.761 $1,000,000.00 104.399 $1,750,000.00 107.770 $2,000,000.00 107.311 $1,000,000.00 106.371 $2,000,000.00 117.910 $1,000,000.00 101.153 $1,000,000.00 102.097 $750,000.00 104.896 $1,500,000.00 107.174 $1,500,000.00 117.762 $1,250,000.00 101.179 $1,000,000.00 102.297 $750,000.00 102.512 $2,000,000.00 101.909 $1,750,000.00 102.828 $1,500,000.00 100.453 $2,000,000.00 99.806 $2,250,000.00 97.673 $1,750,000.00 98.482 $2,500,000.00 97.893 $1,250,000.00 94.189 $1,250,000.00 94.085 $1,250,000.00 93.592 $1,750,000.00 97.703 $2,500,000.00 96.868 $2,500,000.00 96.764 $2,750,000.00 97.516 $1,500,000.00 98.522 $3,000,000.00 98.506 $1,750,000.00 97.665 $2,300,000.00 97.020 $1,000,000.00 99.450 $1,800,000.00 99.785 $1,400,000.00 Total market value Market Value 564,300 350,307 265,060 106,024 125,453 156,297 223,964 126,398 213,416 254,044 153,956 156,511 330,325 $214,404.000 $156,499.50 237,426 100,030 150,429 182,648 243,873 126,125 75,086 100,761 182,698 215,540 107,311 212,742 117,910 101,153 76,573 157,344 160,761 1,472,025 101,179 76,723 205,024 178,341 154,242 150,680 224,564 170,928 246,205 122,366 117,736 117,606 163,786 244,258 242,170 266,101 146,274 295,566 172,386 224,630 97,020 179,010 139,699 1,791,405 Market Value Weight 0.31500 0.19555 0.14796 0.05918 0.07003 0.08725 0.12502 0.07056 0.11913 0.14181 0.08594 0.08737 0.18439 0.11968 0.08736 0.13254 0.05584 0.08397 0.10196 0.13614 0.07041 0.04191 0.05625 0.10199 0.12032 0.05990 0.11876 0.06582 0.05647 0.04274 0.08783 0.08974 0.82172 0.05648 0.04283 0.11445 0.09955 0.08610 0.08411 0.12536 0.09542 0.13744 0.06831 0.06572 0.06565 0.09143 0.13635 0.13518 0.14854 0.08165 0.16499 0.09623 0.12539 0.05416 0.09993 0.07798 Cost of debt = Weighted cost of debt 18.585% 54.832% 14.190% 2.551% 3.018% 10.156% 34.356% 2.321% 14.546% 39.665% 3.506% 0.205% 0.514% 0.167% 12.580% 36.872% 0.000% 2.192% 8.564% 0.216% 0.196% 0.000% 1.755% 9.311% 19.732% 9.369% 20.106% 18.173% 2.778% 1.740% 0.094% 15.076% 227.862% 1.265% 4.034% 17.019% 19.184% 24.117% 3.701% 14.817% 18.596% 37.479% 7.698% 12.993% 17.706% 25.810% 17.207% 23.441% 30.258% 20.732% 44.944% 27.560% 22.207% 11.048% 27.250% 22.295% 137.687% $ Total market value = 1,791,405 Cost of debt = 137.687% Tax rate: 35% 89 90 91 92 93 94 95 96 97 Aftertax cost of debt: 89.05= H98(1-D91) .22 Div. 150 Current Market Value 33.26% Growth Rate of Div. 33.407% is Cost of Equity $ Cost of equity: Market value of equity: Aftertax cost of debt: Market value of debt: 98 F89 99 9 c. Finally, calculate the market value weights for debt and equity. What is the WACC for the company? 200 01 -02 Weight of debt: Weight of equity: 03 04 205 WACC: WD*RD*(1-Tc)+We*re ? 06 -07 08 - n9 a. State the company that you chose. Find out the company's ticker symbol, create hyperlinks to the web pages that you will need to find all of the information necessary to calculate the cost of equity. Use a market risk premium of seven percent when using CAPM. Ticker symbol: AAPL V Stock quote link Stock price: Dividend: LAADINLARDAwIc JLNAGINGHADDNUUTTOMTOTO minco $150.00 0.22 $ httpeut cuacOUTES Key statistics link Beta: Shares outstanding: 1.21 16.41 B Bond center link: Risk-free rate: 1.95% Market risk premium: 7.00% Market value of equity: 252372300 D11*016 7 7 o Cost of equity CAPM: Capital Asset Pricing Model 33.407% with a .22 Div. 150 Shgare price and a Growth rare o 33.26% gives a 33.407% Cost of Equity Price YTM 59.000% 280.400% 95.900% 2.802 43.100% 116.400% 274.800% 32.900% 122.100% 279.700% 40.800% 2.344% 2.790% 1.393% 144.000% 278.200% 26.100% 84.000% 1.586% 2.780% Maturity 5/3/23 5/4/43 5/6/24 5/6/44 2/9/22 2/9/25 2/9/45 5/13/22 5/13/25 5/13/45 2/23/23 2/23/36 2/23/46 2/23/26 8/4/26 8/4/46 2/9/22 N/A 2/9/22 2/9/24 2/9/27 2/9/47 5/11/22 N/A 5/11/22 5/11/24 5/11/27 6/20/27 9/12/27 9/12/47 9/12/22 1/13/23 1/13/25 11/13/27 11/13/47 9/11/22 9/11/24 9/11/26 9/11/29 9/11/49 5/11/23 5/11/25 5/11/30 5/11/50 8/20/25 8/20/30 8/20/50 8/20/60 2/8/26 2/8/28 2/8/31 2/8/41 2/8/51 2/8/61 8/5/28 8/5/31 8/5/51 8/5/61 31.200% 91.300% 164.000% 156.400% 169.300% 276.100% % 49.200% 40.700% 1.072% 168.000% 277.300% 22.400% 94.200% 148.700% 192.700% 280.100% 44.000% 118.200% 194.900% 272.700% 112.700% 197.700% 269.700% 282.300% 126.200% 173.400% 203.700% 253.900% 272.400% 286.400% 177.100% 204.000% 272.700% 285.900% Quoted Book Value 102.600 $5,500,000.00 116.769 $3,000,000.00 106.024 $2,500,000.00 127.322 $1,000,000.00 100.362 $1,250,000.00 104.198 $1,500,000.00 111.982 $2,000,000.00 101.118 $1,250,000.00 106.708 $2,000,000.00 127.022 $2,000,000.00 102.637 $1,500,000.00 125.209 $1,250,000.00 132.130 $2,500,000.00 107.202 ### ### ### 104.333 $1,500,000.00 118.713 $2,000,000.00 100.030 $1,000,000.00 100.286 $1,500,000.00 104.370 $1,750,000.00 108.388 $2,250,000.00 126.125 $1,000,000.00 100.114 $750,000.00 100.761 $1,000,000.00 104.399 $1,750,000.00 107.770 $2,000,000.00 107.311 $1,000,000.00 106.371 $2,000,000.00 117.910 $1,000,000.00 101.153 $1,000,000.00 102.097 $750,000.00 104.896 $1,500,000.00 107.174 $1,500,000.00 117.762 $1,250,000.00 101.179 $1,000,000.00 102.297 $750,000.00 102.512 $2,000,000.00 101.909 $1,750,000.00 102.828 $1,500,000.00 100.453 $2,000,000.00 99.806 $2,250,000.00 97.673 $1,750,000.00 98.482 $2,500,000.00 97.893 $1,250,000.00 94.189 $1,250,000.00 94.085 $1,250,000.00 93.592 $1,750,000.00 97.703 $2,500,000.00 96.868 $2,500,000.00 96.764 $2,750,000.00 97.516 $1,500,000.00 98.522 $3,000,000.00 98.506 $1,750,000.00 97.665 $2,300,000.00 97.020 $1,000,000.00 99.450 $1,800,000.00 99.785 $1,400,000.00 Total market value Market Value 564,300 350,307 265,060 106,024 125,453 156,297 223,964 126,398 213,416 254,044 153,956 156,511 330,325 $214,404.000 $156,499.50 237,426 100,030 150,429 182,648 243,873 126,125 75,086 100,761 182,698 215,540 107,311 212,742 117,910 101,153 76,573 157,344 160,761 1,472,025 101,179 76,723 205,024 178,341 154,242 150,680 224,564 170,928 246,205 122,366 117,736 117,606 163,786 244,258 242,170 266,101 146,274 295,566 172,386 224,630 97,020 179,010 139,699 1,791,405 Market Value Weight 0.31500 0.19555 0.14796 0.05918 0.07003 0.08725 0.12502 0.07056 0.11913 0.14181 0.08594 0.08737 0.18439 0.11968 0.08736 0.13254 0.05584 0.08397 0.10196 0.13614 0.07041 0.04191 0.05625 0.10199 0.12032 0.05990 0.11876 0.06582 0.05647 0.04274 0.08783 0.08974 0.82172 0.05648 0.04283 0.11445 0.09955 0.08610 0.08411 0.12536 0.09542 0.13744 0.06831 0.06572 0.06565 0.09143 0.13635 0.13518 0.14854 0.08165 0.16499 0.09623 0.12539 0.05416 0.09993 0.07798 Cost of debt = Weighted cost of debt 18.585% 54.832% 14.190% 2.551% 3.018% 10.156% 34.356% 2.321% 14.546% 39.665% 3.506% 0.205% 0.514% 0.167% 12.580% 36.872% 0.000% 2.192% 8.564% 0.216% 0.196% 0.000% 1.755% 9.311% 19.732% 9.369% 20.106% 18.173% 2.778% 1.740% 0.094% 15.076% 227.862% 1.265% 4.034% 17.019% 19.184% 24.117% 3.701% 14.817% 18.596% 37.479% 7.698% 12.993% 17.706% 25.810% 17.207% 23.441% 30.258% 20.732% 44.944% 27.560% 22.207% 11.048% 27.250% 22.295% 137.687% $ Total market value = 1,791,405 Cost of debt = 137.687% Tax rate: 35% 89 90 91 92 93 94 95 96 97 Aftertax cost of debt: 89.05= H98(1-D91) .22 Div. 150 Current Market Value 33.26% Growth Rate of Div. 33.407% is Cost of Equity $ Cost of equity: Market value of equity: Aftertax cost of debt: Market value of debt: 98 F89 99 9 c. Finally, calculate the market value weights for debt and equity. What is the WACC for the company? 200 01 -02 Weight of debt: Weight of equity: 03 04 205 WACC: WD*RD*(1-Tc)+We*re ? 06 -07 08 - n9