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

Please solve on excel A 25-year, quarterly amortizing, fixed rate hotel mortgage

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

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 Accounting Questions!