# Module 02 modeling assignment – loan amortization table

Module 02 modeling 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.

• 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?

Based upon the following story

complete the model criteria in Microsoft Excel

:

The model

should contain the following sections: Description, Inputs, and Formula/Outputs.

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 amortizati

on table.

Criteria Complete Using Microsoft Excel

Weight

1.Assuming the original

assumptions, how much in interest

will the organization pay over 3

years? 30%

2. If the interest rate drops to 3%,

what impact does that have on

interest

payments?30%

The final model should contain the

following sections: Description, Inputs,

Formula/Outputs.20%

Total Quality (grammar, spelling, and APA

formatting) 20%

Total 100%

Module 02 modeling assignment – loan amortization table

Pages (275 words)
Standard price: \$0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
All your data is secure and will never be disclosed to third parties. Your essay or assignment is treated as your intellectual property and can never be shared or provided as a sample to aspiring customers.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
You will never have to worry about deadlines – 98% of our assignments are completed on time.
Money Back
We give refunds anytime you feel the work did not meet your expectations. However, we have not refunded any papers in the last 6 months as our team keeps improving their quality and customer service.

## Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00