Hi Preceptor:) you ignored my question but this is specific question as you can see. First question has been solved. Please you may solve related question. Thank you from Turkey :) This is first question: 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. (Solved) Related other question: 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?

Hi Preceptor:) you ignored my question but this is specific question as you can see. First question has been solved. Please you may solve related question. Thank you from Turkey :) This is first question: 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. (Solved) Related other question: 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?

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter19: Lease And Intermediate-term Financing

Section: Chapter Questions

Problem 19P

See similar textbooks

Similar questions

Suppose an engineer purchases a home and secures a loan of ₱2.5M from a commercial bank for 20 years at an annual interest rate of 9%. Find the monthly amortization of the loan. How much is the total amount paid over the life of the loan in Problem 1? How much is the total amount of interest paid over 20 years in Problem 1? I hope you can help me. Thank youu
Suppose you are a relationship manager at an international bank. A customer who recently got admission at a prestigious Business School approached you for an education loan of Rs. 36,00,000. Your bank offers the education loan at 9.6 percent to be repaid in 10 years in EMIs. You are assigned the task of preparing the amortization schedule for the customer and answer the following. Prepare the amortization schedule for the first 5 EMIs. What will be interest paid for 93th EMI? What will be the loan balance after 93th EMI? What is the total interest paid for the loan?
You have been approached to structure a payment plan for a bank client who has been granted a loan of R100 000 at 10% per annum for 60 months. The client is faced with some difficulties so cannot afford the loan payment initially for the first 2 years. However, from the beginning of year 3 the client would be able to contribute an extra amount every year for the rest of the term to ensure that they payoff the loan in the stipulated term. Draw up an amortization table and answer the questions below. All answers to the nearest cents. NB: Extra payment not Growth. 1. What would have been the normal monthly payment for a loan like this? R Blank 1. Fill in the blank, read surrounding text. 2. If the client can only afford R1500 for the first 2 years, what should be the extra payment each month when the client starts making the normal payments for the loan from the beginning of year 3? R Blank 2. Fill in the blank, read surrounding text. 3. How much total interest would be paid over…
Jake has approached you for a loan and based on your assessment, his cash-flow will accommodate a repayment of $6,000 per month. He has agreed to a 5-year repayment term at an interest rate of 16% add-on. What is the maximum loan that Jake can be given? Select one: Oa. $30.000 b. $360,000 c. $160.000 d. $200.000
Create a loan amortization table using the following information: Amount of the loan: $500,000 Length of the loan: 30 years Payment: Equal annual payment Interest rate: Annual interest rate starts at 3% in year 1, then every year after that, the interest rate is previous year's interest rate plus 0.1%. PLEASE DO IT IN EXCEL AND SHOW YOUR STEPS
Please provide your complete solutions to the given problems. You may use MS Excel for your solutions. 1. A loan is to be amortized for 4 years through equal payments of PhP48,532.49 at the end of every 6- month period. If the loan earns interest at 7% compounded semi-annually, create an amortization schedule and find: a. the present value of the loan b. the outstanding principal after 3 years c. the amount of principal already paid after 3 years (sum of the principal repayment column for the first 3 years) d. the total interest paid on this loan (sum of the interest column)
K You have just taken out a five-year loan from a bank to buy an engagement ring. The ring costs $5,500. You plan to put down $1,200 and borrow $4,300. You will need to make annual payments of $1,200 at the end of each year. Show the timeline of the loan from your perspective. How would the timeline differ if you created it from the bank's perspective? Show the timeline of the loan from your perspective. (Select the best choice below.) OA. Year Cash Flow $4,300 0 OB. Year 0 Cash Flow - $1,200 OC. Year Cash Flow $5,500 0 OD. Year 1 - $1,200 1 $1,200 2 Cash Flow - $4,300 $1,200 - $1,200 2 $1,200 - $1,200 - $1,200 2 $1,200 3 - $1,200 3 $1,200 3 - $1,200 3 $1,200 - $1,200 4 $1,200 4 - $1,200 4 $1,200 5 - $1,200 5 $1,200 5 - $1,200 5 $1,200
you have just taken out a 5 year laon frm a bank to buy an engagement ring. The ring costs $5000. You plan to put down $1000 and borrow $4000. you will need to make annual payments of $1000 at the end of each year. show the timeline of the loan from your perspective. How would the timeline differ if you created it from the bank's perspective?
s) You want to purchase a machine for your business and you are given 3 different payment schedules: Pay Php 1,500,000 in cash, upfront. 1. Pay equal amount of Php 395,000 for 5 years. iii. Immediate cash outlay of Php 195,750 and afterward Php 215,000 per year for 10 years Determine which schedule is least expensive and most expensive if the interest rate is 10.0%, compounded continuously. Answer must be justified by complete solution.
Suppose an engineer purchases a home and secures a loan of ₱2.5M from a commercial bank for 20 years at an annual interest rate of 9%. Find the monthly amortization of the loan. How much is the total amount paid over the life of the loan in Problem 1? How much is the total amount of interest paid over 20 years in Problem 1?
An engineer wants to purchase a house for $100,000 and has $20,000 cash to use as the down payment. The bank offers a loan for the remainder at 9% nominal interest with the term of the loan being 20 years and monthly payments. Assuming the payment is the same for all months, the monthly loan payment is close to: a. $720 b. $689 c. $572 d. $741
You lend a friend $10,000, which your friend will repay in 5 equal annual end-of-year payments of $3,000, with the first payment to be received 1 year from now. What rate of return does your loan receive? I need to be able to use excel and manually calculate as well.