For each requirement, change the values of the given information as shown and keep all other original data the same. Then enter your updated final answers for each scenario. Scenario A: Future value to be received $ 10,000 Future date received 3 years Discount Rate 6% 10% 16% Scenario B: Annual Cash Receipt $ 5,000 Number of Years 6 years Discount Rate 6% 10% 16% Scenario C: Discount Rate 8% Investment Project Cash Flow Initial Investment $ (6,500) Year 1 $ 700 Year 2 $ 800 Year 3 $ 1,400 Year 4 $ 3,600 Year 5 $ 6,800 Required: a. A company is expecting to receive a lump sum of money at a future date from now. Using the PV formula in Excel, what is the Present Value of that money at three different rates? (Round your answers to 2 decimal places.)
For each requirement, change the values of the given information as shown and keep all other original data the same. Then enter your updated final answers for each scenario. Scenario A: Future value to be received $ 10,000 Future date received 3 years Discount Rate 6% 10% 16% Scenario B: Annual Cash Receipt $ 5,000 Number of Years 6 years Discount Rate 6% 10% 16% Scenario C: Discount Rate 8% Investment Project Cash Flow Initial Investment $ (6,500) Year 1 $ 700 Year 2 $ 800 Year 3 $ 1,400 Year 4 $ 3,600 Year 5 $ 6,800 Required: a. A company is expecting to receive a lump sum of money at a future date from now. Using the PV formula in Excel, what is the Present Value of that money at three different rates? (Round your answers to 2 decimal places.)
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
For each requirement, change the values of the given information as shown and keep all other original data the same. Then enter your updated final answers for each scenario.
Scenario A:
Future value to be received | $ | 10,000 | |
Future date received | 3 | years | |
Discount Rate |
6% |
10% |
16% |
Scenario B:
Annual Cash Receipt | $ | 5,000 | |
Number of Years | 6 | years | |
Discount Rate |
6% |
10% |
16% |
Scenario C:
Discount Rate 8%
Investment Project | |||
Initial Investment | $ | (6,500) | |
Year 1 | $ | 700 | |
Year 2 | $ | 800 | |
Year 3 | $ | 1,400 | |
Year 4 | $ | 3,600 | |
Year 5 | $ | 6,800 | |
Required:
a. A company is expecting to receive a lump sum of money at a future date from now. Using the PV formula in Excel, what is the Present Value of that money at three different rates? (Round your answers to 2 decimal places.)
![Required:
a. A company is expecting to receive a lump sum of money at a future date from now. Using the PV formula in Excel, what is the
Present Value of that money at three different rates? (Round your answers to 2 decimal places.)
Discount Rate
6%
10%
16%
b. A company is expecting to receive a stream of year-end annual cash payments over multiple years. Using the PV formula in Excel,
what is the Present Value of that money at three different didcount rates? (Round your answers to 2 decimal places.)
Discount Rate
Present Value
6%
10%
16%
Present Value](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbce6a0cf-373b-4a7a-ae65-e94348138195%2F3a38fb3e-9fa7-450a-8b29-8a359eeaefae%2F8ft1dtl_processed.png&w=3840&q=75)
Transcribed Image Text:Required:
a. A company is expecting to receive a lump sum of money at a future date from now. Using the PV formula in Excel, what is the
Present Value of that money at three different rates? (Round your answers to 2 decimal places.)
Discount Rate
6%
10%
16%
b. A company is expecting to receive a stream of year-end annual cash payments over multiple years. Using the PV formula in Excel,
what is the Present Value of that money at three different didcount rates? (Round your answers to 2 decimal places.)
Discount Rate
Present Value
6%
10%
16%
Present Value
![c. A company is planning to invest in a project over a 5-year period, but wants to know its financial implications. It expects the cash in-
flow return on the investment to steadily increase over the 5 years. Using the information given, help to determine the Total Net Cash
Flows, the Net Present Value, and the estimated Payback Period. Note: Estimate the payback period to the nearest year. (Round your
Net Cash Flow values to the nearest whole dollar and your final Net Present Value answer to 2 decimal places.)
Investment Project
Initial Investment
Year 1
Year 2
Year 3
Year 4
Year 5
NPV of investment
Estimated Payback Period
Total Net Cash Flow](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbce6a0cf-373b-4a7a-ae65-e94348138195%2F3a38fb3e-9fa7-450a-8b29-8a359eeaefae%2F5sge44f_processed.png&w=3840&q=75)
Transcribed Image Text:c. A company is planning to invest in a project over a 5-year period, but wants to know its financial implications. It expects the cash in-
flow return on the investment to steadily increase over the 5 years. Using the information given, help to determine the Total Net Cash
Flows, the Net Present Value, and the estimated Payback Period. Note: Estimate the payback period to the nearest year. (Round your
Net Cash Flow values to the nearest whole dollar and your final Net Present Value answer to 2 decimal places.)
Investment Project
Initial Investment
Year 1
Year 2
Year 3
Year 4
Year 5
NPV of investment
Estimated Payback Period
Total Net Cash Flow
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 8 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education