Without the use of excel: A borrows 20000 for 8 years and repays the loan with...
Helen borrows $20000 to be repaid over 15 years with level annual payments with an annual effective interest rate of 8%. The first payment is due one year after she takes out the loan. Helen pays an additional $4000 at the end of year 9 (in addition to her normal payment). At that time (the end of year 9) she negotiates to pay off the remaining principal at the end of year 14 with a sinking fund. The sinking fund...
thumbs up for correct solution 10. Anita borrows 540,000 at annual effective interest rate 3%. She repays this loan by paying off only the interest due at the end of each year to the lender and depositing a level amount Q at the end of each year into a sinking fund account paying 6% APY. The goal is to accumulate the full balance of the loan amount in the sinking fund at the end of 10 years. a. Find the...
Anita borrows 540,000 at annual effective interest rate 3%. She repays this loan by paying off only the interest due at the end of each year to the lender and depositing a level amount Q at the end of each year into a sinking fund account paying 6% APY. The goal is to accumulate the full balance of the loan amount in the sinking fund at the end of 10 years. b. What rate (AEIR) does Anita end up paying...
Dominic borrows 7200 dollars today, and agrees to repay the loan by making annual interest payments to the lender, and by also accumulating a sinking fund with increasing annual deposits to repay the principal. The interest rate on the loan is 8.8 percent, and the interest paid on the sinking fund is 6.7 percent, both effective. If the loan is to be settled 15 years from now, and the sinking fund deposits increase by 7 dollars per year, what is...
Michelle takes out a $50,000 loan for 15 years which she repays with annual payments at the end of each year. The annual interest rate is 1% for the first 2 years and then increases to 5% for the remainder of the loan. Michelle's payments increase by 7% each year. Find the loan balance immediately following the tenth payment.
without using a financial calculator or excel. Please provide all formula used and variables with clear steps Question 8 The rate of interest earned in a bank's savings account is 8% per annum effective (compound). Assume that there is no tax, no fees. John makes a deposit of $100 at time t = 0, and a deposit of $200 at time t = 1 year. (8)(a) What is the account balance at t = 8 years, after interest has been...
1. Callan Muffley borrows $900,000 to buy a house. The stated annual interest rate on the loan is 3.6% with monthly payments over 40 years (3.6% annual, compounded monthly). a) Set up the amortization schedule for the first month of the loan. (4 Points) b) Set up the amortization schedule for the loan with exactly six months to go.(4 Points) Interest Reduction inEnding Principal Principal Balance Month Beginning MonthlyI PrincipalPayment Balance e) What are Callan's total payments to principal during...
should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
A company borrows $160000, which will be paid back to the lender in one payment at the end of 5 years. The company agrees to pay semi-annually interest payments at the nominal annual rate of 10% compounded semi-annually. At the same time the company sets up a sinking fund in order to repay the loan at the end of 5 years. The sinking fund pays interest at an annual nominal interest rate of 4% compounded semi-annually. Find the total amount...
Edward borrows 720,000 at AEIR 6%. At the end of each of the first 6 years he will pay 36,000 in principal alone, plus he pays the interest due. At the end of each of the next eight years he makes level (total) payments of 50,000. He plans on making one final payment at the end of 15 years to satisfy the loan obligation. What is this 15th payment? A. 362,932 B. The answer is not listed here C. 324,122...