Construct the amortization schedule for a $8000 debt that is to be amortized in 6 equal quarterly payments at 2% interest per quarter on the unpaid balance. How much interest must be paid?

Q: Suppose you need to borrow $200,000 to buy a home, and you are deciding between a 15 year mortgage…

A: Since you have asked a question with multiple parts, we will solve the first 3 parts for you. Please…

Q: You may use your financial calculator or excel for calculations but be sure to show your work (i.e.…

A: Part 1: Future Value = $400,000 Rate = 2% Time period = 18 months - 12 months = 6 months Present…

Q: PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 2. - Calculate the annual interest rate…

A: Promissory note:  The parameters of the debt, including the interest rate, principal amount, date,…

Q: process of utilizing excel to finance properties. Consider the following. A realator has a house on…

A: In this we have to calculate the present value FACTOR monthly payment using EXCEL functions.

Q: For TVM calculator:  Write each known variable’s value as it appears in the calculator and use a…

A: The information given: Monthly payments: $425 Time period : 15 x 12=180 Future value : $96,000 (Yes,…

Q: you want to buy a car for $8300 with $360 monthly payments for 4 years, what is the annual interest…

A: Interest rate is the rate which the customer would have to pay on the periodic payment of the…

Q: A property worth $300,000.00 is sold with a down payment of $80,000.00 and the balance in monthly…

A: Amount of present value of monthly payments = Sale price - downpayment = 300000 - 80000 = 220000

Q: Develop a general-purpose spreadsheet to calculate the balance due, principal payment, and interest…

A: workings:

Q: Assume that you will have a 10-year, $14,000 loan to repay when you graduate from college next…

A: Given, Loan amount = $14,000 Annual payment = $2,377 Interest expense = 11%

Q: Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.)…

A: Loan amount = $180000 Number of years = 3 years Compounded annual interest rate = 10% or 0.1…

Q: Five plans are shown that will pay off a loan of $5.000 over 5 years with interest at 8% per year.…

A: The concept of economic equivalence: The concept of economic equivalence states that at a given rate…

Q: A loan of P 120,000 is to be repaid on installment every 6 months for 4 years. Find the size of the…

A: Loan = 120,000 Semi annual payments N = 8 semi annual payments (4 years)  Interest rate = 20%/2 =…

Q: Suppose you graduate with a debt of $42,000 that you or someone must repay. One option is to pay off…

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

Q: PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS Problem 1: Domingo Medina wants to know…

A: The annual worth is a significant method for capital projects.  The annual worth refers to the…

Q: What is the future value of the loan that Mr. Jacinto acquired for $15,500 for 10 months at a simple…

A: Solution:- Future value means the amount to be paid at maturity along with interest portion. Amount…

Q: Answer the Situation below correctly show your complete solution.I already provided the answer I…

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

Q: On January 1, 20X1, you find the perfect home for you and your budding family. The home will cost…

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

Q: Answer the Situation below correctly show your complete solution. A deposit of 120 000.00 Php is…

A: C. Since the payment is made monthly and the interest is also compounded monthly, the number of…

Q: The Johns Hopkington Hospital needs to borrow $3,000,000 to purchase an MRI.  The interest rate for…

A: EMI refers to Equal Monthly Installment. It is the amount payable monthly by the borrower to the…

Q: velop a complete amortization table for a loan of $4500, to be paid back in 24 uniform monthly…

A: Solution: PMT =PV / [(1 – (1+r) -N )) / r] PMT=MONTLY PAYMENT=?, PV = PRESENT VALUE=4500, r…

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: For TVM calculator:  Write each known variable’s value as it appears in the calculator and use a…

A: Future value refers to the worth of the amount in future which is deposited or received today at…

Q: 3.- Carmen Arámbula received her paycheck on August 15 for $23,450.00, and decided to invest it…

A: Annualized return or interest rate shows the return that an investment will generate if the amount…

Q: PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 3.- Carmen Arámbula received her…

A: Data given:: pv=Principal Amount ($) 23450 n (days) 60 nper = 60*1 60 FV ($) 23918.35…

