Question: the table is the correct answer i just want steps on how to do it without trying to find EBC for each combination this is

Consider an 8.5 percent, 30-year, $100,000 loan with fixed monthly payments. Assume upfront financing costs excluding discount points equal to 2% of the loan amount. Compute the effective borrowing cost (EBC) for different combinations of discount points and number of years the loan remains outstanding, i.e., until it is prepaid. Variations of discount points to consider: 0, 0.5, 1, 1.5, 2 and 2.5 percent. Variations of number of years the loan remains outstanding to consider: 2, 4,6,8,10 and 30 years. 105. See the table below. Discount Number of Years Loan is Outstanding Points 2 4 6 8 10 0.00 6.81% 6.44% 6.31% 6.25% 6.22% 0.50 7.09 6.58 6.42 6.34 6.29 1.00 7.36 6.73 6.52 6.42 6.36 1.50 7.64 6.88 6.63 6.51 6.44 2.00 7.92 7.03 6.74 6.59 6.51 2.50 8.20 7.18 6.85 6.68 6.58 30 6.14% 6.19 6.24 6.29 6.34 6.39 Consider an 8.5 percent, 30-year, $100,000 loan with fixed monthly payments. Assume upfront financing costs excluding discount points equal to 2% of the loan amount. Compute the effective borrowing cost (EBC) for different combinations of discount points and number of years the loan remains outstanding, i.e., until it is prepaid. Variations of discount points to consider: 0, 0.5, 1, 1.5, 2 and 2.5 percent. Variations of number of years the loan remains outstanding to consider: 2, 4,6,8,10 and 30 years. 105. See the table below. Discount Number of Years Loan is Outstanding Points 2 4 6 8 10 0.00 6.81% 6.44% 6.31% 6.25% 6.22% 0.50 7.09 6.58 6.42 6.34 6.29 1.00 7.36 6.73 6.52 6.42 6.36 1.50 7.64 6.88 6.63 6.51 6.44 2.00 7.92 7.03 6.74 6.59 6.51 2.50 8.20 7.18 6.85 6.68 6.58 30 6.14% 6.19 6.24 6.29 6.34 6.39
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
