You are asked to help the company "X" by computing the Loan repayment table. a) Draw up the repayment table for a loan of $500,000 at a rate of 7% repayable in 4 constant annual installments (annuities) after an amortization delay of 2 years (which means that the value of the amortization for the first two years is zero) b) Find the total value of the paid annuities.

You are asked to help the company "X" by computing the Loan repayment table. a) Draw up the repayment table for a loan of $500,000 at a rate of 7% repayable in 4 constant annual installments (annuities) after an amortization delay of 2 years (which means that the value of the amortization for the first two years is zero) b) Find the total value of the paid annuities.

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: E. PART E PROBLEM. USE SEPARATE EXCEL ANSWER SHEET. Suppose your business borrow $14,000 from the…

A: The scenario involves taking out a loan of $14,000 to finance the purchase of a car. The loan…

Q: our business requests a 3-month loan for $500,000. What will be the interest paid at the end of the…

A: LIBOR stands for London Interbank Offered Rate. It is the benchmark rate at which all major global…

Q: We will use Excel PMT function to calculate the payment Rand then create an amortization schedule…

A: PMT function in excel is used to calculate the amount of payment received or paid by the individual.…

Q: A loan for 50,000 has level payments to be made at the end of each year for 10 years at an annual…

A: Loan Installment is that amount under which borrower will pay the equal amount at the end of each…

Q: A company has a loan of 80,000 to be paid in 20 level annual payments. The interest and the…

A: Loans are paid by annual payments that carry the interest and loan amount but annual payments are…

Q: You have just been hired as a loan officer at a national bank. Your first assignment is to calculate…

A: A loan refers to a contract between two parties where one party lends a sum to the other party on…

Q: An institutional lender is willing to make a loan for $1 million on an office building at a 6…

A: Hi, there, Thanks for posting the question. As per our Q&A honour code, we must answer the first…

Q: It is important to know how to build an amortization schedule when firms (or individuals) take out…

A: Given: Loan amount (P): $60,000 Number of periods (n): 3 years =3*12= 36 months Interest (i): 12%…

Q: Consider a loan of $98,000 at 7% compounded annually, with 12 annual payments. Find the following.…

A: Loan amortization can be defined as the procedure of amortizing the loan in such a way that the loan…

Q: A loan of $2,000 is paid by the following series of payments, beginning one year after the loan is…

A: Amortization table shows the break up of instalments for the interest charged on the outstanding…

Q: A loan of £4,000 is to be repaid over 5 years by a level annuity payable monthly in arrears. The…

A: To Find: Monthly payment Capital repaid and interest paid in first and lst month Loan repaid after…

Q: ABC Realty sold a piece of land for P250,000. A down payment of P50,000 was made and the remainder…

A: Present Value of Loan = Present Value Factor x Cash Flow during the period

Q: Akuse Tours company secures a loan of GHS200,000 over 2 years at 10.5% compounded quarterly year to…

A: A person or a company or a business takes loan for buying something that it cannot otherwise afford…

Q: Use the appropriate formula to find the amortization payment (in S) you would need to make each…

A: Monthly interest rate Loan amount PV = $8,500,Total number of payments Loan term t=5 years.

Q: You have just been hired as a loan officer at a national bank. Your first assignment is to calculate…

A: The question is based on the concept of Financial Management. Equal periodic payment can be…

Q: Assume you borrowed $20,000 and the terms of the loan include paying 4% interest for a period of 10…

Q: Write the Formula for the equation for the payment on the Loans (you do NOT need to evaluate) (a) 30…

A: Part (a) Loan Amount = $125,000 Time Period = 30 Years Interest Rate = 4.2% Part (b) Loan Amount =…

Q: ABC Inc. asked your company for a 7-year loan of $50,000. The repayment of the loan will be as…

A: Loan is contract between lender and borrower where lender provide funds to borrower for definite…

Q: a. Find the balance owed after 5 years b. Determine the cost of the loan (interest). c. If an extra…

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

Q: The executive of a label is looking to purchase a new rental for $3.9 million. Financing is offered…

A: Borrowings are the liability that is used to finance the requirement of the funds. The borrower…

Q: Data Back-Up Systems has obtained a $29,000, 90-day bank loan at an annual interest rate of 15%,…

A: a)The computation of amount of interest on the loan is as follows:Working note:Hence, the amount of…

Concept explainers

Mortgages

A mortgage is a formal agreement in which a bank or other financial institution lends cash at interest in return for assuming the title to the debtor's property, on the condition that the obligation is paid in full.

Mortgage

The term "mortgage" is a type of loan that a borrower takes to maintain his house or any form of assets and he agrees to return the amount in a particular period of time to the lender usually in a series of regular equally monthly, quarterly, or half-yearly payments.

Question

