Calculate the present value of these ordinary annuities

Assignment Help Accounting Basics
Reference no: EM131759367

Have no idea what I am doing wrong but I can't get the calculations correct.

Compute and show your work for the following scenarios:

Calculate the present value of the following lump sums:
$100,000 to be received five years from now with a 5% annual interest rate
$200,000 to be received 10 years from now with a 10% annual interest rate

Calculate the future value of the following lump sums:
$100,000 if invested for five years at a 5% annual interest rate
$200,000 if invested for 10 years at a 10% annual interest rate

Calculate the present value of these ordinary annuities:
$100,000 to be received each year for five years with a 5% annual interest rate
$200,000 to be received each year for 10 years with a 10% annual interest rate

Calculate the future value of these ordinary annuities:
$100,000 if invested each year for five years at a 5% annual interest rate
$200,000 if invested each year for 10 years at a 10% annual interest rate

Calculate the present value of these perpetuities:
$100,000 to be received each year forever with a 5% annual interest rate
$200,000 to be received each year forever with a 10% annual interest rate

Computations (use Excel).

Show the computations as required above.

Summarize the results in an easy to read table at the top of the spreadsheet or on a clearly labeled separate tab.

Reference no: EM131759367

Questions Cloud

Supervised learning and unsupervised learning : What kinds of problems would you say can be efficiently resolved by both supervised learning and unsupervised learning? Justify your answer.
Write a research paper about the business intelligence : Integrate what you have learned from the course resources (.e.g. Textbook Readings, Discussion Board Posts, Chapter Presentations) into your document.
Explain diets key points in terms of nutrition : Explain diet's key points in terms of nutrition (focus on protein, carbohydrates, etc.). Also discuss the diet plan and the diet's strengths and weaknesses.
What is artificial intelligence : 1. What is Artificial intelligence (AI)? What is the primary goal of AI? How AI is related to Expert Systems?
Calculate the present value of these ordinary annuities : Calculate the present value of these ordinary annuities, Calculate the future value of these ordinary annuities
Research about your companys it architecture : A mid to large company ADP ( Automatic Data Processing ). Research the following about your company.Determine its mission, vision, and goals.
How much should be the debit to equipment : Freebee Corporation's common stock is actively traded on a national exchange. It issues 2,000 shares of its $3 par value stock for equipment.
What you would do to eradicate the problem : In this section you will state, based on your findings, what you would do to eradicate the problem. Be sure to include all sources of information.
Executive briefing memo for technical leadership : Prepare a 2- or 3 pg executive briefing memo for technical leadership.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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