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?

User Account

All Pages