Chapter 7: Applying Excel Data Example E Cost of equipment needed Working capital needed Overhaul of equipment in four years Salvage value of the equipment in five years Annual revenues and costs: Sales revenues Cost of goods sold Out-of-pocket operating costs Discount rate Purchase of equipment Investment in working capital Sales Cost of goods sold Out-of-pocket operating costs Overhaul of equipment Salvage value of the equipment Working capital released Total cash flows (a) $120,000 $80,000 $40,000 $20,000 Enter a formula into each of the cells marked with a ? below Exhibit 7-8 Discount factor (14%) (b) Present value of cash flows (a) x (b) Net present value $255,000 $160,000 $50,000 14% Now *Use the formulas from Appendix 7B: Present value of $1 = 1/(1+r)^n Present value of an annuity of $1 = (1/r)*(1-(1/(1+r)^n)) where n is the number of years and r is the discount rate ? ? ? ? ? ? ? ? ? ? ? ? 2 ? ? ? ? ? ? Years 3 ? ? ? ? ? ? 4 ? ? ? ? ? ? ? 5 ? ? ? ? ? ? ? ?
Chapter 7: Applying Excel Data Example E Cost of equipment needed Working capital needed Overhaul of equipment in four years Salvage value of the equipment in five years Annual revenues and costs: Sales revenues Cost of goods sold Out-of-pocket operating costs Discount rate Purchase of equipment Investment in working capital Sales Cost of goods sold Out-of-pocket operating costs Overhaul of equipment Salvage value of the equipment Working capital released Total cash flows (a) $120,000 $80,000 $40,000 $20,000 Enter a formula into each of the cells marked with a ? below Exhibit 7-8 Discount factor (14%) (b) Present value of cash flows (a) x (b) Net present value $255,000 $160,000 $50,000 14% Now *Use the formulas from Appendix 7B: Present value of $1 = 1/(1+r)^n Present value of an annuity of $1 = (1/r)*(1-(1/(1+r)^n)) where n is the number of years and r is the discount rate ? ? ? ? ? ? ? ? ? ? ? ? 2 ? ? ? ? ? ? Years 3 ? ? ? ? ? ? 4 ? ? ? ? ? ? ? 5 ? ? ? ? ? ? ? ?
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Help filling in where “?” Are present
![Requirement 1
Chapter 7: Applying Excel
Requirement 2a
Data
Example E
Cost of equipment needed
Working capital needed
Overhaul of equipment in four years
Salvage value of the equipment in five years
Annual revenues and costs:
Sales revenues
Cost of goods sold
Out-of-pocket operating costs
Discount rate
Purchase of equipment
Investment in working capital
Sales
Cost of goods sold
Out-of-pocket operating costs
Overhaul of equipment
Salvage value of the equipment
Working capital released
Total cash flows (a)
Discount factor (14%) (b)
Present value of cash flows (a) x (b)
Net present value
$120,000
$80,000
$40,000
$20,000
$255,000
$160,000
$50,000
14%
Enter a formula into each of the cells marked with a ? below
Exhibit 7-8
Now
*Use the formulas from Appendix 7B:
Present value of $1 = 1/(1+r)^n
Present value of an annuity of $1 = (1/r)*(1-(1/(1+r)^n))
where n is the number of years and r is the discount rate
?
?
?
?
?
?
1
Requirement 2 b
?
?
?
?
?
?
2
?
?
?
?
?
?
Years
3
?
?
?
?
?
?
Requirement 2 c
4
?
?
?
?
?
?
?
5
?
?
?
?
?
?
?
?
F](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F495ef8f1-2cba-4999-b711-541c5a5b4322%2F3d01f17d-c1fd-4c61-9cff-021b06a62886%2Fdlpbl7_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Requirement 1
Chapter 7: Applying Excel
Requirement 2a
Data
Example E
Cost of equipment needed
Working capital needed
Overhaul of equipment in four years
Salvage value of the equipment in five years
Annual revenues and costs:
Sales revenues
Cost of goods sold
Out-of-pocket operating costs
Discount rate
Purchase of equipment
Investment in working capital
Sales
Cost of goods sold
Out-of-pocket operating costs
Overhaul of equipment
Salvage value of the equipment
Working capital released
Total cash flows (a)
Discount factor (14%) (b)
Present value of cash flows (a) x (b)
Net present value
$120,000
$80,000
$40,000
$20,000
$255,000
$160,000
$50,000
14%
Enter a formula into each of the cells marked with a ? below
Exhibit 7-8
Now
*Use the formulas from Appendix 7B:
Present value of $1 = 1/(1+r)^n
Present value of an annuity of $1 = (1/r)*(1-(1/(1+r)^n))
where n is the number of years and r is the discount rate
?
?
?
?
?
?
1
Requirement 2 b
?
?
?
?
?
?
2
?
?
?
?
?
?
Years
3
?
?
?
?
?
?
Requirement 2 c
4
?
?
?
?
?
?
?
5
?
?
?
?
?
?
?
?
F
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 3 steps with 2 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