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

  What should they expect to receive for in secondary market

Bond Valuation-In 2013, Carnival Cruise Lines decided to sell some new bonds (something about fixing a big ship). They sold the bonds for $1,000 (face value) with a 20 year maturity and an 8% coupon. Two years have passed. Interest rates on similar b..

  Use present value of annuity table

How much money does Melinda need to deposit into her investment account today if she wishes to withdraw $8,000 a year for twenty years? She expects to earn an average rate of return of 11 percent. (Choose the closest answer, use present value of annu..

  Income statement showed an interest expense

Evans Co. showed long-term debt of $1.7M in 2005, and the December 31, 2006 balance sheet showed long-term debt of $1.9M. The 2006 income statement showed an interest expense of $650,000. What is the firm's cash flow to creditors in 2006?

  Dequate compensation for this investment

You are considering the purchase of Crown Bakery, Inc. common stock that just paid a dividend od $19.59 per share. You expect the dividend to grow at a rate of 1.04 percent per year, indefinitely. You estimate the rate of return od 12.18%, will be ad..

  Relationship b/w the coefficient of variation and debt ratio

Graph the relationship between the coefficient of variation and the debt ratio. Label the areas associated with business risk and financial risk.

  Firm has no internal equity available for investment at time

Valley Flights, Inc. has a capital structure made up of 40% debt and 60% equity and a tax rate of 30%. A new issue of $1,000 par bonds maturing in 20 years can be issued with a coupon of 9% at a price of $1,098.18 with no flotation costs. Flotation c..

  Assets and costs are proportional to sales

Assets and costs are proportional to sales. The company maintains a constant 40 percent dividend payout ratio and a constant debt-equity ratio. What is the maximum increase in sales that can be sustained assuming no new equity is issued? (Do not roun..

  Calculate the federal income tax

Fighting Dyer inc. had taxable income of 19.6 million. Calculate the federal income tax by using the corporate tax rate structure 15% $0-;$50,000 25% $50,001-$75,000 34% $75,001-;$10,000,000 35% over $10,000,000 Total tax due is?

  What is the implicit interest in dollars

A zero coupon bond with a face value of $1,000 is issued with an initial price of $507.96. The bond matures in 18 years. What is the implicit interest, in dollars, for the first year of the bond's life? Use semiannual compounding.

  What is the intrinsic price of microsoft today

Assuming Microsoft dividend grows by 3% every year for 10 years and the discount rate is 6%. What is the intrinsic price of Microsoft today and is it more or less than the market price?

  Savings account to fund her education at that time

Your cousin is currently 12 years old. She will be going to college in 6 years. Your aunt and uncle would like to have $100,000 in a savings account to fund her education at that time. If the account promises to pay a fixed interest rate of 4% per ye..

  What would the annual yield to maturity be on bond

A few years ago, Spider Web, Inc. issued bonds with a 12.03 percent annual coupon rate, paid semiannually. The bonds have a par value of $1,000, a current price of $1,079, and will mature in 20 years. What would the annual yield to maturity be on the..

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