Question

Problem 12.23 (Excel Video) Cullumber Company management is considering a project that will require an initial...

Problem 12.23 (Excel Video) Cullumber Company management is considering a project that will require an initial investment of $50,000 and will last for 10 years. No other capital expenditures or increases in working capital are anticipated during the life of the project. What is the annual EBIT that will make the project economically viable if the cost of capital for the project is 10 percent and the firm will depreciate the investment using straight-line depreciation and a salvage value of $0? Assume that the marginal tax rate is 30 percent. (Do not round intermediate calculations. Round final answer to 2 decimal places, e.g. 52.75.) Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you’ve been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.) EBIT $

Homework Answers

Answer #1
NPV = OCF*PVIFA(10,10)-50000
For being economically viable, the NPV should be atleast 0.
Therefore, 0 = [EBIT*(1-t)+Depreciation]*PVIFA(10,10)-50000
Substituting values, we have
0 = (EBIT*0.7+5000)*6.14457-50000
EBIT*0.7*6.14457 = 50000-5000*6.14457
EBIT = (50000-5000*6.14457)/(0.7*6.14457) = $     4,481.81
CHECK:
NPV = (4481.81*0.7+5000)*6.14457-50000 = $             0.01
Almost 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Problem 10.21 (Excel Video) Oriole Communication Corp. is investing $10,091,700 in new technologies. The company’s management...
Problem 10.21 (Excel Video) Oriole Communication Corp. is investing $10,091,700 in new technologies. The company’s management expects significant benefits in the first three years after installation (as can be seen by the following cash flows), and smaller constant benefits in each of the next four years. Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from...
Question 13 For the year ended June 30, 2017, Cullumber Clothing Company has total assets of...
Question 13 For the year ended June 30, 2017, Cullumber Clothing Company has total assets of $92,000,000, ROA of 9.00 percent, ROE of 15.00 percent, and a net profit margin of 8.00 percent. What are the company's net income and net sales? Calculate the firm’s debt-to-equity ratio. (Round net income and net sales to the nearest whole dollar, e.g. 25 and round debt to equity ratio to 1 decimal place, e.g. 15.2%.) Excel Template (Note: This template includes the problem...
Problem 5.33 (Excel Video) You have $12,000 in cash. You can deposit it today in a...
Problem 5.33 (Excel Video) You have $12,000 in cash. You can deposit it today in a mutual fund earning 9.2 percent semiannually, or you can wait, enjoy some of it, and invest $11,000 in your brother’s business in two years. Your brother is promising you a return of at least 11.6 percent on your investment. Whichever alternative you choose, you will need to cash in at the end of 10 years. Assume your brother is trustworthy and both investments carry...
Blossom Corp. management is planning to convert an existing warehouse into a new plant that will...
Blossom Corp. management is planning to convert an existing warehouse into a new plant that will increase its production capacity by 45 percent. The cost of this project will be $8,467,824. It will result in additional cash flows of $2,312,200 for the next eight years. The discount rate is 11.83 percent. Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template,...
10.21 Sunland Communication Corp. is investing $8,921,700 in new technologies. The company’s management expects significant benefits...
10.21 Sunland Communication Corp. is investing $8,921,700 in new technologies. The company’s management expects significant benefits in the first three years after installation (as can be seen by the following cash flows), and smaller constant benefits in each of the next four years. Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for...
You are a freshman in college and are planning a trip to Europe when you graduate...
You are a freshman in college and are planning a trip to Europe when you graduate from college at the end of four years. You plan to save the following amounts annually, starting today: $610, $660, $660, and $840. If you can earn 4.80 percent annually, how much will you have at the end of four years? (Round answer to 2 decimal places, e.g. 15.25. Do not round factor values.) Excel Template (Note: This template includes the problem statement as...
You own all of the equity in a debt-free app development business that generates cash flows...
You own all of the equity in a debt-free app development business that generates cash flows of $420,000 each year in perpetuity. The cost of assets, kAssets is 10 percent and the tax rate is 25 percent. What is the value of your all-equity firm? Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this...
Please do not use excel to solve problem ​(Capital rationing​) The Cowboy Hat Company of​ Stillwater,...
Please do not use excel to solve problem ​(Capital rationing​) The Cowboy Hat Company of​ Stillwater, Oklahoma, is considering seven capital investment proposals for which the total funds available are limited to a maximum of ​$17 million. The projects are independent and have the costs and profitability indexes associated with them shown in the popup​ window: PROJECT ---- COST ------ PROFITABILITY INDEX A ------------- 4,000,000 ------------- 1.13 B ------------- 2,000,000 ------------- 1.03 C ------------- 6,000,000 ------------- 1.31 D ------------- 5,000,000...
Problem 1 (85% of grade) Summer Tyme, Inc. has cash available and is considering a new...
Problem 1 (85% of grade) Summer Tyme, Inc. has cash available and is considering a new three-year expansion project that requires an initial fixed asset investment of $195.5 million. The fixed assets will be depreciated straight-line to zero over its three-year tax life. The fixed assets will have a market value of $95,871,755 at the end of the project. The project is estimated to generate following revenues during those three years: $84,563,662 for year one, $66,352,100 for year two, and...
(a) Develop proforma Project Income Statement Using Excel Spreadsheet (b) Compute Net Project Cash flows, NPV,...
(a) Develop proforma Project Income Statement Using Excel Spreadsheet (b) Compute Net Project Cash flows, NPV, IRR and PayBack Period (c) Develop Problem-Solving and Critical Thinking Skills 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $   200,000 2) New equipment cost $ (200,000) 9) Sales increase per year 5% 3) Equipment ship & install cost $     (35,000) 10) Operating cost: $ (120,000) 4) Related start up cost $       (5,000)     (60 Percent of...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT