Prepare a spreadsheet using excel or a similar program

Assignment Help Accounting Basics
Reference no: EM131789395

Application: A Letter to the Board of Directors

Decisions involving capital expenditures often require managers to weight the costs and benefits of different options related to the same goal or project. For instance, deciding whether to replace, repair, or do nothing to existing equipment is a capital expenditure decision that involves calculations, projections, and deliberations. Managers must be able to quantitatively analyze different options for capital expenditures to make the best decisions for their organization.

For this Assignment, review the information in the scenario presented. You will utilize the information in this week's resources and media to make a recommendation in regard to a capital expenditure.

Garrison Appliances, Inc.

Garrison Appliances, Inc. is considering expanding its international presence. It sells 25% of all the toaster ovens sold in the United States but only 3% of the toaster ovens sold outside of the United States. The organization believes that it can sell more of its product if it has a production facility located overseas. Estimates concerning two possible locations, Mumbai and Bangalore, India follow:

Possible Location

Mumbai

Bangalore

Initial cash outlay

$5,000,000

                $2,800,000               

Useful life

20 years

20 years

Net cash inflows excluding depreciation

$1,100,000

$860,000

The cost of capital

9%

9%

Tax rate

40%

40%

The Assignment:

Part 1: Prepare a spreadsheet using Excel or a similar program in which you compute the following for each proposed location:

Accounting rate of return on investment

Payback

Net present value

Internal rate of return

Note: Be sure to view the media for this week before starting this Assignment.

Part 2: Utilizing Word or another word processing software program, prepare a written report for the Board of Directors. The intended audience is clear from the salutation and the language used throughout the report.

nclude a detailed and thorough explanation of the conclusion you reached regarding the feasibility of each proposal supported by the calculations prepared in Part 1.

Explain at leastfive non-financial items (e.g., culture, language, etc.), which may impact the perceived desirability of each location.

Select the one location you recommend the Board invest in. Explain your rationale in precise and detailed language.

Reference no: EM131789395

Questions Cloud

According to the national climatic data center : According to the National Climatic Data Center, during 1991, the lowest temperature recorded in Indianapolis, Indiana, was 0°F. If x is the wind speed
How much revenue should green co report in their first year : The costs cannot be reasonably estimated. How much revenue should Green Co. report in their first year under iGAAP
Number of millions of social security beneficiaries : The table gives the number of millions of Social Security beneficiaries (actual and projected) for selected years from 1950 through 2030.
Practices helps to protect consumers from spam : Which of the following practices helps to protect consumers from spam?
Prepare a spreadsheet using excel or a similar program : Prepare a spreadsheet using Excel or a similar program in which you compute the following for each proposed location
Determine the payback period : The Sunny Valley Wheat Cooperative is considering the construction of a new silo. It will cost $70,000 to construct the silo. Determine the payback period
Implementing-deploying innovation technology project : What factors influence your decision on implementing/deploying a innovation technology project?
Calculate the marginal rate of substitution : Suppose the utility function for a consumer is given by U = 5XY. X is the amount of Good X and Y is the amount of Good Y.
Describe the steps of process and the results for each step : Describe the method of analysis, using the article and Chapter 3 of Theoretical Basis for Nursing.Describe the steps of process and the results for each step.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd