Create amortization schedule

Assignment Help Financial Management
Reference no: EM131908816

Because KUNY Bank offers very competitive rates, you approve another loan for a different small business. The loan amount is $12,000, the duration of the loan is six years, and the interest rate is 8.75%. Per the terms of the loan, the borrower has to pay interest on the loan each year, plus a fixed annual payment of $2,000 to reduce the loan balance until full re-payment. Compute the following: (a) Create an amortization schedule for this company, (b) Using a bar chart, graph the cash flows (i.e. Total Payment, Interest Paid, and Principal Paid) on the y-axis versus time on thex-axis, (c) Add data labels to your series, so that your customer can easily visualize the data.

Reference no: EM131908816

Questions Cloud

Effect of these new projects on value of frontier : estimate the effect of these new projects on the value of Frontier
Managers are quick to claim that quantitative analysts : Managers are quick to claim that quantitative analysts talk to them in a jargon that does not sound like English.
Calculate the present value of the company stock : Calculate the present value of the company’s stock and the expected a) dividend yield, b) capital gain yield, and c) total return during
What bid price should you submit on contract : If your tax rate is 34 percent and your required return on this project is 12 percent, what bid price should you submit on the contract?
Create amortization schedule : Create an amortization schedule for this company, Using a bar chart, graph the cash flows.
Using tax formula-beginning with income broadly conceived : Using the Tax formula, beginning with Income Broadly Conceived, provide a detailed calculation of the couple's 2017 taxable income.
Expected rate of return on investment portfolio : What would be the expected rate of return on your investment portfolio if the dollar amount you invested for the three stocks are $8,000,
Started an engineering consulting firm : Consider the following situation:You and two of your very best friends have started an engineering consulting firm.
The regression line tell you about the stock market risk : what would the slope of the regression line tell you about the stock’s market risk?

Reviews

Write a Review

Financial Management Questions & Answers

  Currently unspecified cash flow

You are negotiating to make a 7-year loan of $26,000.00 to Breck In. To repay you, Breck will pay $2,500 at the end of Year 1, $5,000 at the end of Year 2, and $7,500 at the end of Year 3, plus a fixed but currently unspecified cash flow, X, at the e..

  Take advantage of store policies for returns

Are customers that try to take advantage of store policies for returns etc., actually worth keeping loyal in the long run? Why or why not?

  Standard deviation of return on client portfolio

You manage an equity fund with an expected risk premium of 14% and a standard deviation of 54%. The rate on Treasury bills is 6.8%. Your client chooses to invest $120,000 of her portfolio in your equity fund and $30,000 in a T-bill money market fund...

  What are possible solutions to these harms

What if anything should be done about discrimination in private businesses? As far as serving people? And employing people? What are possible solutions to these harms?

  Which parts of health care system are paid for or controlled

Which parts of the health care system are paid for, or controlled, by government?

  Prepare the stockholder equity section of the balance sheet

"Sophia Dueno organized Newtown Type, Inc. in January 1999. The corporation immediately issued at $12 per share one-half of its 150,000 authorized shares of $1 par value common stock. Prepare the stockholder’s equity section of the balance sheet at D..

  Rule of thumb that lenders use to approve mortgage loans

Monthly mortgage payments (PITI) should not exceed 28% of gross income is a rule of thumb that lenders use to approve mortgage loans.

  What is the retention rate and growth rate of earnings

What is the retention rate? What must be the growth rate of earnings? What is the total projected earnings one year from now?

  New residents will move into the community

A group of city developers has begun planning a new community. They project that every three months, a total of 70 new residents will move into the community. They also project that, aside from new residents, the community’s population will grow at a..

  Discuss the business as well as accounting implications

The management of Hinrichs corporate is concerned because survey data suggest that many potential customers do not buy vehicles due to quality concerns it is considering taking the bold step of increasing the length of its warranty from the industry ..

  What was the price you purchased the stocks

What was the price you purchased the stocks at six months ago, if there is no dividend involved?

  Highly correlated with new york stock exchange

If a portfolio is highly correlated with the New York Stock Exchange then

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