Question

In: Finance

Please note that this assignment consists of two separate parts. The first part gives the cash...

Please note that this assignment consists of two separate parts. The first part gives the cash flows for two mutually exclusive projects and is not related to the second part. The second part is a capital budgeting scenario.

Part 1

Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive projects. The required rate of return is 15% and the target payback is 4 years. Explain which project is preferable under each of the four capital budgeting methods mentioned above:

Table 1

Cash flows for two mutually exclusive projects

Year

Investment A

Investment B

0

-$5,000,000

-5,000,000

1

$1,500,000

$1,250,000

2

$1,500,000

$1,250,000

3

$1,500,000

$1,250,000

4

$1,500,000

$1,250,000

5

$1,500,000

$1,250,000

6

$1,500,000

$1,250,000

7

$2,000,000

$1,250,000

8

0

$1,600,000

Part 2

Please study the following capital budgeting project and then provide explanations for the questions outlined below:

You have been hired as a consultant for Pristine Urban-Tech Zither, Inc. (PUTZ), manufacturers of fine zithers. The market for zithers is growing quickly. The company bought some land three years ago for $2.1 million in anticipation of using it as a toxic waste dump site but has recently hired another company to handle all toxic materials. Based on a recent appraisal, the company believes it could sell the land for $2.3 million on an after-tax basis. In four years, the land could be sold for $2.4 million after taxes. The company also hired a marketing firm to analyze the zither market, at a cost of $125,000. An excerpt of the marketing report is as follows:

The zither industry will have a rapid expansion in the next four years. With the brand name recognition that PUTZ brings to bear, we feel that the company will be able to sell 3,600, 4,300, 5,200, and 3,900 units each year for the next four years, respectively. Again, capitalizing on the name recognition of PUTZ, we feel that a premium price of $750 can be charged for each zither. Because zithers appear to be a fad, we feel at the end of the four-year period, sales should be discontinued. PUTZ believes that fixed costs for the project will be $415,000 per year, and variable costs are 15 percent of sales. The equipment necessary for production will cost $3.5 million and will be depreciated according to a three-year MACRS schedule. At the end of the project, the equipment can be scrapped for $350,000. Net working capital of $125,000 will be required immediately. PUTZ has a 38% tax rate, and the required rate of return on the project is 13%.

Now please provide detailed explanation for the following:

  • Explain how you determine the initial cash flows

  • Discuss the notion of sunk costs and identify the sunk cost in this project

  • Verify how you determine the annual operating cash flows

  • Explain how you determine the terminal cash flows at the end of the project’s life

  • Calculate the NPV and IRR of the project and decide if the project is acceptable

  • If the company that is implementing this project is a publicly traded company, explain and justify how this project will impact the market price of the company’s stock

Provide your explanations and definitions in detail and be precise. Comment on your findings. Provide references for content when necessary. Provide your work in detail and explain in your own words. Support your statements with peer-reviewed in-text citation(s) and reference(s).

Solutions

Expert Solution

Part 1:

Based on the given data, pls find below steps, workings and answers:

Payback period of Investment A is 3.33 years and that of Investment B is 4 years

NPV of Investment A is $ 1428598.12 and that of Investment B is $ 723567.51

PI of Investment A is $ 28.6% and that of Investment B is 14.5%

IRR of Investment A is 23.8% and that of Investment B is 19.19%

MIRR of Investment A is 19.2% and that of Investment B is 16.96%

Since these are mutually exclusive projects, based on the above criteria, Investment A is more feasible for recommendation than Investment B, as all the factors are higher than Investment B and the Payback period is lower than Investment B;

Computation of IRR: This can be computed using formula in Excel = IRR("range of cashflows", discounting factor%);

Computation of MIRR: This can be computed using formula in Excel = MIRR("range of cashflows", discounting factor%, reinvestment factor%); Here, both discounting factor % and reinvestment factor% are considered same.

Computation of Net Present Value (NPV) based on the Discounted Cash flows; The Discounting factor is computed based on the formula: For year 0, the discounting factor is 1; For Year 1, it is computed as = Year 0 factor /(1+discounting factor%) ; Year 2 = Year 1 factor/(1+discounting factor %) and so on;

Next, the cashflows need to be multiplied with the respective years' discounting factor, to arrive at the discounting cash flows;

The total of all the discounted cash flows is equal to its respective Project NPV of the Cash Flows;

Computation of Normal / Discounted Pay Back Period: Here, the period is computed for each project, based on cumulative normal /discounted cash flows: If the cumulative value is less than or equal to zero, the period is considered as 12 months (it means that the net cumulative cash flow has not yet paid back the initial investment); Once the value turns positive in a particular year, the period for such year is observed at a proportion of actual discounted cash flow to the cumulative CF; This gives the period less than 12 months in such year; Once this is computed, total of all the years is taken and divided by 12, to arrive at the Payback period in no.of years.

Part 2:

Based on the given data, pls find below steps, workings and answers:

  • Explain how you determine the initial cash flows: Only the cost of Equipment and the increase in the net working capital should be considered as cash outflows; Although the land can be sold, the same is being replaced with a separate contract with a different company to handle the toxic waste; Hence, it is evident that these land (handling toxc waste) and this product (market) of zither are different. Hence, the proceeds from the sale of land not to be considered here.

  • Discuss the notion of sunk costs and identify the sunk cost in this project: The marketing costs are already spent and hence these are considered as sunk costs in this project; Sunk costs are not required to be considered as part of the Projected financials/Capital Budgeting techniques.

  • Verify how you determine the annual operating cash flows: As provided below in the workings (Net Income + Depreciation + working Capital changes)

  • Explain how you determine the terminal cash flows at the end of the project’s life: As provided below in the workings (Net Income + Depreciation + working Capital changes + After Tax salvage value)

  • Calculate the NPV and IRR of the project and decide if the project is acceptable: NPV is $ 1831717.37 and the IRR is 35.22%; Since, the NPV is positive and the IRR is higher than the Cost of Capital, this Project is acceptable.

  • If the company that is implementing this project is a publicly traded company, explain and justify how this project will impact the market price of the company’s stock: This will have a positive impact on the stock price, as there shall be new product/market in to which the company is progressing as well as the internal accruals are being used for the expansion of the operationsl of the company. Hence, this shall be considered as a positive news for the Stock market.


