Suppose you wish to purchase heavy equipment machinery and a commercial bank will lend you $65,000 for the transaction. The loan will be amortized over 5 years and the nominal interest rate will be 8% payable monthly. Calculate the monthly payment and the annual percentage rate (EAR) of the loan to be amortized
Q: You want to buy a $170000 home. You plan to pay $34000 as a down payment, and take out a 20 year…
A: Hi, since you have posted a question with multiple sub-parts, I will answer the first three…
Q: out a 36-month installment loan to finance a delivery van for $26,100. The payments are $987 per…
A: The given problem can be solved using FV function in excel. FV function computes outstanding loan…
Q: Suppose on January 1 you deposit $1000 in an account that pays a nominal, or quoted, interest rate…
A: Future value is the value of an asset that grows after a specific period of time. The future value…
Q: We will use Excel PMT function to calculate the payment Rand then create an amortization schedule…
A: PMT function in excel is used to calculate the amount of payment received or paid by the individual.…
Q: e net price. Your buyer also need to pay the monthly amortization of 34,950 for 5 years.How much was…
A: Amortization is the allocation of the cost of an intangible asset over its life. The maximum life of…
Q: 1)You have taken out a loan of 3,000,000 to buy an apartment. The loan is an annuity loan of 30…
A: The loan is a facility provided by financial institution to buy an asset and repay it in future in…
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 were able to sell a car worth 2,100,000, which would be financed by a bank. You told your buyer…
A: “Since you have posted a question with multiple subparts, we will solve first three subparts for…
Q: You have borrowed $20,000 from a bank for a five-year period. You will be making monthly payments on…
A: Borrowed amount is $20,000 Interest rate on Loan is 12% per annum Interest rate compounded monthly…
Q: You take out a 5-year loan of $20,000 from a bank today, where repayments are made at the end of…
A: Given, The loan amount is $20,000 Term of loan is 5 years Nominal rate is 8% compounded monthly.
Q: An institutional lender is willing to make a loan for $1 million on an office building at a 6…
A: Hi, there, Thanks for posting the question. As per our Q&A honour code, we must answer the first…
Q: Consider a loan of $2 million that is paid quarterly over a period of 10 years. Calculate the dollar…
A: In case of loan payments a fixed amount is paid in each period. While the amount of each payment…
Q: You borrow $ 1 million on a 10-year loan from a bank to finance the expansion of your business.…
A: Note: Since you have posted a question with multiple sub-parts, we will solve first three sub-parts…
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: An institutional lender is willing to make a loan for $1 million on an office building at a 10…
A: Excel Spreadsheet: Excel Workings:
Q: You want to buy a $170000 home. You plan to pay $51000 as a down payment, and take out a 15 year…
A: Given:
Q: Your firm has taken out a $535,000 loan with 8.6% APR (compounded monthly) for some commercial…
A: Loan (L) = $535000 r = 8.6% per annum = 0.7167% per month n = 15 years = 180 months M = Monthly…
Q: A company needs to buy a building in 4 years, and must fund the down payment from its profits. The…
A: For availing a loan for an asset, a person is required to pay some amount as down payment. Down…
Q: You want to buy a $140000 home. You plan to pay $14000 as a down payment, and take out a 20 year…
A: Hi, since you have posted a question with multiple sub-parts, we will answer the first three (as per…
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: borrowed Php200,000 from a local bank having an interest of 8% per annum, compounded monthly. If the…
A: Loans are to be paid by the equated monthly payments which carry the payment of principal and…
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: 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: Suppose you take out a 45-year $125,000 mortgage with an APR of 6%. You make payments for 5 years…
A: Original loan = $125,000 APR = 6% New loan APR = 5.2%
Q: You plan to obtain a $10000 loan from a furniture dealer at 10% annual interest rate that you will…
A: Annual loan payment is the repayment of loan annually for the period of loan, that includes interest…
Q: Your company borrows $500,000 from a bank to finance the purchase of a new machine. The nominal…
A: First let us calculate the 4 equal half yearly payments that need to be made. This can be calculated…
Q: You decide to buy a small office building costing $150.000 and take out a fixed term loan over 5…
A: Excel Spreadsheet:
Q: Your company has determined it can and is willing to pay a monthly mortgage payment of $12,000 (per…
A: Maximum amount the company can pay is present value of monthly payments
Q: You took out a loan 10 years ago that had the following terms. Amount $1,200,000, rate 5.5% and 30…
A: Loan Amount = $1,200.000 Interest rate = 5.5% Time Period = 30 Years Refinance Fee = 5% After 10…
Q: A customer of your bank comes for a car loan 10000 OMR. He is charged with an interest rate of 5%…
A: Formulas:
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: Mr. Jimin borrowed money to CBA Bank for $211,000 for business development the chicken farm. The…
A: Given, Loan Amount - 211,000 Interest rate = 9% (compounded monthly) Period - 12 years
Q: Suppose you borrow $1million to purchase a house. The bank offers you the fixed borrowing rate 4%…
A: Repayment of loan is made in installment of fixed amount which include portion of principal as well…
Q: Suppose you want to purchase a property for $205,000 and you have $30,000 to put down as a down…
A: An effective yearly yield is defined as the overall profit or return on a bond received by an…
Q: A borrower had a loan of $70,000.00 at 6% compounded annually, with 8 annual payments. Suppose the…
A: The question is based on the concept of Loan & Amortization.
Q: Assume you bought a car using a loan that requires payments of $3,000 to be made at the end of every…
A: Present value of annuity due is calculated to determine the total present worth of the annuity paid…
Q: Suppose we need to make 10 end-of-year payments of $5, 000 to pay off a loan. Assuming the rate of…
A: A loan is a sort of debt that is taken on by an individual or another institution. The lender, which…
Q: Suppose you borrowed $ 15 000 at 8% monthly interest to repay it in monthly installments over 4…
A: Present value is the sum of money that must be invested in order to achieve a specific future goal.…
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: A local finance company quotes an interest rate of 17.2% on one-year loans. So, if you borrow…
A: In this question we need to compute the effective annual rate (EAR) from following details : Present…
Q: A friend of yours is interested in purchasing a motor vehicle with at a cost of $3.5 million. The…
A: The spending required to generate and sell products and services, or to acquire assets, is referred…
Q: You were able to sell a car worth 2,100,000, which would be financed by a bank. You told your buyer…
A: Interest rate charged is calculated by RATE function in excel. Commission from car dealer is paid on…
Q: You can obtain a loan of $200000 at a rate of 15 percent for two years. You have a choice of (i)…
A: Loan amount $ 2,00,000.00 Time Period 2 Interest Rate 15%
Q: A chemical engineer wants to deposit an amount now such that she can withdraw an equal annual amount…
A: Cash flow diagram:
Q: A bank is negotiating a loan. The loan can either be paid off as a lump sum of $140,000 at the end…
A: Using excel PMT function
Q: You want to buy a car, and the local bank will lend you $20,000. The loan will be fully amortized…
A: Present value (PV) refers to the present value of a future sum of money or some sort…
Suppose you wish to purchase heavy equipment machinery and a commercial bank will lend you $65,000 for the transaction. The loan will be amortized over 5 years and the nominal interest rate will be 8% payable monthly. Calculate the monthly payment and the annual percentage rate (EAR) of the loan to be amortized.
Step by step
Solved in 2 steps
- You plan to borrow $25,000 at a 3.4% annual interest rate compounded annually. The terms require you to amortize the loan with 5 equal payments each made at the end of each year. You would like to construct an amortization schedule showing details of the payments. Answer the following questions, and choose the closest answer from the possible choices following each question: 1.To find the interest repaid in period 1 only in the financial calculator amortization worksheet, you enter P2 = 2.To find the interest repaid in period 1 only in the financial calculator amortization worksheet, you enter P1 = 3.How much total interest is repaid in periods 1 to 2?You want to buy a car, and a local bank will lend you $40,000. The loan will be fully amortized over 10 years, and the nominal interest rate will be 8% with interest paid annually. 1: What will be the annual loan payment? 2: Construct Amortization Schedule Table.Suppose an engineer purchases a home and secure a loan of 2.5 million from a commercial bank for 20 years at an annual interest rate of 9%. Find the monthly amortization of the loan.
- Use the Amortization Table to determine the payment required to amortize a loan of $7500 at an annual interest rate of 12% with a term of 15 years. Payments are to be made monthly.What is the amount of each payment?Suppose a borrower makes a $100,000 loan with annual payments at a 10 percent rate and a 10-year term. The loan is fully amortizing; however, payments are made on an annual basis to simplify the initial illustration. How the annual loan payment is calculated?You would like to buy a new car and will need to borrow $25,000 to do so. Your loan will be repaid monthly over 6 years at a 5% annual interest rate. Calculate your monthly payment. N (period of time) I (Interest) PV (Present Value) FV (Future Value) PMT (Annuity) Prepare the loan amortization schedule. Period Monthly Payment Interest Expense Principal Payment Principal Balance
- Suppose you get a loan of $2000 from UNO FCU for 2 years. The loan requires semianmual installment payments enabling the loan to be repaid in 4 equal payments. If the loan interest rate is 9%, construct an amortization table for this loan.If you borrow $25,000 from a local finance company and you are required to pay $4,424.50 per year for 10 years, what is the annual interest rate on the loan?Suppose you purchase a car for a total price of $25,445, including taxes and license fee, and finance that amount for 4 years at an annual interest rate of 8%. Please provide step by step to find the monthly payment and what is the total amount of interest paid over the term of the loan? Thanks
- You can obtain a loan of $200000 at a rate of 15 percent for two years. You have a choice of (i) paying the interest (15 percent) each year and the total principal at the end of the second year or (ii) amortising the loan, that is, paying interest (15 percent) and principal in equal payments each year. The loan is priced at par. a. What is the duration of the loan under both methods of payment? b. Explain the difference in the two resultsABC mortgage is to obtain a facility amounting to $200000 to be repaid over a period of 20 years at an annual rate of 10%.Help the company to; 1. Compute monthly mortgage payment for this loan 2. Amortize the mortgage loan for the first one year 3. Suppose the mortgage is paid off after one year, how much will be paid to clear the mortageSuppose that you're planning a vacation and borrow $2,000 from a bank for one year at a stated annual interest rate of 14 percent, with interest prepaid (a discount interest loan). Also, assume that the bank requires you to maintain a compensating balance equal to 10 percent of the initial loan value. What effective annual interest rate are you being charged?
