You decide to buy a small office building costing $150.000 and take out a fixed term loan over 5 years at 10%. The loan is to be paid in 5 equal instalments starting at the end of this year. Estimate the annual repayments and prepare a mortgage repayment table showing interest payments, reduction in capital, opening and closing balances.

You decide to buy a small office building costing $150.000 and take out a fixed term loan over 5 years at 10%. The loan is to be paid in 5 equal instalments starting at the end of this year. Estimate the annual repayments and prepare a mortgage repayment table showing interest payments, reduction in capital, opening and closing balances.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter19: Lease And Intermediate-term Financing

Section: Chapter Questions

Problem 14P

See similar textbooks

Similar questions

Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?
We suggest the use of a spreadsheet to create the amortization tables. You take out a 30-year mortgage for $70,000 at 9.45%, to be paid off monthly. Construct an amortization table showing how much you will pay in interest each year for the first 15 years and how much goes toward paying off the principal. If you sell your house after 15 years, how much will you still owe on the mortgage according to the amortization table? HINT [See Example 8.] (Round your answer to the nearest cent.) $
1) You decide to buy a small office building costing $150.000 and take out a fixed term loan over 5 years at 10%. The loan is to be paid in 5 equal instalments starting at the end of this year. Estimate the annual repayments and prepare a mortgage repayment table showing interest payments, reduction in capital, opening and closing balances. 2) Solve the first problem above with a change in interest rates from 10% to 5% after the second year. For the first two years interest rate is 10%. a) Construct a mortage repayment table with a change in interest rate from 10% to 5% for the last three years. b) When the interest rate dropped to 5%, is it possible to pay off the loan earlier than 5 years by keeping payments constant?
You want to buy a car, and a local bank will lend you $40,000. The loan will be fully amortized over 10 years, and the nominal interest rate will be 8% with interest paid annually. 1: What will be the annual loan payment? 2: Construct Amortization Schedule Table.
Suppose you wish to purchase heavy equipment machinery and a commercial bank will lend you $65,000 for the transaction. The loan will be amortized over 5 years and the nominal interest rate will be 8% payable monthly. Calculate the monthly payment and the annual percentage rate (EAR) of the loan to be amortized.
ABC mortgage is to obtain a facility amounting to $200000 to be repaid over a period of 20 years at an annual rate of 10%.Help the company to; 1. Compute monthly mortgage payment for this loan 2. Amortize the mortgage loan for the first one year 3. Suppose the mortgage is paid off after one year, how much will be paid to clear the mortage
You take out a 30-year $150,000 mortgage loan with an APR of 12% and monthly payments. In 11 years, you decide to sell your house and pay off the mortgage. What is the principal balance on the loan? Use Excel
You are planning on buying a new house and want to make sure you can afford the monthly payments. The house you picked will necessitate you borrow $300,000. You think you can get the following. mortgage terms: borrow $300,000 at a fixed quoted (nominal) annual rate of 3.775%; to be paid off in equal monthly payments over 15 years.Compute the required monthly payment, and prepare an amortization table, showing for each month the beginning balance, payment, payment applied to interest, payment applied to principal, and ending. balance. (Assume monthly compounding) (solution needs to be in excel)
You plan to purchase a $130,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 5.25 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the first six payments.
You plan to obtain a $10000 loan from a furniture dealer at 10% annual interest rate that you will pay off in annual payments over five years. Determine the annual payments on this loan and complete the amortisation table.
Suppose you take out a $117,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 5%. To keep things simple, we will assume you make payments on the loan annually at the end of each year. a. What is your annual payment on the loan? b. Construct a mortgage amortization. c. What fraction of your initial loan payment is interest? d. What fraction of your initial loan payment is amortization? e. What is the total of the loan amount paid off after 10 years (halfway through the life of the loan)? f. If the inflation rate is 3%, what is the real value of the first (year-end) payment? g. If the inflation rate is 3%, what is the real value of the last (year-end) payment? h. Now assume the inflation rate is 6% and the real interest rate on the loan is unchanged. What must be the new nominal interest rate? i-1. Recompute the amortization table. i-2. What is the real value of the first (year-end) payment in this high-inflation scenario? j. What is the real value of the last…
You take a loan of $50,000 loan to buy a car at an interest rate of 13% for 5years. Prepare a loan amortization table.