Question
In: Finance
Freddy and Frieda Finance are looking to buy a house. They find a house that they...
Freddy and Frieda Finance are looking to buy a house. They find a house that they like costing $400,000 and have a $100,000 as a down payment meaning they will need a mortgage loan of $300,000 if they pay their closing costs in cash. Help them evaluate some mortgage options.
1. Nautical Bank offers a 30-year fixed rate mortgage with a nominal annual rate of 3.125%. What would be the Finances’ monthly payment under this loan?
2. Construct an amortization schedule for the 30-year Nautical Bank loan in #1 (see section 5-18 of the textbook). What will be the Finance’s loan balance after 7 years of payments (after payment 84)?
3. Bank of United States offers a 15-year fixed rate mortgage with a nominal annual rate of 2.5%. What would be the Finance’s monthly payment under this loan?
4. Construct an amortization schedule for the 15-year Bank of United States loan in #3 (see section 5-18 of the textbook). What will be the Finance’s loan balance after 7 years of payments (after payment 84)?
Solutions
Expert Solution
1. To Calculate Monthly Payment
Down Payment 100,000
Loan Amount = $400,000 - $100,000= $300,000
r = 3.125/100=0.03
Monthly Payment =
=
= $1285.126
2. Amortization Schedule
| Year | Principal | Interest | Total Paid | Balance |
| 2020 | $1,515.58 | $2,339.81 | $3,855.39 | $298,484.42 |
| 2021 | $6,181.96 | $9,239.60 | $15,421.56 | $292,302.46 |
| 2022 | $6,377.94 | $9,043.62 | $15,421.56 | $285,924.52 |
| 2023 | $6,580.14 | $8,841.42 | $15,421.56 | $279,344.38 |
| 2024 | $6,788.74 | $8,632.82 | $15,421.56 | $272,555.64 |
| 2025 | $7,003.97 | $8,417.59 | $15,421.56 | $265,551.67 |
| 2026 | $7,225.98 | $8,195.58 | $15,421.56 | $258,325.69 |
| 2027 | $7,455.05 | $7,966.51 | $15,421.56 | $250,870.64 |
| 2028 | $7,691.40 | $7,730.16 | $15,421.56 | $243,179.24 |
| 2029 | $7,935.24 | $7,486.32 | $15,421.56 | $235,244.00 |
| 2030 | $8,186.78 | $7,234.78 | $15,421.56 | $227,057.22 |
| 2031 | $8,446.32 | $6,975.24 | $15,421.56 | $218,610.90 |
| 2032 | $8,714.07 | $6,707.49 | $15,421.56 | $209,896.83 |
| 2033 | $8,990.33 | $6,431.23 | $15,421.56 | $200,906.50 |
| 2034 | $9,275.33 | $6,146.23 | $15,421.56 | $191,631.17 |
| 2035 | $9,569.37 | $5,852.19 | $15,421.56 | $182,061.80 |
| 2036 | $9,872.74 | $5,548.82 | $15,421.56 | $172,189.06 |
| 2037 | $10,185.70 | $5,235.86 | $15,421.56 | $162,003.36 |
| 2038 | $10,508.63 | $4,912.93 | $15,421.56 | $151,494.73 |
| 2039 | $10,841.76 | $4,579.80 | $15,421.56 | $140,652.97 |
| 2040 | $11,185.46 | $4,236.10 | $15,421.56 | $129,467.51 |
| 2041 | $11,540.06 | $3,881.50 | $15,421.56 | $117,927.45 |
| 2042 | $11,905.90 | $3,515.66 | $15,421.56 | $106,021.55 |
| 2043 | $12,283.33 | $3,138.23 | $15,421.56 | $93,738.22 |
| 2044 | $12,672.73 | $2,748.83 | $15,421.56 | $81,065.49 |
| 2045 | $13,074.45 | $2,347.11 | $15,421.56 | $67,991.04 |
| 2046 | $13,488.97 | $1,932.59 | $15,421.56 | $54,502.07 |
| 2047 | $13,916.57 | $1,504.99 | $15,421.56 | $40,585.50 |
| 2048 | $14,357.77 | $1,063.79 | $15,421.56 | $26,227.73 |
| 2049 | $14,812.91 | $608.65 | $15,421.56 | $11,414.82 |
| 2050 | $11,414.82 | $149.12 | $11,563.94 | $0.00 |
| Totals | $300,000.00 | $162,644.57 | $462,644.57 |
Balance after 7 years $258,325.69
3. By applying same formulae
we will get monthly payment $2000
4. Amortization Schedule
| Year | Principal | Interest | Total Paid | Balance |
| 2020 | $4,134.72 | $1,866.39 | $6,001.11 | $295,865.28 |
| 2021 | $16,799.42 | $7,205.02 | $24,004.44 | $279,065.86 |
| 2022 | $17,224.26 | $6,780.18 | $24,004.44 | $261,841.60 |
| 2023 | $17,659.84 | $6,344.60 | $24,004.44 | $244,181.76 |
| 2024 | $18,106.44 | $5,898.00 | $24,004.44 | $226,075.32 |
| 2025 | $18,564.33 | $5,440.11 | $24,004.44 | $207,510.99 |
| 2026 | $19,033.79 | $4,970.65 | $24,004.44 | $188,477.20 |
| 2027 | $19,515.12 | $4,489.32 | $24,004.44 | $168,962.08 |
| 2028 | $20,008.64 | $3,995.80 | $24,004.44 | $148,953.44 |
| 2029 | $20,514.61 | $3,489.83 | $24,004.44 | $128,438.83 |
| 2030 | $21,033.39 | $2,971.05 | $24,004.44 | $107,405.44 |
| 2031 | $21,565.30 | $2,439.14 | $24,004.44 | $85,840.14 |
| 2032 | $22,110.64 | $1,893.80 | $24,004.44 | $63,729.50 |
| 2033 | $22,669.80 | $1,334.64 | $24,004.44 | $41,059.70 |
| 2034 | $23,243.09 | $761.35 | $24,004.44 | $17,816.61 |
| 2035 | $17,816.61 | $186.11 | $18,002.72 | $0.00 |
| Totals | $300,000.00 | $60,065.99 | $360,065.99 |
Balance after 7 years $188,477.20
jeff jeffy answered 2 years agoRelated Solutions
Freddy and Frieda Finance are looking to buy a house. They find a house that they...
Freddy and Frieda Finance are looking to buy a house. They find
a house that they like costing $400,000 and have a $100,000 as a
down payment meaning they will need a mortgage loan of $300,000 if
they pay their closing costs in cash. Help them evaluate some
mortgage options.
1. Nautical Bank offers a 30-year fixed rate mortgage with a
nominal annual rate of 3.125%. What would be the Finances’ monthly
payment under this loan?
2. Construct an amortization...
Samantha and Vikas are looking to buy a house in a new development. After looking at...
Samantha and Vikas are looking to buy a house in a new
development. After looking at various models, the three models they
like are colonial, split-entry, and single-story.
The builder gave them the base price and the finished area in
square feet of the three models. They want to know the model(s)
with the least price per square foot.
Instructions
Write a program that accepts as input the base price and the
finished area in square feet of the three...
You are looking to buy your first house. The cost of the house is $325,000. The...
You are looking to buy your first house. The cost of the house
is $325,000. The bank has agreed to make a loan to you for 30 years
at 3.15% if you can make a down payment of 7.00%, and the loan
payments do not exceed 36% of your gross monthly income.
Based upon this information:
What is the amount of the mortgage loan that the bank will lend
to you?
What will be the amount of your monthly payments?...
You looking to buy your first house. The cost of the house is $350,000. The bank...
You looking to buy your first house. The cost of the house is
$350,000. The bank has agreed to make a loan to you for 30 years at
3.25% if you can make a down payment of 10%, and the loan payments
equal 40% of your gross monthly income.
Based upon this information:
A. What will be the amount of your monthly payments?
B. How much is your gross monthly income?
C. What must your annual salary be in order...
Toby, is looking to buy a house in Long Island. He has been following house prices...
Toby, is looking to buy a house in Long Island. He has been
following house prices now for a while. In March 2017, Toby noticed
the average house price in his chosen district was $327,800, while
in March 2001, the average price was $210,300.
How much did sales price increase over the time period that Toby
was considering? (Do not round intermediate calculations.
Enter your answer as a percent rounded to 2 decimal places, e.g.,
32.16.)
You are looking for a $312,598 mortgage to buy a house. The mortgage has a 7...
You are looking for a $312,598 mortgage to buy a house. The
mortgage has a 7 year term with a 22 year amortization. The rate on
the mortgage is 2.75% APR with monthly compounding and monthly
payments.
What is the balloon payment on the mortgage?
Round your answer to 2 decimal places. (For example 2.437 =
2.44)
You are planning to buy a house appraised for $350,000 and finance it through a mortgage...
You are planning to buy a house appraised for $350,000 and
finance it through a mortgage of $300,000. What is the
loan-to-value ratio and is it be above or below the normal cutoff
set by your lender of 80 percent for a prime mortgage? Being
securely employed, your take-home pay is $2,300 per month and you
have no substantial other debts. Your lender has offered you a 2.5
percent, 30 year, fixed-rate mortgage. What is the amount that you
will...
Katekani is looking to buy a house and can afford a payment of R14 000.00 a month.
Katekani is looking to buy a house and can afford a payment of R14 000.00 a month. If the house costs R1 500 000 and Jane can get a 20 year loan at 10.25% p.a. compounded monthly, how much must Jane give as a deposit to lower her payment to R14 000.00 a month?
6. Jim has an annual income of $240,000. Jim is looking to buy a house with...
6. Jim has an annual income of $240,000. Jim is looking to buy a
house with monthly property taxes of $140 and monthly homeowner’s
insurance of $70. Jim has $178 in monthly student loan payments.
Apple bank has a maximum front end DTI limit of 28% and a maximum
back end DTI limit of 36%. Both limits must be satisfied. Apple
bank is offering a fully amortizing 30 year FRM at an annual rate
of 4.5%, with monthly payments, compounded...
Assume you are looking to buy a house $200,000 with a 20 year mortgage at 12%,...
Assume you are looking to buy a house $200,000 with a 20 year
mortgage at 12%, estimate the monthly mortgage payment, first
months interest, total amount to be repaid and the total
interest.
Explain why some financial institutions prefer to sell the
mortgages they originate. Research and provide an example either
current or historical.
Why do you think it is difficult for investors to assess the
financial condition of a financial institution that has purchased a
large amount of mortgage-backed...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 4. Why did the United States and the Soviet Union find themselves in a “Cold War”...
- The Facts: Ann and Bill decided to start a coffee shop. They agreed Bill would provide...
- MARGI sells different types of wine. Customers place orders to the most popular “Summer Wine” at...
- A firm's bonds have a maturity of 8 years with a $1,000 face value, have an...
- Naive reasoning suggests that a string theory vacuum with cosmological constant Lambda1 is always unstable as...
- I. Design and code a class Rectangle that has the following properties: Two private members double...
- A bond has a $1,000 par value, 10 years to maturity, and an 8% annual coupon...
ADVERTISEMENT