Calculate the npv and irr for the equation in excel

Assignment Help Managerial Accounting
Reference no: EM132471889

Point 1: Here is a scenario that I must compute. Please help advise how one would obtain this information and how to explain it in an essay. This is all the info that is given, and Must calculate the NPV, IRR, payback period, and profitability index.

Point 2: You work as a finance manager for Drill Tech, Inc., a mid-sized manufacturing company located in Minnesota. In the meeting to discuss capital projects, the director of finance (and your boss), Jennifer Davidson, gives you a synopsis of the projects along with this question:

Question 1: Which one of these projects will provide the most shareholder value to the company?

She also tells you that other than what is noted in each project scenario, all other costs will remain constant, and you should remember to only evaluate the incremental changes to cash flows.

Project Marketing/Advertising Campaign

  1. A major new marketing/advertising campaign, which will cost $2 million per year and last 6 years.
  2. It is forecast that the campaign will increase sales/revenues and costs of sales by 15% per year.
  3. Annual sales for the previous year were $20 million.
  4. The marginal corporate tax rate is presumed to be 25%. 
  5. Being a moderate risk investment, the required rate of return of the project is 10%.

Question 2: Calculate the NPV and IRR for this equation in excel?

Reference no: EM132471889

Questions Cloud

Research the impact of a specific technology on auditing : Research the impact of a specific technology on auditing, how auditors can better adapt to take advantage of these opportunities. Support your suggestions
Describe major financial business transaction of the company : Analyze current events for their impact on this company's risk and internal control in the future. Include documentation of these current events.
What is the total amount of contributed capital at December : Less: Treasury stock (3,000 common shares at cost) 61,500 and Retained earnings 70,000. What is the total amount of contributed capital at December
Identify in the sales processing subset of the revenue cycle : Based on the deficiencies in the design of controls identified in the sales processing subset of the revenue cycle as explained in the first two paragraphs
Calculate the npv and irr for the equation in excel : Calculate the NPV and IRR for this equation in excel? Determine one of these projects will provide the most shareholder value to the company?
Compute Taylors net unearned income : For 2019, she has the following income: $3,400 wages from a summer job, Compute Taylor's "net unearned income" for the purpose of the kiddie tax
Why is cash called the lifeblood of any company : Why is cash called the lifeblood of any company? What controls are put in place by the best companies to maximize their cash flow?
Create an income statement : Guy McKinley started the McKinley Charter Service at the beginning of August 2019. Create an income statement and a statement of owner's equity for the month
What amount of dividends were paid during the month : The company earned net income of $18,000. If stockholders' equity at October 31 totals $78,000, what amount of dividends were paid during the month?

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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