Canadian Mortgage - Amortization table

I need to recalculate some of the old mortgage documents with slightly different parameters.

You can design your own program or even better, simply create an Excel spreadsheet OR even find an existing free application one on the internet.

The formulas that are used must be for Canada. (There is a difference for mortgage calculation for the US and Canada)

Attached is a file for testing. The solution must show PRECICELY the same results if the same initial parameters are entered.

I need to be able to set payment term (monthly/weekly/bi-weekly etc) and compounding term (Annually/semi-annually/monthly etc)

IMPORTANT: there is a condition that does not allow me to use lots of free mortgage calculators with amortization tables, which is the whole reason why I post this project here. All these calculators calculate the monthly payments for me. I need to be able to set my own monthly payments. So let us say, all calculators show that for some conditions I need to pay $[url removed, login to view] monthly but the actual payments were rounded and set at $410.00, therefore I need to have an ammortization table according to my actual payments of $410.00 per month.

## Deliverables

create an Excel spreadsheet OR find an existing free application one on the internet that can work for my purpose or an application on .NET with the source code.

## Platform

MS Excel or .NET

Evner: PHP

Se mere: canadian amortization, ms bi, mortgage amortization excel spreadsheet, monthly mortgage payment, excel mortgage, mortgage monthly payment, table month php, mortgage program, design project calculation, monthly mortgage, php table excel, excel table php, monthly mortgage program, php excel table, create excel formulas, mortgage file, calculate monthly payments, program calculate monthly payments, mortgage excel, php rounded code

Om arbejdsgiveren:
( 44 bedømmelser ) Canada

Projekt ID: #3323397

Tildelt til:


See private message.

$17 USD in 7 dage
(4 bedømmelser)

2 freelancere byder i gennemsnit $17 på dette job


See private message.

$17 USD in 7 dage
(2 bedømmelser)