Weighted average cost of capital Personal Finance Problem John Dough has just been awarded his degree in business. He has three education loans outstanding. They all mature in 5 years and he can repay them without penalty any time before maturity. The amounts owed on each loan and the annual interest rate associated with each loan are given in the following table: John can also combine the total of his three debts (that is, $64,000) and create a consolidated loan from his bank. His bank will charge an annual interest rate of 8.6% for a period of 5 years. Should John do nothing (leave the three individual loans as is) or create a consolidated loan (the $64,000 question)? The weighted average - X Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Loan 1 2 3 | Balance due $27,000 $11,000 $26,000 Annual interest rate 7.5% 10.5% 6.5%