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...

Hello I am trying to make a pivot table with a custom "Grand total" calculation. 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 Excel 07? <kmack1982@gmail.com> wrote... >What are the benefit(s) of creating an amortization schedule in MS >Excel 07? As opposed to doing it manually with paper, pencil and an 80 year old printed table of compound interest rate accumulation factors? Homework? ...

Hello, 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 ? Thnak you 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. ...

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, £102,259.98, £103,787.57, £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...

Greetings! 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 matter! Uchenna ...

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...

I WOULD LIKE TO GET A AMORTIZATION SCHEDULE. DOES WORKS (VERSION 7) ALLOW ME TO DO THIS. ANY HELP APPRECIATED crabby 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" <mcrabby@hotmail.com> wrote in message news:00dd01c3577d$e0c63340$a301280a@phx.gbl... > 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 news:eHGefFTSFHA.3336@TK2MSFTNGP10.phx.gbl... > Will MS Money 03 amortize loans and manipulate the numbers? None of the > boxes or the salespeople know. Money ...

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...

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 -- Don Guillett SalesAid Software donaldb@281.com "Bradley M. Small" <BSmall@XNOSPAMXmjsi.com> wrote in message news:OcAFd9u%23DHA.2480@TK2MSFTNGP12.phx.gbl... > I would like to create a ma...

how do i create amortization tables in Excel 2003 You can either create one yourself with Excel's financial functions; see http://office.microsoft.com/en-us/excel/HA011117451033.aspx or use one of many templates, like these: http://office.microsoft.com/en-us/templates/results.aspx?qu=amortization&av=TPL000 -- Kind regards, Niek Otten 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 ...

Hi all, 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, or can it be automated by using a macro ? Many thanks in anticipation Joe Deacon ....... Knowledge expanding........ Try this: http://www.mvps.org/access/general/gen0041.htm yeah totally 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, 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 ...

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. hth "NBgorf" <NBgorf@discussions.microsoft.com> wrote in message news:AEB6478C-AC2D-4B01-A7CA-050BF2BA75D7@microsoft.com... > Yesterday I had something like 296 empty messages in my sent box. No > subject, > no addressee but the date is there. Some have the...

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 these. http://img2.uploadimages.net/116085Money_2003_all_of_a_sudden_cant_amortize.JPG and img2.uploadimages.net/538467Money_2003_all_of_a_sudden_cant_amortize-Heres_b ill_details.JPG Thanks Sorry, I accidentally put the server name in the username field....

How do you use an amortization schedule when the interest rates change frequently? 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 > frequently? ...

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" <dhunsaker@prodigy.net> wrote in message news:071701c34bb2$0fee4040$a001280a@phx.gbl... > When paying extra principal on my mortgage the ...

I can't find a loan amortization table that will accept a term of 40 years; the max is 30. Can anyone help? Thanks -- Sue W. "jjbud44" wrote: > 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'...

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... http://office.microsoft.com/en-us/templates/CT101443641033.aspx also, The free Excel add-in "Calculate Payments" could be helpful. Download from... http://www.realezsites.com/bus/primitivesoftware No registration required. -- Jim Cone San Francisco, USA "Linda W" <LindaW@discussions.microsoft.com> wrote in message Is th...

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...

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 Robert Thanks, Dick. According to Microsoft, that's the answer, combined with not entering an interest rate. Robert "Dick Watson" <littlegreengecko@mindspring.com> wrote in message news:%235DPofGZDHA.2960@tk2msftngp13.phx.gbl... > Set the balloon payment equal to t...

How do i "unlock" the Amortization Schedule so that I can add columns for aditional data Hi Tools > Protection > Unprotect sheet. -- Wigi 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 ...

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) Thank you! a combination of dividing by 12 and multiplying by 12. play with it -- Don Guillett SalesAid Software dguillett1@austin.rr.com "ROXYAWORLD" <ROXYAWORLD@discussions.microsoft.com> wrote in message news:46CED19F-2119-43B7-8BC1-57710F6E008D@microsoft.com... >I am wan...