Colorado FIN300 Critical Thinking Irr Calculations Worksheet

Question # 00651435
Subject: Business
Due on: 12/25/2023
Posted On: 12/25/2023 12:55 AM
Tutorials: 1
Rating:
4.9/5
Question Dot Image

FIN 300 Colorado State University Critical Thinking Irr Calculations Worksheet

OPTION #1: CAPITAL RATIONING

Table with Cash Flows for 5 projects.

  Project A Project B Project C Project D Project E
Initial Investment -$100,000 -$25,000 -$40,000 -$10,000 -$150,000
Year 1 $50,000 $15,000 $20,000 $7,000 $100,000
Year 2 $40,000 $10,000 $15,000 $4,000 $25,000
Year 3 $20,000 $5,000 $5,000 $2,000 $10,000
Year 4 $10,000 $1,000 $5,000 $1,000 $10,000
Year 5   $1,000     $10,000
Year 6   $1,000     $10,000
  1. Calculate the IRR for each of the projects presented. Rank the projects based on their IRR.
  2. Graph the projects on an Investment Opportunity Schedule (interest rate on the vertical axis and initial investment on the horizontal). Suppose the firm has a capital rationing amount of $170,000 and a required rate of return of 10%.
  3. Which projects should the firm implement based on your analysis using the IRR approach above? Write an email to your CFO explaining your rationale proving the choices based on the considerations of shareholder value and the maximum investment budget.
  • Submit your 3 to 4 page paper in a Word document, showing all of your calculations (attach Excel File if necessary) with a minimum of four references.
  • Use terms, evidence, and concepts from class readings.
Dot Image
Getsolution Posted By :
Questions: 14429 Tutorials: 14429
Tutorials for this Question

Colorado FIN300 Critical Thinking Irr Calculations Worksheet

Tutorial # 00650325
Posted On: 12/25/2023 12:56 AM
Feedback Score: Not rated yet!
Purchased By: 2
Getsolution
Posted By:
Questions:
14429
Tutorials:
14429
Report this Tutorial as Inappropriate
Tutorial Preview
The solution of Colorado FIN300 Critical Thinking Irr Calculations Worksheet...
Attachments
Colorado_FIN300_Critical_Thinking_Irr_Calculations_Worksheet.ZIP (18.96 KB)

Great! We have found the solution of this question!

Related Questions
Case 2 - Advanced Corporation Finance
Case 2 Advanced Corporation Finance Case #2 is an excel spreadsheet case. Please show your work in excel using cell references and formulas. If you do not show your work in excel, it is difficult t …
FIN570 Final Exam Latest 2024
FIN570 Final Exam  1. Consider the following data for Company Y (12 points):                   &n …
FINA4320 International Financial Management
FINA4320 International Financial Management Quantitative Problems (25 Points in total) Submit your answers with an Excel file on Canvas. Your answers must include Excel functions or formulations …
Financial Accounting Pepsi and Coca Cola Companies Discussion
SEU Financial Accounting Pepsi and Coca Cola Companies Discussion Select two of the four companies shown below. Use the following SEC Edgar website for your research: https://www.sec.gov/edgar …
Finance for Business Accounting Excel - If you were to invest
CSUN Finance for Business Accounting Excel Questions If you were to invest $1,000 each year for the next 40 years, then what rate of return is required for your investment to be worth $1,000,000? ( …
Finance Leading Financial Institutions in Saudi Arabia Project
Finance Leading Financial Institutions in Saudi Arabia Project Choose TWO stocks from the Saudi stock market. ???Write about its history, industry etc. to educate & inform the reader on the …
FIN201 Corporate Finance - What are the different ways
Corporate Finance (FIN-201) Q1. What are the different ways available for the corporations to distribute income among the shareholders? Suppose a firm promises to pay dividends of $200,000 every ye …
Finance - The market value of Majestic, Inc.'s debt claims
Finance Question Assignment questions:   The market value of Majestic, Inc.'s debt claims is $500, and its equity claims are also $500. What is Majestic's weighted average c …
Colorado FIN300 Critical Thinking Irr Calculations Worksheet
FIN 300 Colorado State University Critical Thinking Irr Calculations Worksheet OPTION #1: CAPITAL RATIONING Table with Cash Flows for 5 projects.   Project A Pro …
Colorado FINC615 Management Comparative Financial Analysis
FINC 615 Colorado Technical University Management Comparative Financial Analysis Explain the computation for each of the following, and compute each for Apix and two other companies in the same ind …
Recent Questions
Walden NURS6050 All Assignments Latest 2024
NURS6050C3 / NURS 5050C / NURS 6050N NURS6050 Policy & Advocacy for Pop Hlth- Week 2 Assignment AGENDA COMPARISON GRID AND FACT SHEET It may seem to you that healthcare has been a nat …
Walden NURS6050 Week 11 Assignment Latest 2024
NURS6050C3 / NURS 5050C / NURS 6050N NURS6050 Policy & Advocacy for Pop Hlth- Week 11Assignment GLOBAL HEALTHCARE COMPARISON MATRIX AND NARRATIVE STATEMENT Note: This Assignment (both …
Walden NURS6050 Week 10 Assignment Latest 2024
NURS6050C3 / NURS 5050C / NURS 6050N NURS6050 Policy & Advocacy for Pop Hlth- Week 10 Assignment ASSESSING A HEALTHCARE PROGRAM/POLICY EVALUATION Program/policy evaluation is a valuab …
Walden NURS6050 Week 8 Assignment Latest 2024
NURS6050C3 / NURS 5050C / NURS 6050N NURS6050 Policy & Advocacy for Pop Hlth- Week 8 Assignment ADVOCATING FOR THE NURSING ROLE IN PROGRAM DESIGN AND IMPLEMENTATION As their name …
Walden NURS6050 Week 6 Assignment Latest 2024
NURS6050C3 / NURS 5050C / NURS 6050N NURS6050 Policy & Advocacy for Pop Hlth- Week 6 Assignment REGULATION FOR NURSING PRACTICE STAFF DEVELOPMENT MEETING Nursing is a very highly regu …
Walden NURS6050 Week 4 Assignment Latest 2024
NURS6050C3 / NURS 5050C / NURS 6050N NURS6050 Policy & Advocacy for Pop Hlth- Week 4 Assignment LEGISLATION GRID AND TESTIMONY/ADVOCACY STATEMENT As a nurse, how often have you though …
Walden NURS6050 Week 2 Assignment Latest 2024
NURS6050C3 / NURS 5050C / NURS 6050N NURS6050 Policy & Advocacy for Pop Hlth- Week 2 Assignment AGENDA COMPARISON GRID AND FACT SHEET It may seem to you that healthcare has been a nat …
Walden NURS6050 All Discussions Latest 2024
NURS6050C3 / NURS 5050C / NURS 6050N NURS6050 Policy & Advocacy for Pop Hlth- Week 1 Discussion PRESIDENTIAL AGENDAS Rather than focus on the treatment of chronic disease, policies th …
Walden NURS6050 Week 9 Discussion Latest 2024
NURS6050C3 / NURS 5050C / NURS 6050N NURS6050 Policy & Advocacy for Pop Hlth- Week 9 Discussion THE ROLE OF THE RN/APRN IN POLICY EVALUATION In the Module 4 Discussion, you considered …
Walden NURS6050 Week 7 Discussion Latest 2024
NURS6050C3 / NURS 5050C / NURS 6050N NURS6050 Policy & Advocacy for Pop Hlth- Week 7 Discussion EVIDENCE BASE IN DESIGN When politics and medical science intersect, there can be much …