create and print loan schedule

I would like to create a loan amortization schedule for a 
96,000 dollar loan with a monthly repayment schedule of 
$1,800 at 6 percent interest.  Is this possible with 
Microsoft money?
0
anonymous (74722)
10/3/2004 4:34:24 PM
money 28651 articles. 7 followers. Follow

2 Replies
383 Views

Similar Articles

[PageSpeed] 59

In microsoft.public.money, Bruce wrote:

>I would like to create a loan amortization schedule for a 
>96,000 dollar loan with a monthly repayment schedule of 
>$1,800 at 6 percent interest.  Is this possible with 
>Microsoft money?

Yes. Here is the resulting amortization table.


:       Loan Amortization
:       loan test



:              Payment       Payment                                           Principal
:  Date     Number        Amount     Principal      Interest      Balance

:            Opening Balance                                                     96,000.00

: 10/03/04          1      1,800.00      1,320.00        480.00      94,680.00
: 11/03/04          2      1,800.00      1,326.60        473.40      93,353.40
: 12/03/04          3      1,800.00      1,333.23        466.77      92,020.17
: 01/03/05          4      1,800.00      1,339.90        460.10      90,680.27
: 02/03/05          5      1,800.00      1,346.60        453.40      89,333.67
: 03/03/05          6      1,800.00      1,353.33        446.67      87,980.34
: 04/03/05          7      1,800.00      1,360.10        439.90      86,620.24
: 05/03/05          8      1,800.00      1,366.90        433.10      85,253.34
: 06/03/05          9      1,800.00      1,373.73        426.27      83,879.61
: 07/03/05         10      1,800.00      1,380.60        419.40      82,499.01
: 08/03/05         11      1,800.00      1,387.50        412.50      81,111.51
: 09/03/05         12      1,800.00      1,394.44        405.56      79,717.07
: 10/03/05         13      1,800.00      1,401.41        398.59      78,315.66
: 11/03/05         14      1,800.00      1,408.42        391.58      76,907.24
: 12/03/05         15      1,800.00      1,415.46        384.54      75,491.78
: 01/03/06         16      1,800.00      1,422.54        377.46      74,069.24
: 02/03/06         17      1,800.00      1,429.65        370.35      72,639.59
: 03/03/06         18      1,800.00      1,436.80        363.20      71,202.79
: 04/03/06         19      1,800.00      1,443.99        356.01      69,758.80
: 05/03/06         20      1,800.00      1,451.21        348.79      68,307.59
: 06/03/06         21      1,800.00      1,458.46        341.54      66,849.13
: 07/03/06         22      1,800.00      1,465.75        334.25      65,383.38
: 08/03/06         23      1,800.00      1,473.08        326.92      63,910.30
: 09/03/06         24      1,800.00      1,480.45        319.55      62,429.85
: 10/03/06         25      1,800.00      1,487.85        312.15      60,942.00
: 11/03/06         26      1,800.00      1,495.29        304.71      59,446.71
: 12/03/06         27      1,800.00      1,502.77        297.23      57,943.94
: 01/03/07         28      1,800.00      1,510.28        289.72      56,433.66
: 02/03/07         29      1,800.00      1,517.83        282.17      54,915.83
: 03/03/07         30      1,800.00      1,525.42        274.58      53,390.41
: 04/03/07         31      1,800.00      1,533.05        266.95      51,857.36
: 05/03/07         32      1,800.00      1,540.71        259.29      50,316.65
: 06/03/07         33      1,800.00      1,548.42        251.58      48,768.23
: 07/03/07         34      1,800.00      1,556.16        243.84      47,212.07
: 08/03/07         35      1,800.00      1,563.94        236.06      45,648.13
: 09/03/07         36      1,800.00      1,571.76        228.24      44,076.37
: 10/03/07         37      1,800.00      1,579.62        220.38      42,496.75
: 11/03/07         38      1,800.00      1,587.52        212.48      40,909.23
: 12/03/07         39      1,800.00      1,595.45        204.55      39,313.78
: 01/03/08         40      1,800.00      1,603.43        196.57      37,710.35
: 02/03/08         41      1,800.00      1,611.45        188.55      36,098.90
: 03/03/08         42      1,800.00      1,619.51        180.49      34,479.39
: 04/03/08         43      1,800.00      1,627.60        172.40      32,851.79
: 05/03/08         44      1,800.00      1,635.74        164.26      31,216.05
: 06/03/08         45      1,800.00      1,643.92        156.08      29,572.13
: 07/03/08         46      1,800.00      1,652.14        147.86      27,919.99
: 08/03/08         47      1,800.00      1,660.40        139.60      26,259.59
: 09/03/08         48      1,800.00      1,668.70        131.30      24,590.89
: 10/03/08         49      1,800.00      1,677.05        122.95      22,913.84
: 11/03/08         50      1,800.00      1,685.43        114.57      21,228.41
: 12/03/08         51      1,800.00      1,693.86        106.14      19,534.55
: 01/03/09         52      1,800.00      1,702.33         97.67      17,832.22
: 02/03/09         53      1,800.00      1,710.84         89.16      16,121.38
: 03/03/09         54      1,800.00      1,719.39         80.61      14,401.99
: 04/03/09         55      1,800.00      1,727.99         72.01      12,674.00
: 05/03/09         56      1,800.00      1,736.63         63.37      10,937.37
: 06/03/09         57      1,800.00      1,745.31         54.69       9,192.06
: 07/03/09         58      1,800.00      1,754.04         45.96       7,438.02
: 08/03/09         59      1,800.00      1,762.81         37.19       5,675.21
: 09/03/09         60      1,800.00      1,771.62         28.38       3,903.59
: 10/03/09         61      1,800.00      1,780.48         19.52       2,123.11
: 11/03/09         62      2,133.73      2,123.11         10.62           0.00

