Use the formulas presented in the lectures to CALCULATE the answers to the following items. Round the annuity factor to 4 decimal places and the mortgage payment to the penny. Suppose the current price of a home is $320,000. The amount of the loan is $ if the down payment is 10%. The annuity factor for a 30-year mortgage is if the mortgage rate is 7.2%. The mortgage payment is $ when a 10% down payment is made to purchase a $320,000 given
Q: Suppose your gross monthly income is $5,500 and your current monthly payments are $575. If the bank…
A: Maximum monthly payment = (Gross monthly income *Allowable % for monthly payments)- Current monthly…
Q: Suppose you want to purchase a home for $425,000 with a 30-year mortgage at 4.84% interest. Suppose…
A: PMT function gives the payment for the loan for the constant payment and the constant rate of…
Q: You organize an investment team to purchase a commercial property for $850,000. The bank demands a…
A: A mortgage loan is given by the bank to the purchase of the home for purchasing the home and if the…
Q: You plan to purchase a $390,000 house using either a 30-year mortgage obtained from your local…
A: The question is based on the concept of Financial Management.
Q: Suppose you wish to purchase heavy equipment machinery and a commercial bank will lend you $65,000…
A: Amount lent = $65,000 Loan period = 5 years* 12 = 60 Nominal interest rate = 8%/12 = 0.6667%
Q: Suppose you want to purchase a home for $525,000 with a 30-year mortgage at 5.44% interest. Suppose…
A: Note: No intermediate rounding is done for successive parts as well. Value of house = $525,000…
Q: Suppose you want to purchase a home for $425,000 with a 30-year mortgage at 5.84% interest. Suppose…
A: 30 years 15 years Purchase of house 425000 425000 Downpayment(25%) 106250 106250 Amount…
Q: Suppose you take out a 36-month installment loan to finance a delivery van for $26,100. The payments…
A: Loan amount =26100 Financial charges =9360 Monthly payment =985 Total =36 months Monthly financial…
Q: Use PMT = to determine the regular payment amount, rounded to the nearest cent. The cost of a home…
A: Cost of House is $110,000 Time period is 20 years or 20×12=240 months Interest rate is 3% Monthly…
Q: Using the formula for an annuity, what would be the monthly payments on a 5-year fixed-rate car loan…
A: Loan amortization refers to a schedule which is prepared to shows the periodic loan payments, amount…
Q: Suppose that 10 years ago you bought a home for $150,000, paying 10% as a down payment, and…
A: A mortgage is a property loan given by banks to their customers for purchasing a house or other real…
Q: ut an $8,000 car loan that calls for 7 annual payments of $2,400 each. What is the interest rate?
A: Annual payments are made for payment of loan which carry the interest and payment of principal…
Q: 1. Suppose that 10 years ago you bought a home for $160,000, paying 10% as a down payment, and…
A: Mortgage/ Borrowings: Borrowings are the loan which is taken by the individual to meet its…
Q: Suppose that 10 years ago you bought a home for $170,000, paying 10% as a down payment, and…
A: Computation as follows: Down payment: Hence, the down payment is $17000. Mortgage loan: Hence, the…
Q: Suppose you take out a 30-year mortgage of $100,000 with a fixed interest rate of 5 percent. You…
A: given, p = $100,000 r = 5% m = 12 n = 30
Q: If you went to the bank for a 35 year, $180,000 mortgage at an interest rate of 7% compounding…
A: A borrower is required to pay the lender the interest and the original amount by paying regular…
Q: You want to buy a car, and a local bank will lend you $30,000. The loan would be fully amortized…
A: An effective annual rate (EAR) is the actual rate of interest to be paid annually after taking…
Q: 1. You want to buy a car, and a local bank will lend you $15,000. The loan will be fully amortized…
A: " Since this question contains multiple parts, we will answer only the first part for you. Kindly…
Q: Use PMT= to determine the regular payment amount, rounded to the nearest dollar. The price of a home…
A: “Hi There, thanks for posting the question. But as per Q&A guidelines, we must answer the first…
Q: If your bank approves a $300,000 mortgage for your new home, at an annual percentage rate of 4.5%…
A: Loan amount = $ 300,000 Interest rate = 4.5% Monthly interest rate = 4.5%/12 = 0.375% Monthly…
Q: Suppose you wanted to buy a $200,000 house. You have $30,000 cash to use as the downpayment. The…
A: Given PV = amount of loan = 200000-30000 = $ 170000 r = rate of interest = 6/12 = 0.05 n = number of…
Q: You want to buy a $226,000 home. You plan to pay 5% as a down payment, and take out a 30-year loan…
A: Price = $226000 Down payment = 5% Interest rate = 6.55% Monthly interest rate (r) = 6.55%/12 =…
Q: maximum loan
A: Loan amount refers to the amounts which a person borrowed at any given time under the mortgage. It…
Q: Suppose you want to purchase a home for $475,000 with a 30-year mortgage at 4.54% interest. Suppose…
A: a) Value of home = $475,000 Down payment = 30% = 30%*$475000 = $142500 Loan amount = $332,500 Number…
Q: Suppose you want to purchase a home for $525,000 with a 30-year mortgage at 4.64% interest. Suppose…
A: given, price = $525000 n = 30 years r = 4.64% m = 12 down payment =30%
Q: You purchase a home for $400,000 and make a down payment of $125,000. The balance is borrowed and…
A: Using excel PMT function
Q: You want to buy a car, and a local bank will lend you $15,000. The loan will be fully amortized over…
A: Time value of money (TVM) refers to the concept which proves that the value of money today is higher…
Q: borrow $400,000 from Bank of America on a 30-year mortgage at 6% interest rate. a. What would Tim's…
A: The given problem can be solved using PMT function in excel. PMT function computes installment…
Q: Suppose you purchase a home and obtain a 30-year fixed-rate loan of $145,000 at an annual interest…
A: Time Period = 30 years*12 = 360 months Loan Amount = 145,000 Interest% = 7.5%/12 = 0.625%
Q: You want to buy a $214,000 home. You plan to pay 10% as a down payment, and take out a 30 year loan…
A: a) Mortgage amount = Cost of home - Down payment Monthly payments are calculated using excel PMT…
Q: Suppose your gross monthly income is $5,600 and your current monthly payments are $525. If the bank…
A: Step 1: The calculation is:
Q: A homebuyer wishes to take out a mortgage of $200,000 for a 40-year period. What monthly payment is…
A: Mortgage loan=$200,000 Time period=40 years Interest rate=11% We can calculate the monthly payment…
Q: Suppose you purchase a car for a total price of $21,750, including taxes and license fee, and…
A: Part A and B:Calculation of Monthly Payment and Total Interest Paid:The monthly payment is $317.74…
Q: Suppose you purchase a car for a total price of $24,790 including taxes and licensee and finance…
A: To find the monthly payment, we will use the present value of annuity formula and adjust it to find…
Q: You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 31-year…
A: The annual interest rate that is charged by the lenders or at which the investors earn additional…
Q: Suppose you want to purchase a home for $425,000 with a 30-year mortgage at 4.14% interest. Suppose…
A: We can determine the monthly payments using the PMT function in excel. The syntax is: PMT (rate,…
Q: You want to buy a car, and a local bank will lend you $35,000. The loan will be fully amortized over…
A: Loan is contract between lender and borrower where lender provide funds to borrower that is repaid…
Q: Using a TMV solver You would be borrowing $350,000 for a home loan at 3% interest, but you are…
A: Hello. Since your question has multiple sub-parts, we will solve first three sub-parts for you. If…
Q: Suppose you want to purchase a home for $525,000 with a 30-year mortgage at 4.84% interest. Suppose…
A: Price of Home = $525000 Inetest Rate(r) = 4.84%/12 = 0.4033% Downpayment = 30% Amount financed…
Q: You plan on borrowing $320,000 for a mortgage and are considering the following two loan options: a…
A: Using excel PMT function
Q: Use PMT= to determine the regular payment amount, rounded to the nearest dollar. The price of a home…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: How much downpayment should you put at the time of purchase? how would i calculate this in excel?
A: Downpayment: It refers to the amount of money paid by the buyer in the early phase of purchasing…
Q: What are the monthly payments on the original loans ?(Round nearest to cent)
A: Given values, Mortgage = $2,50,000 for 50 year ---->Monthly Payment No. of payments = 50*12 =…
Q: You have just purchased a new warehouse. To finance the purchase, you've arranged for a 38-year…
A: Annual Percentage Rate: The annual percentage rate (APR) of a loan to a borrower is the total cost…
Q: Suppose you want to purchase a home for $475,000 with a 30-year mortgage at 5.34% interest. Suppose…
A: Monthly payment: Monthly payment $1,854.655875 Answer: $1,854.66
Q: Suppose you want to purchase a house. Your take-home pay is $2830 per month, and you wish to stay…
A: Monthly affordable payment (M) = (1/4) of $2830 = $707.50 r = 3.95% per annum = 0.329167% per month…
Q: A loan officer states, "Thousands of dollars can be saved by switching to a 15-year mortgage from a…
A: We will apply the principles of compounding and time value of money here. The principle of…
Q: Suppose that you get a 15-year mortgage for $100,000 at 6.75%. What is your monthly payment? (Fill…
A: Given: Years = 15 Loan amount = $100,000 Interest rate = 6.75%
Q: Oppenheimer Bank is offering a 30-year mortgage with an EAR of 5 3/8%. If you plan to borrow…
A: A mortgage is taken to purchase or maintain real estate. The borrower pays the lender regular…
Mortgages
A mortgage is a formal agreement in which a bank or other financial institution lends cash at interest in return for assuming the title to the debtor's property, on the condition that the obligation is paid in full.
Mortgage
The term "mortgage" is a type of loan that a borrower takes to maintain his house or any form of assets and he agrees to return the amount in a particular period of time to the lender usually in a series of regular equally monthly, quarterly, or half-yearly payments.
Step by step
Solved in 2 steps
- Suppose you take out a $117,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 5%. 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? b. Construct a mortgage amortization. c. What fraction of your initial loan payment is interest? d. What fraction of your initial loan payment is amortization? e. What is the total of the loan amount paid off after 10 years (halfway through the life of the loan)? f. If the inflation rate is 3%, what is the real value of the first (year-end) payment? g. If the inflation rate is 3%, what is the real value of the last (year-end) payment? h. Now assume the inflation rate is 6% and the real interest rate on the loan is unchanged. What must be the new nominal interest rate? i-1. Recompute the amortization table. i-2. What is the real value of the first (year-end) payment in this high-inflation scenario? j. What is the real value of the last…Based on Exhibit 9-9, or using a financial calculator, what would be the monthly mortgage payments for each of the following situations? Note: Round time value factor and final answers to 2 decimal places. What relationship exists between the length of the loan and the monthly payment? How does the mortgage rate affect the monthly payment? a. $61,000, 15-year loan at 7.50 percent. b. $151,000, 30-year loan at 8.00 percent. c. $88,000, 20-year loan at 6.50 percent. d-1. Longer mortgage terms mean a d-2. For increase in mortgage rate Monthly Mortgage Payment monthly payment. monthly payment is required.Suppose that you get a 15-year mortgage for $100,000 at 6.75%.What is your monthly payment?(Fill in the blank below and round your answer to 2 decimal places.)Your monthly payment would be $______.
- Suppose you purchase a home and obtain a 15-year fixed-rate loan of $195,000 at an annual interest rate of 6.0%. a) What is your monthly payment? N: months I %: P.V: $ PMT: $ F.V: 0 P/Y: 12 C/Y: 12 b) Of the first month's mortgage payment, how much is interest? HINT: I=Prt Interest: I=$ c) Of the first month's mortgage payment, how much is applied to the principal? HINT: PMT - Interest Amount Applied to Principal: $ d) How much is your outstanding balance after the first month’s payment? HINT: Principal - Amount Applied to Principal Outstanding Balance after first payment: $Based on Exhibit 9.9, or using a financial calculator, what would be the monthly mortgage payments for each of the following situations? Note: Round tin value factor and final answers to 2 decimal places. What relationship exists between the length of the loan and the monthly payment? How does the mortgage rate affect the monthly payment? a $120,000, 15-year loan at 5 percent b. $86,000, 30-year loan at 4.5 percent. c$105,000, 20-year loan at 4 percent d-1. Longer mortgage terms mean a d-2 For increase in mortgage rate Monthly Mortgage Payment monthly payment monthly payment is requiredSuppose you are buying your first condo for $190,000, and you will make a $10,000 down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at 3.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be? You are not required to show calculations. However to receive credit you must provide the inputs used (N, PMT, FV, I/Y, PV) to solve. If you utilize a template, you can copy and paste the section used in the submission. $808.28 $853.18 $527.78
- Use graphical approximation techniques or an equation solver to approximate the desired interest rate. A person makes annual payments of $1000 into an ordinary annuity. At the end of 5 years, the amount in the annuity is $5815.35. What annual nominal compounding rate has this annuity earned? Please step by step answer.Please show how to solve this using an Excel spreadsheet and please show the formulas. The maturity of the balloon loan is 5 years, amortization period is 30 years, loan amount is $85,000 with annual interest rate 4.5% and monthly payments. What is the monthly payment for this balloon mortgage? What is the balloon payment at the end of five years for this balloon mortgage?(Components of an annuity payment) You take out a 20-year mortgage for $275,000 to buy a new house. What will your monthly payments be if the interest rate on your mortgage is 6 percent? Use a spreadsheet to calculate your answer. Now, calculate the portion of the 120th monthly payment that goes toward interest and principal. Use five decimal places for the monthly interest rate in your calculations. a. Using a spreadsheet to calculate your answer, your monthly payments will be $ ( Round to the nearest cent.)
- Suppose you take out a 30-year mortgage of $100,000 with a fixed interest rate of 5 percent. You must make 360 equal monthly payments. Write an equation that defines what the payment is?Use the Loan Payoff Table to determine both the finance charge and the payment required to amortize a loan of $4100 at an annual interest rate of 11% with a term of 36 monthly payments. What is the amount of each payment? What is the finance charge?Suppose you take out a home mortgage for $160,000 at a monthly interest rate of 0.6%. If you make payments of $1200/month, after how many months will the loan balance be zero? Estimate the answer by graphing the sequence of loan balances and then obtain an exact answer. Graph the sequence of loan balances. Choose the correct graph below. O A. 160,000 its 125 months loan balance 150 Q Q The loan balance will be zero after 269 months. (Round up to the nearest month.) O B. loan balance 160,000 125 150 months Q O loan balance 160,000 260 290 months Q O D. 160,000 it loan balance 260 ¹290 months Ⓒ Q