CORNELIA ASSOCIATES After a successful semester you are keen to start the first week of your...
Get step-by-step solutions with AI-powered insights and expert guidance to help you understand core concepts.
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66553da0023e4_36766553d9ff04bf.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66553da0873ff_36866553da07f743.jpg)
Transcribed Image Text:
CORNELIA ASSOCIATES After a successful semester you are keen to start the first week of your first 'real' job as an analyst at Cornelia Associates, an econometric research and consulting firm in Mt. Pleasant. DECISION CRITERIA The firm has 2 different internal investment opportunities. A fiscally conservative member of the board of directors insists that all internal investments must be recouped within 2 years. The company uses a 6.5% cost of capital for analyzing internal projects. A B 1 2 3 5 6 (20,000) (50,000) 4,000 8,000 5,000 10,000 6,000 12,000 7,000 8,000 9,000 14,000 16,000 18,000 You are tasked with making a recommendation as to which single internal investment opportunity would benefit the firm the most. Create an Excel worksheet for your calculations. Use and explain the following decision criteria: NPV IRR MURR PB DEB Pl. In your explanation of the decision criteria, do not 'narrate' the formula --- explain what each measurement tells the investor. Create textboxes for your responses or commentary. Management is not sure if the 6.5% cost of capital is correct. Create a data table showing the effects of changing costs of capital, ranging from 3% to 17% in half-percent increments, upon the NPV of Project A and Project B. Create an NPV profile chart. Label the chart, axes, and profiles. Identify and explain the cross-over rate, as well as each firm's intercept of the X axis. Put your explanations in textboxes. CORNELIA ASSOCIATES COST OF CAPITAL One of your take-aways from your finance courses was the importance of using the correct discount rate for analyzing cash flows and investment projects. Another take-away was the importance of using the spell- and grammar check --- for spreadsheet work as well as for text documents --- on every document produced. You have been given an abbreviated balance sheet of the firm, as well as data on historical costs of various funding instruments. Your task is to first find the market costs of these funding instruments and then to establish the market weights of the capital structure of the firm. Ultimately your goal is to check whether the cost of capital currently being used is accurate. If it is not, you must choose the correct cost of capital for the analysis of the capital budget for the new mainframe system proposed below. Before you analyze the capital budget of the mainframe system, comment briefly on the consequences of using the previously given (6.5%) cost of capital rather than the cost of capital that you will have calculated. | The abbreviated balance sheet appears below: CORNELIA ASSOCIATES Book Values 2019 Number of shares 100,000 Current assets 4,000,000 Current liabilities Fixed assets 7,500,000 Notes payable 1,000,000 2,500,000 Long-term debt Common stock 4,000,000 100,000 Retained earnings 3,900,000 Total assets 11,500,000 Total liabilities and equity 11,500,000 CORNELIA ASSOCIATES After a successful semester you are keen to start the first week of your first 'real' job as an analyst at Cornelia Associates, an econometric research and consulting firm in Mt. Pleasant. DECISION CRITERIA The firm has 2 different internal investment opportunities. A fiscally conservative member of the board of directors insists that all internal investments must be recouped within 2 years. The company uses a 6.5% cost of capital for analyzing internal projects. A B 1 2 3 5 6 (20,000) (50,000) 4,000 8,000 5,000 10,000 6,000 12,000 7,000 8,000 9,000 14,000 16,000 18,000 You are tasked with making a recommendation as to which single internal investment opportunity would benefit the firm the most. Create an Excel worksheet for your calculations. Use and explain the following decision criteria: NPV IRR MURR PB DEB Pl. In your explanation of the decision criteria, do not 'narrate' the formula --- explain what each measurement tells the investor. Create textboxes for your responses or commentary. Management is not sure if the 6.5% cost of capital is correct. Create a data table showing the effects of changing costs of capital, ranging from 3% to 17% in half-percent increments, upon the NPV of Project A and Project B. Create an NPV profile chart. Label the chart, axes, and profiles. Identify and explain the cross-over rate, as well as each firm's intercept of the X axis. Put your explanations in textboxes. CORNELIA ASSOCIATES COST OF CAPITAL One of your take-aways from your finance courses was the importance of using the correct discount rate for analyzing cash flows and investment projects. Another take-away was the importance of using the spell- and grammar check --- for spreadsheet work as well as for text documents --- on every document produced. You have been given an abbreviated balance sheet of the firm, as well as data on historical costs of various funding instruments. Your task is to first find the market costs of these funding instruments and then to establish the market weights of the capital structure of the firm. Ultimately your goal is to check whether the cost of capital currently being used is accurate. If it is not, you must choose the correct cost of capital for the analysis of the capital budget for the new mainframe system proposed below. Before you analyze the capital budget of the mainframe system, comment briefly on the consequences of using the previously given (6.5%) cost of capital rather than the cost of capital that you will have calculated. | The abbreviated balance sheet appears below: CORNELIA ASSOCIATES Book Values 2019 Number of shares 100,000 Current assets 4,000,000 Current liabilities Fixed assets 7,500,000 Notes payable 1,000,000 2,500,000 Long-term debt Common stock 4,000,000 100,000 Retained earnings 3,900,000 Total assets 11,500,000 Total liabilities and equity 11,500,000
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Ned Thompson Labs performs tests on super alloys, titanium, aluminum, and most metals. Tests on metal composites that rely upon scanning electron microscope results can be subcontracted, or the labs...
-
On your post-graduation celebration trip you are leaving Paris for Shanghai, China. You leave Paris with 10,000 euros in your money pouch. Wanting to exchange all of these for Chinese RMB, you obtain...
-
2. What assumptions should he make?
-
1. Under the indirect method of calculating operating cash flows, which of the following would be added to net income? a. Increase in current assets b. Non-cash expenses c. Gain on sale of equipment...
-
Shatin Intl. has 9.69.6 million shares, an equity cost of capital of 12.5 %12.5% and is expected to pay a total dividend of $ 19.2$19.2 million each year forever. It announces that it will increase...
-
Dr. Kovaleski is interested in examining whether quantity of sleep impacts problem solving ability. To test problem solving ability, the research team gave participants a puzzle and measured how long...
-
SCENARIO Your organization is an organic food supplierwith employees in the following jurisdictions: Manitoba Prince Edward Island Yukon The organization is planning to implement a company-wide...
-
Give your overall opinion . What do you think about neuromarketing? Is it usefull or is it a waste of time? Some people think this practice is "Orwellian", do you agree? Can marketers manage the...
-
Question 1. Let z= f(x,y), x = g (s, t). and ' y = h (s, t). with f, g & h all differentiable. (a) Set up an appropriate tree diagram for the of chain rule as done in this module's Use video lessons:...
-
ow do synergistic dynamics emerge within high-performance teams, and what role do diverse skill sets, complementary roles, and shared goals play in fostering collaborative innovation and collective...
-
(14%) Problem 3: The circuit shown contains a voltage source with emf & = 5.99 V, a resistor with resistance R = 135 k2, and a capacitor with capacitance C = 507 nF. When switch S is set to position...
-
1. What functions do all managers perform regularly? How do these functions apply to the three levels of management found in most organizations? 2. Identify and distinguish between the different...
-
Concept formation explanation...: Sentence completion : Measurement serves to bridge _ abstract concepts _ with _ empirical realities, or the real world . (Dr. Becky Munson, 2021). Observable...
-
Budgetary Control need not be accompanied by a Standard Costing System. Discuss.
-
I:16-9 Current tax law imposes a $1 million limitation on the deductibility of executive compensation. Should such limitation be retained or repealed? Give reasons for your opinion.
-
I:16-7 What conditions must be met for an accrual-basis corporation to deduct a charitable contribution in a year before it is made?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App