100% Original, Plagiarism Free, Tailored to your instructions

Order Now!

FIN 4303-Blue Bottling, Inc. (BBI) is a bottling company

Blue Bottling, Inc. (BBI) is a bottling company and is considering expanding into filling 16-ounce bottles. In order to do so, BBI must purchase a new bottling machine. The machine would not replace the machine used to fill 32-ounce bottles. The risk of this project is similar to the current risk of the company. BBI uses Net Present Value as its investment decision method. Therefore, BBI executives have decided that their weighted average cost of capital would be an appropriate discount rate to use when analyzing the project.About the MachineBBI managers estimate the cost of the machine to be $260,000. In order for the machine to be usable for BBI, it must be modified, costing $40,000. The machine will be depreciated using straight-line depreciation, assuming a 7-year life and $30,500 salvage value. BBI managers believe that the machine will be replaced at the end of 7 years at which time it will be sold for its salvage value. During the 7 years of its use, managers estimate annual earnings before interest, depreciation, and taxes (EBITDA) to be $60,000. There will be an increase in net working capital of $5000 with the new press, due to increased accounts receivable and inventory costs. Weighted Average Cost of CapitalCurrent investigation shows that the firm has a 40% marginal tax rate. (Round all numbers to one-hundredth of one percent).DebtThe firm has 7000 of its $1000 par, 18-year, 5% semi-annual bonds that are currently outstanding and being quoted at 104:8.Common StockBBI common stock is currently trading for $50 per share and there are 100,000 shares issued and outstanding. There are two methods of computing the cost of capital and you should average the two values for your final cost of common stock.The firm will pay annual dividends of $3.00 per share in the coming year. The firm’s dividends and earnings have been growing at an annual rate of 3.5%, and this is expected to continue in the future. Lang’s beta is current .8 and the current 90-day t-bill rate is 2.5% while the historic market average is 10%.Requirements of the Assignment(Due Module 5) Using Excel, create a spreadsheet that calculates all relevant cash flows (i.e., initial investment, periodic cash flows, and terminal value). Note: The spreadsheet should have data at the top and the cash flow calculations completely in equations, or picking up numbers from a previous cell. The instructor should be able to change inputs. The spreadsheet automatically adjusts to those changes. Round all numbers to the nearest dollar.Submit the spreadsheet by Sunday of Week 5 so the instructor can review your work and provide suggestions for improvement. No points will be assigned for this, but points will be deducted from your final grade on the Portfolio Project if you fail to submit this assignment by the end of Week 5. Additionally, work received later than Week 6 of the course will not receive feedback prior to the final grading of the Portfolio Project.(Due Module 6) Compute the weighted-average cost of capital (WACC) for the chosen firm on your spreadsheet. Take this number out to the nearest hundredth of a percent (e.g., 33.33%). There is no preferred stock in the company. Determine the weight of debt and common equity by the current market value. Complete Requirement 2 and submit your work by Sunday of this week so your professor can review and provide suggestions for improvement. No points will be assigned for this, but points will be deducted from your final grade on the Portfolio Project if you fail to submit this assignment by the end of Week 6. Additionally, work received later than Week 7 of the course will not receive feedback prior to the final grading of the Portfolio Project.Using Excel equations, compute the NPV and IRR.BBI management expressed concern over their estimate of EBITDA of $60,000, especially if the economy deteriorated suddenly. Because of this concern, you have been asked to complete a sensitivity analysis, computing the NPV if EBITDA were $54,000 instead of $60,000. (Note that if your spreadsheet is set up correctly, you should be able to change the $60,000 data input to $54,000 and all calculations will change automatically, including the calculation of a new NPV and IRR.) In fact, managers would like an estimate of the break-even level of EBITDA, if you could provide that information.BBI management has also expressed concern over the cost of the new machine. There has been increased demand for the larger bottles so prices have risen recently on the machine. It is possible that the machine will cost 10% more (i.e., $286,000), with installation not changing. If this occurs, managers believe that salvage value will also rise by 10%. Managers want to be sure the project is still a good one to accept if the machine costs more than originally anticipated. Use EBITDA of $70,000.Write a 1-3 page memo (no more, no less) to the managers of BBI discussing your findings. Assume that the managers do not understand capital budgeting, therefore you should minimize financial jargon in your memo. You should assume the managers will review your spreadsheet prior to reading the memo and before making a final decision.Please include some ideas for the memo

Our Service Charter

  1. Excellent Quality / 100% Plagiarism-Free

    We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers.
  2. Free Revisions

    We keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed.
  3. Confidentiality / 100% No Disclosure

    We make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service.
  4. Money Back Guarantee

    If the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 14-30 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% money-back in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit.
  5. 24/7 Customer Support

    We have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.

Excellent Quality
Zero Plagiarism
Expert Writers

Instant Quote

Instant Quote
Single spaced
approx 275 words per page
Urgency (Less urgent, less costly):
Total Cost: NaN

Get 10% Off on your 1st order!