Question: Please solve on excel A 25-year, quarterly amortizing, fixed rate hotel mortgage loan for $. 300 mi has a contract rate of 5%. Closing costs
Please solve on excel

A 25-year, quarterly amortizing, fixed rate hotel mortgage loan for $. 300 mi has a contract rate of 5%. Closing costs worth $. 75000 and 2 discount points are applied. What is the periodic payment on the loan? PMT What is the total friction cost at origination? 10 What is the APR? APR 1c In the above problem, how many basis points should be charged as discount points for the APR to equal 5.5%? Use this box for your calculations Discount points A 25-year, quarterly amortizing, fixed rate hotel mortgage loan for $. 300 mi has a contract rate of 5%. Closing costs worth $. 75000 and 2 discount points are applied. What is the periodic payment on the loan? PMT What is the total friction cost at origination? 10 What is the APR? APR 1c In the above problem, how many basis points should be charged as discount points for the APR to equal 5.5%? Use this box for your calculations Discount points
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
