Question

In: Finance

What is the loan balance (in dollars) after the third payment, of a 5 year loan...

What is the loan balance (in dollars) after the third payment, of a 5 year loan of $100,000 with an APR of 10% and annual payments?

Solutions

Expert Solution

Loan Amount = $100,000

Firstly calculating the annual payments towards the loan amount:-

Where, P = Loan Amount = $100,000

r = Periodic Interest rate = 10%

n= no of periods = 5

Annual Payments = $26,379.75

So, yearly payments towards looan is $26,379.75

Now, Calculating the Loan Balance after 3rd payment using loan amortization schedule:-

Year Beg bal. Payment Interest amount Principal Amount End Bal.
1 100,000.00            26,379.75                  10,000.00                        16,379.75               83,620.25
2                83,620.25            26,379.75                     8,362.03                        18,017.73               65,602.53
3                65,602.53            26,379.75                     6,560.25                        19,819.50               45,783.03

Note- The following Columns are calculated based on:

- Interest amount = beg. Balnace*Monthly interest rate

- Principal Amount = Payment - Interest amount

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

So, Loan Balance in dollar terms after 3rd payment is $45,783.03

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

What is the outstanding balance after the 23rd payment interval of a 23 year loan of...
What is the outstanding balance after the 23rd payment interval of a 23 year loan of $15,000 with semi-annual payments and an interest rate of 6% compounded semi-annually? Calculate answer to 2 decimal places.
What is the outstanding balance after the 23rd payment interval of a 16-year loan of $14,734...
What is the outstanding balance after the 23rd payment interval of a 16-year loan of $14,734 with semi-annual payments and an interest rate of 6.0% compounded semi-annually?
A 10-year amortized loan of $100,000 with 5% APR requires yearly loan payment. After making four...
A 10-year amortized loan of $100,000 with 5% APR requires yearly loan payment. After making four yearly payments, the fourth year's ending loan balance is $Answer (don't include thousand separator( , ), rounding the number with two decimal places)
1. What would be the monthly payment on a 5 year loan of $35,000 if the...
1. What would be the monthly payment on a 5 year loan of $35,000 if the interest rate is 6.0% compounded monthly? 2. Sarah bought a raft for $664 using her credit card. The interst rate is 0.186 compounded monthly. If she pays $23 a month, how long will it take her to pay off the credit card? 3. What would be the monthly payment on a 5 year loan of $24,000 if the interest rate is 5.0% compounded monthly?
Calculate the loan balance after 6 years of payment of the following Balloon Payment Mortgage: 1...
Calculate the loan balance after 6 years of payment of the following Balloon Payment Mortgage: 1 million dollar loan Rate =5% annualized, monthly compounding Loan term = 25 years Amortization = balloon at the end of loan term of $300,000
26.)What would be the monthly payment on a 5 year loan of $24,000 if the interest...
26.)What would be the monthly payment on a 5 year loan of $24,000 if the interest rate is 5.0% compounded montly? A. $452.91 B. $492.75 C. $377.42 D. $500.00 true or false: 27.)When doing a comparison of ratios for your company, the comparison probably should be with the industry average. 28.)When taking out a loan you would rather get an interest rate of 7% compounded monthly, instead of one compounded daily. 29.)Which of the following financial ratios are market-based ratios?...
Calculate the mortgage balance 25 days after the 45th payment on a mortgage loan of $200,000,...
Calculate the mortgage balance 25 days after the 45th payment on a mortgage loan of $200,000, amortised over 15 years at an interest rate of 5.75%.
Calculate the balloon payment after 5 years on a $100,000 loan with an 10% interest rate,...
Calculate the balloon payment after 5 years on a $100,000 loan with an 10% interest rate, a 20-year amortization and monthly payments of $965.02
a $30000 5-year payment loan with level payment payable at the end of each month. (i)...
a $30000 5-year payment loan with level payment payable at the end of each month. (i) Calculate the level payment of each month with loan interest of 8% effective monthly. (ii) Calculate the loan balance at the end of month 3 after the third loan payment is made by using retrospective method. (iii) Calculate the loan balance at the end of month 3 after the third loan payment is made by using prospective method. (iv) what is total interest paid...
5)What is the monthly payment on a 15 year, $350,000 mortgage loan, where interest rate is...
5)What is the monthly payment on a 15 year, $350,000 mortgage loan, where interest rate is 3% per year, Compounded annually Compounded monthly Compounded daily What are effective annual rates for 1,2, and 3 above?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT