Can anyone help me find the highlighted areas? Please include the excel formulas as well. Thank you!

The problem also included some information about bonds: (if needed)

1st bond issue: 100 semiannual, $1000 par bonds with a settlement date of 3/5/2020 and a maturity date of 3/5/2030, a coupon rate of 6% and a market price of $970. At maturity, the bonds are expected to pay 100% of their face value.

2nd bond issue:1500, semiannual, $1000 par bonds with a settlement date of 1/1/2015 and a maturity date of 1/1/2045. They are zero coupon bonds and have a market price of $115. At maturity, the bonds are expected to pay 100% of their face value.

3rd bond issue: 200, semiannual, $1000 par bonds with a settlement date of 1/15/2022 and a maturity date of 1/15/2052. The coupon rate on the bonds is 6% and they have a market value of $1100. At maturity, the bonds are expected to pay 100% of their face value.

File Home Insert Draw Page Layout Formulas Data Review View Automate ny Calibri v 11 B nov A abe Merg K30 ~x fx B C. E F G H 1 K $ 295,875.00 2396 396 7596 2.1096 8.0096 1.2 Cost Equity Debt Cost WACC 11.7096 0 6.4996 min 10 Risk Free Rate Market Risk Prer Beta Cost of Debt Tax Rate Target Weight Ec Target Weight De 5096 3596 55.5096 44.5096 1696 1.8096 41000 0 10.1096 S $ S 1 Assumptions and Information: 2 Base Year Sales 3 Net Working Capital (% of Sales) 4 Depreciation (% of Gross Assets) 5 COGS (% of sales) 6 Gross Fixed Assets (% of sales) 7 Expected Growth Rate for Years 1-4 8 Expected Growth Rate for Year 5 and On 9 Outstanding Shares 10 Preferred Stock Outstanding 11 Expected Return on Market 12 Value of Debt 13 14 Year 15 Sales 16 COGS 17 EBITDA 18 Depreciation 19 EBIT 20 Cash Taxes 21 Income 22 Add Depreciation 23 Minus Change in WC 24 Minus Capital Expenditure 25 Free Cash Flow 26 Terminal Value 27 Total Free Cash Flows 28 Total Firm Value 29 Value of Debt 30 Value of Equity 31 32 33 34 35 36 37 Gross Fixed Assets 38 Depreciation 39 Net Working Capital un ini ini ini 0 1 2 3 4 5 6 295,875.00 S 343,215.00 S 398,129.40 $461,830.10 $ 535,722.92 $ 545,365.93 $ 555,182.52 221,906.25 S 257,411.25 $ 298,597.05 $ 346, 372.58 $ 401,792.19 $ 409,024.45 $ 416,386.89 73,968.75 S 85,803.75 S 99,532.35 $ 115,457.53 $ 133,930.73 $ 136,341.48 $ 138,795.63 4,438.13 S 5,148.23S 5,971.94 $ 6,927.45 $ 8,035.84 S 8,180.49 $ 8,327.74 69,530.63 $ 80,655.53 $ 93,560.41 $ 108,530.07 $ 125,894.89 $ 128,160.99 $ 130,467.89 24,335.72 S 28,229.43 $ 32,745.14 $ 37,985.53 $ 44,063.21 S 44,856.35 $ 45,663.76 45,194.91 S 52,426.09 S 60,814.27 $ 70,544.55 $ 81,831.68 S 83,304.65 $ 84,804.13 4,438.13 $ 5,148.23 $ 5,971.94 $ 6,927.45 $ 8,035.84 S 8,180.49 $ 8,327.74 S 10,888.20 S 12,630.31 $ 14,651.16 S 16,995.35 S 2,217.89 $ 2,257.81 S 23,670.00 S 27,457.20 $ 31,850.35 $ 36,946.41 5 4,821.51 $ 4,908.29 $ 23,016.12 S 26,698.59 $ 30,970.49 $ 35,925.76 S 84,445.74 $ 85,965.76 $ (765,436.54) Terminal Value Terminal Value $ 23,016.12 S 26,698.69 $ 30,970.49 $ 1729,510.77) (496,405.72 0.0096 Shares Outstan Value Per Share (496,405.72) S (12.11) S 41,000.00 $ $ $ $ S 147,937.50 S 171,607.50 $ 199,064.70 $ 230,915.05 $ 267,861.46 S 4,438.13 $ 5,148.23 S 5,971.94 $ 6,927.45 $ 8,035.84 5 68,051.25 S 78,939.45 S 91,569.76 $ 106,220.92 $ 123,216.27 S 272,682.97 $ 277,591.26 8,180.49 $ 8,327.74 125,434.16 $ 127,691.98 File Home Insert Draw Page Layout Formulas Data Review View Automate ny Calibri v 11 B nov A abe Merg K30 ~x fx B C. E F G H 1 K $ 295,875.00 2396 396 7596 2.1096 8.0096 1.2 Cost Equity Debt Cost WACC 11.7096 0 6.4996 min 10 Risk Free Rate Market Risk Prer Beta Cost of Debt Tax Rate Target Weight Ec Target Weight De 5096 3596 55.5096 44.5096 1696 1.8096 41000 0 10.1096 S $ S 1 Assumptions and Information: 2 Base Year Sales 3 Net Working Capital (% of Sales) 4 Depreciation (% of Gross Assets) 5 COGS (% of sales) 6 Gross Fixed Assets (% of sales) 7 Expected Growth Rate for Years 1-4 8 Expected Growth Rate for Year 5 and On 9 Outstanding Shares 10 Preferred Stock Outstanding 11 Expected Return on Market 12 Value of Debt 13 14 Year 15 Sales 16 COGS 17 EBITDA 18 Depreciation 19 EBIT 20 Cash Taxes 21 Income 22 Add Depreciation 23 Minus Change in WC 24 Minus Capital Expenditure 25 Free Cash Flow 26 Terminal Value 27 Total Free Cash Flows 28 Total Firm Value 29 Value of Debt 30 Value of Equity 31 32 33 34 35 36 37 Gross Fixed Assets 38 Depreciation 39 Net Working Capital un ini ini ini 0 1 2 3 4 5 6 295,875.00 S 343,215.00 S 398,129.40 $461,830.10 $ 535,722.92 $ 545,365.93 $ 555,182.52 221,906.25 S 257,411.25 $ 298,597.05 $ 346, 372.58 $ 401,792.19 $ 409,024.45 $ 416,386.89 73,968.75 S 85,803.75 S 99,532.35 $ 115,457.53 $ 133,930.73 $ 136,341.48 $ 138,795.63 4,438.13 S 5,148.23S 5,971.94 $ 6,927.45 $ 8,035.84 S 8,180.49 $ 8,327.74 69,530.63 $ 80,655.53 $ 93,560.41 $ 108,530.07 $ 125,894.89 $ 128,160.99 $ 130,467.89 24,335.72 S 28,229.43 $ 32,745.14 $ 37,985.53 $ 44,063.21 S 44,856.35 $ 45,663.76 45,194.91 S 52,426.09 S 60,814.27 $ 70,544.55 $ 81,831.68 S 83,304.65 $ 84,804.13 4,438.13 $ 5,148.23 $ 5,971.94 $ 6,927.45 $ 8,035.84 S 8,180.49 $ 8,327.74 S 10,888.20 S 12,630.31 $ 14,651.16 S 16,995.35 S 2,217.89 $ 2,257.81 S 23,670.00 S 27,457.20 $ 31,850.35 $ 36,946.41 5 4,821.51 $ 4,908.29 $ 23,016.12 S 26,698.59 $ 30,970.49 $ 35,925.76 S 84,445.74 $ 85,965.76 $ (765,436.54) Terminal Value Terminal Value $ 23,016.12 S 26,698.69 $ 30,970.49 $ 1729,510.77) (496,405.72 0.0096 Shares Outstan Value Per Share (496,405.72) S (12.11) S 41,000.00 $ $ $ $ S 147,937.50 S 171,607.50 $ 199,064.70 $ 230,915.05 $ 267,861.46 S 4,438.13 $ 5,148.23 S 5,971.94 $ 6,927.45 $ 8,035.84 5 68,051.25 S 78,939.45 S 91,569.76 $ 106,220.92 $ 123,216.27 S 272,682.97 $ 277,591.26 8,180.49 $ 8,327.74 125,434.16 $ 127,691.98