Create the amortization schedule of a four-year ordinary annuity worth $ 15,000 and an effective annual...

Create the amortization schedule of a four-year ordinary annuity worth $ 15,000 and an effective annual return on 6 percent with monthly instalments, and calculate how much principal is expected to be paid in the first month of the second year.

If it possible, could u do it in excel table. Thank you in advance.

Expert Solution

Principal Amount = P = $15000

Number of Years = 4 (= 48 months)

Interest Rate = 6%

Calculating in Excel -

Principal to be paid in first month of second year (13th month) = $294.38

jeff jeffy answered 1 year ago

A residential home worth $ 1,249,000 in a town. Create an amortization schedule with 2 different...

A residential home worth $ 1,249,000 in a town. Create an amortization schedule with 2 different financing options with Excel. Complete the following steps: I. Determine a down payment. (a standard down payment is 20%) II. Research 2 different financing options (describe) III. Use Excel to create a complete amortization schedule for the lif of both financing options. IV. Write up an analysis that compares and contrasts the two financing options in detail. Please be specific. Include justifications for selecting an...

Complete an amortization schedule for a $15,000 loan to be repaid in equal installments at the...

Complete an amortization schedule for a $15,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 9% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. Beginning Repayment Remaining Year Balance Payment Interest of Principal Balance 1 $ $ $ $ $ 2 3 What percentage...

Define annuity due. Would an investment be worth more if it were an ordinary annuity or...

Define annuity due. Would an investment be worth more if it were an ordinary annuity or an annuity due? Explain.

An amortization schedule is a common concept within a banking enterprise. Create your own amortization schedule...

An amortization schedule is a common concept within a banking enterprise. Create your own amortization schedule for a $10,000 loan with monthly payments paid over two years. Assume the annual percentage rate (APR) is 4%. Create the amortization schedule within Excel or another spreadsheet application. Use page 184 as a template. Keep in mind that the example on page 184 uses annual payments, while your schedule will use monthly payments. You will need to adjust the number of payment periods...

Finance- Amortization Schedule Create the amortization schedule for a loan of $5,000, paid monthly over two...

Finance- Amortization Schedule Create the amortization schedule for a loan of $5,000, paid monthly over two years using an 8 percent APR.

Amortization Schedule Consider a $15,000 loan to be repaid in equal installments at the end of...

Amortization Schedule Consider a $15,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 7%. Set up an amortization schedule for the loan. Do not round intermediate calculations. Round your answers to the nearest cent. If your answer is zero, enter "0". Year Payment Repayment Interest Repayment of Principal Balance 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $ 4 $ $ ...

Problem 5-50 Amortization Schedule (LG9) Create the amortization schedule for a loan of $4,300, paid monthly...

Problem 5-50 Amortization Schedule (LG9) Create the amortization schedule for a loan of $4,300, paid monthly over two years using an 9 percent APR. (Round your answers to 2 decimal places.) Month Beginning Balance Total Payment Interest Paid Principal Paid Ending Balance 1 2 3 4 5 6 7 ...

Problem 5-49 Amortization Schedule (LG9) Create the amortization schedule for a loan of $14,000, paid monthly...

Problem 5-49 Amortization Schedule (LG9) Create the amortization schedule for a loan of $14,000, paid monthly over three years using a 9 percent APR. (Round your answers to 2 decimal places.) Month Beginning Balance Total Payment Interest Paid Principal Paid Ending Balance 1 2 3 4 5 6 7...

Create an Amortization Schedule for a $275,000 office building to be purchased with a 30-year loan...

Create an Amortization Schedule for a $275,000 office building to be purchased with a 30-year loan at an APR of 5% compounded monthly. Determine the monthly payments and how much interest is paid over the life of the loan. (format amortization schedule with the following columns: month, beginning principal, monthly payment, monthly interest, principal reduction, ending principal)

A 5-year, $100 ordinary annuity has an annual interest rate of 4%.

A 5-year, $100 ordinary annuity has an annual interest rate of 4%. 1. What is its present value? 2. What would the present value be if it was a 10-year annuity? 3. What would the present value be if it was a 25-year annuity? 4. What would the present value be if this was a perpetuity?

Question