borrow $400,000 from Bank of America on a 30-year mortgage at 6% interest rate. a. What would Tim's monthly payments be on his mortgage? b. Amortize the loan and determine: Interest expense for the first quarter of the loan. Cash flows for the first quarter of the loan. Loan balance at the end of the first quarter of the loan. Please show your calculations, part b is very importa
Q: Stephen has just purchased a home for $151,000. A mortgage company has approved his loan…
A: EMI or monthly mortgage payments are the fixed amount paid by the borrower to the lender that…
Q: You are a loan officer at the West Elm Savings and Loan. Mr. and Mrs. Brady are in your office to…
A: Market Value of House= $170000 Down Payment= 1/5th Of Market value = 1/5 x…
Q: Mr. and Mrs. Murthy have a totally monthly gross income of $6000.00. They are interested in…
A: GDSR is a metric that measures housing costs as a proportion of the gross income of the borrower.
Q: Amna has a housing loan of $50,000 over 15 years with a 6% interest rate. According to the Bank he…
A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: ou can afford a $1,250.00 per month mortgage payment. You can get a loan at 7% interest for 30…
A: When we make a mortgage payment we pay fixed monthly amounts as payments towards the mortgage.…
Q: Dan is considering borrowing $489,000 to purchase a new condo. Based on that information, answer the…
A: The question is based on the concept of the mortgage loan. A mortgage loan is a secured loan, which…
Q: You take out a 30-year $100,000 mortgage loan with an APR of 6% and monthly payments. In 12 years…
A: Principal balance Amount outstanding and owing for satisfying the payoff the amount of an underlying…
Q: sh is taking out a mortgage for $161,000 to buy a new house and is deciding between the offers from…
A: The given problem can be solved using PMT function in excel. PMT function computes installment…
Q: You entered into a mortgage agreement to borrow $100,000 at an interest rate of 3% and to be…
A: Given: Amount borrowed =$100000Interest rate =3%Term of loan =30 years
Q: The Fritzes are buying a house that sells for $196,000. The bank is requiring a minimum down…
A: Mortgage is a value or an amount which is borrowed from other sources for particular time and this…
Q: You are looking to buy a $275,599.00 home in Haverhill. If Bank of America will give them a 30-year…
A: Hi There, thanks for posting the question. But as per Q&A guidelines, we must answer the first…
Q: What is the cost of two points on the mortgage?
A: Information Provided: Selling Price = $125,000 Downpayment = 20% or $25,000 Loan amount = $100,000…
Q: A man plans to take a vacation in 5 years. He wants to buy a certificate of deposit for $1300 that…
A: To calculate the simple interest rate we will use the below formula Interest rate = [(A-P)/P]/T…
Q: Garret just closed a new loan on his 4-unit apartment as follows: Initial loan amount, $1,000,000,…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: Your bank offers the Bradys a 30 year mortgage with a rate of 5%. At that rate, the monthly payments…
A: Hi, there, Thanks for posting the question. As per our Q&A honour code, we must answer the first…
Q: A couple takes out a loan for $350,000 to purchase a house. They get an adjustable rate mortgage…
A: Adjustable- rate mortgage are those mortgages in which interest rate of the mortgage loan keeps…
Q: A student graduates from college with $31,000 in student loans with a 5.6% annual simple interest…
A: Solution:- When an amount is borrowed, it can either be repaid as a lump sum payment or in equal…
Q: Suppose you take out a 20-year mortgage for a house that costs $399,842. Assume the following: The…
A: Here,
Q: The Fritzes are buying a house that sells for $158,000. The bank is requiring a minimum down payment…
A: Equated Monthly Installments are one part of the equally divided monthly outgoes to clear off an…
Q: Suppose an engineer purchases a home and secures a loan of ₱2.5M from a commercial bank for 20 years…
A: Introduction Loan may be defined as that type of debt which is incurred by an individual or a…
Q: You can afford a $1400 per month mortgage payment. You've found a 30 year loan at 8% interest. a)…
A: given, pmt = $1400 m = 30 years r = 8% applying formula for pmt: pmt=loan amount…
Q: Find the monthly amortization of the loan.
A: Monthly Amortization: It refers to the monthly payments made to the lender by the borrower for…
Q: Greg Brown borrowed $100,000 to purchase a house. He agreed to repay the loan with equal monthly…
A: Installment amount is the number of periodic payments necessary to repay a loan.…
Q: John wants to borrow 75,800 from a bank payable in 3 years and 9 months. if the bank charges 9.5%…
A: Note: It is assumed that the loan is given on a simple interest rate basis. Simple Interest refers…
Q: Smith is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for…
A: A loan is a sort of debt that is taken on by an individual or another institution. The lender, which…
Q: Jason bought a home in Arlington, Texas, for $127,000. He put down 25% and obtained a mortgage for…
A: Price of home = $ 127000 Down payment = 25% Loan amount (PV) = 127000*(1-0.25)…
Q: Evan and Emmanuel want to buy a $250,000 home. They plan to pay 15% as a down payment, and take out…
A: Cost of House is $250,000 Down payment is 15% Term of loan is 30 years Interest rate is 4.9% To…
Q: Sarah is planning to purchase a new house. To purchase the house, she will need to borrow $550,000…
A: Data Given: Loan amount = $550,000 n= 30 years Rate of interest =3.5% After 3 years, Rate of…
Q: Calculate the total amount paid for Mortgage A. Calculate the total interest paid for Mortgage A.…
A: Home loan mortgages are paid on a monthly basis. During the initial years interest amounts are…
Q: Andrea is arranging a $90,000 mortgage loan from her bank. The mortgage is to be amortized by making…
A: Mortgages is a loan contract used by persons to buy capital assets such as house on debt. Mortgages…
Q: William wants to borrow $42,000.00 today to purchase a car, which bank's lending option will allow…
A: Present Value of annuity formula is used to check if the loan present value of periodic payments.…
Q: Use the following information to answer the next three questions below: You buy a house on July 1.…
A: Laon amortization schedule means where repayment during the life of loan is written with interest.
Q: Dan is considering borrowing $375,000 to purchase a new condo. Based on that information, answer the…
A: Amortization of loan- is a process to reduce the loan amount by regular payment of principal and…
Q: The Fritzes are buying a house that sells for $152,000. The bank is requiring a minimum down…
A: Mortgage is a value which is borrowed by other sources like banks for a time period and amount in…
Q: Todd Foley is applying for a $290,000 mortgage. He can get a $2,030 monthly payment for principal…
A: Calculation of number of months:Excel spreadsheet for calculation of number of months
Q: A man plans to take a vacation in 4 years. He wants to buy a certificate of deposit for $1200 that…
A: We need to use compound interest formula to solve this problem A=P(1+r)n Where A =Amount/Final…
Q: A student graduates from college with $49,000 in student loans with a 6.8% annual simple interest…
A: Loan is the amount which is borrowed from other sources for a specific period and will be paid with…
Q: Bobby takes out a mortgage for 30 years at an interest rate of 4% and his monthly repayments are…
A:
Q: You entered into a mortgage agreement to borrow $100,000 at an interest rate of 3% and to be…
A: Given: Amount borrowed=$100000Interest rate =3%Term of loan in year=30
Q: You want to buy a $212,000 home. You plan to pay 15% as a down payment, and take out a 30 year loan…
A: a) Amount of down payment = cost of house * % of down payment
Q: The Bainters want to know how much they would pay on their loan each year ds would pay on their loan…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: To go on a summer trip, Bill borrows $500. He makes no payments until the end of 2 years, when he…
A: Here, Borrowed Amount is $500 Time Period is 2 years Interest Rate is 6% Interest Type is Simple…
Q: William wants to borrow $42,000.00 today to purchase a car, which bank's lending option will allow…
A: Because you have posted multiple questions, we will answer the first question nly , for the…
Q: Jeff purchased a house costing $200,000. He put 20% down and borrowed the balance negotiating a…
A: Borrowings are the liability that is used to finance the requirement of the funds. The borrower…
Q: Brendon Walsh wants to borrow $30,000 from the bank. The interest rate is 6% and the term is for 5…
A: A loan is an agreement between two parties where an amount is exchanged in return for future…
Q: Stephen has just purchased a home for $162,000. A mortgage company has approved his loan application…
A: Mortgage is a value which a person borrowed from the sources like bank and repay it later with extra…
Q: Peter and Julia decide on a 15 year mortgage valued at $165,000. They are doing some financial…
A: Mortgage securitization is the process of clubbing mortgages of individuals having same features to…
Tim wants to borrow $400,000 from Bank of America on a 30-year mortgage at 6% interest rate.
a. What would Tim's monthly payments be on his mortgage?
b. Amortize the loan and determine:
-
- Interest expense for the first quarter of the loan.
- Cash flows for the first quarter of the loan.
- Loan balance at the end of the first quarter of the loan.
Please show your calculations, part b is very important. If you are using the TVM chart, please state whether you used PVoA, FVoA, PVoSA, FVoSA.
Step by step
Solved in 3 steps with 3 images
- Suppose you need to borrow $200,000 to buy a home, and you are deciding between a 15 year mortgage and a 30 year mortgage. Research a bank offering 15 year and 30 year mortgage loans and find the interest rates on those loans. Use the techniques you learned in this Module to do the following: 1. Calculate the monthly payment for a 15-year mortgage and for a 30-year mortgage. 2. Find the total amount of interest you will pay on the 15 year mortgage and on the 30 year mortgage. 3. Describe some of the factors (financial and non-financial) that can influence whether to obtain a shorter term mortgage or a longer term mortgage. 4. Which mortgage would you take, the 15 year or the 30 year? Explain your decision.In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, use the PMT function to determine what your monthly payment will be. Submit the spreadsheet in Canvas.Please show all steps and formulas in an excel spreadsheet to answer a. through g. using the information below! You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?
- In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, create a function that determines what your monthly payment will be.You plan to purchase a $320,000 house using a 15-year mortgage obtained from your bank. The mortgage rate offered to you is 5.20 percent. You will make a down payment of 15 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. (1) Construct the amortization schedule for the mortgage. b. (2) How much total interest is paid on this mortgage? Answer is not complete. Complete this question by entering your answers in the tabs below. Req A Req B1 Amortization Schedule Month 1 2 3 179 180 Construct the amortization schedule for the mortgage? (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Req 82 Total Interest Amortization Schedule for the 15-Year Mortgage Interest Cumulative Principal Principal 272,000.00 270,999.26 Cumulative Interest Ending BalanceYou can afford a $1400 per month mortgage payment. You've found a 30 year loan at 8% interest. a) How big of a loan can you afford? Round your answer to the nearest dollar. b) How much total money will you pay the loan company? Round your answer to the nearest dollar. c) How much of that money is interest? Round your answer to the nearest dollar. Question Help: D Post to forum Submit Question
- You can afford a $1200 per month mortgage payment. You've found a 30 year loan at 6.1% interest. a) How big of a loan can you afford? (Round to the nearest cent, as needed.) b) How much total money will you pay the loan company? (Round to the nearest cent, as needed.) S c) How much of that money is interest? (Round to the nearest cent, as needed.) Question Help: Video 1 Submit Question Video 2 Search wwww.gar aPlease build an excel spreadsheet and show the formulas to answer a. through g. using the information below You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?Answer the following question using a spreadsheet and the material in the appendix. You would like to buy a house. Assume that given your income, you can afford to pay $12,000 a year to a lender for the next 30 years. If the interest rate is 7% how much can you borrow today based on your ability to pay? What about if the interest rate is 3%? Maximum mortgage at 7%: $ Maximum mortgage at 3%: $
- You are considering buying a new home and are planning to take out a 30-year, $300,000 mortgage. You are told that the interest rate on your loan will be 3%. You want to figure out how much you will have to pay on the mortgage each month. To analyze your potential loan, you have decided to use Microsoft Excel to calculate the monthly payments. To earn full credit your spreadsheet must contain the following elements: Calculate the required monthly payment using a built-in Excel function. Reference the interest rate via a cell name rather than a cell location Build a 360-month amortization table including the outstanding loan balance at the end of each month. Suppose instead of paying the required monthly payment, you decide to pay an extra $250 per month. How much sooner will you be able to pay off your loan?The Becker family is getting a home loan to finance a $260,000 mortgage. While looking for a mortgage, they found two alternatives: Mortgage A 30-year loan with an interest rate of 3.611% and a monthly payment of $1,184. Mortgage B 15-year loan with an interest rate of 2.7% Recall: Loan Payment Formula.png| A. Calculate the total amount paid for Mortgage A. B. Calculate the total interest paid for Mortgage A. C. Calculate the monthly payment for Mortgage B. D. Calculate the total amount paid for Mortgage B. E. Calculate the total interest paid for Mortgage B. F. Write a two or more sentences giving the Becker family some advice about which mortgage to choose. G. Why might the Becker family not take your advice from part c)? Answer in one or two sentences.You have just taken out a five-year loan from a bank to buy an engagement ring. The ring costs $6,200. You plan to put down $1,400 and borrow $4,800. You will need to make annual payments of $1,100 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.) O A. Year 1 2 3 4 Cash Flow $4,800 - $1,100 -$1,100 - $1,100 - $1,100 - $1,100 O B. Year 1 2 3 4 Cash Flow - $1,400 $1,100 $1,100 $1,100 $1,100 $1,100 O C. Year 1 2 3 4 Cash Flow - $4,800 $1,100 $1,100 $1,100 $1,100 $1,100 O D. Year 1 2 3 4 Cash Flow $6,200 - $1,100 -$1,100 - $1,100 - $1,100 - $1,100