1)
APR:-
=RATE(25*12,-10800,1800000*80%)*12
=7.67%
EAR:-
=(1+7.67%/12)^12-1
=7.94%
2)
=PV(rate,pmt,pv)
=PV(20.2%/12,36,-32)
=858.70
3)
=PV(rate,nper,pmt)
=PV(5.3%/12,4*12,-450)
=19425.49
Bulk Purchases just purchased a new warehouse. To finance the purchase the form arranged for a...
Question 9 3 pts You have just purchased a new warehouse. To finance the purchase, you've arranged for a 25-year mortgage for 80 percent of the $1,800,000 purchase price. The monthly payment on this loan will be $10,800. What is the APR? The EAR? 7.75 percent; 8.03 percent 07.67 percent; 8.03 percent O 7.72 percent; 7.94 percent 7.72 percent; 8.03 percent 7.67 percent; 7.94 percent
You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 25-year mortgage for 75 percent of the $3,600,000 purchase price. The monthly payment on this loan will be $17,700. What is APR?
Suppose you've just purchased a new warehouse for $4,500,000. To finance the purchase, you've arranged for a 30-year mortgage for 80% of the $4,500,000 purchase price. The monthly payment on this loan will be $27,500. What is the APR on this loan? What is the EAR?