Answered step by step
Verified Expert Solution
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
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 2Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started