Mortgage Interest (Calculated)
I used the wizard to set up my home mortgage. It is a direct debit from my
Credit Union savings account. As I am preparing for taxes I ran through the
Tax Estimator and there is $0 showing for Itemized Deductions, #4 Mortgage
Interest. I went to the Bill Summary page, went to edit the payment, then
the split and it shows Mortgage Interested as (Calculated). Why doesn’t this
pick up on the Tax Estimator, Itemized Deductions, #4 Mortgage Interest
automatically? What do I do to force it?
"Doug" <Doug@discussions.microsoft.com> wrote in message
news:0E84D4AE-436B...are multiple interest rates per card supported?
Hi, I was wondering... most credit cards I own have
multiple credit card rates in effect at the same time.
0% intro APR, ends in 6 mo. 8.99% after that
Cash Advance: 18.94%
Balance Transfer: 9.99%
My statements keep these balances separate, but can Money
track these differences too?
It'd be nice if these various rates were reflected in the
In microsoft.public.money, Larry Kyrala wrote:
>My statements keep these balances separate, but can Money
>track these differences too?
It cannot do what you are envisioning.
...how to calculate compound interest ?
Operating System: Mac OS X 10.6 (Snow Leopard)
I would like to put in a spread sheet a compounded rate of return calculator that the user would only have to put in present value, time period, interest rate <br><br>Example: $25,000 present value <br>
1% interest rate <br>
&n...Why can I not open an Excel Compound file with Office Excel xp?
I receive Excel files via e-mail from my head office that can't be opened
with Office xp. As close as I can tell, these files are called "Compound
Excel Files". I can't find any explanation of what a Compound File is and
why I wouldn't be able to open it. In addition, when I notified the office,
they cut out the pertinent information segment of the file and re-sent it.
Surprisingly, I was able to open it. They claim they didn't change the
format or program.
There's information on compound documents in the following article:
Using a Dual File Format i...Currency exchange rate problem
i am using MS Money2006. my default currency is set to ?. one of my account
is in different currency. the problem is it does not calculate the current
value of that account in ? using the current exchange rate. it takes the
older and the same exchange rate.
where can i change the setting so that it always takes the actual current
...interested in learning visual basic in access 2007
Can anyone guide me where I can get started with visual basic for access
2007? Is there any free web site offering courses for VB in Access 2007.
I found these:
http://learnaccessvba.com/ (Access 2003)
You can also find quite good introductions in the Help if you browse rather
than search. Hit Alt-F11 to bring up the (scary!) VBA development
environment and browse the Help there.
It's a highly concentrated subject, though, and expect it to take time to be
How do I get the value of R
Dr. Sachin Wagh
MBBS, DHA, DPH
"Dr. Sachin Wagh" <DrSachinWagh@discussions.microsoft.com> wrote in message
> N=5 (years)
> How do I get the value of R
The easy way is Tools > Goal Seek
Another way is that R= ((1403/P)^(1/N))-1
solved the problem
thanx a ton David!
"David Biddulph" wrote:
> "Dr. Sachin Wagh" <DrSachinWagh@discussions.m...WMP 11
Hi. I am finally ripping my cd collection and digitizing it. I am using
Windows Media Player 11 on Windows XP Home Edition. I have all the updates,
Does ripping in MP3's have a constant-bit rate? I swear I saw the option in
the options tab somewhere, but only the .wma files seem to have constant bit
rate or variable bit rate.
I know some ripping programs have the cbr or vbr choice for mp3's. What is
it in the wma 11 player? I can't find anything in the help topics for the
program or on the pages in the links from the help file. Maybe I missed
something, I d...Compounded Annual Growth Rate (CAGR)
Is there a formula in Excel that returns the Compounded Annual Growt
Rate(CAGR)? For example, I have a column with Yearly $ amounts with 1
years of data. With a financial calculator, if I have the starting
amount, the ending $ dollar amount and the number of years(or periods)
I can calculate the CAGR. Can Excel do something similar with the data
Message posted from http://www.ExcelForum.com
If you want the annualized rate, and have the start and end values, use:
If these values are in cells, it might look like:
-...Annual Percentage Rate
I am trying to calculate annual percentage rate for a mortgage estimate. The
Formula works as long as I don't use a rate above 5.5% and term in months
above 310. I need to calculate using 360 month term.
Also I need to combine 1st and 2nd lien loan info into a single APR. Anyone
know how to creat this;
Here is the formula I Have been using:
Data is as follows:
B1 = 110410 (Loan Amt)
B2 = 6.5% (Interest Rate)
B3 = 3360 (Estimated Closing Costs)
B4 = 360 (Term)
It would help the function converge if you offer it an init...need help..Simple, compound, complex, compound-complex examples
Need to write a paragraph on the four sentence types...Just need to have an
example of each type....please someone help!! Thanks
On 30/05/2010 4:18 PM, Peggylynne wrote:
> Need to write a paragraph on the four sentence types...Just need to have an
> example of each type....please someone help!! Thanks
and some of the other sites that appear when you google for the subject
of your post.
Hope this helps,
Doug Robbins - Word MVP
Please reply to the newsgroup unless you want to obtain my services on a
I would like to have an online database that works with a e-commerc
website. I am going to have all the inventory set at 0's. When th
first order is made I would like it to start an email to be compose
with the product name and number. I want the email sent out at 4pm t
one address everyday. Is there anyway to do with working with Excel an
Hendy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=471
View this thread: http://www.excelforum.com/showthread.php?threadid=...0.4677629 I Have An Interest ... 0.9484228
0.5064431 I Have An Interest ... 9.796143E-02
0.4677629 Now Visit Tobacco Is Drugs 0.9484228
How would I make a Fx. that would add $500 + 4% interest each mouth?
A1 B1 C1
ie 500 +4% =
=+500 +4% =
=+500 +4% =
in C1 put =A1*1.04
In A2 put =C1
Copy both down as far as you ned.
> How would I make a Fx. that would add $500 + 4% interest each mouth?
> A1 B1 C1
> ie 500 +4% =
> =+500 +4% =
> =+500 +4% =
that is not adding the $500 add each mouth, it needs to be A.500 + 4%, than
add B.500, and then A+B+4%, and so on
> Hi Jason
> ...Compound Interest Rate or Growth Rate
Is there a function in Excell that can be used to calculate an investment"s
compound growth rate? If so what is it and how do you use it?
For instance if someone invested $10,000 in 1985 and that investment was
worth $18,000 today is there a function in Excell that can be used to
determine that investment's compound growth rate?
Try this. E11 has 18,000 and D11 has 10,000. D11 has 2010 and D10 has 1985
Microsoft Excel MVP
"1944-71222" <firstname.lastname@example.org> wrot...Currency Exchange rates do not update!
Following the last M05 major update, I noticed that the currency
echange rates do NOT update online (automatically) anymore. If one goes
onto settings / currencies, their is a check box for online update -
but it does not seem to work. Any advice?
...Interested in Microsoft CRM
My company is a Financial Services company that is interested in implementing
MS CRM. This would initially be done for the Investment Advisory portion of
our business and later implemented for the rest of the organization. Are
there any MS CRM customers/clients in the Investment Advisory business that
can comment on their deployment of MS CRM and there overall experience as far
as usage of this solution? Also, can you comment on whether the solution was
useful without customization or was there customization to the product. If
there was customization, then how much (% amount) and wh...Exchange 2007 SCL rating
I have setup a quarantine mailbox, and configured all the content filters.
Eveything seems to be working, but when i look at the SCL rating on a
quarantined email in the quarantined inbox the SCL rating is -1. This cant be
correct, because emails with an SCL rating that =7 get quarantined, so it
appears that i cam not seing the real SCL rating on the email. how can i
expose this ? i know i can look at the headers of the eamil but uit says -1
not 7 as it should
SCL rating of -1 is assigned to authenticated senders, as also senders on
Safe Sender lists, from IP addresses on IP ...Mortgage Compounded Daily and Paid Monthly
Does anyone know how to set up a mortgage/loan so that the payment interest
and principle are calculated based on compounding the balance daily instead
of monthly, which seem to tbe the default? Quicken gave the user the option
of selecting that the loan was compounded daily, monthly, ...
Money doesn't have that level of detail. What I do is enter the term,
payment, etc., and let Money calculate the interest rate. It may be off
slightly from the bank's. At the end of the year, I reconcile it to the
mortgage statement. A simple once-a-year adjustment is easy enough.
Chris Co...Compound Rate (again!)
I deposit Rs. 2574 each year for 21 years
At the end of 21 years I get Rs. 129635
How do I understand the Compound Rate thats' been applied
Regards & Thanx
Dr. Sachin Wagh
MBBS, DHA, DPH
In article <A567B75F-728B-4986-AAF4-0830386AF800@microsoft.com>,
Dr. Sachin Wagh <DrSachinWagh@discussions.microsoft.com> wrote:
> I deposit Rs. 2574 each year for 21 years
> At the end of 21 years I get Rs. 129635
> How do I understand the Compound Rate thats' been applied
> Regards & Thanx
SORRY, Not ...OT: and Out of Interest. HTML Token Sizes?
Hello ASPNET Forum,
I have a question regarding HTML Tokens. I am unable to successfully query Google
for relevant results to my question. Is there anywhere I can find information on
HTML Tokens and their corresponding sizes, and render times. I understand that
there would be many factors that would determine size and draw/render times, but
is there any base standard.
That is; Which would be largest in size, and which would take longest to load (and
render)? Something like,
<div></div> is larger in size (bytes? something like that), than a <p></p&...compound interest formula
Ok, I have a material cost in cell A1 - todays date in A2, the date the
material will be delivered in A3, and an inflation value in A4 (%per annum).
I need a formula that will work out what the material will cost when the
material is delivered.
eg. costs £100 today at a rate of 5%per annum it will cost £105 next year
and £110.25 in two years.
All input values are in seperate cells and can vary. Also it will have to
cope with fractions of a year.
Set A2 and A3 to "Date" format.
A5 = A1*(1+A4)^((VALUE(A3)-VALUE(A2))/365)
...Just Out of Interest
I was wondering, when Microsoft sit down to write the next version of
Excel, say for 2006, does anyone know how they decide what to add or
amend or remove?
Yes is probably an unsatisfying reply, but Yes, of course. Those people are
not allowed to answer your follow-up question, so don't ask it.
Best wishes Harald
"Steve" <email@example.com> skrev i melding
> I was wondering, when Microsoft sit down to write the next version of
> Excel, say for 2006, does anyone know how they decide what to add o...Pay Rate on DD Earnings Statement
Did anything change with the Direct Deposit Earnings Statement in the Year
End Update? My old DD Earnings statement prints the Pay Rate from the Pay
Code window. Now that the Year End update has been applied, the Pay Rate on
the DD Earnings Statement shows the rate per hour. For instance, the salary
pay rate for an employee is $56,559.60. This is the amount that used to show
in the Pay Rate. It now shows $27.19 which is $56,559.60/2080 hours. I just
wanted to make sure that this changed in the year end update.
I need to work out compound interest on =A350. If I have=20
=A350 at 5% per year compound, how much will it be in 5=20
Sorry, but I have absolutely no idea how to figure this=20
one out. Tried the following formula =3DNOMINAL(50,5) but=20
it came up with a wierd answer.
Any help would be most appreciated. Thanking you in=20
On 5/6/04 8:50 AM, in article firstname.lastname@example.org,
> I need to work out compound interes...