Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A B C D 1 Now 1 2 EM 3 F4 2 Purchase of equipment $ (275,000) 3 Working capital investment $ (100,000) 4

image text in transcribed

A B C D 1 Now 1 2 EM 3 F4 2 Purchase of equipment $ (275,000) 3 Working capital investment $ (100,000) 4 Annual net cash receipts 5 Preventive maintenance 6 Working capital released 7 Salvage value of equipment 8 Total cash flows (a) $ 120,000 $ 120,000 $ $ 120,000 $ 120,000 (40,000) $ 100,000 $ 65,000 $ (375,000) $ 120,000 $ 9 Discount factor (20%) (b) 1.00000 10 Present value (a) x (b) $ 11 Net present value $ (375,000) $ (7,928) 0.83333 100,000 $ 120,000 $ 0.69444 83,333 $ 80,000 $ 0.57870 285,000 0,48225 46,296 $ 137,442 12 Jefferson Company The group of employees that submitted this request is disappointed that you provided a "reject" recommendation for its proposal. The group does not understand why working capital is treated as a $100,000 cash outflow now and a $100,000 cash inflow at the end of the project. To explain your accounting for working capital in the NPV analysis shown above, you decide to proceed in two steps. First, you will explain how to calculate the annual opportunity costs that arise from tying up $100,000 of working capital for four years. Second, you will create a data visualization that summarizes these calculations. Assume the company's discount rate of 20% (as shown in cell A9 of the above Excel screen capture) represents its opportunity cost of capital. In other words, it represents the annual return that the company could earn if it invested $100,000 in an alternative capital budgeting proposal, rather than committing it to this project working capital needs. Required: 1. Without considering the time value of money, how much return could Jefferson earn each of the next four years by investing $100,000 elsewhere in the company? 2. Considering the time value of money (and using the discount factors for years 1-4 as shown in the above Excel screen capture), what is the present value of the annual opportunity costs from requirement 1?

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

Basic Finance An Introduction to Financial Institutions Investments and Management

Authors: Herbert B. Mayo

10th edition

1111820635, 978-1111820633

More Books

Students also viewed these Finance questions