Performance task rubric · Business and Consumer Loans, Annuities and Cash Flows, Compound Interest

Loan comparison for a family decision

Task. A family needs ₱60,000 for a motorcycle used for deliveries. Compare at least three options (bank consumer loan, cooperative loan, in-house financing or a 5-6 lender) using amortisation schedules built in a spreadsheet. Compute the total interest and effective rate of each, and recommend an option in a short written advice note.

Learner / group

Criteria	4 · Excellent	3 · Proficient	2 · Developing	1 · Beginning	Weight	Score
Amortisation schedules	Schedules for every option are correct: periodic payment, interest, principal and balance columns reconcile to zero.	Schedules correct except a rounding carry-over.	One schedule has a formula error.	Schedules missing or incorrect.	30%	—
Comment on “Amortisation schedules”
Total interest and effective rate	Total interest and effective annual rate computed correctly for each option and compared in one table.	Totals correct; effective rate computed for some options.	Totals present but rates confused (nominal vs effective).	No totals or rates.	25%	—
Comment on “Total interest and effective rate”
Recommendation	Recommendation weighs cost, monthly affordability and risk; explains why the cheapest option may not be best.	Recommendation based on cost and affordability.	Recommendation based on one factor.	No recommendation.	25%	—
Comment on “Recommendation”
Clarity of advice note	Note is under one page, in plain language, with a summary table and correct peso formatting.	Clear note with minor formatting issues.	Note is hard to follow.	No written note.	20%	—
Comment on “Clarity of advice note”
Total					100%	0/4 scored

Scores and comments are computed on this page only and are not saved. Print or save as PDF to keep a record.