How much of their first payment goes toward interest

Assignment Help Financial Management

Reference no: EM131985252

This is an extensive, five-part question, and requires creation of an amortization table.

Part 1

Michael and Ashley owe $35,000 on their student loans at an interest rate of 5%. The term is 20 years. Find their monthly payment. Note: Round your final answer to two decimal places. Do NOT include a dollar sign in your final answer.

Part 2

Construct the first row of the amortization table for their student loans. How much of their first payment goes toward interest? How much of their first payment goes toward principal? After making their first payment, what is the remaining balance? Note: Round your answers to two decimal places. Do NOT include dollar signs in your answers.

Part 3

Construct the second row of the amortization table for their student loans. How much of their second payment goes toward interest? How much of their second payment goes toward principal? After making their second payment, what is the remaining balance? Note: Round your answers to two decimal places. Do NOT include dollar signs in your answers.

Part 4

Continue constructing the amortization table for their student loans until you have completed 12 rows of the table. What is the total amount of interest that Michael and Ashley will pay on their student loans in the first year? Note: Round your final answer to two decimal places. Do NOT include a dollar sign in your final answer.

Part 5 Explain how you constructed the amortization table for their student loans. Include the formulas that you used. Show your calculations for at least one row of the table.

Reference no: EM131985252

Questions Cloud

What is approximate real rate of interest : What is the approximate real rate of interest?

Two investments to be worth exactly same amount : How long will it take for the two investments to be worth exactly the same amount?

What is diane current outstanding principle : What is Diane's current monthly mortgage payment? What is Diane's current outstanding principle?

What is the effective annual cost of trade credit : Pets store inc. sells on terms of 3/15, net 75. What is the effective annual cost of trade credit under these terms? Use a 365- day year.

How much of their first payment goes toward interest : Construct the first row of the amortization table for their student loans. How much of their first payment goes toward interest?

How much cash will larry and laurie need at? closing : Closing Costs. Larry and Laurie have found a home and made a $101.200 offer that has been accepted. How much cash will Larry and Laurie need at? closing?

What is bart present value of the lease payments : What is Bart's present value of the lease payments? Barts implied interest rate in the lease payment is?

Bank account to make the decision alternatives equivalent : Now use Goal Seek to determine the interest rate required for the bank account to make the decision alternatives equivalent.

Difference between governmental funds and enterprise funds : Describe in your own words the difference between governmental funds and enterprise funds.

User Account

All Pages