Interest Only Loan w/o Routine Payments
I'm looking for advice on how to set up a loan in MS Money 2007 Home &
Business. This is an on demand loan (a loan which is repayable on
demand, rather than on a specific date) to a relative with a fixed
interest rate but no periodic payments or end date. Hopefully I will
get ocassional payments of interest only but those will be sporatic
until her business takes off.
As interest payments come in I would like to record them as interest
earned but still not touch the principle until that starts getting
paid off. The traditional loan setup in Money doesn't quite fit the
situation...Pivot table compound interest
Hello I am trying to make a pivot table with a custom "Grand total"
For example I need to calculated compound interest in the grand total
field. Is this possible?
Suppose 10% return every month (Jan-Dec)compounded monthly.
jan feb mar ... TOTAL
2001 10% 10% 10%... 313.8%
2002 10% 10% 10%... 313.8%
2003 10% 10% 10%... 313.8&
TOTAL = exp(sum(log(1+n))
ANY HELP IS APPRECAITED!!!!
What are the benefit(s) of creating an amortization schedule in MS
>What are the benefit(s) of creating an amortization schedule in MS
As opposed to doing it manually with paper, pencil and an 80 year old
printed table of compound interest rate accumulation factors?
...How to represent this amortization
I was wondering how I simulation an loan amortization of this type.
I have a loan called 30/15. Basically it is calculated over 30 years but
need to be paid in 15. What would be the best way to set it up ?
In microsoft.public.money, Thomas Poteau wrote:
>I was wondering how I simulation an loan amortization of this type.
>I have a loan called 30/15. Basically it is calculated over 30 years but
>need to be paid in 15. What would be the best way to set it up ?
If you know the payments, enter that data. Leave the interest blank
for Money to compute.
...Impact of Fees on Growth Rate
I have been using the following formula to calculate growth but the answer
looks incorrect where there is an inital fee for each regular payment or an
initial fee as indicated below:
Fee £250 Initial Inv £100000 Net Investment £99750 then £500 per month
growth 1%, applied monthly, and income of 3%. The results are £100,747.50,
£105,330.45, £106,888.76, £108,462.64 using the formula:
RATE(6,-500,-100000+500,108462.64,1) it gives an answer of 0.92% which looks
about right but if I use a monthly rate of...Interest
How should I update the interest owed on a student loan.
The interest that Money has calculated is completely off
b/c I just now put the loan into Money, but have actually
had the loan for quite some time. Should I do an account
adjustment? If I do this, will Money think I am changing
the principal? I'd appreciate any help concerning this
...Money Deluxe Plus won't download NSF fees for the same day.
I sometimes have 3 overdraft or NSF charges in the same day, however, Money
Deluxe Plus won't download all 3 charges.. just the first one. I then have
to manually enter.. or go to my banks website to manually download for that
day. I know there is a setting in MSM somewhere.. but I cant find it.
Please help me
In microsoft.public.money, dizzblnd wrote:
>I sometimes have 3 overdraft or NSF charges in the same day, however, Money
>Deluxe Plus won't download all 3 charges.. just the first one. I then have
>to manually enter.. or go to my banks website to manually d...AMORTIZATION
I WOULD LIKE TO GET A AMORTIZATION SCHEDULE. DOES WORKS
(VERSION 7) ALLOW ME TO DO THIS.
ANY HELP APPRECIATED
Please don't SHOUT. It hurts my eyes and is entirely unnecessary.
If Works version 7 has a spreadsheet component, yes, it can be used to
generate an amortization table.
"CRABBY" <firstname.lastname@example.org> wrote in message
> I WOULD LIKE TO GET A AMORTIZATION SCHEDULE. DOES WORKS
> (VERSION 7) ALLOW ME TO DO THIS.
Will MS Money 03 amortize loans and manipulate the numbers? None of the
boxes or the salespeople know.
Money has a type of account, the Loan Account, for amortized loans. It has a
type of transaction, the Loan Payment, that calculates interest expense and
Principal Transfer components of each payment.
That may or may not answer your question.
"Asussertown" <DROPsussertown@adelphia.net> wrote in message
> Will MS Money 03 amortize loans and manipulate the numbers? None of the
> boxes or the salespeople know.
Money ...problem with loan interest and principal
I have a 10 year student loan I'm paying off. I set it up correctly and
each month the amount was entered and the interest amt declined and the
principal increased and the payment numbers advanced as they should.
Then suddenly it stopped doing that and got stuck on payment number 3
and keeps giving me the same principal and interest amt. It has done
this now for about 7 months, except for one month when it suddenly gave
me a payment number 6. I've looked at the loan account settings and
everything looks ok for the original amount and the interest rate,etc.
When I look at the amortizat...Amortization table
I would like to create a macro that creates an amortization table.
Something like putting in the present value, rate, and number of months then
have excel use as many rows as necessary to output the princ/int values.
Can this be done? Is there a sample somewhere that does anything like this?
Why not try recording and then changing rows to a variable controlled by
years in a cell/12
"Bradley M. Small" <BSmall@XNOSPAMXmjsi.com> wrote in message
> I would like to create a ma...amortization tables
how do i create amortization tables in Excel 2003
You can either create one yourself with Excel's financial functions; see
or use one of many templates, like these:
Microsoft MVP - Excel
"Mpho" <Mpho@discussions.microsoft.com> wrote in message news:39A31A72-2793-402D-A1D1-FA45B6D64920@microsoft.com...
| how do i create amortization tables in Excel 2003
...Very Interesting Request
Does anyone know if it is possible to automate by way of a control on
a form, a way for a database to be compacted and reparied instead of
telling the inexperienced data base user how to select this fucntion
from the tools menu,
can it be automated by using a macro ?
Many thanks in anticipation
Joe Deacon ....... Knowledge expanding........
use Access Data Projects; SQL Server has 'Database Maintenance Plan Wizard'
and it is easy to use with SQL Agent in order to automate this type of stuff
MD...Excel template: Loan Amortization for random/irregular payments, .
Excel template: Loan Amortization for random/irregular payments, figures days
between payment dates.
I have a loan with a variable beginning balance and irregular payments with
annual large payment. (based on collections)
Would like to enter payment and date.
then Excel would figure days since last payment, interest amount, principal
amount, Ending Principal balance.
And total interest paid, total pricipal paid
If I change the starting principal, excel would recalculate all entries.
I have tried to use Mr Excel on Excel example on page 389 for random
payments, but it does not work.
I ...why is it that lately my sent mail fills up with EMPTY messages?
Yesterday I had something like 296 empty messages in my sent box. No subject,
no addressee but the date is there. Some have the opened envelop icon and
some are closed. What is going on????
Virus, malware, spyware whatever you may call it. You do need to scan your
system with MSE immediately.
"NBgorf" <NBgorf@discussions.microsoft.com> wrote in message
> Yesterday I had something like 296 empty messages in my sent box. No
> no addressee but the date is there. Some have the...Money Stopped Amortizing Loans
For some unknown reason, Money stopped amortizing ALL loans in its system.
I noticed this when reasearching for info for taxes.
All amortized loans are no longer being amortized.
Since its often hard to convey something I see, which doesn't have any MS
error to list, I've done screen captures. For visual details, please view
Sorry, I accidentally put the server name in the username field....amortization schedule
How do you use an amortization schedule when the interest rates change
as far as i know, your gonna have to change the intrest rate on your work
sheet to match whats on the index. and hopefully everything is linked where
all the payments should update.
"peggy metro" wrote:
> How do you use an amortization schedule when the interest rates change
...How do I put mutliple amortization templates in same file
I want to run several scenarios using the amortization templates but I want
them in the same file--just on different worksheets. How do I do this?
When paying extra principal on my mortgage the loan
amortization payment number stops and starts over again at
payment number one.
Was there a question here?
Seriously, loan payment numbers tend to do lots of flaky things. I have a
loan that pays weekly and it flat refuses to number them.
Whatever. Number them yourself if you care; you can change these at will.
Personally, I'd leave an extra principal payment number blank.
"dave" <email@example.com> wrote in message
> When paying extra principal on my mortgage the ...loan amortization template
I can't find a loan amortization table that will accept a term of 40 years;
the max is 30. Can anyone help?
> I can't find a loan amortization table that will
> accept a term of 40 years; the max is 30.
> Can anyone help?
Usually that's just because they decided to copy their amortization schedule
formulas down only 360 rows or so. They might also have some validation
checks that would need to be tweaked.
But it should not be difficult to modify. If you wish, send me your
favorite template, and I'...Amortization Table
Is there an amortization table in Excel with Office 2000 Professional. If so,
how do I access it? If not where can I get one free. I need to figure
payments for a 3 year loan at 10% interest.
Microsoft has a loan amortization schedule here...
The free Excel add-in "Calculate Payments" could be helpful.
Download from... http://www.realezsites.com/bus/primitivesoftware
No registration required.
San Francisco, USA
"Linda W" <LindaW@discussions.microsoft.com>
wrote in message
Is th...simple interest formula in excel
I would like to know the formula to be used for calculation of Simple
interest in excel . For compount interest it is Fv as i gather
There are many formula for calculating compound interest by the month o
by the day etc.
The calculation for simple interest is the amount of loan outstandin
times the interest rate for the period, which, for a 10% rate charge
monthly would give you
Loan outstanding * 10 / 1200
However, you might need to check the law in your country, and the
ensure that no interest is charged on any previous interest debited.
This could occur if a payment were not received...Interest Only Mortgages
Does anyone know how to set up an interest-only mortgage using Money 2004
Standard? The help file refers to 'endowment mortgages', which seem similar
to what I need, but there doesn't seem to be any way of establishing an
endowment mortgage, despite the program acknowledgingthe concept.
Thanks, Dick. According to Microsoft, that's the answer, combined with not
entering an interest rate.
"Dick Watson" <firstname.lastname@example.org> wrote in message
> Set the balloon payment equal to t...amortization schedule
How do i "unlock" the Amortization Schedule so that I can add columns for
Tools > Protection > Unprotect sheet.
http://www.wimgielis.be = Excel/VBA, soccer and music
"Billy Hatcher" wrote:
> How do i "unlock" the Amortization Schedule so that I can add columns for
> aditional data
...How do I change the values in loan amortization
I am wanting to use the loan amortization spread sheet, and was wondering how
you change the values as I want to change Loan period in Years to calculate
Loan period in Months?? I have tried several things but not having a great
knowledge on using Excel im failing miserably! PLEASE HELP!!! :O)
a combination of dividing by 12 and multiplying by 12. play with it
"ROXYAWORLD" <ROXYAWORLD@discussions.microsoft.com> wrote in message
>I am wan...