You are planning to build a vacation home. Your rich uncle offers you a $35,000 loan at 10.5% interest if you make $325 per month payments at the end of each month, how many payments will be required to pay off the loan, and how many years will this take?

You are planning to build a vacation home. Your rich uncle offers you a $35,000 loan at 10.5% interest if you make $325 per month payments at the end of each month, how many payments will be required to pay off the loan, and how many years will this take?

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter4: Managing Your Cash And Savings

Section: Chapter Questions

Problem 7FPE: Calculating interest earned and future value of savings account. If you put 6,000 in a savings...

See similar textbooks

Related questions

Q: 0 year vs 20 year mortgage How much money you save altogether by taking out 20 year mortgage rather…

A: Option -I Purchase Price of House $ 1,90,000 Down Payment @10% $ 19,000…

Q: You are considering the purchase of a condominium to use as a rental property. You estimate that you…

A: Monthly rent = $1300 Monthly costs = $300 r = 6% per annum = 0.5% per month n = 25 years = 300…

Q: You plan to purchase a house for $ 400,000 and you will make a 20% down payment. You are evaluating…

A: The mortgage is taken to purchase or maintain real estate. The borrower pays the lender regular…

Q: Suppose you are buying your first condo for $180,000, and you will make a $15,000 down payment. You…

A: Condo price = $ 180,000 Down payment = $ 15000 Loan amount(P) = Condo price-Down payment…

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: Suppose yoU want to buy a new house. You currently have $15,000, and you figure you need to have a…

A: Cost of house is $150,000 Interest rate is 7.5% Current amount we have is $15000 Down payment 10%…

Q: I want to buy a $195,000 house and plan to pay 20% as a down payment t and take a 3.8% APR loan for…

A: To find the monthly payment, we will use 'PMT' function in excel. As down payment is 20% ($39,000),…

Q: You are buying a house and have saved a down payment of $15,000. You can afford a monthly payment of…

A: Borrowings are the liability that is used to finance the requirement of the funds. The borrower…

Q: After deciding to acquire a new car, you can either lease the car or purchase it with a three-year…

A: Lease is a way to get the asset for a fixed time period by paying periodicals payments to other…

Q: An engineer purchases a house using only a loan borrowed from a local bank. The loan is offered at…

A: A study that proves that the future worth of the money is lower than its current value due to…

Q: You planned to borrow $575,000 for a house at 2.9% interest for 30 years. You find a house that you…

A: A loan is a sum of money obtained from outside sources such as banks and repaid over time in fixed…

Q: You want to purchase a house valued at $200,000. After a downpayment, you can finance the house…

A: Value of the house = $200,000 Number of years of mortgage = 20 Number of periods (n) = 20*12 = 240…

Q: You have just purchased a new warehouse. To finance the purchase, you have arranged for a 30-year…

A: The calculation is:

Q: You are looking to buy a $415,000.00 home in Haverhill. If Bank of America will give them a 15-year…

A: 1) Loan Amount = 80% of 415,000 = $332,000.

Q: You are looking to buy a $415,000.00 home in Haverhill. If Bank of America will give them a 30-year…

A: Amount to be financed = Cost of house - Down payment = $415,000 - ($415,000*20%) = $332,000 Nos of…

Q: Assume you graduate from college with $32,000 in student loans. If your interest rate is fixed at…

A: given, P = $32000 r=4.9% m =12 (monthly compounding) n = 10 year

Q: You have recently graduated and intend to settle down. Your current salary is $60,000 per annum and…

A: The present value of the annuity is the current worth of a cash flow series at a certain rate of…

Q: You can afford payments of $950 per month for the purchase of a house. a) What is the largest…

A: Given details, Monthly payments, C = $950Interest rate, r = 3.2% p.a. or 0.267% per month (3.2%…

Q: You want to buy a $243,000 home. You plan to pay 10% as a down payment, and take out a loa with a…

A: As per Bartleby honor code, when multiple sub-parts of a question are asked, the expert is required…

Q: You want to borrow $75,000 from your local bank to buy a new sailboat. You can afford to make…

A: The given problem can be solved using RATE function in excel. RATE function provides interest rate…

Q: You are thinking of purchasing a house. The house costs $300,000. You have $43,000 in cash that you…

A: We need to use loan amortization formula to calculate annual payment Annual payment(PMT)…

Q: You are looking to buy a $415,000.00 home in Haverhill. If Bank of America will give them a 15-year…

A: Amount financed = Cost of house - down payment = $415,000 - ($415,000 *20%) = $332,000 Monthly…

Q: You want to buy a $258,000 home. You plan to pay 20% as a down payment, and take out a 4% APR loan…

A: Amortized Loan: Amortized loan is a type of loan in which the borrower would pay periodic payments…

Q: se price of the house, and you are looking at a 20 year loan at 6.12% interest compounded monthly.…

A: Maximum price = Down payment amount + Present value of mortgage payment

Q: You are thinking of renovating a basement apartment beneath your house, which you currently rent out…

A: Incremental rent per month due to reinovation = C = $ 729 - $ 521 = $ 208Payment frequency =…

Q: Your uncle will sell you his bicycle shop for $170,000, with "seller financing," at a 6.0% nominal…

A: Loan amount = Monthly Payment * [1-(1+i)^-n]/i + Final Payment/ (1+i)^n 170000 = Monthly Payment *…

Q: he McBertys have $30,000 in savings to use as a down payment on a new home. They also have…

A: The question is based on the concept of mortgage loans. The mortgage loan is a secured type of loan…

Q: You are looking to buy a $415,000.00 home in Haverhill. If Bank of America will give them a 30-year…

A: For the calculation I have used the above given formula and got the monthly payment to be…

Q: You are looking to buy a $415,000.00 home in Haverhill. If Bank of America will give them a 15-year…

A: Monthly Payment = $2,333

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: Carl and Melissa have a monthly income of $6000. They want to buy a house for $200,000 and make a…

A: Carl and Melissa have a monthly income of $6000. The cost of the house is $200,000. Down payment of…

Q: You plan to purchase a house for $400,000 and you will make a 20% down payment. You are evaluating…

A: A mortgage (or loan) with a fixed annual stated rate is the net amount of borrowings that a borrower…

Q: You want to buy a $194,000 home. You plan to pay 20% as a down payment, and take out a 3.3% APR loan…

A: We will only answer the first three subparts for the remaining subparts kindly resumit the whole…

Q: You have an outstanding student loan with required payments of $500 per month for the next four…

A: Here, Lottery Amount is $10,000

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: Suppose you have a student loan of $50,000 with an APR of 12% for 40 years. Complete parts (a)…

A: Student Loan Amount (P) = $50,000 APR (r)= 12% or 0.12 n = 12 because payment is monthly Time ( t)…

Q: You have just made an offer on a new home and are seeking a mortgage. You need to borrow $600,000.…

A: Mortgage: It is termed as a loan used for purchasing properties, homes, and other real estate…

Q: If you borrow $30,000 from your dad for college and you agree to pay him back at 14% interest per…

A: GIVEN, LOAN (P)= $30,000 RATE(R) =14% MONTHLY INSTALLMENT(A)= $750 FREQUENCY OF COMPOUNDING (M) =12

Q: a) You are planning to retire in 25 years time. Immediately after your retirement, you wish to go…

