Cash flow estimation and capital budgeting

Assignment Help Finance Basics
Reference no: EM13833910

Cash Flow Estimation and Capital Budgeting

Case Assignment

Estimating Project Cash Flows

ABC 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 outlay

2) Straight-line depreciation

3) Operating cash flows for the 5-year period

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):

2) Calculate straight-line depreciation, where salvage value is $30,000 and useful life of the equipment is 5 years:

3) Calculate operating cash flows, where CFt = (revenues - costs)*(1 - tax rate)

CF1 = ($300,000 - $210,000)*(1 - 35%) = $58,500
CF2 = ($300,000 - $210,000)*(1 - 35%) = $58,500
CF3 = ($300,000 - $210,000)*(1 - 35%) = $58,500
CF4 = ($300,000 - $210,000)*(1 - 35%) = $58,500
CF5 = ($300,000 - $210,000)*(1 - 35%) = $58,500

Required:

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.

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

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

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

Reference no: EM13833910

Questions Cloud

Find a position within a human resources department : Using Lewin's framework, make two suggestions for change as to help employees adjust to their new positions and manifest the needed behaviors. Justify your suggestions.
Optimal debt-to-asset ratio : Suppose that a company with total assets of $1,000 pays a corporate tax rate of 30%, and that its bankruptcy cost function is given by k(D) = 0.0005D2. What is the optimal debt-to-asset ratio, D/A, for this company?
Create a food intake plan for a breastfeeding woman : Create a food intake plan for a breastfeeding woman by completing the steps outlined below. Your food intake plan must be at least two pages in length, double-spaced, Times New Roman, and 12-point font. Please be sure to cite any references used
What is the least-cost combination of labour and capital : What is the least-cost combination of labour and capital to employ in producing 80 units of output? What is the profit-maximising combination of labour and capital for the firm to employ?
Cash flow estimation and capital budgeting : ABC 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.
Forced ranking performance appraisal and the motivation : What's your opinion regarding forced ranking performance appraisal and the motivation it has to employees?
Research assistant from prospectuses : Assume these are financial data that have been extracted by your research assistant from prospectuses of New Zealand Non-bank Financial Institutions (NBFIs). The data are organized by alphabet in the blue sheet tabs A-G etc.
How mark keating found the sequence of the human herg : Explain how Mark Keating found the sequence of the human HERG cDNA sequence. Make sure to explain how cDNA libraries were constructed and screened to find the unique clone - Explain how the inward rectifying potassium channel cDNA sequence was fou..
How would you explain its metabolic control : A young student was troubled by the idea that a bacterium is able to control its diverse and complex metabolic activities, even though it lacks a brain. How would you explain its metabolic control

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd