Question

In: Finance

A company is intending to invest in a capital budgeting project to manufacture a medical testing...

A company is intending to invest in a capital budgeting project to manufacture a medical testing device and has projected the following sales:

Year 1 Year 2 Year 3                    Year 4 Year 5

50,000                   66,400                   81,200                   68,500                   54,500

The installed cost of the new assets will be $18,500,000 which will be depreciated using the 7-year MACRS schedule. The assets will have a salvage value of $3,700,000. Initial NWC requirements are $1,500,000 and additional working capital needs are estimated to be 15% of the projected sales increases for the following year. Total fixed costs are $2,000,000 per year. The medical device has a selling price of $300 per unit and variable production costs are $175. The firm has a marginal tax rate of 35% and a required rate of return of 18%. Analyze this project and give your recommendation as to whether they should invest in it or abandon it.

caculate all the results below:

FC 2,000,000
Profits
-DEP
EBT
-TAXES
EAT
+DEP
-/+ NWC 738,000

Solutions

Expert Solution


Related Solutions

It is a capital budgeting problem. Assume that XYZ company wants to invest in a new...
It is a capital budgeting problem. Assume that XYZ company wants to invest in a new project that needs $2.65 billion (time 0). It is expected that it will give cash flows as given below. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5-10 Year 11 Year 12-14 Year 15 2,650 million 0 million 0 million 100 million 200 million 550 million 400 million 200 million 50 million Find the NPV and IRR of the project. Should...
6) Refer to the capital budgeting narrative. What is the MIRR of the project? Capital Budgeting...
6) Refer to the capital budgeting narrative. What is the MIRR of the project? Capital Budgeting Narrative: (Use the following information for questions referring to the narrative): Aferine Electric is considering a new project. The initial investment required is $106,639.60 and the cost of capital is 8%. Expected cash flows over the next four years are given below: Years Cash Flow ($) 1 7,000 2 37,000 3 41,000 4 90,000 A) 17.1% B) 13.8% C) 14.1% D) 15.0% E) 8%
Company X is evaluating a proposed capital budgeting project (project Sigma) that will require an initial...
Company X is evaluating a proposed capital budgeting project (project Sigma) that will require an initial investment of $850,000. Company X has been basing capital budgeting decisions on a project's NPV; however, its new CFO wants to start using the IRR method for capital budgeting decisions. The CFO says that the IRR is a better method because returns in percentage form are easier to understand and compare to required returns. Blue Llama Mining Company's WACC is 9%, and project Sigma...
Sigma Company is examining the cash flows of the capital budgeting project shown below. The project...
Sigma Company is examining the cash flows of the capital budgeting project shown below. The project is expected to cost $400,000. Sigma has a required rate of return of 12%, and a maximum acceptable payback period of 3 years. 0 1 2 3 4 5    ($400,000) $150,000 $150,000 $200,000 $100,000 $100,000 a. Calculate the NPV of the project. Based on the NPV analysis, should Sigma accept the project? Why or why not? b. Calculate the payback period of the...
You are evaluating a capital budgeting project for your company that is expected to last for...
You are evaluating a capital budgeting project for your company that is expected to last for six years. The project begins with the purchase of a $1,200,000 investment in equipment. You are unsure what method of depreciation to use in your analysis, straight-line depreciation or the 5-year MACRS accelerated method. Straight-line depreciation results in the cost of the equipment depreciated evenly over its life. The 5-year MACRS depreciation rates are 20%, 32%, 19%, 12%, 11%, and 6%. Your company's WACC...
Exercise Example - Capital Budgeting Project Analysis - Chapter 5 As director of capital budgeting, you...
Exercise Example - Capital Budgeting Project Analysis - Chapter 5 As director of capital budgeting, you are reviewing three potential investment projects with the following cost and cash flow projections.   Cash Flow Project A Project B Project C Investment Cost ($500,000) ($375,000) ($475,000) Year One Cash Flow $200,000 $175,000 $250,000 Year Two Cash Flow $180,000 $50,000 $200,000 Year Three Cash Flow $100,000 $50,000 $75,000 Year Four Cash Flow $80,000 $50,000 $30,000 Year Five Cash Flow $140,000 $300,000 $30,000 Calculate the...
Capital Budgeting Theoretical Framework. Capital budgeting for a foreign project uses the same theoretical framework as...
Capital Budgeting Theoretical Framework. Capital budgeting for a foreign project uses the same theoretical framework as domestic capital budgeting. What are the basic steps in domestic capital​ budgeting?
Petram company is considering two alternative capital budgeting projects. Project A is an investment of $300,000...
Petram company is considering two alternative capital budgeting projects. Project A is an investment of $300,000 to renovate office facilities. Project B is an investment of $600,000 to expand diagnostic capabilities. Relevant cash flow data for the two projects over their expected two-year lives are as follows: Year 1 Year 2    Pr.     Cash Flow    Pr.        Cash Flow Project A 0.18 $     0 0.08 $    0 0.64 100,000 0.84 100,000 0.18 200,000 0.08 200,000 Project...
Capital budgeting The company is going to analyse a new investment project, which has the following...
Capital budgeting The company is going to analyse a new investment project, which has the following characteristics: Unit price                                                                $5.00 Annual unit sales                                                   40,000 Variable cost per unit                                           $2.5 Investment into new machinery (t=0)              $400,000 Investment in working capital                           $50,000               (fully recovered at the end of project) Project life                                                              6 years Annual depreciation                                             $60,000 Market value of machinery (t=6)                       80,000 Tax rate                                                                    40 %                     (the same for profits and capital...
23- Celsius Corp. is conducting a capital budgeting analysis to decide whether to invest in a...
23- Celsius Corp. is conducting a capital budgeting analysis to decide whether to invest in a new project which has an expected life of 5 years. The following information is available: The installed cost of the new equipment is $360,000. Installation will cost an additional $40,000 The equipment will be depreciated using 5-year MACRS depreciation over the 5-year life of the project. An initial NOWC investment equal to 10 percent of year 1 sales will also be required. The equipment...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
Tax rate 35%
Calculation of annual depreciation
Depreciation Year-1 Year-2 Year-3 Year-4 Year-5 Total
Cost $           18,500,000 $     18,500,000 $      18,500,000 $      18,500,000 $     18,500,000
Dep Rate 14.29% 24.49% 17.49% 12.49% 8.93%
Depreciation Cost * Dep rate $             2,643,650 $       4,530,650 $        3,235,650 $        2,310,650 $       1,652,050 $      14,372,650
Calculation of after-tax salvage value
Cost of machine $     18,500,000
Depreciation $     14,372,650
WDV Cost less accumulated depreciation $       4,127,350
Sale price $       3,700,000
Profit/(Loss) Sale price less WDV $         (427,350)
Tax Profit/(Loss)*tax rate $         (149,573)
Sale price after-tax Sale price less tax $       3,849,573
Calculation of annual operating cash flow
Year-1 Year-2 Year-3 Year-4 Year-5
No of units                       50,000                 66,400                  81,200                  68,500                 54,500
Selling price $                        300 $                  300 $                   300 $                   300 $                  300
Operating cost $                        175 $                  175 $                   175 $                   175 $                  175
Sale $           15,000,000 $     19,920,000 $      24,360,000 $      20,550,000 $     16,350,000
Less: Operating Cost $             8,750,000 $     11,620,000 $      14,210,000 $      11,987,500 $       9,537,500
Contribution $             6,250,000 $       8,300,000 $     10,150,000 $       8,562,500 $       6,812,500
Less: Fixed cost $             2,000,000 $       2,000,000 $        2,000,000 $        2,000,000 $       2,000,000
Less: Depreciation $             2,643,650 $       4,530,650 $        3,235,650 $        2,310,650 $       1,652,050
Profit before tax (PBT) $             1,606,350 $       1,769,350 $       4,914,350 $       4,251,850 $       3,160,450
Tax@35% PBT*Tax rate $                562,223 $          619,273 $        1,720,023 $        1,488,148 $       1,106,158
Profit After Tax (PAT) PBT - Tax $             1,044,128 $       1,150,078 $       3,194,328 $       2,763,703 $       2,054,293
Add Depreciation PAT + Dep $             2,643,650 $       4,530,650 $        3,235,650 $        2,310,650 $       1,652,050
Cash Profit after-tax $             3,687,778 $       5,680,728 $       6,429,978 $       5,074,353 $       3,706,343
Calculation of working capital movement
Projected Increase in sale in next year $                             -   $             4,920,000 $       4,440,000 $      (3,810,000) $      (4,200,000)
Additional working capital required $               1,500,000 $                738,000 $          666,000 $          (571,500) $          (630,000)
Calculation of NPV
18.00%
Year Capital Working capital Operating cash Annual Cash flow PV factor, 1/(1+r)^time Present values
0 $         (18,500,000) $      (1,500,000) $    (20,000,000)                 1.0000 $    (20,000,000)
1 $         (738,000) $        3,687,778 $        2,949,778                 0.8475 $        2,499,811
2 $         (666,000) $        5,680,728 $        5,014,728                 0.7182 $        3,601,499
3 $          571,500 $        6,429,978 $        7,001,478                 0.6086 $        4,261,315
4 $          630,000 $        5,074,353 $        5,704,353                 0.5158 $        2,942,242
5 $             3,849,573