Problem 13-28 Net Present Value Analysis [LO13-2]

Bilboa Freightlines, S.A., of Panama, has a small truck that it uses for intracity deliveries. The truck is worn out and must be either overhauled or replaced with a new truck. The company has assembled the following information:

If the company keeps and overhauls its present delivery truck, then the truck will be usable for five more years. If a new truck is purchased, it will be used for five years, after which it will be traded in on another truck. The new truck would be diesel-operated, resulting in a substantial reduction in annual operating costs, as shown above.

The company computes depreciation on a straight-line basis. All investment projects are evaluated using a 6% discount rate.

Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine the appropriate discount factor(s) using tables.

Required:

1. What is the net present value of the “keep the old truck” alternative?

2. What is the net present value of the “purchase the new truck” alternative?

3. Should Bilboa Freightlines keep the old truck or purchase the new one?

Bilboa Freightlines, S.A., of Panama, has a small truck that it uses for intracity deliveries. The truck is worn out and must be either overhauled or replaced with a new truck. The company has assembled the following information: Present Truck New Truck Purchase cost new $ 23,000 $ 28,000 Remaining book value $ 10,000 - Overhaul needed now $ 9,000 - Annual cash operating costs $ 11,500 $ 8,000 Salvage value-now $ 5,000 - Salvage value-five years from now $ 4,000 $ 4,000 If the company keeps and overhauls its present delivery truck, then the truck will be usable for five more years. If a new truck is purchased, it will be used for five years, after which it will be traded in on another truck. The new truck would be diesel-operated, resulting in a substantial reduction in annual operating costs, as shown above. The company computes depreciation on a straight-line basis. All investment projects are evaluated using a 9% discount rate. Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine the appropriate discount factor(s) using tables. Required: 1. What is the net present value of the “keep the old truck” alternative? 2. What is the net present value of the “purchase the new truck” alternative? 3. Should Bilboa Freightlines keep the old truck or purchase the new one?

Bilboa Freightlines, S.A., of Panama, has a small truck that it uses for intracity deliveries. The truck is worn out and must be either overhauled or replaced with a new truck. The company has assembled the following information: Present Truck New Truck Purchase cost new $ 31,000 $ 36,000 Remaining book value $ 24,000 - Overhaul needed now $ 23,000 - Annual cash operating costs $ 22,000 $ 19,500 Salvage value-now $ 5,000 - Salvage value-five years from now $ 20,000 $ 12,000 If the company keeps and overhauls its present delivery truck, then the truck will be usable for five more years. If a new truck is purchased, it will be used for five years, after which it will be traded in on another truck. The new truck would be diesel-operated, resulting in a substantial reduction in annual operating costs, as shown above. The company computes depreciation on a straight-line basis. All investment projects are evaluated using a 7% discount rate. Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine the appropriate discount factor(s) using tables. Required: 1. What is the net present value of the “keep the old truck” alternative? 2. What is the net present value of the “purchase the new truck” alternative? 3. Should Bilboa Freightlines keep the old truck or purchase the new one?

Bilboa Freightlines, S.A., of Panama, has a small truck that it uses for intracity deliveries. The truck is worn out and must be either overhauled or replaced with a new truck. The company has assembled the following information:

If the company keeps and overhauls its present delivery truck, then the truck will be usable for five more years. If a new truck is purchased, it will be used for five years, after which it will be traded in on another truck. The new truck would be diesel-operated, resulting in a substantial reduction in annual operating costs, as shown above.

The company computes depreciation on a straight-line basis. All investment projects are evaluated using a 11% discount rate.

Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine the appropriate discount factor(s) using tables.

Required:

1. What is the net present value of the “keep the old truck” alternative?

2. What is the net present value of the “purchase the new truck” alternative?

3. Should Bilboa Freightlines keep the old truck or purchase the new one?

Bilboa Freightlines, S.A., of Panama, has a small truck that it uses for intracity deliveries. The truck is worn out and must be either overhauled or replaced with a new truck. The company has assembled the following information:

If the company keeps and overhauls its present delivery truck, then the truck will be usable for five more years. If a new truck is purchased, it will be used for five years, after which it will be traded in on another truck. The new truck would be diesel-operated, resulting in a substantial reduction in annual operating costs, as shown above.

The company computes depreciation on a straight-line basis. All investment projects are evaluated using a 13% discount rate.

Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine the appropriate discount factor(s) using tables.

Required:

1. What is the net present value of the “keep the old truck” alternative?

2. What is the net present value of the “purchase the new truck” alternative?

3. Should Bilboa Freightlines keep the old truck or purchase the new one?

