Purchase Solution

Investment on New Plant Decision Making Calculations

Not what you're looking for?

Ask Custom Question

Please provide an Excel spread sheet answer with calculations.

Question:
Looner Industries is considering investing in a new manufacturing plant. The plant requires an item of equipment that costs $200,000. In addition, Looner will spend $10,000 on shipping costs and $30,000 on installation charges. The equipment will be housed in a building currently owned by the company. The building was bought at a cost of $75,000 five years ago, but it could be sold now for $125,000. Similar buildings in the area are leasing for $5,000 per month.

You estimate that if the new plant is constructed, the company will increase its inventories by $25,000, while accounts payable also will rise by $5,000. New sales from the plant are estimated to be 120,000 units per year, at a price of $3.50 per unit. Variable costs are expected to total 60% of sales, while fixed costs are estimated at $20,000 per year. The plant has an estimated economic life of 4 years, after which time it will be scrapped for $25,000 (excluding the building). Depreciation will be calculated using the 3-year MACRS rates of 33%, 45%, 15%, and 7% for the first through the fourth year, respectively. Looner Industries' marginal tax rate is 40%, and its cost of capital is 10%. Should the plant be built?

Purchase this Solution

Solution Summary

The solution discusses the investment on new plant decision making calculations.

Solution Preview

See the attached file for Excel spreadsheet of calculations in its formatted version.

Inputs
Equipment Cost $200,000
Shipping Cost $10,000
Installation Charges $30,000
Total Plant Cost $240,000

Salvage Cost $25,000

Relevant building cost $5,000 per month
Marginal tax rate 40%
Cost of capital 10%
Fixed Costs $20,000 ...

Purchase this Solution


Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.