: Grand Total           111,933.73     96,000.00     15,933.73           0.00


0
via_newsgroup (13114)
10/3/2004 4:54:11 PM
By creating the loan account. If you don't want the actual account in MS 
Money, simply delete it after creating the report. There may be another way 
to produce this report, but I'm unaware of it without poking around.
-- 
Chris Cowles,
Gainesville, FL

"Bruce" <anonymous@discussions.microsoft.com> wrote in message 
news:2f4801c4a966$d7d9f3c0$a401280a@phx.gbl...
>I would like to create a loan amortization schedule for a
> 96,000 dollar loan with a monthly repayment schedule of
> $1,800 at 6 percent interest.  Is this possible with
> Microsoft money? 


0
NoSpam1246 (979)
10/3/2004 6:48:34 PM
Reply:

Similar Artilces:

How does one view a document created in Publisher.
I have gotten a document (calendar) in .pub format. Word does not recognize it. Is there a viewer? What's the link? I have Office 2000 with the converters installed. Collins wrote: >I have gotten a document (calendar) in .pub format. Word > does not recognize it. Is there a viewer? What's the > link? I have Office 2000 with the converters installed. ==================================== There is no viewer for Publisher files. Maybe you could ask the sender to convert it to a .pdf file. Or you could order the Trial version of Pub2003... which will still function as a viewer a...

Fixed printing page breaks
Hello I am trying to set fixed page breaks (excel 97) I have set the print area (3 pages) I have set the fitting (3 pages) I have put pages breaks (2) The printing is fine on my printer but it changes the page breaks when printed from other printers (ie: start of page 2 appear at the bottom of page 1) please help, I am dying... thanks ben When you set the print to fit option it calculates the reduction in page size. Change your selection after your print to fit back to the "adjust to" option and you page breaks will work. Lance >-----Original Message----- >Hello &...

Creating conditional clause in a module
I am in the process of writing module using vba in ACCESS 2003 which imports forecasted financial data from a particular excel file based on three inputs. I am trying to include an "error check" that will end the process if the three inputs do not match specific data in the excel file. I'm not sure how to go about doing this. Do you have any ideas what the best way to do this would be? Below is the code I have for the import part so far if that is helpful. Sub Test1() Dim ImportDir As String Dim Forecast As String Dim Version As String Dim Country As Stri...

Printing Issues when distributing a form to multiple users
I am distributing a spreadsheet to multiple users. The spreadsheet is being used as a form for data entry. The problem i am having is that when it is being printed, the users are getting varying page layouts where the page breaks have changed, due the changes to the length of the document growing from the free text they are entering. The page breaks that excel chooses don't seem to be spaced well, leading to one or two of the pages being very short (i.e., leaving a lot of free white space), whereas the other pages are taking up the entire page. Is there a particular page layout selection...

How to create web-based reports from RMS database.
The reports available in RMS is not specific enough for my apparel retail store. I need sell the through rate, average sale, sales/sf, return rate, discount analysis, all broken down by date, week, month, year, category, supplier, and then compare against last year's numbers. I want to create my own web-based reports accessing RMS's SQL database. Does anyone have a template of data access web page so all I have to do is change the SQL statement in getting to the right database table? mas wrote: > The reports available in RMS is not specific enough for my apparel retail > ...

