Estimating Project Cash FlowsABC Golf Equipment Corporation is considering venturing into the golf club manufacturing business with a new driver golf club. As the CFO, it is your job is to add the financial perspective to the decision. It is estimated that the current cost (t=0) of the machinery to create the golf club would cost $2,050,000 including all installation expenses. The company also expects to have to maintain $100,000 of inventories associated with the manufacturing of the golf clubs. The machinery is expected to last ten years. The production equipment is expected to last ten years. The projectâs cash inflows are expected at begin during year 1 (t=1) and continue through all ten years (t=10). The company expects to sell 500 golf clubs per year at an anticipated price of $500 per golf club. Operating costs, excluding depreciation, are anticipated to be 75% of sales each year. The projectâs cost of capital is 12% and the firmâs tax rate is 35%. Determine the projectâs cash flows for years t=0 to t=10.Note: Donât forget to consider depreciation (use straight line) when doing the calculations. The equipment is expected to have a resale value of only $40,000 at the end of the tenth year, so this amount is the salvage for purposes of the analysis.Before you start the analysis, you can work through the example below for guidance.Acme Company is considering the purchase of new equipment that will be used to produce widgets. As the CFO, youâve been asked to complete a financial analysis of cash flows associated with this new purchase. It is estimated that the cost (t=0) of the equipment will be $285,000, with shipping and installation costs of $25,000. The machinery is expected to last 5 years, and is expected to sell for $30,000 at the end of the 5-year period (this remaining value is referred to as the âsalvage valueâ). Assume that the salvage value of the equipment will be equal to the market value of the equipment (i.e., there will be no gain or loss on sale of the equipment at end of Year 5). The projectâs cash inflows will begin during year 1 (t=1) and will continue through all five years (t=5). The company expects to sell 600 widgets each year at a price of $500 per widget. Operating costs, excluding depreciation, are anticipated to be 70% of sales each year. The firmâs tax rate is 35%. Calculate:1) The initial investment cash outlay2) Straight-line depreciation3) Operating cash flows for the 5-year periodAnswers:1) Compute the initial investment cash outlay. This is the total cost of equipment purchase ($285,000), installation and shipping ($25,000), and change in net working capital ($20,000):= $285,000 + $25,000 + $20,000= $330,0002) Calculate straight-line depreciation, where salvage value is $30,000 and useful life of the equipment is 5 years: = ($330,000 – $30,000) = $300,000 = ($300,000 / 5 years) = $60,0003) Calculate operating cash flows, where CFt = (revenues – costs)*(1 – tax rate)CF1 = ($300,000 – $210,000)*(1 – 35%) = $58,500CF2 = ($300,000 – $210,000)*(1 – 35%) = $58,500CF3 = ($300,000 – $210,000)*(1 – 35%) = $58,500CF4 = ($300,000 – $210,000)*(1 – 35%) = $58,500CF5 = ($300,000 – $210,000)*(1 – 35%) = $58,500= $58,500 x 5= $292,500Required:Computations (use Excel).Use Excel to estimate the projectâs cash flows. Presentation always matter, but you want to make sure that Mr. Hillbrandt can easily follow your work. He is a busy man.Memo (use Word).Write a memo to Mr. Hillbrandt and comment on the three questions below. Limit the memo to four or five paragraphs since CEOs want an initial succinct explanation to accompany the financial calculations. Start with an introduction and end with a recommendation. Each of the four or five paragraphs should have a heading.If the manufacturer plans on using debt to finance the project, should the estimated project cash flows be changed to reflect these interest charges? Why or why not?If the manufacturer spent $200,000 studying golf clubs last year, should that cost be taken into account with this analysis? Why or why not?If the manufacturer could rent out the factory that is storing the golf club machinery for $80,000 a year, should that be taken into account with this analysis? Why or why not?Short Essay (use Word).If ABC Golf Equipment Corporation goes ahead with this new manufacturing venture, the company may no longer be allowed to represent a competing brand of golf clubs that currently accounts for 20% of its profits. Should this be considered in the analysis? Why or why not? What other factors should be considered in making the decision?Start with an introduction and end with a summary or conclusion. Use headings. Donât forget to reference your sources. Maximum length of two pages
Our Service Charter
-
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. -
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. -
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. -
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. -
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.