You plan to borrow $35,000 at an 8% semiannual interest rate. It is a 3 year...

You plan to borrow $35,000 at an 8% semiannual interest rate. It is a 3 year loan that requires 6 payments to fully amortize.

a) Calculate the amount of semiannual payment you would be making every period?

b) Set-up an amortization schedule.

Solutions

Expert Solution

The amount of semi-annual payment is found using the following equation

The amount of semi-annual payment made every period = $ 6676.67

-------------------------------------------------------------------------------------------------------

The amortization schedule can be built using excel.

Interest for each period = ( 0.08 2) Beginning balance

Principal amount paid for each period = Semi-annual payment - interest

Ending balance for each period = Beginning balance - principal paid

Period	Beginning balance	Semi-annual payment	Interest	Principal paid	Ending balance
1	$35,000	$6,676.67	$1,400	$5,276.67	$29,723.33
2	$29,723.33	$6,676.67	$1,189	$5,487.74	$24,235.59
3	$24,235.59	$6,676.67	$969	$5,707.25	$18,528.35
4	$18,528.35	$6,676.67	$741	$5,935.54	$12,592.81
5	$12,592.81	$6,676.67	$504	$6,172.96	$6,419.85
6	$6,419.85	$6,676.67	$257	$6,419.88	($0.02)

The formulas used to build the schedule in excel is shown in the following table.

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Question 1 I. You plan to borrow $35,000 at an 8% annual interest rate. The terms...

Question 1 I. You plan to borrow $35,000 at an 8% annual interest rate. The terms require you to amortize the loan with 6 equal end-of- year payments. a) Calculate the amount of annual payment you would be paying every year? b) Set-up an amortization schedule. II. Allied Bank offers to lend you at a nominal rate of 5.0%, simple interest, with interest paid quarterly. Standard Bank offers to lend you the same amount, but it will charge 6.0%,...

You plan to borrow $15,000 for 3 years. The interest rate is 8% compounded semi-annually. The...

You plan to borrow $15,000 for 3 years. The interest rate is 8% compounded semi-annually. The terms require you to amortize the loan with equal payments made every period. a) Calculate the amount of payment you would be paying every period? b) Set-up an amortization schedule

You borrow a GPM of $50,000 with annual payments and 3- year term. The interest rate...

You borrow a GPM of $50,000 with annual payments and 3- year term. The interest rate is 10% and the payment factors from years 1 to 3 are as follows: 50%, 50% and 100% Questions: 1.What are the annual payments for years 1 to 3? 2.What is remaining balance at the end of year 1? 3.What are interest payment and principal payment for years 1 to 3?

You plan to borrow $100,000 at a 10% annual interest rate. The terms require you to...

You plan to borrow $100,000 at a 10% annual interest rate. The terms require you to amortize the loan with 10 equal end-of-year payments. How much interest would you be paying in Year 1?

You plan to borrow $100,000 at a 4.5% annual interest rate. The terms require you to...

You plan to borrow $100,000 at a 4.5% annual interest rate. The terms require you to amortize the loan over 15 years what is monthly payment and how much total interest would you be paying during the Year 1?

If you borrow $7,000 with an interest rate of 3 percent, to be repaid in five...

If you borrow $7,000 with an interest rate of 3 percent, to be repaid in five equal yearly payments at the end of the next five years, what would be the amount of each payment? Use Exhibit 1-D. (Round time value factor to 3 decimal places and final answer to 2 decimal places.) Amount of each paymet

If you borrow $7400 at $700 interest for one year, what is your effective interest rate...

If you borrow $7400 at $700 interest for one year, what is your effective interest rate for the following payment plans? (Input your answers as a percent rounded to 2 decimal places.) Effective Rate of Interest a. Annual payment % b. Semiannual payments % c.Quarterly payments % d. Monthly payments %

Compound Interest 22.) You borrow 1,000,000 for one year from a friend at an interest rate...

Compound Interest 22.) You borrow 1,000,000 for one year from a friend at an interest rate of 1% per month instead of taking a loan from a bank at a rate of 13% per year. Compare how much money you will save or lose on the transaction. 24.) John expects to receive Php 20,000 in 10 years. How much is the money worth now considering interest at 6% compounded quarterly? 25.) A man who won P 500,000 in a lottery...

You are buying a car and will borrow $31,837 with a 5-year loan. The interest rate...

You are buying a car and will borrow $31,837 with a 5-year loan. The interest rate is 4.46%, what is your monthly payment?

You borrow a ten-year loan of $1,500,000. The annual interest rate is 13% that to be...

You borrow a ten-year loan of $1,500,000. The annual interest rate is 13% that to be repaid every 2 weeks. Assume 52 weeks a year. List the numerical answers and EXCEL formulas of payment, interest, principal paid and end balance of 115th periodic payment in the table provided. Payment Interest Principal End Balance (Period 115) (Numerical Answer) (Numerical Answer) (Numerical Answer) (Numerical Answer) (EXCEL Formula) (EXCEL Formula) (EXCEL Formula) (EXCEL Formula)

Subjects