Question

In: Finance

Ian Borrows $5,600 at rate of interest i(2)=5.55%. He repays the loan by making N payments...

Ian Borrows $5,600 at rate of interest i(2)=5.55%. He repays the loan by making N payments of $350 at the end of each half-year plus a final larger payment of X at the end of N+1 half-years.

Find X (nearest cent)

Solutions

Expert Solution

Calculating the Value of X(i.e., the last large final payment) using Amortization Scchedule:-

Half-Yearly Beg bal. Payment Interest amount Principal Amount End Bal.
1 5,600.00                  350.00                        155.40                              194.60                  5,405.40
2                  5,405.40                  350.00                        150.00                              200.00                  5,205.40
3                  5,205.40                  350.00                        144.45                              205.55                  4,999.85
4                  4,999.85                  350.00                        138.75                              211.25                  4,788.60
5                  4,788.60                  350.00                        132.88                              217.12                  4,571.48
6                  4,571.48                  350.00                        126.86                              223.14                  4,348.34
7                  4,348.34                  350.00                        120.67                              229.33                  4,119.00
8                  4,119.00                  350.00                        114.30                              235.70                  3,883.31
9                  3,883.31                  350.00                        107.76                              242.24                  3,641.07
10                  3,641.07                  350.00                        101.04                              248.96                  3,392.11
11                  3,392.11                  350.00                           94.13                              255.87                  3,136.24
12                  3,136.24                  350.00                           87.03                              262.97                  2,873.27
13                  2,873.27                  350.00                           79.73                              270.27                  2,603.00
14                  2,603.00                  350.00                           72.23                              277.77                  2,325.24
15                  2,325.24                  350.00                           64.53                              285.47                  2,039.76
16                  2,039.76                  350.00                           56.60                              293.40                  1,746.36
17                  1,746.36                  350.00                           48.46                              301.54                  1,444.83
18                  1,444.83                  350.00                           40.09                              309.91                  1,134.92
19                  1,134.92                  350.00                           31.49                              318.51                     816.41
20                      816.41                  350.00                           22.66                              327.34                     489.07
21                     489.07                  502.64                           13.57                              489.07                          0.00

So, Final Large Payment of X is $502.64 ($489.07 + $13.57)

Note- The following Columns are calculated based on:

- Interest amount = beg. Balnace*Monthly interest rate

- Principal maount = Payment - Interest amount

- End Bal. = Beg. Bal + Interest - Payment

If you need any clarification, you can ask in comments.     

If you like my answer, then please up-vote as it will be motivating       


Related Solutions

Roberto borrows $10,000 and repays the loan with three equal annual payments. The interest rate for...
Roberto borrows $10,000 and repays the loan with three equal annual payments. The interest rate for the first year of the loan is 4% compounded annually; for the second year of the loan the interest rate is 5% compounded annually; for the third year of the loan the interest rate is 6% compounded annually. a. Determine the size of the equal annual payments. b. Would interchanging the interest rates for first year and third year change the answer to part...
Common information for 6 and 7 Andrew borrows 360,000 at i=.05. He repays this loan by...
Common information for 6 and 7 Andrew borrows 360,000 at i=.05. He repays this loan by paying off only the interest due at the end of each year to the lender and depositing a level amount Y at the end of each year into a sinking fund account offering 8% APY so as to accumulate the full balance of the loan amount in the sinking fund at the end of 20 years. What value Y must he deposit into the...
Bob borrows 540,000 at annual effective interest rate 3%. She repays this loan by paying off...
Bob 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 level sinking fund deposit. b. What...
JOHN BORROWS $14000 FROM THE SAVINGS AND LOAN AT A COMPOUND INTEREST RATE OF 5%/YR. HE...
JOHN BORROWS $14000 FROM THE SAVINGS AND LOAN AT A COMPOUND INTEREST RATE OF 5%/YR. HE WILL PAY BACK THE LOAN IN EQUAL ANNUAL PAYMENTS OVER A 4- YEAR PERIOD. BERTHA BORROWS $10,000 FROM SETH, WHO IS JOHN’S BROTHER.   -DETERMINE THE EQUAL ANNUAL PAYMENTS - SUMMARIZE JOHN’S FINANCIAL POSITION IN BULLET OUTLINE FORMAT          - BORROWS: $14000          -
A loan is being amortized over​ n-years with monthly payments of​ $295.32. The rate of interest...
A loan is being amortized over​ n-years with monthly payments of​ $295.32. The rate of interest on the loan is j12=12%. The principal repaid in the 25th payment is​ $206.41.What is the size of the​ loan? ​
Ron's Loan: Ron borrows $3,000,000 to purchase a warehouse. The annual interest rate on the loan...
Ron's Loan: Ron borrows $3,000,000 to purchase a warehouse. The annual interest rate on the loan is 8.25 percent, and the term of the loan is 15 years. Suppose Ron refinances the loan at the end of month 48 at the then prevailing interest rate of 8%. Rather than reducing his monthly payment, however, Ron decides to continue making the same monthly payments. How many months must Ron continue to make the payments on this new loan? (Round your answer...
Ron's Loan: Ron borrows $3,000,000 to purchase a warehouse. The annual interest rate on the loan...
Ron's Loan: Ron borrows $3,000,000 to purchase a warehouse. The annual interest rate on the loan is 8.25 percent, and the term of the loan is 15 years. How much principal will Ron pay in month 37? Enter your answer rounded to the nearest penny with no punctuation, but do not use the rounded intermediate results in future calculations involving Ron's Loan (keep all available decimals).
Ron's Loan: Ron borrows $3,000,000 to purchase a warehouse. The annual interest rate on the loan...
Ron's Loan: Ron borrows $3,000,000 to purchase a warehouse. The annual interest rate on the loan is 8.25 percent, and the term of the loan is 15 years. The loan requires the borrower to pay two discount points at the time of origination. A) What is the monthly payment necessary to amortize this loan? B) What is the balance on the loan at the end of month 36? C) How much interest will Ron pay in month 37?    D) How...
Barbara borrows $3000. She agrees to make monthly interest payments on the loan and will build...
Barbara borrows $3000. She agrees to make monthly interest payments on the loan and will build up a sinking fund with monthly deposits to repay the principal with a single payment 19 months from now. If the interest being charged on the loan is j12 = 8.5% and the interest being earned on the sinking fund is j12= 5.4%, what is the monthly cost of the debt for Barbara?
Harry borrows $3,500 from Mary. He agrees to repay the loan with annual payments, made at...
Harry borrows $3,500 from Mary. He agrees to repay the loan with annual payments, made at the end of each year, of $500, $1,000, $1,500, etc. with a smaller final payment one year after the last regular payment. Mary charges Henry a rate of discount 10% convertible 4 times per year. Determine the amount of the final payment. Ans: At least $1670, but less than $1700.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT