Question

In: Finance

Suppose you buy your first condo that costs $226,500 , you have 20% of it for...

Suppose you buy your first condo that costs $226,500 , you have 20% of it for a down payment, for the rest you will take a 30 years mortgage loan at a 3% nominal interest rate.

a) What will your first year annual payment be?

b) How much of this first payment will be interest and how much principal?

c) How much will be the loan balance at the end of year 10?

d) How much of the last payment will be interest and how much principal?

*Show your work

Expert Solution

A) 6876

B) first payment interest 311 and principal will be 453

C)133934

D) emi is of 762 which includes principal of 760 and interest of 2

2020

₹ 2,827

₹ 4,049

₹ 1,78,373

2021

₹ 3,869

₹ 5,298

₹ 1,74,504

2022

₹ 3,987

₹ 5,181

₹ 1,70,518

2023

₹ 4,108

₹ 5,059

₹ 1,66,409

2024

₹ 4,233

₹ 4,934

₹ 1,62,177

2025

₹ 4,362

₹ 4,806

₹ 1,57,815

2026

₹ 4,494

₹ 4,673

₹ 1,53,320

2027

₹ 4,631

₹ 4,536

₹ 1,48,689

2028

₹ 4,772

₹ 4,395

₹ 1,43,917

2029

₹ 4,917

₹ 4,250

₹ 1,39,000

2030

₹ 5,067

₹ 4,101

₹ 1,33,934

2031

₹ 5,221

₹ 3,947

₹ 1,28,713

2032

₹ 5,380

₹ 3,788

₹ 1,23,333

2033

₹ 5,543

₹ 3,624

₹ 1,17,790

2034

₹ 5,712

₹ 3,456

₹ 1,12,079

2035

₹ 5,885

₹ 3,282

₹ 1,06,193

2036

₹ 6,065

₹ 3,103

₹ 1,00,129

2037

₹ 6,249

₹ 2,918

₹ 93,880

2038

₹ 6,439

₹ 2,728

₹ 87,441

2039

₹ 6,635

₹ 2,532

₹ 80,806

2040

₹ 6,837

₹ 2,331

₹ 73,969

2041

₹ 7,045

₹ 2,123

₹ 66,924

2042

₹ 7,259

₹ 1,908

₹ 59,665

2043

₹ 7,480

₹ 1,688

₹ 52,186

2044

₹ 7,707

₹ 1,460

₹ 44,479

2045

₹ 7,942

₹ 1,226

₹ 36,537

2046

₹ 8,183

₹ 984

₹ 28,354

2047

₹ 8,432

₹ 735

₹ 19,922

2048

₹ 8,689

₹ 479

₹ 11,233

2049

₹ 8,953

₹ 215

₹ 2,280

2050

₹ 2,280

₹ 11

₹ 0

Jan	₹ 758	₹ 6	₹ 1,522
Feb	₹ 760	₹ 4	₹ 762
Mar	₹ 762	₹ 2

jeff jeffy answered 2 years ago

Suppose you take out a $107,000, 20-year mortgage loan to buy a condo. The interest rate...

Suppose you take out a $107,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 4%. 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? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. Construct a mortgage amortization. (Do not round intermediate calculations. Round your answers to 2 decimal places.) c....

Amortizing loans. Suppose that you take out a $200,000, 20-year mortgage loan to buy a condo....

Amortizing loans. Suppose that you take out a $200,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 6%, and payments on the loan are made annually at the end of each year. What is your annual payment on the loan? Construct a mortgage amortization table in Excel similar to Table 2.1, showing the interest payment, the amortization of the loan, and the loan balance for each year. What fraction of your initial loan payment...

YOUR first condo cost you $160,000, and you pay 20% cash as a down payment, for...

YOUR first condo cost you $160,000, and you pay 20% cash as a down payment, for the remainder you arrange a 30-year mortgage at a 6.5% nominal interest rate, with the first payment due in one month. a ) What will your annual payments be? b) How much of this payment will be interest and how much principal the first year? c) How much would you still owe after the third payment?

Suppose you are buying your first condo for $160,000, and you will make a $15,000 down...

Suppose you are buying your first condo for $160,000, and you will make a $15,000 down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at a 4.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be?

You plan to buy a condo with a price of $375,000. You can pay 20% of...

You plan to buy a condo with a price of $375,000. You can pay 20% of the total price and need to borrow the rest from the bank. Currently TD Canada Trust offers you a fixed rate mortgage of 2.14%. You plan to pay back your mortgage loan in 25 years. Please find out your monthly mortgage payment. After first 4 monthly payments, please find out the unpaid principal balance of your mortgage loan. Please show your detail calculation. If...

You want to purchase a new condo which costs $687,000. Your planis to pay 20...

You want to purchase a new condo which costs $687,000. Your plan is to pay 20 percent down in cash and finance the balance over 15 years at 4.50 percent. What will be your monthly mortgage payment?b) What is the interest payment in month 3? Show the amortization table for three months.

You have just borrowed $300,000 to buy a condo. You will repay the loan in equal...

You have just borrowed $300,000 to buy a condo. You will repay the loan in equal monthly payments of $3,950.37 over the next 20 years. a-1. What monthly interest rate are you paying on the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) a-2. What is the APR? (Do not round intermediate calculations. Enter your answer as a whole percent.) b. What is the effective annual rate on that loan? (Do...

You have just borrowed $160,000 to buy a condo. You will repay the loan in equal...

You have just borrowed $160,000 to buy a condo. You will repay the loan in equal monthly payments of $1,287.40 over the next 30 years. a-1. What monthly interest rate are you paying on the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) a-2. What is the APR? (Do not round intermediate calculations. Enter your answer as a whole percent.) b. What is the effective annual rate on that loan? (Do...

You have just borrowed $100,000 to buy a condo. You will repay the loan in equal...

You have just borrowed $100,000 to buy a condo. You will repay the loan in equal monthly payments of $804.62 over the next 30 years. a. What monthly interest rate are you paying on the loan?' b. What is the APR? c. What is the effective annual rate on that loan? d. What rate is the lender more likely to quote on the loan?

You have just borrowed $200,000 to buy a condo. You will repay the loan in equal...

You have just borrowed $200,000 to buy a condo. You will repay the loan in equal monthly payments of $2,106.45 over the next 25 years. a-1. What monthly interest rate are you paying on the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) Monthly interest rate % a-2. What is the APR? (Do not round intermediate calculations. Enter your answer as a whole percent.) APR% b. What is the effective annual...