Related Solutions

Assignment Tasks This assignment consists of three parts as follows (100 marks): Part 1(30 marks): Write...
Assignment Tasks This assignment consists of three parts as follows : Part 1: Write a report of 300 words that covers the following:  Fixed Cost  Variable Cost  Profit Part 2 : Solve the following questions by completing the required calculations:  A factory has fixed cost of RO 10,000 and produces 500 units of a product at a variable cost of RO 75 per unit. Calculate Total Cost of the factory  Calculate variable cost per unit...
Assignment Specifications Task Criteria: There are two parts to this assignment. Part 1 – Analysis of...
Assignment Specifications Task Criteria: There are two parts to this assignment. Part 1 – Analysis of Mini Case (must demonstrate understanding of the theories or concepts in the case and their applications. Part 2 – Critical Thinking. Must demonstrate critical thinking skills to develop a valid discussion and with supporting evidence to your chosen product and target markets. Details of task requirements: Part 1: Mini Case (video) Analysis of Market Segmentation, watch “Grilled Burger” ad and answer 2 questions below....
TWO PARTS PROBLEM PART 1)  Statement of the Assignment: Please prepare a comprehensive list of financial ratios...
TWO PARTS PROBLEM PART 1)  Statement of the Assignment: Please prepare a comprehensive list of financial ratios . Write a brief explanation below each financial ratio, e.g. what does the financial ratio measures or what the significance of it is. For example: Current Ratio = Current Assist / Current Liabilities Current ratio measures whether our current assets, if liquidated, are sufficient to pay all of our current liabilities. A CR of 1.5, for example, shows that if we were to liquidate...
This question has two parts. Please answer both, thank you! Part A.) On the first day...
This question has two parts. Please answer both, thank you! Part A.) On the first day of the fiscal year, a company issues a $8,200,000, 9%, 9-year bond that pays semiannual interest of $369,000 ($8,200,000 × 9% × ½), receiving cash of $6,868,206. Journalize the first interest payment and the amortization of the related bond discount. Round to the nearest dollar. If an amount box does not require an entry, leave it blank. Interest Expense Discount on Bonds Payable Cash...
This problem consists of two parts Part I A portion of the Stockholders’ Equity section of...
This problem consists of two parts Part I A portion of the Stockholders’ Equity section of Hatten Corporation’s balance sheet as of December 31, 2016, appears below. Dividends have not been paid for the years 2014 and 2015. There has been no change in the number of shares of stock issued and outstanding during these years. Assume that the board of directors of Hatten Corporation declares a dividend of $28,650 after completing operations for the year 2016.      Stockholders’ Equity...
This problem consists of two parts. Part I A portion of the Stockholders’ Equity section of...
This problem consists of two parts. Part I A portion of the Stockholders’ Equity section of Hatten Corporation’s balance sheet as of December 31, 2016, appears below. Dividends have not been paid for the years 2014 and 2015. There has been no change in the number of shares of stock issued and outstanding during these years. Assume that the board of directors of Hatten Corporation declares a dividend of $28,650 after completing operations for the year 2016. Stockholders’ Equity Preferred...
Auditing - Chapter Seven This assignment consists of one question with two parts listed below. Answer...
Auditing - Chapter Seven This assignment consists of one question with two parts listed below. Answer the questions and submit to the drop box on the assigned date. Your paper should be double-spaced and at minimum two pages long. You may use any format for the answer, however, when appropriate, the Conclusion, Rule, Application, Conclusion format is preferable for clarity and better understanding. Question Importance of materiality judgments Explain how auditors determine planning materiality and performance materiality. What happens if...
NOTE: For this assignment, you will make two HTML pages. First, highlight and copy the following...
NOTE: For this assignment, you will make two HTML pages. First, highlight and copy the following code, paste it into your editor, and save the document as NumberCheck.html. <!doctype html> <html> <head> <meta charset="UTF-8"> <title>Number Check</title> <script type="text/javascript"> /* <![CDATA[ */ function checkTheNumber() { var num = document.getElementById("theNumber").value; var msg = ""; if (num >= 100) msg = msg + "The number is greater than "; msg = msg + "or equal to 100."; alert(msg); } /* ]]> */ </script>...
IA 2 is a two-part assignment. The first part requires you to identify, by statute number,...
IA 2 is a two-part assignment. The first part requires you to identify, by statute number, and summarize the statute that prohibits telephone solicitors from blocking or interfering with a residential telephone subscriber's caller ID function.
University Hospital has two separate units that are part of the hospital but are two separate...
University Hospital has two separate units that are part of the hospital but are two separate facilities. The first is the main hospital that performs emergency room functions, surgeries, and recovery. Separate from the main hospital is an outpatient surgery center. In an effort to control costs, some of the patients that need minor surgeries are routed to the outpatient surgery center. The outpatient surgery center treats patients in three activity centers: (1) Surgery, (2) Phase I recovery, where patients...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT