Example to work out monthly payment schedules

Assignment Help Financial Management

Reference no: EM131617803

Use your parents’, your relative’s, or your own loan (either mortgage or auto loan) as an example to work out monthly payment schedules (For each month, list the total monthly payment, interest payment, and payment toward principal). List: 1. Total loan amount (If you want to protect privacy, you may multiply this number by 2, or 3, or 0.5) for first month and beginning balances for other months. 2. The starting month of the loan and number of years of amortization left. (monthly payment) 3. APR of the loan (normally the “Rate” quoted by the loan broker) 4. Monthly payment 5. Interest payment each month. 6. Payment toward principal. Check if the total interest payment last year (2016) you calculated is same as shown on form 1098 (Optional) . Put everything in Excel spreadsheet and use the spreadsheet formula. Please do not use any built-in formula from your broker or online mortgage resource if you are not able to fully explain the built-in formula.

Reference no: EM131617803

Questions Cloud

Calculate sale value-break-even npv of keeping the machine : Calculate the sale value, X, that can break-even the NPV of keeping the machine. Consider 40% income tax rate and after-tax minimum ROR of 18%.

Explain importance when developing an elevator speech : Then, rank the following factors in order of importance when developing an elevator speech, and provide a rationale for your response.

Define responsbilities and principles : Responsibilities and Performance Principles. Respond to each of the following comments that you heard related to the audit of Swan Company, a public entity.

Discuss a child challenging behavior : What are the key features needed for an intervention plan to decrease a child challenging behavior which is not complying to rules not doing school work

Example to work out monthly payment schedules : Use your parents’, your relative’s, or your own loan (either mortgage or auto loan) as an example to work out monthly payment schedules

Discuss about the reasonable assurance : Performance Principle. Identify how each of the following statements relates to the performance principle by considering which element(s) of the principle.

What are the ethical undertaking transactions expressly : What are the ethical undertaking transactions expressly to temporarily hide how much money a firm has borrowed?

How is communication different in the learning environment : How is communication different in this online learning environment than a traditional classroom? How do you adjust to this communication channel?

Using constant payment loan method : Calculate interest and principle for a $250,000 loan with the rate of 4%. using Constant Payment Loan method.

User Account

All Pages