What is the NPV for Real Time Inc.?
Not what you're looking for?
Please provide detailed answer in MS Excel file and text file
Given the information in the attachment, what is the NPV?
The president of Real Time Inc. has asked you to evaluate the proposed acquisition of a new computer. The computer's price is $40,000, and it falls into the MACRS 3-year class. Purchase of the computer would require an increase in net operating working capital of $2,000. The computer would increase the firm's before-tax revenues by $20,000 per year but would also increase operating costs by $5,000 per year. The computer is expected to be used for 3 years and then be sold for $25,000. The firm's marginal tax rate is 40 percent, and the project's cost of capital is 14 percent.
Purchase this Solution
Solution Summary
This solution is comprised of a detailed explanation to find NPV for Real Time Inc. in both Word and Excel files.
Solution Preview
1. What is the net investment required at t = 0?
Cost 40,000
Change in NWC 2,000
Total 42,000
2. What is the operating cash flow in Year 2?
Year Percent Basis Depreciation
1 0.33 $40,000.00 $ 13,200.00
2 0.45 $40,000.00 $ 18,000.00
3 0.15 $40,000.00 $ 6,000.00
4 0.07 $40,000.00 $ 2,800.00
$ 40,000.00
Operating Cash Flows
Year 1 Year 2 Year 3
1 Increase in Revenues $20,000.00 $ 20,000.00 $20,000.00
2 Increase in Costs $ (5,000.00) $ (5,000.00) $ (5,000.00)
3 Before-tax change in earnings $15,000.00 $ 15,000.00 $15,000.00
4 After-tax change in earnings (line 3 X .60) $ 9,000.00 $ 9,000.00 $ 9,000.00
5 Depreciation $13,200.00 $ 18,000.00 $ ...
Purchase this Solution
Free BrainMass Quizzes
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.