A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: You need a 30-year, fixed-rate mortgage to buy a new home for $400,000. Your mortgage bank will lend…

A: Mortgage/ Borrowings Borrowings are the loan which is taken by the individual to meet its financial…

Q: You plan to purchase a house for $ 400,000 and you will make a 20% down payment. You are evaluating…

A: Price of house $400,000 Down payment [$400,000*20%] $80,000 Loan amount or PV of loan $320,000…

Q: You want to buy a $168,000 home. You plan to pay 5% as a down payment, and take out a 30 year loan…

A: Cost of home = $168000 Down payment = 5% Loan period = 30 Years Interest rate = 6.95%

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: Marie and Danny Would like to buy a house for $220,000. The down payment for the mortgage is 30% of…

A: “Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Q: You are buying your first house for $220,000 and are paying $30,000 as a down payment. You have…

A: Answer) Calculation of monthly payment Installments are to be paid monthly Amount Borrowed…

Q: Anna and Doug are in the market for a new house. The maximum payment they can afford is $700 per…

A: The loan amount will depend upon the periodic payment, interest rate and the duration of the loan

Q: McBertys have $20,000 in savings to use as a down payment on a new home. They also have determined…

A: Given, Down payment is $20,000 Payment is $1500 to $1800 Rate is 11% Term of loan is 30 years

Question

show relevant calculation

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?
Calculating interest earned and future value of savings account. If you put 6,000 in a savings account that pays interest at the rate of 3 percent, compounded annually, how much will you have in five years? (Hint: Use the future value formula.) How much interest will you earn during the five years? If you put 6,000 each year into a savings account that pays interest at the rate of 4 percent a year, how much would you have after five years?
You can afford payments of $950 per month for the purchase of a house. a) What is the largest amount you can finance for this house at 3.2% APR for 30 years? (Round to the nearest dollar.) b) How much total will you be paying the loan company at the end of 30 years for this house if you are paying $950 per month for 30 years? c) Now you are curious what the payments would be if you financed the amount found in part a) at 3.2% APR for 20 years instead of 30 years. How much would your monthly payments be if you financed the amount you found in part a) for 20 years at 3.2% APR? (Round to the nearest dollar.) d) Using the payments you found from part c), how much total will you pay the loan company at the end of 20 years?
You can afford to pay $15,000 at the end of each of the next 30 years to repay a home loan. If the interest rate is 7.50%, what is the most you can borrow?
You lend a friend $10,000, which your friend will repay in 5 equal annual end-of-year payments of $3,000, with the first payment to be received 1 year from now. What rate of return does your loan receive? I need to be able to use excel and manually calculate as well.
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…
After making payments of $901.10 for 8 years on your 30 year loan at 8.3%, you decide to sell your home. What is the loan payoff?
You are looking to buy a $415,000.00 home in Haverhill. If Bank of America will give them a 15-year mortgage at 3.25% annual interest rate for the cost of the house after they receive a 20% down payment. Determine the loan amount? How much their monthly payment will be?
We suggest the use of a spreadsheet to create the amortization tables. You take out a 30-year mortgage for $80,000 at 9.25%, to be paid off monthly. Construct an amortization table showing how much you will pay in interest each year for the first 15 years and how much goes toward paying off the principal. If you sell your house after 15 years, how much will you still owe on the mortgage according to the amortization table? HINT [See Example 8.] (Round your answer to the nearest cent.) $
You need a 30-year, fixed-rate mortgage to buy a new home for $400,000. Your mortgage bank will lend you the money at a 6 percent APR for a 360 month loan. You can only afford a monthly payment of $1000. How much downpayment should you put at the time of purchase? Please show your work using excel formulas.
there is a house on sale for $800,000. You believe you can finance the home for $500,000 for 20 years at a 2% interest rate. What would the monthly principle and interest payment be for the acquird loan? Calculate using the PV funtion in excel.
You want to buy a new house. You can afford to pay $15,000 per year for 30 years with the first payment being due one year from today. If the interest rate on your loan is 3%, what price of home can you buy today? Enter your answer as a number rounded to 2 decimal places.