Create a Microsoft Excel spreadsheet that will replicate example 13-11 in your textbook. This should be fairly easy (see figures in the book that provide useful formulas for this activity). One change that needs to be added is the use of WACC instead of a given interest rate. Your model should be able to accommodate different tax rates. Your submission should generate Table 13-2 and Table 13-3 as well as Figure 13-8. The optimal life should be identified.

Review the rubric below before submitting your assignment.