DOS Corporation is considering two possible investments and needs your help in determining which will be...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
DOS Corporation is considering two possible investments and needs your help in determining which will be the better financial option. Perform the necessary calculations using Microsoft Excel so that maximum precision can be obtained. (Unless indicated otherwise, enter your answers rounded to the nearest whole dollar/input code: 0). Investment Option "North" This potential investment is a little more risky and longer term, so it has a minimum rate of return of 13.90%. This investment would require an initial outlay of cash to purchase a piece of equipment for $145,500, and at the end of the 8-year life of this investment is expected to have a salvage value of $43,650. For each year of this investment, net annual cash inflows are expected to be $27,500. 1. How much is the present value of the purchase of equipment? 2. How much is the present value of the salvage value? 3. How much is the present value of the annual cash inflows? 4. How much is the Net Present Value? 5. What is the value of the Present Value Index? (round to the nearest thousandths place/input code: 0.000) Investment Option "South" Investment Option "South" This potential investment is less risky and shorter term, so it has a minimum rate of return of 6.60%. This investment would require an initial outlay of cash of $140,500, and at the end of the 4- year life of this investment DOS Corporation is expected to have to pay a wind-down cost of $21,075. For the first 3 years of this investment, net annual cash inflows are expected to be $30,250 and for the last year of the investment, the net annual cash inflow is expected to be $75,625. 6. How much is the present value of the purchase of equipment? 7. How much is the present value of the wind-down cost? 8. How much is the present value of the annual cash inflows for the first 3 years? 9. How much is the present value of the annual cash inflow for the final year of this investment? 10. How much is the Net Present Value? 11. What is the Internal Rate: of Return? (round to the nearest hundredths place/input code: 0.00) % DOS Corporation is considering two possible investments and needs your help in determining which will be the better financial option. Perform the necessary calculations using Microsoft Excel so that maximum precision can be obtained. (Unless indicated otherwise, enter your answers rounded to the nearest whole dollar/input code: 0). Investment Option "North" This potential investment is a little more risky and longer term, so it has a minimum rate of return of 13.90%. This investment would require an initial outlay of cash to purchase a piece of equipment for $145,500, and at the end of the 8-year life of this investment is expected to have a salvage value of $43,650. For each year of this investment, net annual cash inflows are expected to be $27,500. 1. How much is the present value of the purchase of equipment? 2. How much is the present value of the salvage value? 3. How much is the present value of the annual cash inflows? 4. How much is the Net Present Value? 5. What is the value of the Present Value Index? (round to the nearest thousandths place/input code: 0.000) Investment Option "South" Investment Option "South" This potential investment is less risky and shorter term, so it has a minimum rate of return of 6.60%. This investment would require an initial outlay of cash of $140,500, and at the end of the 4- year life of this investment DOS Corporation is expected to have to pay a wind-down cost of $21,075. For the first 3 years of this investment, net annual cash inflows are expected to be $30,250 and for the last year of the investment, the net annual cash inflow is expected to be $75,625. 6. How much is the present value of the purchase of equipment? 7. How much is the present value of the wind-down cost? 8. How much is the present value of the annual cash inflows for the first 3 years? 9. How much is the present value of the annual cash inflow for the final year of this investment? 10. How much is the Net Present Value? 11. What is the Internal Rate: of Return? (round to the nearest hundredths place/input code: 0.00) %
Expert Answer:
Answer rating: 100% (QA)
NPV is a technique of capital budgeting It is excess of present value of annual cash flow over the present value of cash outflow A positive NPV is alw... View the full answer
Posted Date:
Students also viewed these accounting questions
-
calculate the slope of this embankment 2m 3 m 7 m 3 m
-
3 x 3 grid solve example 1, choosing h = 3 and starting values 100, 100,.
-
The point masses m and 2m lie along the x-axis, with m at the origin and 2m at x = L. A third point mass M is moved along the x-axis. (a) At what point is the net gravitational force on M due to the...
-
Your client, Mr. Brakes Inc., owns and operates an auto-motive repair shop in Cooperstown, New York. Mr. Brakes specializes in replacing and repairing brakes on cars, sport utility vehicles, and...
-
Give an example of a characteristic that could be measured as either a discrete or a continuous variable, depending on the types of units used. Exercises 40 to 44 refer to News Story 2, Research...
-
The drawing shows a force vector that has a magnitude of 475 newtons. Find the (a) x, (b) y, and (c) z components of the vector. Section 1.8: Addition of Vectors by Means of Components 54.0 33.0
-
An engineer prepares a report to evaluate a project using PW and IRR. Just before submitting the report, he spills coffee on it, making the first digit of the 2-digit IRR unreadable. The second digit...
-
Wescott Company has three divisions: A, B, and C. The company has a hurdle rate of 8 percent. Selected operating data for the three divisions are as follows: Wescott is considering an expansion...
-
Suppose a company pays its regular wage for employees working up to 40 hours a week, and overtime pay 50% greater(time and a half) for hours worked over 40 hours. Assuming employe es have full...
-
Consider the unadjusted trial balance of Burrows Landscaping at December 31, 2017, and the related month-end adjustment data: The following adjustments need to be made before the financial statements...
-
Supply chains of the Roman Empire had much in common with modern supply chains. Supply chains then and now require development of good mental models to understand them and keep them working well....
-
In the 1960s, Chicano/a activists embraced a nonwhite identity-often calling themselves Indians or mestizos, and denounced Anglo America culture's emphasis on imperialism, militarism, commercialism,...
-
You have a project that is scheduled to be completed in 10 days at a budgeted cost of $100,000. At the end of day 6 you do an analysis and you determine the job is 70% complete and you have spent...
-
The Optical Scam Company has forecast a sales growth rate of 20 percent for next year. Current assets, fixed assets, and short-term debt are proportional to sales. The current financial statements...
-
Accountants spend a considerable amount of time on the ETL process. Some estimate that almost 80% of the total time spent analyzing data is dedicated to the ETL process. The goal of ETL is to extract...
-
Read the following profiles and identify the person responsible for updating the team with legislative changes and industry codes of conduct. Name: Karen Jones Qualifications: Advanced Diploma of...
-
According to the Turkish farmer, all of the following are great worldly evils EXCEPT A. Cruelty B. Boredom C. Poverty D. Vice
-
Suppose that a company has 10.000 outstanding shares in the beginning of the year. On April 1st, the company increases its shares by 6.000. On July 1st, the company increases its shares again, but...
-
A furniture mover is lifting a small safe by pulling on a rope threaded through the pulley system shown in Figure P2.81. (a) What is the ratio of the vertical distance the safe moves to the length of...
-
Two steamrollers begin \(100 \mathrm{~m}\) apart and head toward each other, each at a constant speed of \(1.00 \mathrm{~m} / \mathrm{s}\). At the same instant, a fly that travels at a constant speed...
-
The position of a yo-yo as a function of time is given by \(x(t)=A \cos (p t+q)\), where \(A=0.60 \mathrm{~m}, p=\frac{1}{2} \pi \mathrm{s}^{-1}\), and \(q=\frac{1}{2} \pi\). (a) Plot this function...
Study smarter with the SolutionInn App