Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. time value of money: basics using excel or the e

Time Value of Money: Basics Using Excel or the equations and tables in...

90.2K

Verified Solution

Question

Accounting

Time Value of Money: Basics
Using Excel or the equations and tables in Appendix 12A of this chapter, determine the answers to each of the following independent situations.
Round answers to the nearest whole number.
(a) The future value in two years of $2,000 deposited today in a savings account with interest compounded annually at 6 percent.
$Answer
(b) The present value of $8,000 to be received in four years, discounted at 12 percent.
$Answer
(c) The present value of an annuity of $2,000 per year for five years discounted at 14 percent.
$Answer
(d) An initial investment of $32,010 is to be returned in eight equal annual payments. Determine the amount of each payment if the interest rate is 12 percent.
$Answer
(e) A proposed investment will provide cash flows of $20,000, $8,000, and $6,000 at the end of Years 1,2, and 3, respectively. Using a discount rate of 20 percent, determine the present value of these cash flows.
Year 1
Year 2
Year 3
(f) Find the present value of an investment that will pay $5,000 at the end of Years 10,11, and 12. Use a discount rate of 14 percent.
$Answer

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Suppose you are single and work for a company that pays you $24/hour for all regular...

Accounting
Q

Anderson et al. (1990) studied the effect of diet on the level of low-density lipoprotein (LDL,...

Basic Math
Q

Two rods of equal length and area of cross section are kept parallel and lagged...

Physics
Q

The closed cylinder shown in figure has a freely moving piston separating chambers 1 and...

Physics
Q

Find the reference number for each value of t a t b c d t...

Basic Math
Q

Approximate the number using a calculator.1.9e1.9(Round to three decimal places.)

Basic Math
Q

At the city museum, child admission is $6.20 and adult admission is $9.80. On Friday,...

Basic Math
Q

A1A is a proprietorship that has a calendar fiscal year. The proprietorship begins operations on...

Accounting
Q

Identifying the appropriate net asset classification For each of the following transactions, identify the net...

Accounting
Q

Compare the guidelines for preparing flowcharts, BPDs, and DFDs. What general design principles and limitations...

Accounting
Q

solve for the yellow square as well as part 4 Q: what critisicism can be...

Accounting
Q

What are sources of cash to an investor from owning stock? Group of answer choices...

Finance