Question: Create an amortization schedule/sinking fund schedule for the following: a. A $500,000 loan with level payments made at the end of each year for 30-years.

Create an amortization schedule/sinking fund schedule for the following: a. A $500,000 loan with level payments made at the end of each year for 30-years. Assume an annual effective interest rate on the loan of 4% and that the loan is repaid with the amortization method.

In excel with equations listed please.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

A business manufactures refrigerators for domestic use. There are three models: Lo, Mid and Hi. The models, their quality and their price are aimed at different markets. Product costs are computed...

Create an amortization schedule/sinking fund schedule for the following: c. A $500,000 loan with level payments made at the end of each year for 30-years. Assume an annual effective interest rate on...

Create an amortization schedule/sinking fund schedule for the following: b. A $500,000 loan with level payments made at the end of each year for 30-years. Assume an annual effective interest rate on...

Math 4065 Excel Project #3: Loans Using the template, fill out an amortization schedule/sinking fund schedule for the following: A$100,000 loan with level payments made at the end of each year for...

Using the template, fill out an amortization schedule/sinking fund schedule for the following: A $100,000 loan with level payments made at the end of each year for 30-years. Assume an annual...

i need an excel method with every equation in that project. Create an amortization schedule for the following: a. A $500,000 loan with level payments made at the end of each year for 30-years. Assume...

I need excel solution. I have my own solution, but I want to know if there is other ways or if my solution is correct. If you can use excel function, that would be good as well. 1. A $100,000 loan...

1. A 20-year annuity immediate pays 100 the first year and increases by 100 a year through year 10. Starting in year 11 each yearly payment is 5% greater than the previous payment. The annuity earns...

1. The current price of a bond is 100. The instantaneous rate of change or derivative of the price of the bond with respect to the yield rate is -700. The yield rate is an annual effective rate of...

Could someone help me with problems 13, 14, 15, and 16 on the attached PDF? I need to show work for all, so explanations would be really helpful. Thank you! 1. Assume the following rates are being...

Can someone help me with those questions? It's related to my major and I want to check whether I understand them (Could you show me the process). Thank you so much! 1. Assume the following rates are...

Colonial North Manufacturing, Inc. is considering eliminating one of its product lines. The fixed costs currently allocated to the product line will be allocated to other product lines upon...

Database Systems is considering expansion into a new product line. Assets to support expansion will cost $380,000. It is estimated that Database can generate $1,410,000 in annual sales, with an 8...

if ending inventory is understated, what is the effect on net income and current ratio

How to solve Life insurance needs analysis method

e. In how many cases were people depicted in stereotypical rolesfor example, African Americans as athletes, or women as homemakers?

1. Discuss the four components of language.

a. How many different groups were represented?