Excel Financial Capital Structure 8 Problems

1. Answer the eight problems in the “Capital Structure Problems 1"
2. Please submit all answers in a single Excel file. 
3. Please show all formulas to show an understanding of the concepts. 
4. Please show all calculations, step by step, performed by using Excel, and all answers should be thoroughly explained.
 

They are:

1. The Capital Structure 8 Problems
2. Bond Valuation: how to value bonds using Excel functions.
3. Stock Valuation: how to value bonds using Excel functions.
4. Time Value of Money Examples
5. Capital Budgeting: how to use NPV, IRR, MIRR Excel functions