In cell B2 compute the size of the payments

Assignment Help Financial Management
Reference no: EM131817181

You buy a car for $29,500. The dealer offers financing at 8.5% APR, with $2,500 cash down, and monthly payments for three years. In cell B2 compute the size of the payments. Starting in row 15, construct a full amortization schedule for your loan. Columns should include column A: Payment Number, column B: Loan Balance at Start of Month, column C: Monthly Payment, column D: Interest Paid this Month, column E: Principal Repaid this Month, and column F: Loan Balance at End of Month. Print out the full spreadsheet on one sheet of paper.

Reference no: EM131817181

Questions Cloud

What is the fair price for consol bond : What is the fair price for a Consol bond? (present value of the stream of coupon? payments) if the appropriate interest rate is 9?%?
Opening savings account : Uriah Heep celebrated his 18th birthday by opening a savings account at the Thames River Bank and depositing $5,000. What was the amount of his?withdrawal?
What is the rate of return on your investment : At the beginning of the year, you invest $1,000 in a company's common stock. What is the rate of return on your investment?
What is the npv associated with the transaction : What is the NPV associated with the transaction?
In cell B2 compute the size of the payments : The dealer offers financing at 8.5% APR, with $2,500 cash down, and monthly payments for three years. In cell B2 compute the size of the payments.
Points you would be willing to pay to buy down interest rate : What are the most points you would be willing to pay to buy down the interest rate?
What rate would you actually be paying here : You are looking at a one-year loan of $17,000. The interest rate is quoted as 8.6 percent plus four points. What rate would you actually be paying here?
Break-even resale price-different between buying and leasing : What break-even resale price in two years would make you indifferent between buying and leasing? What is the present value of purchasing the car?
Liquidity-asset management-debt management-profitability : Choose one or two ratios from each of the groups: liquidity, asset management, debt management, profitability, and market value over three years for 2015,2016,

Reviews

Write a Review

Financial Management Questions & Answers

  How much was jennie charged in interest for billing cycle

If Jennie's credit card uses the average daily balance method, how much was Jennie charged in interest for the billing cycle

  Complete the table with the correct postp-merger figures

The following table show pre-merger figures of CH Enterprises and ComYon Corporation: CH Enterprises (Pre-Merger) ComYon Corp.(Pre-Merger) CH Enterprises (Post-Merger) 1) EPS $2.00 $2.00 ? 2) Price per Share $40 $20 ? 3) P/E Ratio 20 10 ? 4) # of Sha..

  Yankee inc a us based mnc has recently decided to expand

yankee inc. a u.s. based mnc has recently decided to expand its international trade relationship by exporting to

  What results of calculation mean to you as project manager

Describe what the results of each calculation mean to you as a project manager.

  The correlation between the two stocks

Consider two stocks, Stock D, with an expected return of 20 percent and a standard deviation of 36 percent, and Stock I, an international company, with an expected return of 6 percent and a standard deviation of 16 percent. The correlation between th..

  How is your realized after-tax return different

After reading this chapter, it isn't surprising that you're becoming an invest- ment wizard. With your newfound expertise, you purchase 100 shares of KSU Corporation for $37 per share.  What would be your total return on your KSU Corporation investme..

  Present value of the net cash flow

A company XYZ is considering manufacturing a product in space. The project lifetime is 10 years and has the following consecutive phases: Phase 1 (years 1 to 3): The engineering design and development requires 3 years. what is the present value of th..

  Order to finance the aforementioned

You have the following information. In 10 years and in 15 years you will send your two nephews to attend school. The tuition now is $10,000 but will grow at 7% per annum. The school will guarantee the tuition to be the same per year at the time your ..

  What is your high target stock price over the next year

If you look at stock prices over any year, you will find a high and low stock price for the year. What is your high target stock price over the next year?

  Savings account-credits interest at nominal discount rate

Quang accumulates a fund by depositing $20,000 in a savings account that credits interest at a nominal discount rate of 4.8% per year compounded quarterly. How many years will his money last after he starts withdrawing it from the new account?

  Forward price and the initial value of the forward contract

A one-year long forward contract on a non-dividend-paying stock is entered into when the stock price is $38 and the risk-free rate of interest is; 8% per annum with continuous compounding. What are the forward price and the initial value of the forwa..

  What is the expected return and risk of the portfolio

If an investor puts one-fourth of his wealth in A and three-fourths in B, what is the expected return and risk of this portfolio?

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