|
10-26-03, 08:30 PM
| #1 (permalink) |
| Cal Poly Forum  Joined: Sep 2003 Location: Pomona
Posts: 5,265
 |  Finance Amortization Table Computer Project Use an electronic spreadsheet to prepare an amortization schedule for a $300,000.00, 30-year home loan. Assume that interest, in annual percentage rate, is 6.25%. The loan will be paid back in fixed monthly payments. Your excel spreadsheet should be designed to compute all of the output numbers by formulas. That is, if one changes any input number, the output should be adjusted automatically. Save your work on a diskette and have it available in case you are asked to turn it in. Observe the pattern of payments for interest and principal for the entire life of the loan. Turn in a one-page printout containing the following information: a) The amortization table for the first 3 months and the last 3 months (hide the rest of the monthly data). b) The formula cell table corresponding to the numbers in part (a) above. c) A short paragraph, describing the pattern of payments for interest and principal.
__________________ SLOPomona Cal Poly Forums |
|      |
 |
| Bookmarks |
| Thread Tools | Search this Thread |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| New Product Development Project Construction, Implementation and Continual Improvemen | Cal Poly RSS | University Newsletters | 0 | 07-19-11 09:52 AM |
| Improved Commuter Rail Workstation Table through Crash Energy Management | Cal Poly RSS | University Newsletters | 0 | 06-09-10 08:41 AM |
| Dr. Carney FRL383 Real Estate Finance | Admin | Professor Evaluation | 2 | 05-10-08 02:21 PM |
| Serious Flaws In Windows Leave Your Computer Open to Attack | Admin | General Discussions | 12 | 02-17-06 11:39 PM |
| Accounting ACC 207A Quickbooks Project | Admin | Classwork & Homework | 1 | 05-22-04 01:59 PM |
