Question: thats what i have Homework Problem Based on your choice from the Mortgage Problem worksheet (either the 15 year plan or 30 year plan), can

 thats what i have Homework Problem Based on your choice from
thats what i have

Homework Problem Based on your choice from the "Mortgage Problem" worksheet (either the 15 year plan or 30 year plan), can you build an additional schedule which will allow you to make additional payments (to help speed up paying off your mortgage and saving on interest)? Can you project how much time and interest will be saved it on your first five payments you pay an additional $1,000 each time? Here is an example of how the title of your loan schedule should look: Payment Schedule (PMT) (IPMT) (PPMT) Outstanding Period Payment Interest Principle Balance Below is a copy of how your Dato Section should be set up to drive your payment schedule Data Section Annual Rate: Number of periods (or payments) per year, Number of Years: Number of Periods (npor): Rate per period (rate): ? Present Value (pv): ? Future Value (fv): ? Payment (PMT) =PMT(rate,nper.pv.fv.type); ? Type (type): ? Homework Problem Based on your choice from the "Mortgage Problem" worksheet (either the 15 year plan or 30 year plan), can you build an additional schedule which will allow you to make additional payments (to help speed up paying off your mortgage and saving on interest)? Can you project how much time and interest will be saved it on your first five payments you pay an additional $1,000 each time? Here is an example of how the title of your loan schedule should look: Payment Schedule (PMT) (IPMT) (PPMT) Outstanding Period Payment Interest Principle Balance Below is a copy of how your Dato Section should be set up to drive your payment schedule Data Section Annual Rate: Number of periods (or payments) per year, Number of Years: Number of Periods (npor): Rate per period (rate): ? Present Value (pv): ? Future Value (fv): ? Payment (PMT) =PMT(rate,nper.pv.fv.type); ? Type (type)

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!