Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE provide formulas!! thanks M15 B A 1 Chapter 14: Applying Excel D E Years 3 1 2 4 5 8 Data Example E 5

image text in transcribed

PLEASE provide formulas!! thanks

M15 B A 1 Chapter 14: Applying Excel D E Years 3 1 2 4 5 8 Data Example E 5 Cost of equipment needed $60.000 5 Working capital needed $100 000 7 Overhaul of equipment in four years $5,000 3 Salvage value of the equipment in five years $10 000 9 Annual revenues and costs 0 Sales revenues $200 000 1 Cost of goods sold $125,000 2 Out of pocket operating costs $35,000 3 Discount rate 149 4 15 Enfer a formula into each of the cells marked with a ? below 6 Exhibit 14-8 17 Now 19 Purchase of equipment 2 20 Investment in working capital 2 1 Sales 2 Cost of goods sold 3 Out-of-pocket operating costs 24 Overhaul of equipment S Salvage value of the equipment 26 Working capital released 27 Total cash flows (a) 2 18 Discount factor (14%) (b) 2 29 Present value of cash flows (@)) 2 2 30 Net present value 31 32 Use the formulas from Appendix 13B Chapter 14 Form Lady Scroll Lock 2 7 2 2 2 ? ? 2 2 2 2 2 ? 2 2 2 ? 2 ? 2 ? ? 2 9 2 ? ? 2 2 2 2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions