What is the amount of the monthly payments

Assignment Help Finance Basics
Reference no: EM133120578

A commercial bank will loan you $10,500 for three years to buy a car.

The loan must be repaid in equal monthly payments. The annual interest rate on the loan is 9% of the unpaid balance. What is the amount of the monthly payments?

After the 24th payment, what will the balance be?

Subject: Time Value of Money

Please don't do this by hand.

Answer in Excel using formulas e.g. PV=XXX, FV=XXX, N(NPER)=XXX, I(Rate)=XXX, PMT=$$.

i.e. =fv(rate, nper, pmt, [pv], [type]

Reference no: EM133120578

Questions Cloud

Access capital in the international capital markets : Consider an Australian MNE that is undertaking a major expansion into the US. Comment, in general terms, on any four possible strategies this MNE might follow t
Government revenues and expenses : 1. It facilitate the flow of funds from the suppliers to the demanders in the financial market.
Calculate the break-even point in units and break-even point : The following information is related to CTH Corporation which manufactures a single product: Calculate the contribution margin per unit and contribution margin
Suppliers of funds in the financial market : 1. Households can only be considered as suppliers of funds in the financial market.
What is the amount of the monthly payments : The loan must be repaid in equal monthly payments. The annual interest rate on the loan is 9% of the unpaid balance. What is the amount of the monthly payments?
Prepare the bank reconciliation at September : At September 30, deposits in transit were $4,620, and outstanding checks totaled $2,553. Prepare the bank reconciliation at September
Numerous confusing regulations : Providers who agree to participate in these programs and accept payment for services must comply with numerous confusing (and expensive) regulations.
Expected return and standard deviation of portfolio : The Bank of Tinytown has three loans that have the following characteristics but only needs to select two loans to include in their portfolio. If the covariance
Download daily historical prices of klse market index : -Download daily historical prices of KLSE MARKET INDEX, from Yahoo finance or Bursa Malaysia. Use the latest one year data for this purpose

Reviews

Write a Review

Finance Basics Questions & Answers

  Find out the realized compound yield

You are considering a bond with a 4.2%% coupon rate, 18 years until maturity, and a $1,000 par If the bond's quoted price is 104.14, and you can reinvest the co

  How savings institutions could use interest rate swaps

Will SIs that use swaps perform better or worse than those that were unhedged during a period of declining interest rates? Explain.

  Material change affecting financial results

The SEC is trying to get companies to notify the investment community more quickly when a "material change" will affect their forthcoming financial results.

  What is the profit-loss per option

The premium of the option at time zero was $1.2. At maturity, the price of the underlying is 9.62. What is the profit/loss per option?

  Objectives of supply chain management strategy

Discuss the main objectives of supply chain management strategy? SET examples of your own?

  Is signature from one of the companys a necessary part of

your company inc. wants to do business with my company llc. because our companies are both savvy they would like to

  A fast growing firm recently paid a dividend of

1. A fast-growing firm recently paid a dividend of $0.40 per share. The dividend is expected to increase at a 20 percent rate for the next three years. Afterwards, a more stable 10 percent growth rate can be assumed. If an 11 percent discount rate is..

  Cf required to provide a given rate of return

You have been offered a 5-year investment at a price of $40,000. It will pay $3,250 at the end of Year 1, $4,500 at the end of Year 2, and a fixed

  Discuss how any company can become an mnc

Discuss how any company can become an MNC. What are some of the options available to companies that allow them to use international markets and locations competitively?

  What is the amount of the operating cash flow

Bluedo's has sales of $435,000, depreciation of $35,000, and net working capital of $56,000. The firm has a tax rate of 34% and a profit margin of 8%. The firm has no interest expense. What is the amount of the operating cash flow?

  Calculate the money received by the company

Invester banker five enters into a best efforts arrangement to try and sell ten million shares of stock at $15.00 per share for Rogers Company. The investment banker five incurs expenses of $300,000 in floating the issue and the company incurs expens..

  Compute the dividends over the specific time

Suppose that a firm's recent earnings per share and dividend per share are $2.20 and $1.20, respectively. Both are expected to grow at 10 percent.

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