Go Back   CDN Business Directory > Main Category > Financial Planning

 
 
Thread Tools Display Modes
 
Old 08-28-2006, 02:02 AM
dapperdobbs
Guest
 
Posts: n/a
Default Re: Repay or Invest Calculation?


Simple is x% - y% and adjust for prepayment penalty in year one. But if
you want to see the numbers:

add 1 (one) to (x%-y%)
R = return (1+(x%+y%))
P = prepayment penalty
A = amount of money you're talking about
S1 = net savings in period one (one year)
n = number of years

then A*R - P = S1

which you extend to

A*R^n - P = Sn

However ... it gets a little more complicated than that since
C = changes in your income result in
Td = tax bracket changes (delta)
which affects
Md = your mortgage deductibility
all of which is subject to
Gu = unpredictable changes in tax laws

Get a piece of tax software to get real after-tax numbers, and input
numbers for several years. Then you can adjust x% and y% accordingly.

  #-1  
Old 08-27-2006, 10:43 AM
Beep
Guest
 
Posts: n/a
Default Repay or Invest Calculation?

I have extra funds at my disposal, I have 2 choices
- Invest in CD's, MF's, stocks etc
- Pay back extra money into my home loan.

Assume I will make x% in the first option.
Assume my home loan rate is y%.

Ignoring any tax benefits for/against paying
back the home loan, how would I calculate
which would be the better option for me.

I am not looking for online calculators, but rather
looking for a way to calculate this myself - can
some financial wiz help me how to go about it.

Also, if I had to factor in a pre-payment penalty
how would that change the equation.

 

Tags
calculation, invest, repay
Similar Threads
Thread Forum Replies Last Post
YTM calculation for TIPS?
Rich Carreiro: (and I mean TIPS, not iBonds) Anyone know how the YTM calculation is done for TIPS? I know how to do it for normal bonds, but there the...
Financial Planning 3 04-14-2006 01:42 AM
Repay signing bonus
topsocket: I received a small signing bonus with a job I may be leaving. The condition of the binus requires 100% repayment if I leave before a specified...
Taxes 3 04-15-2005 11:24 PM
Calculation of Ann. Ret.
Retired Trader: Does anyone know how Money 2004 calculates the Ann. Ret. in the stock portfolio???? I get different percentages when I do it manually. Thanks for...
Microsoft Money 1 01-07-2005 07:37 AM
Interest Calculation
Joey: Is there a way to configure Money (either on a loan-by- loan basis or system-wide) so that it calculates the interest portion of my loan payment...
Microsoft Money 1 01-16-2004 03:33 AM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 12:35 AM.