Canadian Mortgage Financing Comparison

I'm looking for a spreadsheet that can demonstrate the following details:

* payment amount - monthly, semi-monthly, accelerated bi-weekly and accelerated weekly

* interest paid over term

* interest paid over amortization

* savings if the bi-weekly or weekly option are taken - $ and amortization

Please keep in mind that interest in Canada is calculated semi-annually, which is different than most other areas. I also need it to calculate the numbers with monthly compounding but only demonstrate it if that option is selected.

Here are the items for entry by the user that will determine the output:

* client name

* prepared by

* mortgage amount

* interest rate

* first payment date (optional)

* term of mortgage (in months)

* amortization of mortgage (in years)

* compounding frequency - semi-annually or monthly

As part of the output, please include an amortization schedule for the term selected

Compétences : Excel

en voir plus : mortgage amortization excel spreadsheet, canadian numbers, canada numbers, financing, monthly mortgage payment, excel mortgage, mortgage monthly payment, canadian amortization, term frequency, option spreadsheet, monthly mortgage, excel mind, excel financing, interest monthly payment, calculate payment interest, calculate years excel, need comparison, mortgage excel, excel client, schedule excel, calculate monthly payment, excel schedule, canadian mortgage, calculate mortgage interest excel, spreadsheet calculate

Concernant l'employeur :
( 2 commentaires ) Toronto, Canada

Nº du projet : #1637661

Décerné à:


Hi.. I would like to apply for the job.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(10 Commentaires)

2 freelance font une offre moyenne de $70 pour ce travail


Hi, I can do it. Please check the demo of a morgage sheet. I can modify to suit you need in adding comparison options. I can also write a VBA macro to generate all scenarios and highlight best scenario according your Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(20 Commentaires)