Purchase Solution

Depreciation, Investment Appraisal

Not what you're looking for?

Ask Custom Question

This two problems MUST be done in excel format. Please include explanation

1. Office equipment whose initial cost is $100,000 has an estimate actual life of 6 years , with an estimated salvage value of $10,000. Prepare tables listing the annual cost of depreciation and the book value at the end of each 6 years , based on the straight line , sum of years digits and MACRS depreciation.

2. A corporation with $7 million in annual taxable income is considering two alternatives:

Year Alternative1 Alternative2
0 -$10,000 -$20,000
1-10 $4500 $4500
11-20 $0 $4500

Both alternatives will be depreciated by straigh -line depreciation assuming a 10 year depreciable life and no salvage value.Neither alternative is to be replaced at the end of its useful life. If the corporation has a minimum atractive rate of retun of 10% after taxes , which alternative should i choose? Solve the problem by:

Present Worth Analysis
Annual Cash Flow Analysis
Rate of Retun Analyis
Future Worth Analyis
Benefit-Cost ratio analyis

Purchase this Solution
Solution Summary

Answers to two questions:
1) Depreciation calculation using straight line , sum of years digits and MACRS ;
2) Investment Appraisal using Present Worth Analysis, Annual Cash Flow Analysism Rate of Retun Analyis, Future Worth Analyis, Benefit-Cost ratio analyis.

Purchase this Solution
Free BrainMass Quizzes
Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

View More Free Quizzes
Related BrainMass Solutions

  • Appraisal Investment

    d) How should we calculate and treat working capital in investment appraisal? e) How should we treat taxable depreciation allowance in investment appraisal?

  • ARR, PP,NPV and IRR

    Explain your preferred method of evaluating the investment merits of these machines. 4. Why cash flows rather than profit flow that used in the IRR, NPV and PP method of investment appraisal? 5.

  • Cost Classifications for The Door Company

    Analysis of the cause of defects in production Appraisal costs d. Depreciation of test equipment Appraisal costs e. Warranty repairs External failure costs f.

  • Geico Problem: Capital Budgeting Decisions

    Producing didgeridoos will require an investment in equipment of $100,000 and operating costs of $15 per didgeridoo produced.

  • Consolidated Financial Worksheet

    Appraisal values were greater than book values for identifiable assets in the following amounts: Inventory ($300,000) and Plant and Equipment ($700,000).

  • Three methods of valuation: discuss, provide examples

    If you come up with a value from the other methods, you can change an assumption (rent, discount rate, depreciation) and change the value. This doesn't really change what others are willing to pay!

  • investment appraisal methods

    396115 List and describe the four main investment appraisal methods List and describe the four main investment appraisal methods. Which one is the best method to evaluate a risky investment and why?

  • Cost of land versus building: Stakeholder interest, ethics

    For example: Appraisal % Purchase Price Land $100,000 25% $140,000 Bldg $300,000 75% $420,000 Total $400,000 100% $560,000 To find the objective measure for allocation could require another appraisal to find the best data that would fit with

  • Appraisal value issue

    You discovered that the company is carrying its property, plant, and equipment at appraisal values and determines depreciation on the basis of these values.

View More Related Solutions