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.

Reviews

Write a Review

Financial Management Questions & Answers

  What is the equation for cost function and revenue function

What is the equation for the cost function. What is the equation for the revenue function,

  Completing your corporate finance class

After successfully completing your corporate finance class, you feel the next challenge ahead is to serve on the board of directors of Schenkel Enterprises. Unfortunately, you will be the only person voting for you. Schenkel has 435,000 shares outsta..

  How much more will pay over the life of the loan

Siena Normann is buying her first new car. The purchase price is $22,350 and she’ll put $2,350 down. She will finance the car over five years at 7.25%. Her twin sister, Reese, is buying the same car, but because she has a higher credit score, her rat..

  Low-regular-and-extra dividend policy

Bennett Farm Equipment Sales, Inc., is in a highly cyclic business. Although the firm as a target payout ratio of 25%, its board realizes that strict adherence to that ration would result in a fluctuating dividend and create uncertainty for the firm'..

  Advantage of owning growth stocks

Which of the following is an advantage of owning growth stocks?

  What is the expected return on the portfolio

What is the expected return on the portfolio? What should be Greta’s capital allocation for the risk free asset, hedgefund, and S&P?

  What is the rate of return on your investment

what is the rate of return (APR) on your investment if we assume annual compounding? What about semi-annual compounding?

  Company repurchase as result of the debt issue

How many shares will the company repurchase as a result of the debt issue? How many shares of common stock will remain after the repurchase?

  Expect the trust fund to earn an average return

You would like to establish a trust fund that would pay annual payments to your heirs of $95 thousand a year forever. You expect the trust fund to earn an average return of 7.12 percent. How much do you need to deposit into this trust fund today to a..

  The use of debt financing rdeuces the firm total tax

other things the same, the use of debt financing rdeuces the firm's total tax bill resulting in a higher market value. Accounting profits are used to make capital budgeting decisions because generally accepted accounting principles ensure that profit..

  Otherwise acted equivalently

Two identical firms, A and B, have the same revenue of $10 million and equal variable and fixed costs for the current year. At the start of the year, they both owned $20,000,000 in equipment which follows a depreciation schedule of 5% per year. They ..

  Injured in an automobile accident

Carlos, a citizen of Maine, is injured in an automobile accident in Vermont.  Alex, the driver of the other car, is a citizen of Rhode Island. Carlos wants Alex to pay $125,000 in medical expenses and car repairs. What court would Carlos begin in and..

Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd