| Course | MT431 Real Estate Finance and Ethics |
|---|---|
| Unit | Unit 2 |
| Paper type | Amortization schedule |
| Length | About 940 words, 6 pages double-spaced |
| Format | APA 7 student paper |
| School | Purdue University Global |
| Program | BS in Business Administration |
| Updated | October 2026 |
Free sample paper for MT431 Unit 2
Payment 240 Is Where Principal Wins: An MT431 Unit 2 Amortization Schedule for a $312,000 Loan
[Student Name]
Purdue University Global
MT431: Real Estate Finance and Ethics
Unit 2 Amortization Schedule
[Instructor Name]
[Date]
The loan is composite; every row was produced by the script described in the appendix and checked against the annuity formula, and the sources cited are real.
Inputs and the Payment
The loan amount is $312,000, the annual rate 6.875 percent and the term 360 monthly payments. The monthly rate is 0.06875 divided by 12, or 0.0057292. The payment comes from the level-payment annuity formula. The top of the fraction is one month's interest on $312,000, or $1,787.50; the bottom is one less the discount factor, where the discount factor is 1.0057292 raised to the power of minus 360, about 0.1279. Each term has a meaning. The numerator is one month's interest on the full balance; the denominator spreads repayment across the whole term so that every payment is the same. The result is $2,049.62.
How Each Row Is Built
Every row follows the same three steps. Interest equals the balance at the start of the month times the monthly rate. Principal equals the payment minus that interest. The new balance equals the old balance minus the principal. Interest is always charged on the declining balance, never on the original amount, which is why the split changes even though the payment does not.
Year One
The first payment is $1,787.50 of interest and $262.12 of principal, leaving a balance of $311,737.88. The first twelve rows read as follows.
1. Payment 1: interest 1,787.50, principal 262.12, balance 311,737.88
2. Payment 2: interest 1,786.00, principal 263.62, balance 311,474.26
3. Payment 3: interest 1,784.49, principal 265.13, balance 311,209.13
4. Payment 6: interest 1,779.90, principal 269.71, balance 310,404.59
5. Payment 9: interest 1,775.24, principal 274.38, balance 309,586.15
6. Payment 12: interest 1,770.50, principal 279.12, balance 308,753.55
Across the first year the borrower pays $24,595 in total, of which $21,349 is interest and only $3,246 reduces the loan. In the first year, about 87 percent of every dollar paid goes to the lender as interest.
After a full year of payments, the borrower has paid off about 1 percent of the loan.
The Crossover
Each month a little more of the payment goes to principal, because the balance it is charged on is a little smaller. At payment 239, interest is still $1,028.71 and principal $1,020.91. At payment 240, principal reaches $1,026.75 and interest falls to $1,022.86, the first time principal is larger. By then the balance is $177,509.47, and twenty years of the thirty have passed.
Year Thirty
The last year looks like the first turned upside down. Across payments 349 to 360, interest totals about $892 and principal about $23,703. The final payment, number 360, is $11.68 of interest and $2,037.94 of principal, which clears the balance exactly.
The Balance Over Time
A balance chart plots the remaining debt at each anniversary. After five years the balance is $293,295, down only 6.0 percent. After ten years it is $266,942, down 14.4 percent. After fifteen years it is $229,815, down 26.3 percent, and after twenty years $177,509, down 43.1 percent. The curve is shallow at first and steepens toward the end.
This matters because most borrowers do not keep a loan for thirty years. Campbell (2006) notes that many households sell or refinance well before maturity, and a borrower who sells after five years will have repaid only about $18,700 of a $312,000 loan while paying more than $104,000 in interest.
Adding $250 a Month
A short rerun adds $250 to every payment as extra principal, raising the monthly outlay to $2,299.62. The loan is paid off in 263 months instead of 360, about eight years sooner. Total interest falls from $425,862 to $292,588, a saving of about $133,274. Every extra dollar reduces the balance on which all future interest is charged, which is why the saving is so much larger than the $65,750 of extra payments. Agarwal et al. (2013) show how sensitive mortgage decisions are to the rate and the expected life of the loan, and prepayment is one of the simplest ways a borrower changes that life.
Why Lenders Front-Load Interest
The pattern is sometimes described as lenders taking their interest first, as if the schedule were designed in their favor. It is not. Each month's interest is simply the rate applied to what is still owed, and early in the loan almost everything is still owed. A borrower who wanted equal shares of principal each month would face much larger payments at the start and smaller ones at the end. The level payment trades that shape for predictability, and the amortization schedule is the record of what that trade looks like month by month.
What the Schedule Shows
The payment never changes, but what it buys does. Early payments mostly rent money; late payments mostly repay it. For a buyer expecting to move within ten years, the schedule shows that little equity will come from paying down the loan, and most will come from any change in the home's value. Stanton and Wallace (1998) showed that expected time in the loan also decides whether paying points to lower the rate makes sense, which is the question the Unit 3 comparison takes up.
Appendix
All 360 rows are produced by a short script that applies the three steps in a loop, rounds each row to the cent for display while carrying full precision, and prints the payment, interest, principal and balance for each month. Its output is the full table the excerpts above are drawn from.
References
Agarwal, S., Driscoll, J. C., & Laibson, D. I. (2013). Optimal mortgage refinancing: A closed-form solution. Journal of Money, Credit and Banking, 45(4), 591-622. https://doi.org/10.1111/jmcb.12017
Campbell, J. Y. (2006). Household finance. Journal of Finance, 61(4), 1553-1604. https://doi.org/10.1111/j.1540-6261.2006.00883.x
Stanton, R., & Wallace, N. (1998). Mortgage choice: What's the point? Real Estate Economics, 26(2), 173-205. https://doi.org/10.1111/1540-6229.00743
Reading the MT 431 Unit 2 instructions
Unit 2 asks students to build an amortization schedule for a fixed-rate mortgage and to interpret it. Instructors expect the inputs stated and the payment derived from the annuity formula, not just copied from a calculator. Every row must charge interest on the declining balance, with principal equal to the payment minus that interest. Tables need headings and payment numbers so they can be read. Excerpts from the first and last years, a balance chart and the point where principal overtakes interest are common requirements. Many prompts add an extra-payment scenario. Interpretation matters: the schedule should be connected to how long the borrower is likely to keep the loan and what that means for equity. A script or spreadsheet producing the full table is usually attached.
How the MT 431 Unit 2 example is put together
This example opens with the inputs and the payment, explaining what each part of the formula does. A section sets out the three steps behind every row. Year-one excerpts show the split, under a highlighted line on how little of the loan a year of payments retires. The crossover at payment 240 is shown with the rows on either side of it. Year thirty is set against year one. The balance section reports the remaining debt at four anniversaries and, citing Campbell, what that means for a borrower who sells after five years. The extra-payment rerun and Agarwal and colleagues follow. A section on why interest is front-loaded corrects a common misreading, and the appendix describes the script.
Reading the MT431 Unit 2 grading rubric
Amortization schedules are usually graded on correct arithmetic first: a payment that ties to the formula and interest charged on the declining balance. Errors there undermine every later row. Rubrics reward labeled tables with payment numbers and clear headings. Credit goes to interpretation beyond the table, such as what the early-year split means for a borrower who moves. Identifying the crossover payment and charting the balance show understanding. An extra-payment scenario rerun in full, rather than estimated, earns method credit. Explaining why interest dominates early, without suggesting the schedule is rigged, shows conceptual accuracy. A full table in an appendix, with the tool that produced it, lets graders check any row.
MT431 Unit 2 help from the desk
The most common weak schedule charges interest on the original loan amount every month, which makes every row wrong after the first. Another frequent error copies a payment from an online calculator without showing where it comes from. Tables often lack payment numbers or column headings. Many papers present the table and stop, with no sentence about what the early years mean. Extra-payment scenarios are often estimated by subtracting the extra amount from total interest. Before submitting, check that your final row's balance is zero, or within a few cents, and that total principal across all rows equals the amount borrowed. If either fails, the error is in the rate per period or in how the balance carries forward.
Get an 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. The paper above is an original model document written by our desk, not a submitted student paper and not an official Purdue University Global document.
More MT431 papers and BS in Business Administration samples
- MT431 Unit 1: Cost of Borrowing Board Post
- MT431 Unit 3: Loan Comparison Analysis
- MT431 Unit 4: Borrower Qualification Worksheet
- MT431 Unit 5: Refinance Break-even Analysis
- MT431 Unit 6: Seminar Reflection
- MT431 Unit 7: Income Property Pro Forma
- MT431 Unit 8: Ethics Case Analysis
- MT431 Unit 9: Fair Lending Memo
- MT431 Unit 10: Financing Recommendation
- MT423 Unit 2: Risk Tolerance Assessment
- MT422 Unit 2: Return and Risk Calculation
- MT421 Unit 2: Personal Budget Analysis
- MT400 Unit 2: Process Architecture Outline
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.
Where can I find a free MT431 Unit 2 sample paper?
You can read the complete MT431 Unit 2 schedule here, with excerpts from years one and thirty and the full 360 rows in the appendix.
How much does $250 a month save in the MT431 Unit 2 sample?
About $133,274 in interest, and the loan ends in 263 payments instead of 360, about eight years sooner.