Worked example · EX:time-value-of-money-and-financial-mathematics/cedar-works-loan-schedule

Build and reconcile Cedar Works' analytical loan schedule

Compute a level monthly payment, allocate the first rows between interest and principal, and reconcile the full analytical schedule.

Updated Aug 7, 2026 Review due Nov 7, 2026
Worked-example setupScope and assumptions
  • The $48,000 principal is outstanding at month 0; 48 equal payments occur at month-end.
  • The 6 percent stated annual rate converts to 0.5 percent per month and remains fixed.
  • The schedule is analytical and does not round payment, interest, principal, or balance each month.
Period
Month 0 through month 48
Units
USD and decimal rate per month
Rounding
Retain full precision in the schedule; display illustrative rows to cents.

The monthly rate is 0.06 / 12 = 0.005. The level payment is:

$48,000 × 0.005 / [1 - (1.005)^(-48)] = $1,127.281394…

The first two analytical rows are:

Month Opening Interest Principal Payment Closing
1 $48,000.00 $240.00 $887.28 $1,127.28 $47,112.72
2 $47,112.72 $235.56 $891.72 $1,127.28 $46,221.00

Interest falls because it applies to a smaller opening balance. Principal reduction rises because the total payment remains level.

Across all 48 full-precision rows, principal reductions sum to $48,000, total interest is $6,109.5069…, and ending principal is zero within numerical tolerance. A contractual schedule that rounds every row to cents may adjust the last payment and need not reproduce these analytical decimals exactly.

The schedule does not include fees, insurance, taxes, default, prepayment, affordability, disclosures, or a borrowing recommendation. Accounting entries and classification require separate applicable guidance and period facts.

Verified calculation · time value analysis

The curriculum loader recomputed this example before it entered the site build. Expand any structured input to inspect the stated facts.

loans
1 field
Inspect data
{
  "equipment_loan": {
    "payment_periods": 48,
    "payment_timing": "end-of-period",
    "payments_per_year": 12,
    "principal": 48000,
    "rounding_policy": "unrounded-analytical",
    "stated_annual_rate": 0.06
  }
}

Recomputed result

Values recomputed by the curriculum loader
MeasureValue
ending balance0
payment1,127.2814
periodic rate0.005
total interest6,109.5069
total payments54,109.5069
total principal48,000