Assignment 15 Amortization - teched-resources



93345-123825Lesson (11) Loan Amortization Answers0Lesson (11) Loan Amortization AnswersType your Name : FORMTEXT ????? Grade level: FORMTEXT ?????You will use this sheet with the amortization spreadsheet lesson. Please place all answers in the spaces provided Save this sheet and the Excel spreadsheet in a folder called EXCEL under a sub folder called called LOAN. Please type all your information that you find out on the spreadsheet and again save the spreadsheet and this paper in the folder called LOAN. When you have completed this lesson, staple this page to the top of the Two Assignments below that you must printout. (1 and 3) those are the only two (2) you must printout the other assignments are just softcopies for you to determine the answers that will be displayed on the screen and write below. Please follow the directions listed underneath and fill in the correct answers. The H stands for hard copy to be printed out. Respect guidelines on this instructional page to set up your spreadsheet.Page Layout - Page setup – Header/Footer – Custom Header - place your name and grade level on the left side.Click on the tab called Sheet and Place a check under Gridlines and Rows and columns headings, (this should already be existing as I saved your spreadsheet this way.You will enter the information listed below in the first three columns on your spreadsheet and then place the subsequent answers from the screen in the next three columns.IMPORTANT IMPORTANT IMPORTANTPrior to printing out a hard copyTake your mouse and highlight from Row 1 to the last row for actual number of payments (this number will be presented to you at the top of the spreadsheet). In doing this you will only print out what is essential to be printed.You will notice under PAGE LAYOUT at the top ribbon an icon that says PRINT AREA This icon is designed to allow you to only printout an area you designated. Please make sure you have done this prior to printing, as it will save a lot of paper.No.Amount FinancedInterest RateFrom the BankYears of the loanMonthly PaymentTotal InterestTo the BankTotal Cost of the loan1 H$3,0008%5 FORMTEXT ????? FORMTEXT ????? FORMTEXT ?????2$20,0005%10 FORMTEXT ????? FORMTEXT ????? FORMTEXT ?????3 H$200,00010%15 FORMTEXT ????? FORMTEXT ????? FORMTEXT ?????4$200,00010%30 FORMTEXT ????? FORMTEXT ????? FORMTEXT ?????515,0007%6 FORMTEXT ????? FORMTEXT ????? FORMTEXT ????? ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download