User Account

All Pages

Compute the future value and the present value

Assignment Help Financial Management
Reference no: EM131145848

Complete the following problem sets in Microsoft Excel:

• Future Value: Compute the future value in year 9 of a $2,000 deposit in year 1 and another $1,500 deposit at the end of year 3 using a 10 percent interest rate.

• Future Value of an Annuity: What is the future value of a $900 annuity payment over five years if interest rates are 8 percent?

• Present Value: Compute the present value of a $2,000 deposit in year 1 and another $1,500 deposit at the end of year 3 if interest rates are 10 percent.

• Present Value of an Annuity: What's the present value of a $900 annuity payment over five years if interest rates are 8 percent?

• Present Value of an Annuity: Due If the present value of an ordinary, 6-year annuity is $8,500 and interest rates are 9.5 percent, what's the present value of the same annuity due?

• Effective Annual Rate: A loan is offered with monthly payments and a 10 percent APR. What's the loan's effective annual rate (EAR)?

Calculate monthly payment only:

• Loan Payments: You wish to buy a $25,000 car. The dealer offers you a 4-year loan with a 9 percent APR. What are the monthly payments? How would the payment differ if you paid interest only? What would the consequences of such a decision be?

Reference no: EM131145848

Questions Cloud

What will be start up ratio of market value to book value : What will be Start-Up's ratio of market value to book value? How would that ratio change if the firm can earn only a 10% rate of return on its investments?
The external recruitment process : Within the external recruitment process, which of the following is most closely associated with strategy development?
How do companies use responsibility centers : How do companies use responsibility centers? How are the managers of the responsibility centers held accountable? Why is budgeting important? Describe how you use budgeting in your personal life or in your company.
Calculate current ratio inventory turnover receivables : Compute the following: (It is not necessary to use averages for any balance sheet figures involved.) (a) Current ratio (b) Inventory turnover (c) Receivables turnover (d) Book value per share  (e) Earnings per share (f) Debt to total assets
Compute the future value and the present value : Compute the future value in year 9 of a $2,000 deposit in year 1 and another $1,500 deposit at the end of year 3 using a 10 percent interest rate.
Calculate cp capability ratio and cpk capability index : Calculate Cp (Capability ratio) and Cpk (Capability index) from the following data: Sigma (standard deviation) = 20Upper spec limit = 250 Lower spec limit = 100
Describe five cardinal virtues of professional accountants : Describe the five cardinal virtues of professional accountants that the article's authors discuss. Compare and contrast the AICPA's Code of Professional Conduct and the IFAC Code of Ethics for Professional Accountants.
Calculate investment as a percentage of gdp for each year : Go to Table B-2 of the Economic Report of the President and collect data on real GDP and real gross domestic investment for the period 1992 to 2000. Calculate investment as a percentage of GDP for each year. What happened to investment over the pe..
Which aicpa code applies to all members : The AICPA code of professional conduct begins with the preface which applies to all members, and the code is presented in 3 parts: This part is applied to the members who practice the profession in the public area

Reviews

Write a Review

Financial Management Questions & Answers

  Select the highly marketable investment

Select the highly marketable investment

  What is the net asset value of the fund

The composition of the Fingroup Fund portfolio is as follows: Stock Shares Price A 370,000 $35 B 470,000 40 C 570,000 10 D 770,000 15 The fund has not borrowed any funds, but its accrued management fee with the portfolio manager currently totals $30,..

  What circumstances will the holder of option make profit

Suppose that a march call option to buy a share for $50 costs $2.50 and is held until march. Under what circumstances will the holder of the option make a profit? Under what circumstances will the option be exercised?

  Introduce new portable camper to fill out its product line

Winnebagel Corp. currently sells 23,000 motor homes per year at $61,000 each, and 8,500 luxury motor coaches per year at $98,000 each. The company wants to introduce a new portable camper to fill out its product line; it hopes to sell 18,000 of these..

  The liquidity premium on the corporate bond

A Treasury bond that matures in 8 years has a yield of 3.24%. A 8-year corporate bond has a yield of 7.8%. Assume that the liquidity premium on the corporate bond is 0.36%. What is the default risk premium on the corporate bond?

  Operating assets is considering the purchase of a machine

(Ignore income taxes in this problem.) A company with $675,000 in operating assets is considering the purchase of a machine that costs $77,000 and which is expected to reduce operating costs by $23,000 each year. These reductions in cost occur evenly..

  New sausage system with an installed cost

Kolby’s Korndogs is looking at a new sausage system with an installed cost of $538,000. This cost will be depreciated straight-line to zero over the project’s four-year life, at the end of which the sausage system can be scrapped for $114,000. If the..

  Outstanding bonds-what is the bonds price

Nungesser Corporation's outstanding bonds have a $1,000 par value, a 6% semi-annual coupon, 18 years to maturity, and an 7.5% YTM. What is the bond's price? Round your answer to the nearest cent.

  Bond as long as the yield to maturity

Heymann Company bonds have 6 years left to maturity. Interest is paid annually, and the bonds have a $1,000 par value and a coupon rate of 8%. What is the yield to maturity at a current market price of. You would buy the bond as long as the yield to ..

  Proposed new investment has projected sales

A proposed new investment has projected sales of $828,000. Variable costs are 54 percent of sales, and fixed costs are $187,180; depreciation is $92,500. Assume a tax rate of 35 percent. Required: What is the projected net income?

  Interest is compounded continuously

How long will it take for $1400 to grow to $39,800 at an interest rate of 10.2% if the interest is compounded continuously? Round the number of years to the nearest hundredth.

  Discuss any benefits for a company to cross list equity

Discuss any benefits you can think of for a company to Cross-list its equity shares on more than one national exchange, and To source new equity capital from foreign investors as well as domestic investors.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd