We will use Excel PMT function to calculate the payment Rand then create an amortization schedule for the problem below: The Turners have purchased a house for $250,000. They made an initial down payment of $50,000 and secured a mortgage with interest charged at the rate of 6%/year on the unpaid balance . Interest computations are made at the end of each month . Assume that the loan is amortized over 15 years . Determine the size of each installment such that the loan is amortized at the end of the term Type the raw data of P, r, m, t into cells Calculate i by its definition Calculate n by its definition Calculate R by Excel function PMT. Note : please reference in PMT What will be their total interest payment ?
We will use Excel PMT function to calculate the payment Rand then create an amortization schedule for the problem below: The Turners have purchased a house for $250,000. They made an initial down payment of $50,000 and secured a mortgage with interest charged at the rate of 6%/year on the unpaid balance . Interest computations are made at the end of each month . Assume that the loan is amortized over 15 years . Determine the size of each installment such that the loan is amortized at the end of the term
Type the raw data of P, r, m, t into cells Calculate i by its definition
Calculate n by its definition
Calculate R by Excel function PMT. Note : please reference in PMT What will be their total interest payment ?
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
