A monthly amortizing, 30-year fixed-rate hotel mortgage for $100 mi was issued 10 years ago at...
A monthly amortizing, 30-year fixed-rate hotel mortgage for $100 mi was issued 10 years ago at 2%. Market rates for such mortgages today has increased to 5%. How much will you pay to buy this mortgage today? Please show all work in an Excel File
Homework Answers
Enter the below formula in any cell in Excel
=PV(5%/12,12*20,PMT(2%/12,12*30,100*10^6))
=5,60,06,706.32
Add Answer to:
A monthly amortizing, 30-year fixed-rate hotel mortgage for $100
mi was issued 10 years ago at...
Ann is looking for a fully amortizing 30-year Fixed-Rate Mortgage with monthly payments for $3,200,000. Mortgage...
Ann is looking for a fully amortizing 30-year Fixed-Rate Mortgage with monthly payments for $3,200,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 30 years, what is Ann’s annualized IRR from mortgage B?
Ten years ago you obtained a 30-year mortgage for $400,000 with a fixed interest rate of...
Ten years ago you obtained a 30-year mortgage for $400,000 with a fixed interest rate of 3% APR compounded monthly. The mortgage is a standard fixed rate mortgage with equal monthly payments over the life of the loan. What are the monthly fixed mortgage payments on this mortgage (i.e., the minimum required monthly payments to pay down the mortgage in 30 years)? What is the remaining loan balance immediately after making the 120th monthly payment (i.e., 10 years after initially...
Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan...
Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate. After 28 years, you would like to sell the property. What is your loan balance at the end of 28 years? Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate and your balloon payment is $50,000. What is your...
6. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $1,250,000...
6. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $1,250,000 at 4.38%. What fraction of Ann's 40th payment goes to interest? Write your answer in percent, without the % sign.
Exactly six years ago, Cathy bought her dream home using a 30-year mortgage with an APR...
Exactly six years ago, Cathy bought her dream home using a 30-year mortgage with an APR of 6.5% on a $230,000 loan. She has been making her monthly payments. Today, she came to know that her bank is offering a special mortgage refinance offer at an APR of 4.25% on 20-year mortgages. How much will Cathy’s monthly payment change, if she decides to refinance today? Original loan Years Ago (N) 6.00 years Term (years, N0) 30.00 years APR...
2 years ago we purchased a house with a $525,000 mortgage at 9% with 30 year mortgage What is the monthly payment? Ho...
2 years ago we purchased a house with a $525,000 mortgage at 9% with 30 year mortgage What is the monthly payment? How much is owed after 2 years? How much interest did we pay over a 2 yr period? If we are looking to refinance and the current rate is 6.75% what would be the monthly payment on a 20yr and 15 yr mortgage.
6. A company issued a 25-year bond two years ago at a coupon rate of 5.3...
6. A company issued a 25-year bond two years ago at a coupon rate of 5.3 percent. The bond makes semiannual coupon payments. If the bond currently sells for 105 percent of its par value of $1,000, what is the YTM? 7. Bond X makes semiannual payments. The bond pays a coupon rate of 7 percent, has a YTM of 6.2 percent, and has 13 years to maturity. Bond Y makes semiannual payments. This bond pays a coupon rate of...
Real Estate Finance answer all please . John Corbitt takes a fully amortizing mortgage for $80,000 at 10 pe...
Real Estate Finance
answer all please
. John Corbitt takes a fully amortizing mortgage for $80,000 at 10 percent interest for 30 years, monthly payments. What will be his monthly payment? 2. Dave Burns wants to buy a house. To do so, he must incur a mortgage. A local lender has determined that Dave can afford a monthly payment of $600, principal and interest. If the current interest rate on 30-yearm fixed-rate mortgage is 9.50 percent, what is the maximum...
Consider a fully amortizing mortgage loan of $75,000 for 30 years with an interest rate of...
Consider a fully amortizing mortgage loan of $75,000 for 30 years with an interest rate of 12%. What is the loss if Interest rates increase to 13%?
Exactly six years ago, Cathy bought her dream home using a 30-year mortgage with an APR of 6.5% on a $230,000 loan. She...
Exactly six years ago, Cathy bought her dream home using a 30-year mortgage with an APR of 6.5% on a $230,000 loan. She has been making her monthly payments. Today, she came to know that her bank is offering a special mortgage refinance offer at an APR of 4.25% on 20-year mortgages. How much will Cathy’s monthly payment change, if she decides to refinance today?
6. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $1,250,000 at 4.38%. What fraction of Ann's 40th payment goes to interest? Write your answer in percent, without the % sign.
6. A company issued a 25-year bond two years ago at a coupon rate of 5.3 percent. The bond makes semiannual coupon payments. If the bond currently sells for 105 percent of its par value of $1,000, what is the YTM? 7. Bond X makes semiannual payments. The bond pays a coupon rate of 7 percent, has a YTM of 6.2 percent, and has 13 years to maturity. Bond Y makes semiannual payments. This bond pays a coupon rate of...
Real Estate Finance
answer all please
. John Corbitt takes a fully amortizing mortgage for $80,000 at 10 percent interest for 30 years, monthly payments. What will be his monthly payment? 2. Dave Burns wants to buy a house. To do so, he must incur a mortgage. A local lender has determined that Dave can afford a monthly payment of $600, principal and interest. If the current interest rate on 30-yearm fixed-rate mortgage is 9.50 percent, what is the maximum...
Consider a fully amortizing mortgage loan of $75,000 for 30 years with an interest rate of 12%. What is the loss if Interest rates increase to 13%?
Most questions answered within 3 hours.
-
1. A 1200 kg car is practicing on a flat test
track. The car begins moving...
asked 6 minutes ago -
An
agency collects demographics concerning the number of people in
families per household in a certain...
asked 7 minutes ago -
Writing a Persuasive Essay on:
(Smoking in public places should be banned) Can i please get...
asked 10 minutes ago -
Q23 Suppose H0 is left-tailed and tTest = -2.26. (Note tTest not
zTest). The tTest value...
asked 18 minutes ago -
A runaway train car that has a mass of 1.71e+4 kg travels at a
speed of...
asked 18 minutes ago -
Question 1: For each of the sections in this part, the
competitive market for labor is...
asked 16 minutes ago -
Lincoln, Inc., which uses a volume-based cost system, produces
cat condos that sell for $170 each....
asked 23 minutes ago -
On November 3, the spot price for cotton was $0.81/lb., and the
February futures price was...
asked 24 minutes ago -
Using Python:
A Prime number is an integer greater than 1 that cannot be
formed by...
asked 46 minutes ago -
Read about Cokes strategy in Africa in the article below and
discuss the ethics of selling...
asked 33 minutes ago -
What made of a 40.0% NaOH solution should be diluted to 1.00 L
with water to...
asked 33 minutes ago -
Draw and describe the results of the Meselson-Stahl experiments
showing that DNA replication followed the Semi-conservative...
asked 38 minutes ago