**Loan Amortization Table Overview**You have taken a loan of $64,000.00 for 26 years with an interest rate of 4.7% compounded quarterly. Use the table below to fill in the payment details. All computations should be rounded to 2 decimal places.**Table Columns:**1. **Payment Number:** Indicates the sequence of the payments, starting from 0.2. **Payment Amount:** Total amount paid in each payment period.3. **Principal Amount:** Portion of the payment that goes toward reducing the loan's principal balance.4. **Interest:** Portion of the payment that goes toward paying interest on the loan.5. **Balance:** Remaining loan balance after each payment.**Initial Condition:**- **Balance at Payment 0:** $64,000.00**Empty Table for Completion:**| Payment Number | Payment Amount | Principal Amount | Interest | Balance ||----------------|----------------|------------------|----------|------------|| 0 | | | | $64,000.00 || 1 | $ | $ | $ | $ || 2 | $ | $ | $ | $ || 3 | $ | $ | $ | $ |**Instructions:**Calculate the payment amount, principal, interest, and remaining balance for each payment period using the compound interest formulas and amortization schedule methods. Use the interest rate of 4.7% compounded quarterly for your calculations.

Here, Particulars Values Loan Amount $ 64,000.00 No. of years 26.00 Interest rate 4.700%…

Answered: You have taken a loan of $64,000.00 for…

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

Similar questions

Subject.... account
Answer in typing
Develop an amortization schedule for the loan described. (All answers should be entered in dollars. Round your answers to the nearest cent.) 1 $90,000 for 2 years at 12% compounded semiannually Period 1 2 3 4 5 $ $ $ $ $ Payment $ $ $ $ $ Interest Balance Reduction $ $ $ $ $ Unpaid Balance $90,000 $ $ $ $ $0.00
The buyer of a piece of real estate is often given the option of buying down the loan. This option gives the buyer a choice of loan terms in which various combinations of interest rates and discount points are offered. The choice of how many points and what rate is optimal is often a matter of how long the buyer intends to keep the property. Darrell Frye is planning to buy an office building at a cost of $987,000. He must pay 10% down and has a choice of financing terms. He can select from a 9% 30-year loan and pay 4 discount points, a 9.25% 30-year loan and pay 3 discount points, or a 9.5% 30-year loan and pay 2 discount points. Darrell expects to hold the building for four years and then sell it. Except for the three rate and discount point combinations, all other costs of purchasing and selling are fixed and identical. (Round your answers to the nearest cent. Use this table, if necessary.) (a) What is the amount being financed? $4 (b) If Darrell chooses the 4-point 9% loan, what…
find the interest, interest rate,monthly payment, and the new principal.
Using this table as needed, calculate the required information for the mortgage. Number Table Monthly Payment (in $) Term Total Amount Interest of $1,000s Financed of Loan Factor Interest Financed Rate (years) (in $) (in $) $74,500 8.00% 30 %24
Question 22 You have taken a loan of $63,000.00 for 36 years at 5.5% compounded quarterly. Fill in the table below: (Round all answers to 2 decimal places.) Payment number Payment amount Principal Amount Interest Balance 0) $63,000.00 1) S $ S $ 2) $ S $ 3) $ S $
Subject: Finance
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.)
Suppose that you borrow$ 12000 at interest rate of 5% per year. If you must be repaid the loan in equal end of year payments over the next 4 years, how much must you repay at the end of each year? O a. $3672 Ob. $3384 Oc. $2672 O d. $2384
Answer all the 4 requirement, please answer complete otherwise skip it
Examine the loan of $210,000, 15-year mortgage with an APR of 3.8%. The borrower paid an extra $100 each month towards the principal. Determine the ending balance after the first month? Payment Beginning Monthly Extra Balance Number Payment Payment 1 210,000.00 a. 100.00 2 b. a. 100.00 3 208,351.69 a. 100.00 4 207,521.35 a. 100.00 5 206,686.86 a. 100.00 Towards Towards Interest Principal 1,050.00 1,045.89 d. 1,037.61 1,033.43 Ending Balance 822.10 209,177.90 826.21 830.34 e. 838.67 C. 207,521.35 206,686.86 205,848.19

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

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

You have taken a loan of $64,000.00 for 26 years at 4.7% compounded quarterly. Fill in the table below: (Round all answers to 2 decimal places.) Payment number Payment amount Principal Amount Interest 0) 1) 2) 3) $ $ $ $ $ $ $ Balance $64,000.00 $ $ $