MRP not creating planned orders in version 10.0
I'm testing version 10.0 on a test system and using a copy of my live database. Version 8.0 creates a planned PO when QTY Available falls below Order Point Qty. It's not working in 10.0. I've checked all my settings from 8.0 to 10.0 and they all look the same. Is there a setting I'm missing? Thanks, Ken Have you rebuilt your low level codes after the upgrade? -- Tim Foster "KRoy" wrote: > I'm testing version 10.0 on a test system and using a copy of my live > database. Version 8.0 creates a planned PO when QTY Available falls below > Ord...

cant print spread sheet with lines on it
i am trying to put some info onto excel but when i print it out i only get the print and not the grid lines can somebody tell me the correct settings thanks. File > Page Setup > Sheet tab > Put a checkmark in 'Gridlines'. Hope this helps. George Gee "steve earle" <steve earle@discussions.microsoft.com> wrote in message news:6017023B-592D-400B-A671-8B65C1BB02A4@microsoft.com... >i am trying to put some info onto excel but when i print it out i only get > the print and not the grid lines can somebody tell me the correct settings > thanks. t...

How to use excel file created in version earlier than 4.0a in 4.0
Thanks to whomever answered my query but when I opened the email the screen was blank. My laptop is sick. My question was and still is, how can I use my Excel files created in a recent version on my laptop in my PC which is loaded only with Excel 4.0a . Please and thanks. -- Thanks, Ajimmo Hi Ajimmo You can't, the file format changes twice since version 4. You need a newer Excel version, a compatible spreadsheet program, or simply a viewer if all you want to do is view / print the file. HTH. Best wishes Harald "ajimmo" <ajimmo@discussions.microsoft.com> skrev i m...

id like to know where i can find a template for repay of a loan
...

Create Pivot Table Reports
I just finished installing Analysis Cube on the server, everything seemed working fine until when I try to create the Pivot Table Report (Tools->Analysis Cubes->Create Pivot Table Reprots). After I called up the pre-defined 'Definition ID' and click on the Excel icon, a message popped up saying " The WHTemplate.XLT file was not found." Anybody have any idea what that is, and how to resolve it?? Thanks. 1.) There are two pieces of software. Did you install both the server piece, and the client piece? 2.) Is Excel installed on the machine, on which you'r...

How do I print a list of my E-mail folders?
I need to print a list of my e-mail folders. "AHD23" <AHD23@discussions.microsoft.com> wrote in message news:5BFD12CA-5D55-4376-AF9C-58703042577D@microsoft.com... >I need to print a list of my e-mail folders. I don't believe there's a way to do that, except as a screen shot. -- Brian Tillman [MVP-Outlook] This might be a workaround for you: http://www.vboffice.net/sample.html?mnu=2&smp=12&cmd=showitem&lang=en In example #1, replace the line LoopItems Folder.Items by Debug.Print Folder.Name After running the code,...

Help with creating a formula
Hello! I am trying to create a formula that will sum up certain criteria from one column as it relates to criteria in the same row in another column. For example, I want to sum up all the entries that begin with the letter "H" in column A as it relates to an entry of "2" from column B that is in the same row as the "H" entry from column A. COLUMN A COLUMN B H10 2 G01 2 H09 3 H15 2 H12 2 If there is such a formula...

Creating only a mailbox
I'm doing some DR testing and I was wondering if there is any way to create just a mailbox that isn't associated with an AD account. I could create an account with a mailbox and then disconnect it, but I'd like a way to build hundreds of mailboxes that aren't associated with any AD account. Any help would be great. Thanks. Eric In AD just add it as a Contact instead of a user, this will allow you to give it exchange attributes without an AD account. >-----Original Message----- >I'm doing some DR testing and I was wondering if there is >any way to cre...

Auto-create activity from Mobile
Hi all, We have CRM 4.0 Roll Up 7. We are looking for a solution that offers advanced mobile integration to CRM. We would like the mobile client to auto-generate an Activity in CRM whenever a phone call is made to a CRM contact. Has anyone done this? //Johan Johan; There are a few vendors that offer good mobile solutions. I know for certain that MobileAccess from Ten Digits (http://www.tendigits.com/) has that specific feature. Dave Ireland "Jobro" <Jobro@discussions.microsoft.com> wrote in message news:4F1B3A1D-E23E-4E49-933F-B221C0DD1ECE@microsoft.com... >...

set a reminder to print or edit in an excel document
Is there a way to set a reminder to print part of a workbook or edit a workbook on a certain day. I need to print and edit a workbook on a certain day at a certain time, but I can never remember to do this. Is there any way of setting a reminder alarm or notification. Thanks > Is there a way to set a reminder to print part of a workbook or edit a > workbook on a certain day. ... If you have Excel, you might be using Outlook also. Both are part of Office 2003. Outlook has a "calendar" feature that pops up reminders the user can schedule. I use it all the ti...

How do you print the last page of an 8 page banner in Publisher?
When I make a large banner, I would like to select a particular page to print. The print preview option allows selection of pages 1,2, etc but does not allow for example only the last page. Print to a PDF... http://www.primopdf.com/ -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "FredSC" <FredSC@discussions.microsoft.com> wrote in message news:78386D22-8473-4EC8-A032-82F802A26C59@microsoft.com... > When I make a large banner, I would like to select a particular page to > print. The print preview option allow...

Print multiple copies per sheet
I have a pubisher file that is a card with a size of 5 x 6 and is 2 pages. Is it possible to print 2 copies of this file on a letter size page so that there will be 2 double sided copies on the letter size page. I need to laminate these cards so if I could get 2 per page I would just need to cut the page in half. I am using Publisher 2003. Thanks in advance for any help. Best regards, Dee Page setup, Business card, change copies per sheet, Side margin 1.25, top margin ..5, zero gaps, okay out, in the next screen change the measurements to width 6" height 5". The above will...

How do I print labels after I have mailmerge on excel
?I saved my addresses in Excel. I want to print them on labels How do I do that? Also how can I get a picture on the labels? Bika, do a mail merge with word. For help on Word mail merge using Excel as the data source have a look here http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Ex...

"Print to Scale" Excel 2007 Charts
In Excel 2003, one could double-click a chart, print, and the chart would auto-size to fill a page. I am unable to print my newly-created Excel 2007 charts so they auto-size to print one-to-a-page (now requires several time-consuming steps for reformatting titles, axes, etc.). I do not have a "print to scale" option in my page setup. Printing to a Ricoh Aficio AP610N. Thanks so much. I will assume we are talking of an embedded chart (one sitting on a worksheet) and not a chart sheet. In Excel 2003 (all earlier) you did not double click, you just single clicked to...

not enough memory or disk space to display or print the picture after 1st time
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC I know this topic has been covered before, but not in the way I get the problem. I can open a document with a math formula or a graphic the FIRST time and it will correctly display. Any changes to the document or any subsequent openings I then get the error message, &quot;not enough memory or disk space to display or print the picture&quot;. <br><br>eMac 1.25 Gz 10.4.6, Word 2004 <br><br>Thanks. One possible cause: You're *way* behind on Tiger -- it's been at 10.4.11 for ...

Schedule Exchange PS scripts
Can anyone point me at a reference on how to schedule powershell scripts for Exchange? I have tried a reference I found, but it doesn't work with Exchange powershell: powershell -nologo -noninteractive -command " {C:\PSScripts\script.ps1}" I tried this instead, but it states that & isn't allowed. Removing it didn't work either. C:\WINDOWS\system32\WindowsPowerShell\v1.0\PowerShell.exe -PSConsoleFile "C:\Program Files\Microsoft\Exchange Server\bin\exshell.psc1" -noexit -command ". 'C:\Program Files\Microsoft\Exchange Server\bin\Exchange.ps...

Dbl sided printing problem
I am making a "Program" for a Barbershop Chorus concert using MS Publisher in the "Catalog" mode (which prints both sides of course.) I cannot seem to find out what kind of paper I can get (short of photo imaging paper) that is opaque enuff to prevent the backside of a page from showing through the "white areas" of the front side. It's not a bleed-through, it's just that the paper is to darn translucent. I am using 24 lb inkjet paper with an inkjet printer. I am sure this is anything but a new problem, but I have not found anything in the Goog...

Publisher 2000 print problem
What we see in the working document and what goes to print is different. Is there a way to enter the print preveiw document to fix it at that point. There seems to be no way to resolve this issue??? Please help if you can. ...

re-print an RTV packing slip
There should be a way to re-print an RTV packing slip after the RTV shipping has been processed. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=8f250615-702c-4e00-8f24-f90...

Printing Custom sized booklet in Publisher 2000
The printer settings for a Riso machine on a network do not hold when sending copy to the Riso machine for printing. Anyone have any ideas about settings for custom sized paper in a booklet? If I could have the steps needed in order, it would help. Thanks. Maybe here http://www.riso.com/public/tipsorter.asp I don't know if Riso handles printing any different than other printers. In page setup, set your printer, then the page setup. -- Mary Sauer MS MVP http://office.microsoft.com/ http://www.mvps.org/msauer/ news://msnews.microsoft.com "Kathryn Ketcham" <anonymous@di...