Question: Hansco borrowed $9200 paying interest at 11% compounded annually. If the loan is repaid by payments of $2000 made at the end of each year,

Hansco borrowed $9200 paying interest at 11% compounded annually. If the loan is repaid by payments of $2000 made at the end of each year, construct an amortization schedule showing the total paid and the total interest paid.

Step by Step Solution

★★★★★

3.61 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

PV n 920000 PMT 200000 i 11 Payment number 0 1 4 56 6 7 Total Amount ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

726-B-F-F-M (2102).docx

120 KBs Word File

Students Have Also Explored These Related Finance Questions!

Construct an amortization schedule for a four-year, $10,000 loan at 6% interest compounded annually.

A loan of $16 000 with interest at 9% compounded quarterly is repaid in seven years by equal payments made at the end of each year. Find the size of the annual payments and construct an amortization...

A debt of $12 500 with interest at 7% compounded semi-annually is repaid by payments of $1900 made at the end of every three months. Construct an amortization schedule showing the total paid and the...

For Question 9, calculate the principal repaid in the fourth payment period. Verify your answer by checking the amortization schedule. In Question 9 Hansco borrowed $9200 paying interest at 11%...

Hansco borrowed $9200 paying interest at 11% compounded annually. If the loan is repaid by payments of $2000 made at the end of each year, construct an amortization schedule showing the total paid...

For Question 9, calculate the principal repaid in the fourth payment period. Verify your answer by checking the amortization schedule. In Question 9 Hansco borrowed $9200 paying interest at 11%...

prepare an amortization schedule using a spreadsheet. Include totals for the amount paid, interest paid, and principal repaid. Hansco borrowed $9200.00 paying interest at 13% compounded annually. If...

Please help to get answer for all following questions, please note that, Excel functions needs to be used as given in picture to answer them. Thanks !! 1. Mr. and Mrs. Good purchased a ski chalet for...

Read the instruction sheet and amortize the loan in Question #1 in Microsoft Excel. 1. Hansco borrowed $5,317 paying interest at 3.93% compounded annually. If the loan is repaid by payments of $339...

Hansco borrowed $5872 paying interest at 3.69% compounded annually. If the loan is repaid by payments of $308 made at the end of each year. Find the number of payments. Round your answer to 8 decimal...

Discuss the importance of target marketing when analyzing organizational markets. How easy is it to isolate homogeneous market segments in these markets?

The following graph shows the daily market for jeans. Suppose the government institutes a tax of $11.60 per pair. This places a wedge between the price buyers pay and the price sellers receive. 50 45...

1 4 . 4 2 A sequential circuit is to be used to control the operation of vending achine which dispenses a $ 0 . 2 5 product. The circuit has three inputs , and Q and two outputs and C ) . The coin...

how easy is it to evaluate the economic benefit of legacy? give examples to illustrate your answer.

In Problem, find all horizontal and vertical asymptotes. f(x) = x-1 r+ 2 ,

In Problem, find all horizontal and vertical asymptotes. f(x)- 2.4

In Problem, find all horizontal and vertical asymptotes. f(x)-2x9 .t

Sunrise, Inc., has no debt outstanding and a total market value of $245,000. Earnings before interest and taxes, EBIT, are projected to be $19,000 if economic condition is normal. If there is strong...

Homework: Chapter 4 Homework Sav Score: 0 of 1 pt 5 of 21 (4 complete) HW Score: 19.05%, 4 of 21 F P4-6 (similar to) Question Help 3 Consider the following alternatives: i. $150 received in one year...

(a) What are the major differences (assumption or results between Fisher (a) and Taylor model? (b) What is the implication of CKM model for Taylor model