You are asked to help the company "X" by
computing the Loan repayment table.
a) Draw up the repayment table for a loan
of $500,000 at a rate of 7% repayable in 4
constant annual installments (annuities)
after an amortization delay of 2 years
(which means that the value of the
amortization for the first two years is zero)
b) Find the total value of the paid annuities.

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

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 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

You have just been hired as a loan officer at a national bank. Your first assignment is to calculate the amount of the periodic payment (in $) required to amortize (pay off) the following loan being considered by the bank (use Table 12-2). (Round your answer to the nearest cent.) LoanPayment PaymentPeriod Term ofLoan (years) NominalRate (%) Present Value(Amount of Loan) $ every month 1 1 4 6 $30,000
Consider a loan of 1,000,000 which is to be amortized by 60 monthly payments. The interest rate is 10% converted monthly. Construct the first 5 rows (t=0 to t=4) of the amortization schedule
You have just been hired as a loan officer at a national bank. Your first assignment is to calculate the amount of the periodic payment (in $) required to amortize (pay off) the following loan being considered by the bank (use Table 12-2). (Round your answer to the nearest cent.) LoanPayment PaymentPeriod Term ofLoan (years) NominalRate (%) Present Value(Amount of Loan) $ every month 1 3 4 6 $40,000
Using manual formulas and not excel:
1. An amortized loan of P250,000 with an interest rate of 9% will be paid monthly for 3 years. Find the monthly amortization. A high-end laptop computer was bought at an amortized loan of P100,000 with 12% annual interest for 24 months. Find the semi- annually amortization and construct an amortization schedule.
Give complete solutions and draw a cashflow diagram. Provide an amortization schedule 1. You have a car loan of $15,000 with an annual interest rate of 8%. The loan term is 3 years. Calculate the outstanding balance after 2 years of making monthly payments.
A design studio received a loan of $8,950 at 5.60% compounded semi-annually to purchase a camera. If they settled the loan in 2 years by making quarterly payments, construct the amortization schedule for the loan and answer the following questions: a. What was the payment size? Round to the nearest cent b. What was the size of the interest portion on the first payment? ← a acer SUBMIT QUESTION SAVE PROGRESS V SUBMIT ASSIC
To pay for remodeling, the company will take out a $500,000 five-year loan at 9.5% interest, compounded quarterly. The terms of the loan have been entered in the Loan Analysis worksheet. In cell B8, calculate the quarterly payment on the loan based on the loan conditions already entered. Complete the amortization schedule in cells B11 through E30. Column B contains the interest payment for each quarter, and column C contains the principal payment. Column D contains the remaining principal at the start of each month. The initial principal remaining is $500,000. The subsequent remaining principal values are reduced by the principal payment made in the previous quarter. Calculate the ending balance in cell D31. Use the IPMT function in cell B11 to calculate the interest amount paid per period. Copy this formula to cell B30. Use the PPMT function in cell C11 to calculate the principal amount paid per period. Copy this formula to cell C30. Write a formula in cell D11 to indicate the…
Suppose you secure a home improvement loan in the amount of $5,000 from a local bank. The loan officer gives you the following loan terms:• Contract amount = $5,000• Contract period = 24 months• Annual percentage rate = 12%• Monthly installment = $235 .37Shown is the cash flow diagram for this loan. Construct the loan payment schedule by showing the remaining balance, interest payment, and principal payment at the end of each period over the life of the loan.
CZ Enterprises borrows $202,775 at an interest rate of 10% today and will repay this amount by making 10 semiannual payments. Payments begin in six months. What is the amount of the payments that CZ will need to make? (Use the present value and future value tables, a financial calculator, a spreadsheet or the formula method for your calculations. If using present and future value tables or the formula method, use factor amounts rounded to five decimal places, X.XXXXX. Round your final answer to the nearest cent, $X.XX.) CZ will need to make payments of $ 26,260.31.
To pay for remodeling, the company will take out a $500,000 five-year loan at 9.5% interest, compounded quarterly. The terms of the loan have been entered in the Loan Analysis worksheet. In cell B8, calculate the quarterly payment on the loan based on the loan conditions already entered. Complete the amortization schedule in cells B11 through E30. Column B contains the interest payment for each quarter, and column C contains the principal payment. Column D contains the remaining principal at the start of each month. The initial principal remaining is $500,000. The subsequent remaining principal values are reduced by the principal payment made in the previous quarter. Calculate the ending balance in cell D31. Use the IPMT function in cell B11 to calculate the interest amount paid per period. Copy this formula to cell B30. Use the PPMT function in cell C11 to calculate the principal amount paid per period. Copy this formula to cell C30. Write a formula in cell D11 to indicate the…
You have just been hired as a loan officer at a national bank. Your first assignment is to calculate the amount of the periodic payment (in $) required to amortize (pay off) the following loan being considered by the bank (use Table 12-2). (Round your answer to the nearest cent.) Payment Period Nominal Rate (%) Loan Term of Present Value Payment Loan (years) (Amount of Loan) every month 6 $40,000 4 %24

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