This worksheet requires you to use the IPMT and PPMT funtions to calculate the loan balance, and the principle/interest portion of a loan payment at any given point in time. Be sure to use cell references. Initial Balance $10,000.00 Annual Interest Rate 10% Years 10 Annual Payemnt $1,627.45 Summary loan data for year 4 Balance at start of year Balance at end of year Interest paid during the year Principle paid during the year

This worksheet requires you to use the IPMT and PPMT funtions to calculate the loan balance, and the principle/interest portion of a loan payment at any given point in time. Be sure to use cell references. Initial Balance $10,000.00 Annual Interest Rate 10% Years 10 Annual Payemnt $1,627.45 Summary loan data for year 4 Balance at start of year Balance at end of year Interest paid during the year Principle paid during the year

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter7: Using Consumer Loans

Section: Chapter Questions

Problem 5FPE

See similar textbooks

Similar questions

Use the amortization table to determine how much interest is paid in the first 4 months of the loan. Click the icon to view the amortization table. $ (Type an integer or a decimal.) Amortization Table Payment Number 0 1 2 3 4 5 6 7 8 9 10 11 12 Amortization Table Amount of Payment $215.17 $215.17 $215.17 $215.17 $215.17 $215.17 $215.17 $215.17 $215.17 $215.17 $215.17 $215.13 Print Interest for Period $12.50 $11.49 $10.47 $9.44 $8.42 $7.38 $6.34 $5.30 $4.25 $3.20 $2.14 $1.07 Portion to Principal $202.67 $203.68 $204.70 $205.73 $206.75 $207.79 $208.83 $209.87 $210.92 $211.97 $213.03 $214.06 Done Principal at End of Period $2500.00 $2297.33 $2093.65 $1888.95 $1683.22 $1476.47 $1268.68 $1059.85 $849.98 $639.06 $427.09 $214.06 $0.00
Loan payment Determine the equal, annual, end-of-year payment required each year over the life of the loan shown in the following table to repay it fully during the stated term of the loan. (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Principal $42,000 Interest rate 14% www The amount of the equal, annual, end-of-year payment, CF, is $ Term of loan (years) 20 (Round to the nearest cent.)
Use the actuarial method to find the payoff amount for the loan paid in full before its due date. Amount Financed: $9000 Regular Monthly Payment. $189 02 Total Number of Payments scheduled: 60 Loan repaid in full instead of making: 12th payment
Make an amortization table to show the first two payments for the mortgage. Amount of mortgage Annual interest rate Years in mortgage Monthly payment $407,181 5.50% 35 $2186.63 Question content area bottom Part 1 Month Monthly payment Interest Principal End-of-month principal 1 $2186.63 $enter your response here $enter your response here $enter your response here 2 $2186.63 $enter your response here $enter your response here
Compute the size of the final payment for the following loan. Principal $ Periodic Payment $ Payment Period Payment Made at: Interest Rate % Compounding Period 8100 520 3 months beginning 8 quarterly The size of the final payment is $_ .?
Fl in an amortization table (in dollars) for a loan of $8,500 to be paid back over 2 years, at an annual interest rate of 1.3, compounded quarterly. For eech value in the table, round your answer to the nearest cent and use this value to calculate the next value. Payment number Payment amount Payment amount to interest Payment amount to debt Outstanding principal S0.500 13 14
Given the annual interest rate and a line of an amortization schedule for that loan, complete the next line of the schedule. Assume that payments are made monthly. Annual Interest Paid on Interest Rate Payment Paid Principal Balance 11.6% $425.57 $64.23 $361.34 $6,280.78 Fill out the amortization schedule below. Annual Interest Paid on Payment Balance Interest Rate Paid Principal 11.6% $425.57 $64.23 $361.34 $6,280.78 (Round to the nearest cent as needed.)
Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet a. Complete an amortization schedule for a $42,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 9% compounded annually. Round all answers to the nearest cent. Year 1 2 3 Year 1: Year 2: Year 3: I $ $ $ Beginning Balance ||| IV V % Interest % heck My Work $ $ % Payment b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all answers to two decimal places. % Principal % Reset Problem % $ $ $ % Interest $ $ $ Repayment of Principal $ c. Why do these percentages change over time? I. These percentages change over time because even though the total payment is constant the amount of interest paid each year is declining as…
Develop an amortization schedule for the loan described. (All answers should be entered in dollars. Round your answers to the nearest cent.) $50,000 for 2 1 2 years at 10% compounded semiannually Period Payment Interest Balance Reduction Unpaid Balance $50,000 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $ 4 $ $ $ $ 5 $ $ $ $0.00
Find the ending balance for December in the below monthly loan amortization schedule. Purchase price: $200,000 Down payment: 25% Interest rate: 4% Term: 10 years Amortization: 15 years Ending balance for the prior month (November): $123,746.22 (Note: to answer this question you do not need to know when the loan started) Group of answer choices $123,473.10 $123,049.18 $123,246.77 $122,227.54 $122,640.03
Saved Prepare an amortization schedule for a five-year loan of $70,000. The interest rate is 9 percent per year, and the loan calls for equal annual payments. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Leave no cells blank - be certain to enter "O" wherever required.) Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 3 4. How much interest is paid in the third year? (Do not round intermediate-calculations 2. 5
Calculate the amount financed, the finance charge, and the total deferred payment price (in $) for the following installment loan. Purchase(Cash)Price DownPayment AmountFinanced MonthlyPayment Number ofPayments FinanceCharge TotalDeferredPaymentPrice $2,600 0 $ $188.69 18 $ $

SEE MORE QUESTIONS

Recommended textbooks for you

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

Amortization Table - Breaking Down Your Payment - No video

This worksheet requires you to use the IPMT and PPMT funtions to calculate the loan balance, and the principle/interest portion of a loan payment at any given point in time. Be sure to use cell references.

Initial Balance		$10,000.00
Annual Interest Rate		10%
Years		10
Annual Payemnt		$1,627.45

Summary loan data for year	4

Balance at start of year
Balance at end of year
Interest paid during the year
Principle paid during the year