Question: I need help ASAP please. (: Q2 & Q3: APR and EBC Calculations 1. Use Excel formulas to calculate and compare the two loan's APRs


I need help ASAP please. (:
Q2 & Q3: APR and EBC Calculations 1. Use Excel formulas to calculate and compare the two loan's APRs in Question 2. Assume you hold the loan until maturity. Remember that APR considers interest rate, loan fees (points"), and applicable closing costs. For the sake of simplicity there loan fees, but no closing costs in this assignment. a. Calculate the APR for both loans b. Which loan would you choose and why? (One or two sentences is sufficient) 2. Fill out the blank blue cells to compare the two loan's Effective Borrowing Costs (EBC) in Question 3. Assume you will not hold the loans until maturity. If necessary, feel free to perform additional calculations off to the side in Exce Calculate the EBC for both loans Which loan would you choose and why? (One or two sentences is sufficient) a. b. Q2 & Q3: APR and EBC Calculations 1. Use Excel formulas to calculate and compare the two loan's APRs in Question 2. Assume you hold the loan until maturity. Remember that APR considers interest rate, loan fees (points"), and applicable closing costs. For the sake of simplicity there loan fees, but no closing costs in this assignment. a. Calculate the APR for both loans b. Which loan would you choose and why? (One or two sentences is sufficient) 2. Fill out the blank blue cells to compare the two loan's Effective Borrowing Costs (EBC) in Question 3. Assume you will not hold the loans until maturity. If necessary, feel free to perform additional calculations off to the side in Exce Calculate the EBC for both loans Which loan would you choose and why? (One or two sentences is sufficient) a. b
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
