Evaluate the NPV of net income after taxes

Assignment Help Accounting Basics
Reference no: EM132695019

Question - Kurbe Marketing Research

Kurbe Marketing Research (KMR), located in Boston, specializes in marketing research in the consumer goods industry. Each year KMR conducts hundreds of research studies for a variety of clients utilizing focus groups, internet surveys and telephone surveys. KMR is currently studying the resources it dedicates to telephone surveys.

Demand for KMR's telephone research varies throughout the year. KMR conducts the vast majority of its research in-house, but if it cannot handle all of the work at peak demand times, it is forced to subcontract some of the phone interviewing, which results in a lower profit margin. Also, outsourcing the phone interviews means that KMR loses some control of the process. This can result in problems such as missed deadlines and a decrease in quality. However, dedicating enough resources to ensure no outsourcing would not be very efficient, since it would result in more costs and decreased productivity due to idle time during slower periods. Nonetheless, based on the recent amount of outsourcing, KMR management feels that the company has too few operators conducting telephone survey research. You have been assigned the task of studying this problem and making a recommendation.

The annual fixed costs (management, facilities and other overhead charges) associated with the telephone survey group are $320,000. Every operator needs a computer-assisted telephone interviewing station (known as a CATI). Currently KMR has 48 CATIs and they are considering purchasing additional ones this year. Of the 48 CATIs currently on hand, 16 per year will be replaced each year for the next 3 years. New CATIs will not need replacement over this time period.

The purchase cost of a CATI is $36,000 and is likely to remain stable for the next 3 years. The cost of an operator (one per CATI) per month is $2,200. Assume that only additional CATIs (beyond the current number of 48) require training (replacement CATIs do not since they already have operators).

The time frame for the study is the next three years. Demand varies by month and forecasted demand for the coming year is shown in the table below (demand is expressed in dollars of revenue). A CATI can handle approximately $12,000 of work per month. Demand is expected to grow by 10% per year (the forecasted amounts in the table have already factored this in for next year). Assume that each month's demand will grow by this amount in years 2006 and 2007. This increase in revenue will come from increased volume of work rather than increases in pricing (the forecast assumes stable pricing).

Month Demand ($000)

January $890

February $820

March $575

April $860

May $695

June $330

July $740

August $700

September $255

October $750

November $170

December $160

Forecasted demand (in dollars of revenue) for 2005

Management is looking for the best level of in-house operation (number of CATIs). KMR receives 15% of the revenue for the work that is outsourced to an outside vendor. Finally, for studies such as this, KMR uses an annual discount rate of 10% and their tax rate is 34%.

Required -

a. Build a spreadsheet to help KMR analyze this situation. In your base case, evaluate the NPV of net income after taxes assuming KMR maintains 48 CATIs in all years.

You may use the following page to sketch your spreadsheet (although your sketch will not be graded). Your spreadsheet will be graded both for its technical correctness and for its adherence to the principles of spreadsheet engineering. Note, however, that documentation is not required, nor is extensive formatting for appearance.

b. Construct a graph on a separate sheet in your workbook to show the sensitivity of the NPV of net income after taxes to the number of CATIs. Sketch your results here, showing numerical scales for the horizontal and vertical axes, and clearly identify the optimal number of CATIs.

c. In the base case (with 48 CATIs) how much lower does KMR's tax rate have to be to increase the NPV of net income after taxes by 10%?

Reference no: EM132695019

Questions Cloud

What was the effective rate of interest per period : The costs directly associated with issuing the bonds totaled $25,000. What was the effective rate of interest per period on this bond issue?
Define best value contracting : Define Best Value Contracting, and briefly describe the contractor's role in an Integrated Process Team (IPT).
What amount should be credited to common shares on september : The fair market value of the conversion option at this date was $5. What amount should be credited to common shares on September 26, 20X6?
Realistic understanding of the context of evaluations : Evaluators need to have a realistic understanding of the context of evaluations, the political uses of evaluations, and the conditions under which information
Evaluate the NPV of net income after taxes : Build spreadsheet to help KMR analyze this situation. In your base case, evaluate the NPV of net income after taxes assuming KMR maintains 48 CATIs in all years
Compute the refundable tax on hand balance as at december : Compute the refundable tax on hand balance as at December 31, 2020, showing in detail your calculation and compute the dividend refund for 2020
What is the amount of the impairment loss : What is the amount, if any, of the Impairment Loss for 2020? (Assume that the present value of expected future cash flows also closely approximates fair value)
Local responsiveness at mtv networks : Identify and list the international global competitive forces that have shaped the firm's strategy. What is the impact of this forces in the organization?
Monitoring of police communications and consequences : In this discussion, you review citizen monitoring of police communications and its consequences.

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