Complete the following table: (Do not round intermediate calculations. Round your answers to the nearest cent.) First Payment Broken Down Into- Selling price $ 126,000 $ 7,000 Down payment Amount mortgage Rate 7.50 % Years 30 Monthly payment Interest Principal Balance at end of month

Complete the following table: (Do not round intermediate calculations. Round your answers to the nearest cent.) First Payment Broken Down Into- Selling price $ 126,000 $ 7,000 Down payment Amount mortgage Rate 7.50 % Years 30 Monthly payment Interest Principal Balance at end of month

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Q: Find the monthly payment and estimate the remaining balance. Assume interest is on the unpaid…

A: Variables in the question:Loan=$2770Rate=6.7%N=5 year

Q: The interest rate on a $14,200 loan is 8.6% compounded semiannually. Semiannual payments will pay…

A: Given: Loan = $14,200 Interest rate =8.6% Years = 9

Q: Complete the following table: (Do not round intermediate calculations. Round your answers to the…

A: The question is based on the concept of Financial Management.

Q: Find the ending balance for December in the below monthly loan amortization schedule.…

A: Loans are paid by fixed equal monthly installments that carry the payment for interest and payment…

Q: Prepare an amortization schedule for the first 3 payments (in $) of a $66,000 mortgage at 5% for 20…

A: Present Value Annuity Factor=1-1+rate-timerate

Q: Calculate the finance charge (in $), the finance charge per $100 (in $), and the annual percentage…

A: in this we have to calculate financial charges and we have to use given table.

Q: What is the monthly interest expense for the following open-end credit loan? Loan balance of…

A: The open ended credit loan you have to pay interest on balance amount used and calculation are done…

Q: Calculate the monthly payment by using the loan amortization table: (Round your answer to the…

A: Annuity: An annuity is defined as a series of payments, whether received or made, that are equal and…

Q: Find the total monthly payment, including taxes and insurance. Interest Rate Term of Loan Annual…

A: A mortgage is a loan taken out for the purchase of real estate. The real estate being purchased acts…

Q: Make an amortization table to show the first two payments for the mortgage. Amount of Annual…

A: Amortization is a repayment schedule which is generally used by lenders such as banks, financial…

Q: If you borrow $4,600 at $850 interest for one year, what is your effective interest rate for the…

A: The Effective Annual Rate (EAR), also known as the annual equivalent rate (AER) or annual percentage…

Q: For the following loan, make a table showing the amount of each monthly payment that goes toward…

A: When the borrower borrows a loan from the lender, he has to pay a rate of interest on the borrowed…

Q: Calculate the finance charge (in $), the finance charge per $100 (in $), and the annual percentage…

A: Using excel Rate function

Q: Calculate the finance charge (in $), the finance charge per $100 (in $), and the annual percentage…

A: Loan amount (L) = $13000 Number of payments (n) = 36 Monthly payment (M) = $454 Let r = Monthly rate

Q: Prepare an amortization schedule for a three-year loan of $84,000. The interest rate is 9 percent…

A: Loans have to be paid in the form of fixed periodic payments. The periodicity can be monthly,…

Q: Complete the following table: (Use Table 15.1.) Note: Round your intermediate calculations and final…

A: Amortization is a form of finance used over a certain period of time to gradually reduce the book…

Q: Annual % rate: 5.9% Amt of Mort: $180,000 Unpaid Balance: Monthly Payent: $1067.65 Number of Monthly…

A: Loans are paid by equal monthly payments and the unpaid balance is the present value of payments…

Q: Calculate the finance charge (in $), the finance charge per $100 (in $), and the annual percentage…

A: AMOUNT FINANCED = $17.910 NO OF PAYMENT = 48 MONTHLY PAYMENT = $550.47 TOTAL PAYMENT = $550.47 x 48…

Q: Example: You will receive three payments: $1,000, $2,000 and $3,000 on March 1, May 1 and December 1…

A: Due Date Amount receivedMarch 1 Amount received on March 1=$1,000May 1 Amount received on May…

Q: Compute the size of the final payment for the following loan. Principal $ Periodic Payment $…

A: A loan is basically a type of debt that an individual or the other entity incurs. The lender, who…

Q: Erindale Bank offers you a $58,000, four-year term loan at 7.0% annual Interest. What will your…

A: To calculate the annual loan payment, we can use the formula for the present value of an annuity:…

Q: Calculate the finance charge (in $), the finance charge per $100 (in $), and the annual percentage…

A: A loan is a financial arrangement in which one or more people, companies, or other entities lend…

Q: Calculate the finance charge (in $), the finance charge per $100 (in $), and the annual percentage…

A: amount financed = $50,000 no of payment = 60 monthly payment = $1,176.33 total payment = 60 x…

Q: Prepare an amortization schedule for a three-year loan of $96,000. The interest rate is 9 percent…

A: Amortization table is prepared to repay the debt. The debts can be paid in installments or in…

Q: Create the amortization schedule for a loan of $5,000, paid monthly over two years using an 8…

A: Here,Loan Amount is $5,000Time Period of Loan is 2 yearsInterest Rate on Loan is 8%Compounding…

Q: Calculate the finance charge (in $), the finance charge per $100 (in $), and the annual percentage…

A: Amount Financed = $14,000 Number of payment = 36 Monthly payment = $503

Q: alculate the table factor, the finance charge, and the monthly payment (in $) for the loan by using…

A: The given problem can be solved using PMT function in excel. PMT function computes installment…

Q: Delos Debt Renegotiations (B). Delos is continuing to renegotiate its prior loan agreement (E80…

A: The remaining outstanding loan balance after two years is $57,604,807.60.

Q: mplete the following table: (Use Table 15.1.) ze: Round your intermediate calculations and final…

A: Loans are paid by monthly payments and these are fixed and the carry the payment for interest and…

Q: Prepare an amortization schedule for the first 3 payments (in $) of a $68,000 mortgage at 5% for 20…

A: Loan installment is that which is paid by borrower to lender for a specified period of time. This…

Q: A loan is repaid with payments of $2560 made at the end of each month for 13 years. If interest on…

A: Amortization of a loan refers to the process of spreading out the repayment of a loan over a set…

Question

Complete the following table: (Do not round intermediate calculations. Round your answers to the nearest cent.)
First Payment Broken Down
Into-
Selling
price
$ 126,000 $ 7,000
Down
payment
Amount
mortgage
Rate
7.50 %
Years
30
Monthly
payment
Interest
Principal
Balance at end of
month

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Formulas.

VIEW

Step 2: Computation of amount of mortgage.

VIEW

Step 3: Computation of monthly payment.

VIEW

Step 4: Computation of interest component of first payment.

VIEW

Step 5: Computation of principal component of 1st payment.

VIEW

Step 6: Computation of balance at the end of month.

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 7 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

5 % rate for 15 years is 7.90794
Calculate the finance charge (in $) and the annual percentage rate for the installment loan by using the APR formula. (Round dollar amounts to the nearest cent and percentages to one decimal place.) Amount Number of Financed Payments $18,500 72 Monthly Payment $424.08 $ tA Finance Charge APR %
Letter of credit or line of credit. As We Go Bank offers its customers a line-of-credit loan in which each month’s outstanding balance has an interest charge at 12% APR. For the following loans, all with a $100,000 credit line, what are the required monthly interest payments and the total interest paid for the year?
Calculate the finance charge (in $) and the annual percentage rate for the installment loan by using the APR formula. (Round dollar amounts to the nearest cent and percentages to one decimal place.) Amount Financed 18,200 Number of Payments = 72 Monthly Payment = 424.08 Solve for Finance Charge and APR
Complete the following table: (Use Table 15.1.) Note: Do not round intermediate calculations. Round your answers to the nearest cent. Selling price down payment amount mortgage rate years Monthly paymeny First payment broken down to interest first payment broken down to principal Balance at end of month $236,000 $47,200 7.00% 15 TABLE 15.1 Amortization table (mortgage principal and interest per $1,000) Rate Interest Only 10 Year 15 Year 20 Year 25 Year 30 Year 40 Year 2.000 0.16667 9.20135 6.43509 5.05883 4.23854 3.69619 3.02826 2.125 0.17708 9.25743 6.49281 5.11825 4.29966 3.75902 3.09444 2.250 0.18750 9.31374 6.55085 5.17808 4.36131 3.82246 3.16142 2.375 0.19792 9.37026 6.60921 5.23834 4.42348 3.88653 3.22921 2.500 0.20833 9.42699 6.66789 5.29903 4.48617 3.95121 3.29778 2.625 0.21875 9.48394 6.72689 5.36014 4.54938 4.01651 3.36714 2.750 0.22917 9.54110 6.78622 5.42166 4.61311 4.08241 3.43728 2.875 0.23958 9.59848 6.84586 5.48361 4.67735 4.14892…
Calculate the table factor, the finance charge, and the monthly payment (in $) for the loan by using the APR table, Table 13-1. (Round your answers to the nearest cent.) Amount Number of Financed Payments $6,200 36 APR 11% LA Table Factor Finance Charge Monthly Payment
Subject.... account
You have taken a loan of $78,000.00 for 20 years at 4.9% compounded quarterly. Fill in the table below, rounding all values to the nearest cent. Note that the principal column is listed before the interest column even though the interest calculation is done first. Many lending institutions use this order in the amortization schedules they provide to their customers. Payment number Payment amount Principal Amount Interest 0) 1) 2) 3) $ S $ $ s Balance $78,000.00 $
Calculate the monthly payment from the following information by formula. Note: Do not round intermediate calculations. Round your answer to the nearest cent. Number of monthly payments 48 $ Amount financed 4,450 APR 13 % PMT
Prepare an amortization schedule for a five-year loan of $47,000. The interest rate is 7% per year, and the loan calls for equal annual payments. (Do not round intermediate calculations. Enter all amount as positive value. Round the final answers to 2 decimal places. Leave no cells blank - be certain to enter "O" wherever required.) Year 1 Beginning Balance $ 2 2 3 4 5 Total Payment $ Interest Payment Principal Payment Ending Balance $ How much interest is paid in the third year? (Do not round intermediate calculations. Round the final answer to 2 decimal places.) Interest paid $ How much total interest is paid over the life of the loan? (Do not round intermediate calculations. Round the final answer to 2 decimal places.) Total interest $
What are the repayment schedules for each of the following five-year, 9 percent $11,000 term loans? Use Appendix D to answer the questions. Do not leave any cells blank. If the answer is zero, enter "0". Do not round intermediate calculations. A. Equal annual payments that amortize (retire) the principal and pay the interest owed on the declining balance. Round your answers to the nearest cent. Balance Interest Principal Year payment repayment on loan $ $ $ $ $ 1 2 3 4 5 $ $ $ $ $ Interest Principal Balance Year payment repayment on loan 1 $ $ 2 is B. Equal annual principal repayment, with interest calculated on the remaining balance owned. Round your answers to the nearest dollar. $ $ 3 $ $ $ 4 5 es $ $ $ $ $ $ $ $ $ $ $ $ $
Suppose you borrow $14,000. The interest rate is 11%, and it requires 4 equal end-of-year payments. Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. Round your answers to the nearest cent. If your answer is zero, enter "0". Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $ fill in the blank 60 $ fill in the blank 61 $ fill in the blank 62 $ fill in the blank 63 $ fill in the blank 64 2 $ fill in the blank 65 $ fill in the blank 66 $ fill in the blank 67 $ fill in the blank 68 $ fill in the blank 69 3 $ fill in the blank 70 $ fill in the blank 71 $ fill in the blank 72 $ fill in the blank 73 $ fill in the blank 74 4 $ fill in the blank 75 $ fill in the blank 76 $ fill in the blank 77 $ fill in the blank 78 $ fill in the blank 79

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS