Prepare the amortization schedule for the loan

Assignment Help Financial Management
Reference no: EM131055309

Bill has $25,000 in an investment account earning 6 percent per year. Bill decides to purchase a new car with a sticker price of $25,000. The car dealer offers Bill either $2,000 cash back or 2% financing for 5 years. If Bill takes the financing, he will make 60 equal monthly payments. Otherwise, he will pay $23,000 today for the car.

Calculate the monthly payment required if Bill agrees to the sticker price of $25,000 and finances the car at 2% per year.

Prepare the amortization schedule for the loan using an Excel spreadsheet.

Prepare a graph in Excel that shows the portion of each payment that goes to interest and the portion that goes to principal.

Based on the time value of money, should Bill take the $2,000 cash back or the 2% financing? Clearly explain and defend your choice.

Reference no: EM131055309

Questions Cloud

Discuss some of the methodological issues unique : State the topic you selected and then write two potential research questions that could be explored on the topic you selected. Identify at least one potential research design to answer each of the research questions you wrote (you will identify a t..
What is the expected NPV of the new project : A firm is considering a new project that has a cost of $1,000. Suppose, the CFO asked you to set up the decision tree to show its three most likely scenarios. The best case scenario happens with probability of 0.2, and produces three cash flows of $8..
Required return on stock-what is the current share price : Apocalyptica Corporation is expected to pay the following dividends over the next four years: $6.90, $17.90, $22.90, and $4.70. Afterwards, the company pledges to maintain a constant 6.00 percent growth rate in dividends, forever. Required: If the re..
Should she pursue the poison pill strategy : How should Dr. Bauer proceed? Provide reasons to support your answer. Should she offer her advice regarding the syndrome evidence? Why or why not?
Prepare the amortization schedule for the loan : Bill has $25,000 in an investment account earning 6 percent per year. Bill decides to purchase a new car with a sticker price of $25,000. The car dealer offers Bill either $2,000 cash back or 2% financing for 5 years. Calculate the monthly payment re..
If the benchmark price-sales ratio for the company : TwitterMe, Inc., is a new company and currently has negative earnings. The company’s sales are $2,700,000 and there are 275,000 shares outstanding. If the benchmark price-sales ratio for the company is 5.3, how much will you pay for the stock? If the..
The managing editor of well-known business journal : Beverly Sutton is now employed as the managing editor of a well-known business journal. Although she thoroughly enjoys her job and the people she works with, wat she would really like to do is open a bookstore of her own. She would like to open her s..
Does monsanto maintain an ethical culture : Does Monsanto maintain an ethical culture that effectively responds to various stakeholdwes?

Reviews

Write a Review

Financial Management Questions & Answers

  Calculate the price value of basis point and the yield value

Calculate the price value of a basis point and the yield value of a price change for a 30-year US Treasury bond with a coupon of 5%, a maturity date of 8/15/2042, a settlement date of 10/29/2012, and a price of 101:24.

  Expected return on the stock fund

Your retirement strategy is to invest 500 per month in an equity mutual fund and 200 per month in a bond fund. Your retirement date is 30 years from now. The expected return on the stock fund is expected to be 8% and the expected return on the bond f..

  Units of production depreciation method

Oil Company may calculate depreciation using the “units of production” method of depreciation. Consider a depreciable asset costing $100,000 that is expected to have a useful life of 120,000 units. Salvage value is estimated to be $20,000. Estimated ..

  Problem 1on completion of mba eddie and mike were so

problem 1on completion of mba eddie and mike were so pleased with the amount of useful and interesting knowledge that

  Equipment will lead to cash flows

Muncy, Inc., is looking to add a new machine at a cost of $4,133,250. The company expects this equipment will lead to cash flows of $819,822, $863,275, $937,250, $1,020,110, $1,212,960, and $1,225,000 over the next six years. If the appropriate disco..

  Stock expects the future free cash flows

You are working on the valuation for an upcoming IPO. The company that wants to sell its stock expects the following future free cash flows (FCF, in millions of dollars): -6 in year 1, 9 in year 2, 16 in year 3, and cash flows are expected to grow st..

  What must the expected return on the market be

A stock has an expected return of 10.2 percent, its beta is 1.03, and the risk-free rate is 6.40 percent. What must the expected return on the market be?

  The existence of unemployment compensation

The existence of unemployment compensation most likely will cause less unemployment.

  What is the after tax salvage value of the asset

An asset used in a four-year project falls in the 5 year MACRS class for tax purposes. The asset has an acquisition cost of $6,500,000 and will be sold for $1,600,000 at the end of the project. If the tax rate is 35% what is the after tax salvage val..

  What is the required return on the firms levered equity

Lone Star Industries just issued $260,000 of perpetual 10 percent debt and used the proceeds to repurchase stock. The company expects to generate $123,000 of earnings before interest and taxes in perpetuity. What is the value of the company as an unl..

  Butterfly trade

Butterfly trade is: (a) Investing the same amount in long term bonds in a rolling period; (b) Buying short-term and long-term bonds and short intermediate-term bonds; (c) Mimicking the portfolio of a bond index; (d) Buying under-priced bonds using va..

  Find the future value of an ordinary annuity if payments

Find the future value of an ordinary annuity if payments are made in the amount R and interest is compounded as given. Then determine how much of this value is from contributions and how much is from interest. The future value of the ordinary annuity..

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