Construction of an Amortization Schedule
MarcoPolo239SEE EXCEL TEMPLATE - ATTACHED
You plan to purchase a $750,000 home using a 30-year mortgage obtained from a local commercial bank.
The mortgage rate offered is 5.25 percent and requires a 20 percent down payment.
a. What are the monthly payments on the mortgage?
b. Construct the amortization schedule for the first 10 payments.
see chart on excel file
c. If the rate offered was 7.50 percent, what would the monthly payments be?
d. If a 15-year mortgage with a 4.50 percent rate and 20 percent down payment was obtained for the purchase, what would the monthly payments be?
- 7 years ago
- 8
Answer(1)
Purchase the answer to view it
- amortazation_schedule.xlsx
Bids(1)
other Questions(10)
- please respond to my TWO CLASSMATE BELOW ( FOLLOW THE GUIDE CAREFULLY)
- i need someone who can assist me to my homewok
- Finite Analysis PROF DOUBLE R
- human resources
- United States
- Week 1 Discussion - Responses - Econ
- BUS402 Week 4 Quiz New (2017)
- Assessing Stakeholder Needs
- Application: Choosing an Alternative: Which Option is the Most Cost-Effective?
- Essay