4. A Capital Budgeting Project Standard Food Company plans to establish a new production line for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
4. A Capital Budgeting Project Standard Food Company plans to establish a new production line for producing ice creams. The equipment costs $2,500,000 with a 10-year life. For depreciation the company is using MACRS method. The project is expected to generate $ 1,050,000 sales in the first year and the sales is expected to grow by 5% every year afterwards. The annual fixed expense is $ 100,000 per year, and the variable cost is always 35% of the sales of the same year. Starting at year 0, the company needs to maintain an inventory that is worth 15% of next year's sale. At the end of the project, no inventory needs to be maintained and all existing inventories will be liquidated. The tax rate is 25% for capital gains and net income. The cost of capital (minimum required return) is 12% for the company, while the firm is paying $10,000 interest to every year debt holders. as financing cost. Three years before the project starts, the company spent $40,000 for marketing research. a. Create a capital budgeting table with the calculation of Free Cash Flows for each year of the project. (22 points, you must show all your work to earn full credits) MACRS Depreciation rate for recover period of 10 years 1 2 31 4 10% 18% 14.40% 11.52% 5 9.22% 6 7 8 9 10 7.37% 6.55% 6.55% 6.56% 6.55% 3.28% You can copy and paste the MACRS table above to your spreadsheet for calculation. b. Calculate the Project's NPV, IRR, Regular Payback Period, Discounted Payback Period and Modified Internal Rate of Return, assuming a 9% reinvestment rate (15 points) Please show all your work for full credit. c. From part b, please calculate the sensitivity of NPV to sales (3 points) and the sensitivity of NPV to the cost of equipment at year 0 (3 points). (Hint: you can put 10% increase for each variable and calculate the corresponding NPV). Which variable would affect NPV more effectively? (Extra credit 3 points if you create a Scatter Chart in Excel to show the sensitivities of the two variables) | 4. A Capital Budgeting Project Standard Food Company plans to establish a new production line for producing ice creams. The equipment costs $2,500,000 with a 10-year life. For depreciation the company is using MACRS method. The project is expected to generate $ 1,050,000 sales in the first year and the sales is expected to grow by 5% every year afterwards. The annual fixed expense is $ 100,000 per year, and the variable cost is always 35% of the sales of the same year. Starting at year 0, the company needs to maintain an inventory that is worth 15% of next year's sale. At the end of the project, no inventory needs to be maintained and all existing inventories will be liquidated. The tax rate is 25% for capital gains and net income. The cost of capital (minimum required return) is 12% for the company, while the firm is paying $10,000 interest to every year debt holders. as financing cost. Three years before the project starts, the company spent $40,000 for marketing research. a. Create a capital budgeting table with the calculation of Free Cash Flows for each year of the project. (22 points, you must show all your work to earn full credits) MACRS Depreciation rate for recover period of 10 years 1 2 31 4 10% 18% 14.40% 11.52% 5 9.22% 6 7 8 9 10 7.37% 6.55% 6.55% 6.56% 6.55% 3.28% You can copy and paste the MACRS table above to your spreadsheet for calculation. b. Calculate the Project's NPV, IRR, Regular Payback Period, Discounted Payback Period and Modified Internal Rate of Return, assuming a 9% reinvestment rate (15 points) Please show all your work for full credit. c. From part b, please calculate the sensitivity of NPV to sales (3 points) and the sensitivity of NPV to the cost of equipment at year 0 (3 points). (Hint: you can put 10% increase for each variable and calculate the corresponding NPV). Which variable would affect NPV more effectively? (Extra credit 3 points if you create a Scatter Chart in Excel to show the sensitivities of the two variables) |
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Vista Company purchased a delivery truck. The total cash payment was $26,784, including the following items. Negotiated purchase price $23,040, Installation of special shelving $1,056, Painting and...
-
For a stock, you are given:. (a) The current stock price is $50.00, (b) = 0.08, (c) The continuously compounded risk-free interest rate is r = 0.04, (d) The prices for one-year European calls (C)...
-
Standard Food Company plans to establish a new production line for producing ice creams. The equipment costs $2,500,000 with a 10-year life. For depreciation the company is using MACRS method. The...
-
What is the cofactor of an entry of a matrix? How are cofactors used to find the determinant of the matrix?
-
In which section of the statement of cash flows will Big report the cash collected in question 23?
-
Partial pressure of a component in a mixture is (a) the average of pressure of all the components (b) the total pressure minus its own pressure (c) the pressure exerted by the component (d) the...
-
(Appendix) Record materials and labor transactions (Learning Objective 6) Make the journal entries to record the purchase and use of direct materials and direct labor made by Dock Guard in Ell-27.
-
Recording Adjusting and Closing Entries and Preparing a Balance Sheet and Income Statement Including Earnings per Share (AP4-7) Ellis, Inc., a small service company, keeps its records without the...
-
Which of the following has been an unexpected effect of off shoring. A.Companies who use off shoring find that their travel costs decrease B.Energy cost for the company rise increasing the benefits...
-
Standard deviation is wrong for stock b and d is wrong
-
Describe the nature of the Smart supply chain sustainability? What is the objective of Smart supply chain sustainability? Created a brief background? What Methods? Data collection method Data...
-
40.The oral stage is about _______________ and the anal stage is about ______________. a. Dependence and trust; control and compliance b. Control and compliance; dependence and trust c. Dependence...
-
6. What is the magnitude of charge on a particle that is moving at 3.6 x 106 m/s and experiences a magnetic force of 1.2 x 10-10 N when it encounters a magnetic field of 3.0 T? a. What are the...
-
Tochi Kogyo* Company 2021 1) Perform a five forces analysis on the Japanese water treatment chemical industry. For each of the forces, write the name of the force, your conclusion about its level,...
-
We know that profit is = TR - TC Total income is 18Q - 3q Total cost is 12+ Q What is the profit drop? What are the break even points of profit and cost When is the profit the highest and what is the...
-
The risk report is not needed when conducting the Plan Risk Responses process because the necessary risk information is in the risk register? A. True B. False
-
Information graphics, also called infographics, are wildly popular, especially in online environments. Why do you think infographics continue to receive so much attention? How could infographics be...
-
The total assets and liabilities at the beginning and end of the year for Luther Company are listed below. Determine Luther Companys net income or loss for the year under each of the following...
-
Below is information from the statement of retained earnings of Mrs. Bells Cookies, Inc. for a recent year. Prepare the statement of retained earnings for Mrs. Bells Cookies in good form. You will...
-
Primorsk Corporation began the year 20x6 with cash of $55,900. In addition to earning a net income of $32,500 and paying a cash dividend of $19,500, Primorsk borrowed $78,000 from the bank and...
Study smarter with the SolutionInn App