Principal overtakes interest only in payment 240 on a composite $312,000 loan at 6.875 percent, and this Unit 2 schedule for MT431 prints every row leading there. Searches like "mt 431 unit 2 assignment example", "mt431 unit 2 sample" and "mt431 unit 2 example" land here.
What a finished MT431 Unit 2 amortization schedule looks like
Five pages plus an appendix. Page one states the inputs, $312,000, 6.875 percent and 360 monthly payments, and derives the $2,049.62 payment from the annuity formula with each term labeled. A twelve-row excerpt covers year one: the first payment splits into $1,787.50 of interest and $262.12 of principal, and the year closes with $21,349 of interest against $3,246 of principal. A second excerpt covers year thirty, where the split has nearly inverted to $892 and $23,703. A balance chart plots the remaining debt at each anniversary, down only 6.0 percent by year five and 14.4 percent by year ten. A short section adds $250 a month to principal and reruns the table, and the full 360 rows sit in the appendix beside the script that produced them.
How a MT431 Unit 2 example is structured
Formula, excerpts, chart and variation make up the order, each answering a question the one before it raises. The payment derivation comes first so that every row can be checked against it: interest is the prior balance times the monthly rate of 0.5729 percent, and principal is whatever remains of $2,049.62. Year-one and year-thirty excerpts then sit on facing pages, since the contrast carries the lesson better than any sentence could. Two milestones follow, drawn from the script rather than eyeballed from the chart: payment 240, where principal first exceeds interest, and payment 260, where the balance finally drops below half. The prepayment section recalculates the schedule with $250 added each month, ending the loan in month 263, about 21.9 years in, and saving $133,275 of interest. What the table means for a buyer likely to move within a decade is spelled out at the end.
The payment, derived
The annuity formula applied to $312,000 at a monthly rate of 0.5729 percent over 360 periods, yielding $2,049.62, with each symbol defined.
Year one against year thirty
Twelve rows from each end of the loan, showing $21,349 of interest in the first year and $892 in the last.
Where the lines cross
Payment 240 as the first in which principal exceeds interest, and payment 260 as the one that finally takes the balance below $156,000.
What five years buys
$122,977 paid, $18,705 of it principal, leaving $293,295 owed if the home is sold or refinanced at that point.
An extra $250 a month
The same loan retired in 263 payments with $133,275 less interest, drawn as a second balance line on the chart.
Where marks go in MT431 Unit 2
Graders tend to begin with the arithmetic. A payment that does not tie to the formula, or interest charged on the original amount rather than the declining balance, undermines every row after it. Unlabeled tables cost credit as well, because an amortization schedule exists to be read, and columns without headings or payment numbers defeat that purpose. Many rubrics ask for interpretation beyond the table, so a schedule presented without a sentence on early-year equity looks like software output rather than analysis. Crossover and halfway points shown as computed rows, rather than estimates, earn more. A prepayment scenario is not always required, but when included it has to rerun the whole schedule instead of subtracting months by guesswork. Rounding drift, where stray cents accumulate into a final payment that no longer matches, draws comment too.
Get a MT431 Unit 2 example written to your instructions
Loan amount, rate and term are the only inputs a Unit 2 schedule needs, whether the prompt states them or a case borrower supplies them; include the rubric too. Built in Excel or Python as your section expects, the free first schedule prints all 360 rows, derives the payment and returns in 24-48h; any prepayment scenario requested reruns the table in full.
MT431 Unit 2 questions, answered
Why is so little principal paid in the early years?
Each payment first covers interest on the current balance, and the balance is largest at the start. On a $312,000 loan at 6.875 percent, the first month's interest is $1,787.50, so only $262.12 of a $2,049.62 payment reduces debt. As the balance shrinks, interest falls and the principal share grows, slowly at first and quickly near the end.
Should the MT431 schedule be built in Excel or by script?
Either works if your instructor permits it, so check the prompt. Excel's PMT, IPMT and PPMT functions produce the same figures as a script, and both should tie to the annuity formula. Whichever tool is used, include the formula or code so the grader can trace a row, and round consistently to avoid a final payment that drifts by several dollars.
How do extra principal payments change the table?
They reduce the balance immediately, so every later interest charge is smaller and the loan ends sooner. The required payment stays the same on most fixed-rate loans; only the payoff date moves. Rerun the entire schedule rather than estimating, because the savings compound. In the sample, $250 more each month removes about eight years and $133,275 of interest.