| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for Bi-Weekly CDN Amortization Schedule
The Template Gallery has a wonderful Bi-Weekly Amortization Schedule however
it does not calculate Canadian Mortgages. I was wondering if anyone had such a schedule for Bi-Weekly payments or had converted the one online to do CDN Mortgages? Thanks so much, Nathalie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for Bi-Weekly CDN Amortization Schedule
How do CDN mortgages differ from the mortgage calculations used in the
template? Perhaps someone can explain how to convert them for you.... Dave -- Brevity is the soul of wit. "Nathalie" wrote: The Template Gallery has a wonderful Bi-Weekly Amortization Schedule however it does not calculate Canadian Mortgages. I was wondering if anyone had such a schedule for Bi-Weekly payments or had converted the one online to do CDN Mortgages? Thanks so much, Nathalie |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for Bi-Weekly CDN Amortization Schedule
try a google for
canadian biweekly:excel -- Don Guillett SalesAid Software "Nathalie" wrote in message ... The Template Gallery has a wonderful Bi-Weekly Amortization Schedule however it does not calculate Canadian Mortgages. I was wondering if anyone had such a schedule for Bi-Weekly payments or had converted the one online to do CDN Mortgages? Thanks so much, Nathalie |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for Bi-Weekly CDN Amortization Schedule
Canadian mortgages are compounded semi-annually, not annually.
-- Regards, Fred "Dave F" wrote in message ... How do CDN mortgages differ from the mortgage calculations used in the template? Perhaps someone can explain how to convert them for you.... Dave -- Brevity is the soul of wit. "Nathalie" wrote: The Template Gallery has a wonderful Bi-Weekly Amortization Schedule however it does not calculate Canadian Mortgages. I was wondering if anyone had such a schedule for Bi-Weekly payments or had converted the one online to do CDN Mortgages? Thanks so much, Nathalie |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for Bi-Weekly CDN Amortization Schedule
Fred Smith wrote:
"Dave F" wrote: How do CDN mortgages differ from the mortgage calculations used in the template? Canadian mortgages are compounded semi-annually, not annually. And at least some web sites say semi-annually instead of __monthly__ (for monthly payments). Personally, neither description works for me. In any case, the following example demonstrates the implication of the difference. For the US (et al), the monthly payment ($706.78) for a 300-month $100,000 loan at 7% is computed by: =pmt(7%/12, 300, -100000) But for Canada, the monthly payment ($700.42) for the same loan is computed by: =pmt(rate(6, 0, -1, 1+7%/2), 300, -100000) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Excel Template- Weekly Appt. Schedule by 15-min increments | Excel Discussion (Misc queries) | |||
| Can Excel create an amortization schedule? | Excel Discussion (Misc queries) | |||
| amortization schedule calc without interest rate known | Excel Discussion (Misc queries) | |||
| How do I do an amortization schedule knowing the princ, int rate,. | Excel Worksheet Functions | |||
| does anyone have a great Interest only amortization schedule wher. | Excel Discussion (Misc queries) | |||
Linear Mode
