Question

You have been hired as a financial consultant by BUBBA corporation. BUBBA is considering investing in a new machine to produc

BUBBA has provided you with the following information: Full price of machine is $150,000. There is no increase in net working

0 0
Add a comment Improve this question Transcribed image text
Answer #1
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

AutoSave © of HO- Book1 - Excel Sign in - File Home Insert Draw Page Layout Formulas Data Review View Help O Tell me what you

Add a comment
Know the answer?
Add Answer to:
You have been hired as a financial consultant by BUBBA corporation. BUBBA is considering investing in...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You have recently been hired as a consultant for a personal financial planning firm. One of...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT