Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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 model2. Input; There are three inputs required for this model, annual interest rate, number of months of the loan, and the loan amount3. 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?
Mr. Husker's Tuxedos Corp. ended the year 2012 with an average collection period of 39 days. The firm's credit sales for 2012 were $56.8 million.
The American Automobile Association checks the values of gasoline before many holiday weekends. Given below are the self-service prices for a sample of fifteen retail outlets during the May 2003
What are the five levels of Maslow’s Hierarchy?
unfortunately in recent times we have seen a number of examples of unethical behavior in organizations often tied to
xyz company has sales of 15450 costs of 4800 depreciation expense of 1900 and interest expense of 1250. if the tax rate
a) When the price of luxury cars increases, the number of luxury cars purchased increases. b) The percentage change in the price of luxury cars is less than the percentage change in the quantity demanded. c) If average family incomes fall, sales of l..
The firm has been extremely successful thus far and has decided to incorporate and offer shares of stock to the general public. What is this type of an equity offering called?
question a firm has the following preferred stocks outstandingbullpfd a 32 annual dividend 1000 par value no
place the following in the proper chronological order and describe the purpose of each ex-dividend date record date
What is the weighted average cost of capital (WACC) for Cypress?
She will have to borrow $3,650 in order to make the trade. The bank provides a loan that must be paid off in 18 months. The loan charges interest at the rate of .5% per month. How much are the monthly loan payments?
Current assets are equal to 20% of sales and fixes assets remain at their current level of 1 million.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd