Create the amortization schedule for a loan

Assignment Help Finance Basics
Reference no: EM132154729

Create the amortization schedule for a loan of $12,500, paid monthly over three years using an APR of 9 percent. Enter the data for the first three months.

Month. Beginning balance --- Total Payment ---- Interest paid ---- Principle Paid ------Ending balance

1

2

3

Reference no: EM132154729

Questions Cloud

Write a script to display the percentage of rows below : Write a script to display the PERCENTAGE of rows BELOW and OVER the AVERAGE.
Investors and issuers of stock : What is ß and why is it important to investors and issuers of stock? Describe the behavior of stocks with ßs of greater than one, less than one.
Write a short sequence of assembly language to copy words : Use 1 dm and s t m to write a short sequence of assembly language to copy 16 words of data from a source address to a destination address.
Cash cycle and the operating cycle : What is the difference between the cash cycle and the operating cycle? Under what condition would they be the same?
Create the amortization schedule for a loan : Create the amortization schedule for a loan of $12,500, paid monthly over three years using an APR of 9 percent. Enter the data for the first three months.
Evaluate the performance of a computer : When should I use Arithmetic Mean, Geometric Mean, and Harmonic Mean to evaluate the performance of a computer?
What will be the new portfolio beta : You have a portfolio with a beta of 1.47. What will be the new portfolio beta if you keep 86 percent of your money in the old portfolio
Pure expectations theory : If the pure expectations theory is correct what is the yield on 1 yr T bond one year from now?
Create a url object and write the file name : Create a URL object and write the file name, path name, port number, and protocol name for that URL.

Reviews

Write a Review

Finance Basics Questions & Answers

  Problem regarding the expected return on the portfolio

You own a portfolio that has $3,100 invested in Stock A and $4,100 invested in Stock B. If the expected returns on these stocks are 9 percent and 12 percent, respectively, what is the expected return on the portfolio?

  How well a company adapts to international audiences

In what ways does the company adapt its writing style, use of graphics, and other features to adapt to different cultures? Write a brief report on your findings, and include screenshots of the company's website(s) to illustrate your points.

  Calculate the new number of shares outstanding

To discourage short-term investing in its fund, the fund now charges a 5% upfront load and a 2% back-end load. The same investor decides to put $50,000 back into the fund. Calculate the new number of shares outstanding. Assume the fund manager buys b..

  Find number of chests produced

Layne Cedar manufactures cedar chests. The estimated number of chests for the first three months of 20x7 are as follows: Finished goods inventory at the end of December is 4,000 units. Ending finished goods are equal to 40% of next month's sales.

  Which project would you recommend and why

Project S costs $15,000, and its expected cash flows would be $4,500 per year for 5 years. Mutually exclusive Project L costs $37500, and its expected.

  What is the amount of the monthly payments

A commercial bank will loan you $40,422 for 5 years to buy a car. The loan must be repaid in equal monthly payments at the end of the month. The annual interest rate on the loan is 6.75 percent of the unpaid balance. What is the amount of the mont..

  Prepare budgeted financial statements

Ma & Pa Kettle's Chili Corporation has start selling a new chili recipe and they want you to help them with next year's budgeted financial statements.

  What is the after-tax cost of the debt for perpetual

Perpetual Ltd. has issued bonds that never require the principal amount to be repaid to investors. Correspondingly, Perpetual must make interest payments.

  If a company has an option to abandon a project would this

if a company has an option to abandon a project would this tend to make the company more or less likely to accept the

  Review and analysis of the annual report

Research the Internet or the Strayer Library for a publicly traded company and then download the annual report for the most recent year reported for use in this assignment. Based on your review and analysis of the annual report, prepare a ten to tw..

  Define the capital asset pricing model

You have two stocks in your portfolio. $20,000 is invested in a stock with a beta of 0.6 and $40,000 is invested in a stock with a beta of 1.4. What is the beta of your portfolio?

  What will the monthly payment be

Since TVM is an important concept in finance, we'll go over several problems for this week discussions. Let's say that somebody takes out a car loan. The loan is for $20,000, monthly payments are made for five years, and the annual interest rate i..

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