NPV | $4,874.33 |
The machine should be purchased since NPV is positive.
Workings
INPUTS | |
Initial cost | 150000 |
Tax rate | 30% |
Selling price | 10000 |
Working capital | 0 |
MARR | 12% |
EBITDA | 40000 |
Year | Depreciation rate |
1 | 33.00% |
2 | 45.00% |
3 | 15.00% |
4 | 7.00% |
5 | |
6 |
Year | Initial cash flow | Tax shield= Tax rate*MACRS rate*Initial cost | EBITDA*(1-Tax) | Working capital | Salvage-After tax | Net cash flows |
0 | -150000 | 0 | -150000 | |||
1 | 14850 | $28,000.00 | 42850 | |||
2 | 20250 | $28,000.00 | 48250 | |||
3 | 6750 | $28,000.00 | 34750 | |||
4 | 3150 | $28,000.00 | 31150 | |||
5 | 0 | $28,000.00 | 28000 | |||
6 | 0 | $28,000.00 | 0 | 7000 | 35000 | |
NPV | $4,874.33 |
You have been hired as a financial consultant by BUBBA corporation. BUBBA is considering investing in...
You have recently been hired as a consultant for a personal financial planning firm. One of your first projects is creating a retirement plan for a couple, Xavier and Elizabeth Martell. They have just celebrated their 40th birthdays and after paying for their children’s education, they have decided to get serious about saving for retirement. Xavier and Elizabeth hope to retire 25 years from now (on their 65th birthdays), and they expect to live until age 90. Their hope is...
Excel Online Structured Activity: Statement of cash flows You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year....
Excel Online Structured Activity: Statement of cash flows You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year....
You have been hired as a consultant to ABC company that is seeking to increase its value. ABC has asked you to estimate the value of two privately held companies that ABC is considering acquiring. But first, the senior management of ABC would like for you to explain how to value companies that don't pay any dividends. You have structured your presentation around the following questions. 1. List the two types of assets that companies own. 2. What are assets-in-place?...
Excel Online Structured Activity: Statement of cash flows You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year....
You have been engaged as a consultant to design a master budget model and then to assist Helping Hand Corp. in making some management decisions based on that master budget. Helping Hand is a small, rapidly growing wholesaler of consumer electronic products. The company's main product lines are small kitchen appliances and power tools. The marketing manager has recently completed a sales forecast. She believes the company's sales will increase by 2 percent each month over the previous month's sales...
Exhibit 10.1 Assume that you have been hired as a consultant by CGT, a major producer of chemicals and plastics, including plastic grocery bags, styrofoam cups, and fertilizers, to estimate the firm's weighted average cost of capital. The balance sheet and some other information are provided below. Assets Current assets Net plant, property, and equipment Total assets $38,000,000 $101,000,000 $139,000,000 Liabilities and Equity Accounts payable Accruals Current liabilities Long-term debt (40,000 bonds, $1,000 par value) Total liabilities Common stock (10,000,000...
Exhibit 10.1 Assume that you have been hired as a consultant by CGT, a major producer of chemicals and plastics, including plastic grocery bags, styrofoam cups, and fertilizers, to estimate the firm's weighted average cost of capital. The balance sheet and some other information are provided below. Assets Current assets $38,000,000 Net plant, property, and equipment $101,000,000 Total assets $139,000,000 Liabilities and Equity Accounts payable $10,000,000 Accruals $9,000,000 Current liabilities $19,000,000 Long-term debt (40,000 bonds, $1,000 par value) $40,000,000 Total...
Suppose you have been hired as a management consultant by a major oil company to help it optimally price gasoline at its service stations. Your client wants to know what wl happen to gasoline demand if it increases gasoline prices by one cent higher than its nearest competitors. One of the members of your consulting team, Debbie, shares that one time in college she stopped buying gasoline from a service station that was one cent more expensive Based on this...
You have been hired as a marketing consultant to Big Book Publishing, Inc., and you have been approached to determine the best selling price for the hit calculus text by Whiner and Istanbul entitled Fun with Derivatives. You decide to make life easy and assume that the demand equation for Fun with Derivatives has the linear form q = mp + b, where p is the price per book, 9 is the demand in annual sales, and m and b...