The Excel worksheet form that appears below is to be used to recreate Example C and Exhibit 13–4...

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?

Related Questions in Managerial Accounting Basics

is necessary for her division to get the oven manufacturer contract and thereby keep its core of highly trained people. The company uses return on investment (ROI) to measure divisional performance. Required: 1 . Assume that you are the manager of the Electronics Division. Would you recommend

as operations would appear after the proposed changes. Show both total and per unit data on your statements. 4. Refer to the data in (3) above. How many lanterns would have to be sold at the new selling price to yield a minimum net operating income of $72,000 per month?

from these short projects tend to be below average. Data concerning activity in the local commercials market appear below : The total sales for local commercials amounted to $240,000. Required: 1 . Determine the cost of serving the local commercials

Answer Preview :

to the standards, what direct labor cost should have been incurred to prepare 6,000 meals? How much does this differ from the actual direct labor cost? 2 . Break down the difference computed in ( 1 ) above into a labor rate variance and a labor effi- ciency variance.

Answer one paragraph only for each question and all the answers in one word file and make sure no plagiarism1- Are than any other reasons other than cost as to why an organization would choose to outsource cost? 2-Do you think that outsourcing is ne
Posted
3 days ago

Some companies have created controversy over the decision to outsource major activities to companies based in other countries. The decision to outsource should begin with an analysis of the relevant costs.What is your opinion of outsourcing?Should o
Posted
5 days ago

Harrison Company makes two products and uses a conventional costing system in which a single plantwide, predetermined overhead rate is computed based on direct labour-hours. These products are customized to some degree for specific customers. Data f
Posted
6 days ago

Harrison Company makes two products and uses a conventional costing system in which a single plantwide, predetermined overhead rate is computed based on direct labour-hours. These products are customized to some degree for specific customers. Data f
Posted
6 days ago

Financial Statement Analysis ProjectThe financial statement analysis project is due Thursday, November 15th by midnight via Canvas email. It will not be accepted late for any reason but you can submit it early.Project InstructionsStudents should rea
Posted
6 days ago

Some companies have created controversy over the decision to outsource major activities to companies based in other countries. The decision to outsource should begin with an analysis of the relevant costs. · oWhat is your opinion of outsourcing? oSh
Posted
8 days ago

An unfavorable variable overhead spending variance may be caused bya. the payment of lower prices for variable overhead items used. b. the use of excessive quantities of the variable overhead allocation base. c. the use of excessive quantities of va
Posted
9 days ago

Morton Ltd had on issue $5,000,000 10% unsecurednotes at 30 June 2011. Following agood year, the company had surplus cash at its disposal. On 31 March 2012 it took the opportunity tore-purchase $3,000,000 of its unsecured notes at a price of $103 fo
Posted
13 days ago

Financial Statement Analysis ProjectThe financial statement analysis project is due Thursday, November 15th by midnight via Canvas email. It will not be accepted late for any reason but you can submit it early.Project InstructionsStudents should rea
Posted
15 days ago