You walk into the offices of Global Private Bank early in the morning on February 2nd, 2006. You are employed by the bank to market proprietary financial products to moderate to high net worth customers. Going into the break room to grab a cup of coffee, you flip on the TV to CNBC to catch the morning financial news. The commentator says “… and the latest release shows that consumer confidence has fallen for the second straight month. Given this, and the previous statistics on business inventories, it is not surprising that investors are nervous. So, now, all eyes turn to the Fed”. You switch the TV off. It looks like the economy is going to be the topic of discussion for the next week. More importantly, the people you work with will expect you to know what is happening (and maybe explain it to them). It is going to be a busy day. Global Private Bank is a mid-tier regional bank, focused primarily on consumer and small business lending. Historically the bank has funded its loans through traditional bank deposits. However, given the rapid development in convenience of mutual funds and online investing, the bank has shifted its focus to offering a larger range of financial products and advice to its high-end customers. This included offering its own mutual funds, annuity and insurance products from other companies, and financial planning courses. Global Private Bank has a large staff dedicated to customer relations. Jobs range from handling accounts to marketing consumers’ products to providing financial advice. Your job is to work with this staff to determine what the best products are and how best to market them. You interact daily with people from all over the bank, including some of the bank’s major customers (since they are a good source of information on how the company is doing). A large part of the bank’s customer base is retired individuals who have had long-term relationships with the bank. These individuals have a range of financial expertise, some being dedicated followers of the financial news, while others have never heard of the Federal Reserve. The bank’s customers get their income from a variety of sources. Most have traditional bank accounts. Some, particularly the middle age customers, have substantial holdings of stock. Retired investors also typically have some sort of pension or retirement plan. The bank’s customers can be very concerned about changes in the economy. Those holding stock are worried about corporate profitability; the more profitable the company, the higher the value of the stock. Some of those with pensions have other concerns. Often, the value of their pensions does not keep up with inflation. These investors tend to watch for signs of future inflation that could mean they would have a lower real income in the years ahead. The growth of GDP seems to be slowing, leading many investors to be concerned about the future prospects for the economy. One indicator of the weakness of the economy is the decline in consumer confidence, a measure of how optimistic consumers are about the strength of the economy in the near future. If this decline continues, it could lead to a decrease in consumer spending. Also, firms have spent the last two years dramatically expanding their capacity by buying new machinery and building new factories. Because of this, it is expected that companies are likely to rein in spending on investment over the next year. The Economic Research Group of Global Private Bank has provided historical data on GDP along with forecasted values for the upcoming year (see the spreadsheet on the course website). The forecasts are based on the information given above, but the forecasts also assume that the Federal Reserve will not take action. The Federal Open Market Committee (FOMC) of the Federal Reserve will be meeting in two weeks to make a decision on monetary policy. The leading issue at that meeting will be the weakness in the economy. Many of the members of the FOMC believe that the Federal Reserve should take immediate action to counter the forecasted decline in the economy.

Question: If the Federal Reserve decides to act, how will that affect investors that deal with Global Private Bank? Limit your answer to issues discussed in the case.

A company institutes an exercise break for its workers to see the effect on job satisfaction, as measured by a questionnaire that assesses workers’ satisfaction. Scores for 10 randomly selected workers before and after the implementation of the exercise program are shown in the following table. Determine if there is a significant increase in worker job satisfaction after the implementation of the exercise program using a 5% level of significance.

Job Satisfaction Index Table

Must complete all parts of this problem:

• PART 1: Use Excel to perform a Matched Pairs Test on the data (di = before – after). Copy and paste the output from Excel into a word document.
• PART 2: Write 3 - 4 sentences on the findings from the Matched Pairs Test. Is there a significant increase in worker job satisfaction after the implementation of the exercise program using a 5% level of significance? Support your answer by using the output from the test. You must include: the hypotheses for the test, a discussion of the p-value, and the decision you reach and why.

Assume a company manufacturing many products, one of which normally sells for $48 per unit. The company’s accounting system reports the following unit product cost for this product:

The company estimates that $3 of its manufacturing overhead varies with respect to the number of units produced. The remainder of its overhead is fixed and unaffected by the volume of units produced within the relevant range.

A customer has approached the company with an offer to buy 300 units of a customized version of the product mentioned above for $39. The company can fulfill this order using existing manufacturing capacity. To accommodate the customer’s desired product design, the company would incur additional direct materials cost per unit of $3. It would also have to buy a special tool for $560 that has no other use or resale value after the special order is completed. Assuming that accepting this order will not have any effect on sales to other customers, what is the financial advantage (disadvantage) of accepting the special order?

Brilliant Design Company makes custom chairs for individual customers. Brilliant Design Company is a job-order costing manufacturer that applies overhead on the basis of Direct Labor Cost. At the beginning of the year, to establish a predetermined overhead rate, Brilliant Design Company estimated total $700 in overhead costs and total $1,000 in direct labor cost.

On October 1, there was one job in process, Job 243, with a cost of $1,300.

Jobs 244, 245, and 246 were started during the month of October. Data on costs added during the month are as follows:

Job 245 was completed and the client was billed at cost plus 55%. All other jobs remained in process.

Q23. What is the manufacturing overhead applied to Job 243?

Q24. what is the total manufacturing overhead for job 245?

Q25. what is the Balance in work of process in October 31?

Q26. what is the price of Job 245?

ABC Company sells its inventory to customers for $50 per
unit. During May, ABC Company had total fixed costs of
$200,000 and needed to sell 10,000 units in order to
break-even. ABC Company's actual sales in May amounted
to 26,352 units.

Calculate ABC Company's net income for May.