Question: 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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!