Home / Questions / The Excel worksheet form that appears below is to be used to recreate Example C and Exhibi...
The Excel worksheet form that appears below is to be used to recreate Example C and Exhibit 13–4 on pages 586–587. Download the workbook containing this form from the Online Learning Center at www.mhhe.com/garrison14e. On the website you will also receive instructions about how to use this worksheet form.
You should proceed to the requirements below only after completing your worksheet.
Required:
1. Check your worksheet by changing the discount rate to 10%. The net present value should now be between $56,518 and $56,535—depending on the precision of the calculations. If you do not get an answer in this range, find the errors in your worksheet and correct them.
Explain why the net present value has fallen as a result of reducing the discount rate from 14% to 10%.
2. The company is considering another project involving the purchase of new equipment. Change the data area of your worksheet to match the following:
a. What is the net present value of the project?
b. Experiment with changing the discount rate in one percent increments (e.g., 13%, 12%, 15%, etc.). At what interest rate does the net present value turn from negative to positive?
c. The internal rate of return is between what two whole discount rates (e.g., between 10% and 11%, between 11% and 12%, between 12% and 13%, between 13% and 14%, etc.)?
d. Reset the discount rate to 14%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive net present value?
Jun 27 2020 View more View Less
Construct the shear force and bending moment diagrams for the beam shown by the area method. Neglect the weight of the beam.
Jun 30 2020Present a written analysis of the evidence offered in the journal article to support the view that organisational learning contributes positively both to innovation and c...
May 12 2020Subhash Pvt. Ltd., an Indian company, has a fully owned subsidiary in the USA. The profits earned by the subsidiary in the USA is recorded in [A]GDP of India and GNP of ...
Jan 09 2018Jane MacFarlane wants a weekly schedule for two business services, X and Y. Each ‘unit ’ of X delivered to customers needs one service package, while each unit of Y us...
Aug 01 2020Group Oral PresentationAssignmentThe Oral Presentation builds on the information synthesised both in the Critical Summaries and the Report Essay. Students organise inform...
May 16 2020XYZ stock is currently selling for per share The company just paid its first annual dividend of a share The firm plans to increase the dividend by percent per year ind...
Feb 13 2020A steel rod 'L' m long is at a temperature of 'T1'°C, the rod is heated to a temperature 'T2'°C. Let us assume, a temperature rise is denoted by 'T'°C. Derive an expressi...
May 13 2020Solve x tanx -1 by regular false method when a = 2,5 and b=3 >
Aug 04 2020Formal planning in an organization involves formal documentation, with properly laid-down guidelines to be followed. Which of the following statements is not a correct cr...
Dec 05 2017Examine ethics in general and ethics in the specifically.2. Include two “case studies”: One situation where the problem was resolved using positive ethical principles an...
Feb 04 2020