14-5, please see that attached. I need the answer and associated formula. Thank you.

Problem 14-5 Suppose there are no taxes. Firm ABC has no debt, and firm XYZ has debt of $5000 on whi have identical projects that generate free cash flows of $800 or $1000 each year. After payin free cash flows to pay dividends each year. a. Fill in the table below showing the payments debt and equity holders of each firm wil cash flows. b. Suppose you hold 10% of the equity of ABC. What is another portfolio you could hol same cash flows? c. Suppose you hold 10% of the equity of XYZ. If you can borrow at 10%, what is an a flows? Debt ABC Debt XYZ Interest rate $0 $5,000 10% a. Fill in the table below showing the payments debt and equity holders of each firm wil cash flows. ABC FCF Debt Payments XYZ Equity Dividends Debt Payments $800 $1,000 b. Suppose you hold 10% of the equity of ABC. What is another portfolio you could hol same cash flows? Ownership 10% Equity in ABC would provide cash flows of Cash flows could be replicated by owning The debt cash flows would be The equity cash flows would be For total cash flows of c. Suppose you hold 10% of the equity of XYZ. If you can borrow at 10%, what is an a flows? Ownership 10% Equity in XYZ would provide cash flows of Cash flows could be replicated by borrowing You would receive dividends of You would pay interest of Your total cash flow would be Requirements 1. In cell D18, by using absolute cell references, calculate firm ABC's debt payments gi 2. Calculate firm ABC's debt payments given the second level of free cash flows by cop 3. In cell E18, by using cell references, calculate firm ABC's equity dividends given the 4. Calculate firm ABC's equity dividends given the second level of free cash flows by c 5. In cell F18, by using absolute cell references, calculate firm XYZ's debt payments gi 6. Calculate firm XYZ's debt payments given the second level of free cash flows by cop 7. In cell G18, by using cell references, calculate firm XYZ's equity dividends given the 8. Calculate firm XYZ's equity dividends given the second level of free cash flows by c 9. In cell F25, by using cell references, calculate the cash flows provided by owning 10% cash flows (1 pt.). 10. In cell H25, by using cell references, calculate the cash flows provided by owning 10 free cash flows (1 pt.). 11. In cell F26, calculate the percent of debt ownership that could help to replicate the ca 12. In cell H26, calculate the percent of equity ownership that could help to replicate the pt.). 13. In cell F27, by using cell references, calculate the debt cash flows given the first leve 14. In cell H27, by using cell references, calculate the debt cash flows given the second l 15. In cell F28, by using cell references, calculate the equity cash flows given the first lev 16. In cell H28, by using cell references, calculate the equity cash flows given the second 17. In cell F29, by using cell references, calculate the total cash flows given the first leve 18. Calculate the total cash flows given the second level of free cash flows by copying ce 19. In cell F35, by using cell references, calculate the cash flows provided by owning 10% cash flows (1 pt.). 20. In cell H35, by using cell references, calculate the cash flows provided by owning 10 free cash flows (1 pt.). 21. In cell F36, by using cell references, calculate the amount to borrow to help replicate 22. In cell H36, by using cell references, calculate the percent of firm ABC's ownership t 23. In cell F37, by using cell references, calculate the dividends that you would receive g 24. In cell H37, by using cell references, calculate the dividends that you would receive g 25. In cell F38, by using cell references, calculate the amount that you would pay in inter 26. In cell H38, calculate the amount that you would pay in interest given the second leve F38, since the interest payments are independent of the level of free cash flows (1 pt. 27. In cell F39, by using cell references, calculate the total cash flows given the first leve 28. In cell H39, by using cell references, calculate the total cash flows given the second l YZ has debt of $5000 on which it pays interest of 10% each year. Both companies $1000 each year. After paying any interest on debt, both companies use all remaining uity holders of each firm will receive given each of the two possible levels of free other portfolio you could hold that would provide the borrow at 10%, what is an alternative strategy that would provide the same cash uity holders of each firm will receive given each of the two possible levels of free XYZ Equity Dividends other portfolio you could hold that would provide the or of debt and or or or per year of equity of XYZ per year per year per year, as you would get from buying ABC equity borrow at 10%, what is an alternative strategy that would provide the same cash or and buying or in one case or per year of the equity of ABC per year in another case per year, as you would get from buying XYZ equity irm ABC's debt payments given the first level of free cash flows (1 pt.). vel of free cash flows by copying cell D18 and pasting it onto cell D19 (1 pt.). 's equity dividends given the first level of free cash flows (1 pt.). level of free cash flows by copying cell E18 and pasting it onto cell E19. rm XYZ's debt payments given the first level of free cash flows (1 pt.). vel of free cash flows by copying cell F18 and pasting onto cell F19 (1 pt.). 's equity dividends given the first level of free cash flows (1 pt.). level of free cash flows by copying cell G18 and pasting it onto cell G19 (1 pt.). ows provided by owning 10% equity in company ABC given the first level of free lows provided by owning 10% equity in company ABC given the second level of could help to replicate the cash flows by making a cell reference to cell D23 (1 pt.). at could help to replicate the cash flows by making a cell reference to cell D23 (1 ash flows given the first level of free cash flows (1 pt.). ash flows given the second level of free cash flows (1 pt.). cash flows given the first level of free cash flows (1 pt.). cash flows given the second level of free cash flows (1 pt.). ash flows given the first level of free cash flows (1 pt.). ree cash flows by copying cell F29 and pasting it onto cell H29 (1 pt.). ows provided by owning 10% equity in company XYZ given the first level of free lows provided by owning 10% equity in company XYZ given the second level of t to borrow to help replicate the cash flows (1 pt.). nt of firm ABC's ownership to help replicate the cash flows (1 pt.). nds that you would receive given the first level of free cash flows (1 pt.). nds that you would receive given the second level of free cash flows (1 pt.). t that you would pay in interest given the first level of free cash flows (1 pt.). nterest given the second level of free cash flows by making a cell reference to cell evel of free cash flows (1 pt.). ash flows given the first level of free cash flows (1 pt.). ash flows given the second level of free cash flows (1 pt.). BC equity YZ equity