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

the table is the correct answer i just want steps on how to do it without trying to find EBC for each combination
the table is the correct answer i just want steps on how
to do it without trying to find EBC for each combination this
this is the whole question. im just trying to figure out how he made the table

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!