Calculate the monthly interest payments by building a loan

Assignment Help Finance Basics

Reference no: EM131172558

Module Assignment - Loan Amortization Table

You work for We Build the World Manufacturing Inc. The company has decided to get a three year loan to purchase a high end lathe for $1M. The current interest rate is 6%. Your job is to calculate the monthly interest payments by building a loan amortization table.

The model should have three areas:

1. Documentation: Explaining the purpose of the model
2. Input; There are three inputs required for this model, annual interest rate, number of months of the loan, and the loan amount
3. Formula/Output Area: As shown on the example for a $500 loan for twelve months, the inputs are feeding the calculations in the

Formula/Output Area.

Answer the following questions:

• Assuming the original assumptions, how much in interest will the organization pay over 3 years?

• If the interest rate drops to 3%, what impact does that have on interest payments?

Reference no: EM131172558

Questions Cloud

Determine the eccentricity which produces this amount : Determine the eccentricity which produces this amount of acceleration at 5000 rpm, and give the permissible amount of unbalance in N.m (Wr) for a 4500 N rotor.

Demanded for the corn was less than the quantity supplied : In 2012, the price of corn was $8 a bushel. In 2014, a huge harvest caused the price to drop to about $4 a bushel because quantity demanded for the corn was less than the quantity supplied. If quantity demanded for corn is much less than quantity sup..

Which country or industry are seen as scarce : HI5003 Economics for Business. Scarce resources- which resource and in which country/industry are seen as scarce and what is being done in the industry or country. What substitutes have been used to overcome this problem

Is the father a patient and protected by confidentiality : Is the father a patient and protected by confidentiality? Even if he is not a patient, is his explicit request, which was not refused, a protection of his confidentiality? If the matter is confidential, what can the physician say or do to protect ..

Calculate the monthly interest payments by building a loan : The company has decided to get a three year loan to purchase a high end lathe for $1M. The current interest rate is 6%. Your job is to calculate the monthly interest payments by building a loan amortization table.

Technological matrix m for island economy : A) Write the technological matrix M for this island economy. B) If a,final demand of $25. million, $15 million and $20 million from tourism, agriculture and fishing is to be met, then set up the equation to be satisfied by the inputs from the resp..

Petroleum exporting countries reduces oil production : The purpose of this assessment is to help you analyze the factors that affect the demand and supply of any product in the market. Assessment Description: Analyze the following events: The price of oil increases because Organization of Petroleum Expor..

Determine the size and location of the holes : However, the balancing is to be achieved by drilling holes in the webs of the gears at the diameters shown. Determine the size and location of the holes for dynamic balance.

Log-linear model and log-log model : How do you choose between log-linear model and log-log model? How about linear log-linear? And how about linear-log and log-log? Why? How do you interpret coefficients of a A) log-linear B) log-log and C) linear-log model?

User Account

All Pages