Question

In: Accounting

Create a loan amortization table for a $100,000 2 year loan at 4.875% annual interest payable...

Create a loan amortization table for a $100,000 2 year loan at 4.875% annual interest payable semi-annually:

a) Calculate the payment amount.

b) Do the loan amortization table.

c) What is the journal entry to receive the third payment?

Expert Solution

Answer A)

Annual Interest Rate = 4.875%.

Semi Annual Interest Rate = 2.4375%

Using excel function 'PMT' and taking the following variables, payment amount (Installment amount) comes to $ 26,541.78

Rate = 2.4375%

nper = 4

PV = 100,000

0 = Payment to made at the end of the period

Alternative Way:

PVIFA @ 2.4375% for 4 half years comes to 3.7676.

Installment Amount = 100,000 / 3.7676 = 265,41.78

Answer B)

Loan Amortization Table:

Half Year	Beginning Loan Balance	Interest	Repayment	Ending Balance
1	1,00,000.00	2,437.50	26,541.78	75,895.72
2	75,895.72	1,849.96	26,541.78	51,203.90
3	51,203.90	1,248.10	26,541.78	25,910.21
4	25,910.21	631.56	26,541.78	(0.01)

Answer C)

Journal entry to receive the third payment

Loan A/c	Dr	25,293.68
Interest Expense on Loan A/c	Dr	1,248.10
Bank A/c	Cr		26,541.78

ekkarill92 answered 2 months ago

complete an amortization schedule for the following loan. the loan is $100,000 at 3.5% interest, amortized...

complete an amortization schedule for the following loan. the loan is $100,000 at 3.5% interest, amortized on a YEARLY basis over five (5) years.

calculate a loan amortization schedule for a $10,000 loan, 5% annual interest, one payment a year...

calculate a loan amortization schedule for a $10,000 loan, 5% annual interest, one payment a year for 10 years, starting on 1/1/2010. All calculations must be shown, i.e., do not use a “package” to complete this question. Loan period starts from 1/1/2010. I mean the first payment is to be made on 1/1/2010.

Prepare an amortization table for the calculation of interest and payment of the Document payable to...

Prepare an amortization table for the calculation of interest and payment of the Document payable to a natural person, for $ 2,000,000 at the annual rate of 12%, payable in 3 years. The interest plus the payment of the document will be made at the end of the 3 years. Calculate with simple interest and also calculate cost with compound interest

$100,000 Amortizing Loan 9% Stated Rate 20 Year amortization Annual payments -Calculate annual payments - Prepare...

$100,000 Amortizing Loan 9% Stated Rate 20 Year amortization Annual payments -Calculate annual payments - Prepare amortization table

$100,000 Amortizing Loan 9% stated rate 20-year amortization 5-year balloon Annual Payments a) Calculate annual payment...

$100,000 Amortizing Loan 9% stated rate 20-year amortization 5-year balloon Annual Payments a) Calculate annual payment b) Calculate balloon payment c) Value at 12% yield d) Prepare an amortization table

In Excel, create the amortization table for a 15-year mortgage for $780,000 at 6.6% interest. Individual...

In Excel, create the amortization table for a 15-year mortgage for $780,000 at 6.6% interest. Individual taxpayers may be able to deduct the amount of interest that they paid on a mortgage for a personal residence. If the mortgage was issued on July 1, how much interest will be earned in the first year? How much interest will be earned in the second year?

In Excel, create the amortization table for a 15-year mortgage for $950,000 at 4.2% interest. Individual...

In Excel, create the amortization table for a 15-year mortgage for $950,000 at 4.2% interest. Individual taxpayers may be able to deduct the amount of interest that they paid on a mortgage for a personal residence. If the mortgage was issued on May 1, how much interest will be earned in the first year? How much interest will be earned in the second year? Upload your Excel file below.

For this quiz, create an amortization table spreadsheet for a loan with initial balance of $50,000...

For this quiz, create an amortization table spreadsheet for a loan with initial balance of $50,000 at 6.43% with a monthly payment of $1200. Answer the following questions based on that spreadsheet. What will the loan balance be after the first payment is made? After which monthly payment does the loan become fully paid off? Using the $1200 regular monthly payment in that last month will overpay the loan. How much should that last monthly payment be reduced to so...

a. Prepare the amortization schedule for a thirty-year loan of $100,000. The APR is 3% and...

a. Prepare the amortization schedule for a thirty-year loan of $100,000. The APR is 3% and the loan calls for equal monthly payments. The following table shows how you should prepare the amortization schedule for the loan. Month Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 $100,000.00 b. Use the annuity formula to find how much principal you still owe to the bank at the end of the third year. Check that this value is the same...

Excel, create the amortization table for a 15-year mortgage for $950,000 at 4.2% interest. Individual taxpayers...

Excel, create the amortization table for a 15-year mortgage for $950,000 at 4.2% interest. Individual taxpayers may be able to deduct the amount of interest that they paid on a mortgage for a personal residence. If the mortgage was issued on May 1, how much interest will be earned in the first year? How much interest will be earned in the second year? Upload your Excel file below. I dont know how to create an ammortization in excel. It is...