DSC2604 :Excel workbook with worked out examples and formula's

Compund interest of loan Repayment
Sensitivity analysis
Price amount 450000 Annual rate
Annual rate 11.25% 11.25%
Deposit 0 10.00%
Loan amount 450000 10.25%
Number of years 25 10.50%
Number of payments 300 10.75%
11.00%
11.25%
Monthly payment -R4,492.08 11.50%
Total amount paid -R1,347,623.39 11.75%
12.00%
Total interest paid -R897,623.39

, Sensitivity analysis
Monthly Payment
-R4,492.08