Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Evaluating the Best Use of Funds for Capital Investments Data analytics can be used to evaluate the best use of funds for capital investments. Joe Fox is the manager of the Gear division and plans to

Evaluating the Best Use of Funds for Capital Investments

Data analytics can be used to evaluate the best use of funds for capital investments. Joe Fox is the manager of the Gear division and plans to submit a proposal for an expanded production area. Joe has projected various conditions for revenues and expenses for the expansion, including different sizes and quality components. Knowing that the effect will likely differ under each, Joe plans to submit a conservative estimate for his proposed capital budgeting project this year to avoid a repeat of an unfavorable post-audit evaluation as occurred two years ago. Joe has provided the following data to be used in the analysis of selecting the proposal to be submitted to the capital budget committee.

Required rate of return: 6.0%

Table of useful lives and cash flows for different capital budgeting scenarios (Dollar amounts in thousands)

Project Scenario

Years of Useful Life

Net Initial Investment

Operating Cash Flows Year 1

Operating Cash Flows Year 2

Operating Cash Flows Year 3

Operating Cash Flows Year 4

Operating Cash Flows Year 5

Operating Cash Flows Year 6

A

6

$(43,869)

$  9,006

$  9,564

$  8,831

$  9,557

$  9,143

$  8,906

B

6

    (51,967)

11,372

12,042

11,259

11,517

11,880

10,758

C

4

      (46,516)

12,414

12,970

12,586

11,730

D

4

      (51,118)

14,982

12,853

13,817

14,031

E

5

      (71,715)

15,237

17,496

17,826

15,962

17,682

F

4

      (49,709)

13,054

12,078

13,866

13,686

G

4

      (55,519)

15,361

13,898

15,514

15,491

H

6

      (46,336)

10,422

10,050

9,228

10,221

10,725

9,079

I

5

      (53,417)

12,843

13,283

12,562

11,670

12,677

J

5

      (60,032)

12,845

12,328

10,734

10,113

10,960

K

6

      (51,321)

10,630

8,576

9,787

8,273

9,265

10,909

L

5

      (67,073)

13,627

12,263

13,931

13,080

12,984

M

4

      (43,994)

9,537

8,490

8,690

9,395

N

5

      (39,793)

9,526

9,079

9,779

10,746

8,277

Joe Fox is the manager of the Gear division and plans to submit a proposal for an expanded production area. Joe has projected various conditions for revenues and expense for the expansion, including different sizes and quality components. Knowing that the effect will likely differ under each, Joe plans to submit a conservative estimate for his proposed capital budgeting project this year to avoid a repeat of an unfavorable post-audit evaluation as occurred two years ago. Joe has provided the following data to be used in the analysis of selecting the proposal to be submitted to the capital budget committee.

Use the following template:

  • Module 6 CTA Excel File TemplateDownload Module 6 CTA Excel File Template

Requirements

There are three parts to this problem. Use Excel to perform the following:

  1. Use Excel’s IRR function to calculate IRR for each project scenario.
  2. Create a column chart that illustrates the IRR for each project. Include a descriptive chart title and axes labels in the chart.
  3. Examine the chart. Which project scenarios are acceptable? Which project scenario would you recommend that Joe submit to the capital budget committee? Justify your response. Be specific.

Submit the provided Excel spreadsheet containing your answers to each of the above requirements. Use Excel functions to make any required calculations described in the requirements. Post your completed Excel spreadsheet containing your answers for your instructor to grade. Submit a Word file detailing your answer to part 4 above to indicate and explain any relationships you identify from examining the chart you prepare and your responses to parts 1 and 2.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Jayhawk CAPITAL ADVISORS Mid-Term Assignment Background: You work as an analyst for Jayhawk Capital Advisors (“JCA”), a leading middle- market investment bank. JCA has been engaged by the shareholders

Jayhawk CAPITAL ADVISORS Mid-Term Assignment Background: You work as an analyst for Jayhawk Capital Advisors (“JCA”), a leading middle- market investment bank. JCA has been engaged by the shareholders of ABC Auto Parts (“ABC” or the “Company”) to evaluate an unsolicited takeover bid for $175 million from the Company’s largest

Ridgecrest Electric manufactures electric motors. It competes and plans to grow by selling high-quality motors at a low price and by delivering them to customers quickly after receiving customers’ ord

