A 5-years, $6000 loan is being amortized with monthly payments at j12 = 10%. Just after making the 30th payment, the borrower has the loan refinanced at j12 = 8% with the number of payments to remain unchanged. What will be the monthly savings in interests?
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: You would be borrowing $350,000 for a home loan at 3% interest, but you are given two options: pay…
A: The calculation is: The formulation image is:…
Q: Sam would like to use the PMT function in Excel to calculate the monthly payments on a car loan of…
A: There are two types of annuities, i.e., (i) annuity due and (ii) ordinary annuity. An annuity can be…
Q: You want to buy a car, and a local bank will lend you $20,000. The loan would be fully amortized…
A: A loan is an agreement where an amount is forwarded in exchange for periodic payments that cover the…
Q: A company wants to have $20,000 at the beginning of each six month period for the next 4 1/2 years.…
A: Using excel PV function
Q: You want to buy a car, and a local bank will lend you $35,000. The loan would be fully amortized…
A: Financial management consists of directing, planning, organizing and controlling of financial…
Q: You borrow $10,000 at 8% for 4 years. The loan is repayable in four equal instalments at year end.…
A: Answer: Calculation of the amount of annual/yearly equal instalment: In order to calculate the size…
Q: A sum of money is deposited now in a savings account. The effective annual interest rate is 12% and…
A: Given, Amount (A) = P8,000 Principal (P) = ? Interest rate (i) = 12% Number of times compounded (n)…
Q: To start your business, you take a loan of $20,000 at 6.25 % compounded semi-annually. You want to…
A: Requirement : Question 1C Loan = 20,000 Interest rate = 6.25℅ compounded semi annually Annual loan…
Q: enny puts $200 into a savings account today, the account pays an annual interest rate of 5%, but…
A: PV = 200, N = 1, rate = 5%/2, PMT = 0 use FV function in Excel balance in the account after 6 months…
Q: Solve the following problem completely. A loan is to be repaid quarterly for 5 years that will start…
A: Quaterly Payment is $10,000 Interest rate is 6% compounded quaterly To find: Present value of the…
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: 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: 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: You are asked to help the company "X" by computing the Loan repayment table. a) Draw up the…
A: An equal cashflow for a fixed number of times at equal intervals is called annuity. If A is equal…
Q: You have just purchased a new automobile costing $24000. the trade-in you have is valued at $6000.…
A: After trade in value the cost remains at $24000 -$6000 = $18000. This much needs to be financed. The…
Q: A borrower has secured a 30 year, $131.000 loan at 8% with monthly payments. Fifteen years later,…
A: Loan Amount = $131,000 Time period = 30 Years Interest rate = 8%
Q: You want to buy a $330000 home. You plan to pay $33000 as a down payment, and take out a 20 year…
A: given, price = $330000 downpayment = $33000 principal = $330000 - $33000 = $297,000 n=20 m=12…
Q: Write the Formula for the equation for the payment on the Loans (you do NOT need to evaluate) (a) 30…
A: Part (a) Loan Amount = $125,000 Time Period = 30 Years Interest Rate = 4.2% Part (b) Loan Amount =…
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: Use the following information to answer the next 3 questions. $280,000 Loan Amount 30 year loan with…
A: To convert the time period in months, multiply it by 12 To convert interest monthly, divide it by 12…
Q: how much do you need to repay for your yearly instalment if you had borrowed $20,000 at 10% for 5…
A: Year installment will be calculated by amount of borrowings divided by Present value of an ordinary…
Q: The executive of a label is looking to purchase a new rental for $3.9 million. Financing is offered…
A: Borrowings are the liability that is used to finance the requirement of the funds. The borrower…
Q: Assume interest is paid in full at the end of each year. a. How much would Sauer Food Company save…
A: There is interest to be paid on the loan that depends on the period of loan and interest rate on the…
Q: You want to buy a car, and a local bank will lend you $35,000. The loan will be fully amortized over…
A: An effective annual rate is the modified interest rate from the nominal rate that represents the…
Q: A borrower has secured a 30 year, $131,000 loan at 8% with monthly payments. Fifteen years later,…
A: Loan Amount is $131,000 Time Period of Loan is 30 years Interest Rate is 8% Compounding Period is…
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: Teal and Associates needs to borrow $35,000. The best loan they can find is one at 12% that must be…
A: Monthly payment for the loan comprise of an interest part and principal repayment part and is…
Q: vings account may allow the owner to withdraw ₱30,000 semi-annually for 3 years starting at the end…
A: In this we need to calculate the present value of money.
Q: I. Hamilton wants to accumulate ₺30000 at the end of 4 years. It starts quarterly payments in a bank…
A: A study that proves that the future worth of the money is lower than its current value due to…
Q: How much would your monthly payment be on a 3-year loan if the following assumptions were true? You…
A: In order to find the payment per month and the total amount paid to the bank, one has to use excel…
Q: What would be r in this problem? A $100,000 loan is to be paid monthly for 2 years with an interest…
A: Here, Loan Amount is $100,000 Time Period is 2 years Payment Period (p) is Monthly i.e 12 Interest…
Q: set with a 5% annual payment cap. On the reset date, the composite rate is 6% (at the end of year…
A: Mortgage Loan = $393000 Tenure = 30 years i,e360 months Teaser Rate of Interest = 4 %pa (for 2…
Q: You lend a friend $10,000, which your friend will repay in 5 equal annual end-of-year payments of…
A: Computation:
Q: You have taken out a loan of $17,000 for 4 years with an interest rate of 3% compounded annually.…
A: The given problem can be solved using PMT function in excel. PMT function computes installment…
Q: With the given information please confirm if my calculations for how many years it will take to pay…
A: using excel nper function
Q: A borrower made a constant payment mortgage loan 8 years ago for $400,000 at 12 percent interest for…
A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
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: 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: You borrow $22541 to buy a car. You will have to repay this loan by making equal monthly payments…
A: In order to calculate the monthly payment on the financial calculator, firstly we are required to…
Q: ffering MACY’S has a six-year term deposit that will pay 7% per annum compounded quarterly. If…
A: EAR stands for effective annual rate. EAR is greater than APR (annual percentage rate) when the…
Q: A person borrows $45000 at an interest rate of 12% per year. It is desired to repay the loan in 12…
A: In this we have to calculate the annual payment required to get fifth payment.
Q: A borrower has secured a 30 year, $154,000 loan at 7% with monthly payments. Fifteen years later,…
A: Return on investment Return on investment is a performance metric used in evaluating the…
Q: Athena took out a home loan 4 years ago with a 30-year term, monthly payments of $1,600, and an…
A: The given problem can be solved using FV and PMT function in excel. FV function will compute…
Step by step
Solved in 2 steps
- Suppose that you need an amount of money which equals to $10000000. It is possible to find it from bank A at an annual interest rate of 18% under 12 equal payment. If the first payment will be 1 month later the day you used the loan. Find the CF (Cash Flow), the equal payments and prepare the amortization table.Answer the Situation below correctly show your complete solution. A loan of 30 000.00 Php is to be paid monthly for 5 years that will start at the end of 4 years . If converted monthly at 12 % , how much is the monthly payment ?a . The type of annuity illustrated in the problem is _________________.b. The total number of payments is ______.c . The number of conversion period in the period deferral is ___________________.d. The interest rate per period is _________.e . The present value of the loan is_______. (I just need the Solution) Answers: a. Deferred Annuity; b. 60; c. 47; d. 0.01; e. 30 000.00 PhpAnswer the Situation below correctly show your complete solution. A loan of 30 000.00 Php is to be paid monthly for 5 years that will start at the end of 4 years . If converted monthly at 12 % , how much is the monthly payment ?a . The type of annuity illustrated in the problem is _________________.b. The total number of payments is ______.c . The number of conversion period in the period deferral is ___________________.d. The interest rate per period is _________.e . The present value of the loan is_______.
- Suppose you want to borrow $90,000 and you find a bank offering a 20-year loan with an APR of 5%. a. Find your regular payments if you pay n = 1, 12, 26, 52 times a year. b. Compute the total payout for each of the loans in part (a). c. Compare the total payouts computed in part (b). a. The payment for n = 1 would be $ The payment for n = 12 would be $ The payment for n = 26 would be $ The payment for n= 52 would be $ (Do not round until the final answer. Then round to the nearest cent as needed.)Answer the Situation below correctly show your complete solution.I already provided the answer I just need the SOLUTION.( Annuities )A loan of 30 000.00 Php is to be paid monthly for 5 years that will start at the end of 4 years . If converted monthly at 12 % , how much is the monthly payment ?a . The type of annuity illustrated in the problem is _________________.b. The total number of payments is ______.c . The number of conversion period in the period deferral is ___________________.d. The interest rate per period is _________.e . The present value of the loan is_______. Answers: a. Deferred Annuity; b. 60; c. 47; d. 0.01; e. 30 000.00 Php1. Let's assume that a loan of $100,000 with an annual interest rate of 6% over 30 years pays monthly payments of $500. a. Calculate the accumulation rate b. Calculate the payment rate . c. Answer : How will the balance of the principal be at the end of the loan in relation to the original amount of the loan? Less, equal or greater? Provide calculations.
- Sam would like to use the PMT function in Excel to calculate the monthly payments on a car loan of $35,000 which is to be paid off in full after 3 years. Interest is charged at a rate of 4.43% per year and the payment to the loan is to be made at the end of each month. Which function argument is correct? (Reminder: =PMT(rate, nper, pv, [FV], [type]) =PMT( 4.43%, 36, -35000) =PMT( 4.43%/12, 36, -35000) =PMT( 4.43%/12, 3, -35000) =PMT( 4.43%, 3, -35000)Answer the following question correctly refer to the given problem below and show your Complete Solution (Given, Required, Equation, Solution, Answer). Mr. Quiton loans an amount of Php 30,000.00 which is to be paid monthly for 5 years that will start at the end of 4 years , if converted monthly at 12%, how much is the monthly payment ? 1. What is the type of annuity illustrated in the given problem? A. Simple Annuity B. General Annuity C. Deferred Annuity D. Complex Annuity 2. Compute for the interest rate per period. A. 0.01 B. 0.05 C. 0.10 D. 0.12 3. Determine the present value of the loan. A. Php 12,000.00 B. Php 30,000.00 C. Php 60,000.00 D. Php 75,000.00you are analyzing a GPM. the terms are $60,000 loan amount, 9% note rate, 30 years, monthly payments, OFV, payments in year one based based upon 7%, and payment in year two based on 8%. how much will you owe on this loan at the end of the second year? Please assist, using HP 10bII+.
- Use the appropriate function(s) in Excel to answer the following questions. How much would your monthly payment be on a 3-year loan if the following assumptions were true? You borrowed $7,400. The fixed APR on the loan is 3.2%. Note: A fixed APR is an annual interest rate that does not change during the 3-year period. You will make equal monthly payments to repay both the loan amount and the monthly interest charges. You want to completely pay off the loan in exactly 3 years. (Round to the nearest cent, do not include a negative sign) Note: while this money is "leaving your wallet" the negative sign should not be included in the numeric answer because it is already implied by the word "payment" What is the total amount that you would pay to the bank over this 3-year period? Hint: Be sure to use your rounded answer from the previous step in the calculation of this answer. (Round to the nearest cent, do not include a negative sign) How much total interest would you have paid…1. If you receive $176 each month for 12 months and the discount rate is 0.04, what is the future value? (show the process and can use financial calculator)Give typing answer with explanation and conclusion Find the interest rate (or rates of return) in each of the following situations. Do not round intermediate calculations. Round your answers to the nearest whole number. You borrow $740 and promise to pay back $814 at the end of 1 year. % You lend $740 and receive a promise to be paid $814 at the end of 1 year. % You borrow $60,000 and promise to pay back $171,156 at the end of 8 years. % You borrow $11,000 and promise to make payments of $3,359.50 at the end of each of the next 5 years. %