Q: An engineering firm borrowed $500,000 at a 5%/year interest rate. They will repay the loan in 5…

A: Using Simple Interest: Amount borrowed (P) = $500,000 Tenure (t) = 5 years Interest rate (r) = 5% We…

Q: Suppose you are a relationship manager at an international bank. A customer who recently got…

A: To create the amortization table, first we will have to find the EMI. To find the EMI, we will use…

Q: A student borrows $6000 at 10% for 6 months to pay tuition. The total amount due after 6 months is $…

A: To calculate the interest amount we will use the below simple interest formula   Total amount due =…

Q: You need additional cash for the payment of your tuition fee and other expenses for your studies.…

A: Solution:- When a loan is taken, it can be either repaid as a lump sum payment or in installments.…

Q: A student purchases a laptop computer by obtaining a simple interest loan. The computer costs…

A: Computer cost (C) = P 35000 Interest rate (r) = 8% Total weeks in 1.5 years (n) = 52 * 1.5 = 78

Q: Osmara Del Toro deposits her life savings working at HoneyBee for $545,000, for when her retirement…

A: This question is related to the retirement plan in which he invests an amount of money in the…

Q: You take out a loan for $L at i12 = 19.8 % and repay $6113 at the end of each month for as long as…

A: Loan is the amount that has been borrowed by the borrower on which interest & principal payments…

Q: Alexa takes out a loan of 94,000 at an annual effective discount rate of 6%. The loan is to be…

A: Present value (PV) is the current value of a future sum of money or stream of cash flow given a…

Q: Miguel purchased a hot tub costing $5,070 by taking out an installment loan. He made a down payment…

A: APR (Annual Percentage Return) The rate of interest charged by a creditor on the amount lent or the…

Q: blem 2: René Lara has just signed in notary #8, the contract for the purchase and sale of a house,…

A: Loans are paid by the equal monthly installments that carry the principal and interest amount.

Q: You are considering buying a new home and are planning to take out a 30-year, $300,000 mortgage. You…

A: Installment is the amount of periodic payments a borrower makes to its lender in order to pay back…

Q: Say you purchase a computer for $1300 at 7% interest and want to have it paid off in 48 months. Use…

A: A loan is an agreement between two parties in which one party gives money to the other party in…

Q: Jake has approached you for a loan and based on your assessment, his cash-flow will accommodate a…

A: Loan is repaid in 5 years, on monthly basis. No. of repayments = 5yrs*12 = 60 Total Repayment = No.…

Q: Mr Dela Cruz deposited ₱18,980.00 from the project you’ve earned in a time deposit account with your…

A: Future Value is the product of present value with interest rate and its time period  Future Value =…

Q: Prepare an amortization schedule showing how much money you will need to save to pay the entire…

A: Amortization Schedule: Amortization schedule represents a table containing information about…

Q: An engineering practitioner can lease a fully equipped computer and color printer system for $800…

A: Lease means get the right to use the particular asset for a definite time period by paying…

Q: solve the following showing all workings in microsoft word   It is now January 1, 2018 you plan to…

A: Future value annuity due is a method used to calculate the total amount at the end of a period when…

Q: You have just completed your four-year degree at Southwest Minnesota State University (SMSU)!  Your…

A: The question is related to Amortization Schedule. The details are given.

Q: The manager of Steve’s Audio has approved Daisy’s application for 24 months of credit at maximum…

A: To open the "PV function" window - MS-Excel --> Formulas --> Financials --> PV.

Q: A financial planning service offers a college savings program. The plan calls for you to make six…

A: Return on Investment can be computed as follows:

Q: .Use the TVM solver on the calculator, fill in the information that you typed in the calculator..…

A: Repayment of loan is done in fixed instalments which also carry rate of interest charge over the…

Q: Find the value of the payment (installment) if the interest rate is 24.5% compounded quarterly and…

A: Repayments of debt in equal instalments is a type of annuity. A series of equal payments in equal…

Amortized Loans

The term "amortization" refers to spreading the value of a loan or a debt over a series of regular payments or installments comprising of both the principal and interest amount. It generally involves the process where in the value of a loan or an intangible asset is written down over its maturity period.