What is the project pb and dpb

Reference no: EM131964305

Question: Create an Excel spreadsheet:

Atlantic Control Company purchased a machine four years ago at a cost of $70,000. At that time the machine's expected economic life was six years and the expected salvagte value was $10,000 at the end of its life. The machine is being depreciated using the straight line method so that its book value at the end of six years is $10,000.A new machine can be purchased for $80,000 including shipping and installation costs. It has an economic life estimated at four years. MACRS depreciation will be used, and the machine will be depreciated over its 3-year class life rather than its 4-year economic life. (MACRS 3-year schedule = 33%, 45%, 15%, 7%). During its 4-year life the new machine will reduce Atlantic's cash operating expenses by $20,000 per year. Sales are not expected to change but the new machine will require an increase in net working capital of $4,000. At the end of its useful life, the machine is estimated to have a market value of $2,500.The old machine can be sold today for $20,000. If it is not replaced the company believes that the old machine can be usd for another four years. At that time the old machine will be worthless, so its market value will be zero. Atlantic's tax rate is 40%, and its required rate of return is 10 percent.

What is the project's: PB, DPB, IRR, MIRR, NPV, and PI?

Reference no: EM131964305

Questions Cloud

Create an argument of the present value free cash-flow : Create an argument that use of the present value free cash-flow method has a more beneficial economic meaning than earnings-based methods.

Influence on the effectiveness of communication : In what ways is context a powerful influence on the effectiveness of communication? Describe an instance in which situational or cultural context has influenced

Explain how you would determine your pricing model : Explain how you would determine your pricing model. What seems most appropriate for your business and industry in which you will compete?

New organizational structure for the company : Based on what you have observed in "1" and "2" above; suggest a new organizational structure for the company.

What is the project pb and dpb : Atlantic Control Company purchased a machine four years ago at a cost of $70,000. At that time the machine's expected economic life was six years.

What is the publishers reputation : Analyze the strength of your sources and to practice citing two of your sources in the documentation style you have chosen for your paper.

Major arguments for and against an open trading system : What are some of the major arguments for and against an open trading system?

Think about how the first amendment : Think about how the First Amendment may affect you as an employee. Should your first amendment protection extend to you as an employee?

Marketing mix of companies : The cultural, economic, political and legal environment affects the Marketing mix of companies trying to enter a new market

User Account

All Pages