Ridgecrest Electric manufactures electric motors. It competes and plans to grow by selling high-quality motors at a low price and by delivering them to customers quickly after receiving customers’ orders. There are many other manufacturers who produce similar motors. Ridgecrest believes that continuously improving its manufacturing processes and having satisfied

Company: Apple Using the APUS library and other sources, complete a presentation that includes a balanced score card for a public corporation of your choosing. Unlike other weekly assignments, this as

Company: Apple Using the APUS library and other sources, complete a presentation that includes a balanced score card for a public corporation of your choosing. Unlike other weekly assignments, this assignment does not have a standard template. Complete the balanced score card in presentation format to present to management your

Write 200-250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200-250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  For this Discussion Board, please complete the following: Gross domestic product (GDP) is a measurement of how much people produce of goods and services. What

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  For this Discussion Board, please complete the following: You have recently been promoted to the position of controller for M&K Industries. You have partnered

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Please complete the following:

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  Please complete the following: You have completed several assignments in the online learning platform. Everyone is challenged by different parts. Learning how to successfully

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  For this Discussion Board, please complete the following: You have learned about supply and demand. You know that when prices go up, people buy

Topic: Appraise the role of fraud through the auditing process In this discussion, please reflect on the previous weeks’ topics. Choose a topic you found to be difficult or hard to understand. Researc

Topic: Appraise the role of fraud through the auditing process In this discussion, please reflect on the previous weeks’ topics. Choose a topic you found to be difficult or hard to understand. Research this topic and present your findings. Include a summary of the topic, why you found the topic

Paula Beane owns a restaurant franchise that is part of a chain of “Southern Homestyle” restaurants. One of the chain’s popular breakfast items is biscuits and gravy. Central Warehouse makes and freez

Paula Beane owns a restaurant franchise that is part of a chain of “Southern Homestyle” restaurants. One of the chain’s popular breakfast items is biscuits and gravy. Central Warehouse makes and freezes the biscuit dough, which it then sells to the franchise stores where it is thawed and baked in

Topic: You are an auditor at a prestigious CPA firm. After several years of hard work, your boss informs you that you will be in charge of this year’s audit of the firm’s most important client, Bullse

Topic: You are an auditor at a prestigious CPA firm. After several years of hard work, your boss informs you that you will be in charge of this year’s audit of the firm’s most important client, Bullseye, a general merchandise retailer with hundreds of stores throughout the United States. Bullseye is

Studydaddy Critics You all noticed that the site’s support team has basically ghosted everyone. No replies to tickets, no fixing complaints, no refunds, no dispatching payments straight radio silence.

Studydaddy Critics You all noticed that the site’s support team has basically ghosted everyone. No replies to tickets, no fixing complaints, no refunds, no dispatching payments straight radio silence. So yeah, we got fed up and threw this dumb little script. It just keeps posting this same question after approximately

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  For this Discussion Board, please complete the following: Tax code changes in the United States occur for several reasons, reflecting both economic and social

Description: Professionals increase their awareness of current research related to the teaching of young children by reading professional journal articles. Review one journal article written in the l

Description: Professionals increase their awareness of current research related to the teaching of young children by reading professional journal articles.  Review one journal article written in the last 5 years concerning individualizing instruction in early childhood classrooms. Please use Google Scholars from Miami Dade College for the article. Directions: Read

Topic: Assess the key elements of the audit report, auditor responsibilities, audit objectives, audit evidence, audit planning, audit strategy, audit program, materiality, risk, and analytical procedu

Topic: Assess the key elements of the audit report, auditor responsibilities, audit objectives, auditevidence, audit planning, audit strategy, audit program, materiality, risk, and analytical procedures. In this discussion, please reflect on the previous weeks’ topics. Choose a topic you found to be difficult or hard to understand. Research this topic

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  For this Discussion Board, please complete the following: Tax planning involves strategic decision making to minimize tax liability within the bounds of the law.

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Understanding tax concepts, po

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  Understanding tax concepts, policies, and effective tax planning strategies is essential for individuals. Explore the rationale behind two of the tax concepts, policies, or

Corporation: Walmart In this discussion, please reflect on changes in accounting principles and error corrections. How can you determine the difference between error correction and fraud? Add an exa

Corporation: Walmart  In this discussion, please reflect on changes in accounting principles and error corrections.  How can you determine the difference between error correction and fraud? Add an example from a public corporation. Include a copy of the corporation’s disclosure note and explain the effect the change or error correction