Question

In: Finance

initial capital cost = 3,500,000 operating cash flow for each year = $1,000,000 recovery of capital...

initial capital cost = 3,500,000
operating cash flow for each year = $1,000,000
recovery of capital Assets after five years =$270,000

the hurdle rate for this project is 12%. it the initial cost of working capital is $490,000 for each items as teapots, teacups, saucers, and napkins, should farbucks open this new shop if it will be in business for only five years?

what is the most it can invest in working capital and still have a positive net present value?

Solutions

Expert Solution

Following screenshot shows how to calculate the NPV:

Explanation:

  • As no tax rate is give, the operating CF is same as after tax CF because we dont need to consider depreciation to first find out the NI and then add it back to find the CF
  • CF in year 0 = Fixed investment+Working capital investment
  • CF in year 5 = Annual operating CF+salvage value+Working capital investment = 1000000+270000+490000
  • As NPV is positive, the company should invest in this project if the discount rate is 12%

To find out the maximum possible value of working capital investment keeping the NPV positive, we can either do a hit an trial method or use the goal seek function of excel:

Unis the goal seek above screen shot shows that the NPV becomes 0 at a working capital investment of 596388 so any value below this will give a positive NPV keeping everything else constant


Related Solutions

operating cash flow. find the operating cash flow for the year for robinson and sons if...
operating cash flow. find the operating cash flow for the year for robinson and sons if it had sales of $81,200,000,,, cost of goods of $35,500,000, sales and administrative costs of $6,200,000, depreciation expense of $7,000,000, and a tax rate 0f 30%. the operating cash flow is ....... (round to the nearest dollar)
Calculate “Operating” Cash Flow, ΔNet Working Capital, Net Capital Spending, Cash Flow from Assets, Cash Flow...
Calculate “Operating” Cash Flow, ΔNet Working Capital, Net Capital Spending, Cash Flow from Assets, Cash Flow to Creditors, and Cash Flow to Shareholders. Please show work and equations. Balance Sheet 2015 2016 Income Statement 2016 Cash 5800 5820 Sales 26500 All Other Current Assets 4000 4910 Various Operating Expenses 11900 Net Fixed Assets 6600 9200 Depreciation Expense 1400 Current Liabilities 7200 8870 Interest Expense 920 Long-term Liabilities 5700 6940 Gain on Sale of Asset 1020 Common Stock 2500 3380 Taxable...
The following four-year project has an initial cost of $1,000,000. The future cash inflows for the...
The following four-year project has an initial cost of $1,000,000. The future cash inflows for the next four years are $600,000, $500,000, $400,000, and $400,000, respectively. If the rate of return is 12%, determine the discounted payback period for this project.
Operating cash flow.??Find the operating cash flow for the year for Harper? Brothers, Inc. if it...
Operating cash flow.??Find the operating cash flow for the year for Harper? Brothers, Inc. if it had sales revenue of $308,600,000?, cost of goods sold of $135,600,000?, sales and administrative costs of $39,300,000?, depreciation expense of $65,700,000?, and a tax rate of 40%.
Project K has an initial required investment of $1,000,000. The project will result in operating cash...
Project K has an initial required investment of $1,000,000. The project will result in operating cash inflows of $200,000 per year for Years 1-3, $100,000 per year for Years 4-9, and have no cash flows in Year 10 and beyond. Calculate the payback period for Project K.
During the past year, a company had cash flow to creditors, an operating cash flow, and...
During the past year, a company had cash flow to creditors, an operating cash flow, and net capital spending of $30,817, $70,361, and $31,140, respectively. The net working capital at the beginning of the year was $12,526 and it was $14,950 at the end of the year. What was the company's cash flow to stockholders during the year? Multiple Choice $2,424 $10,828 $5,980 $4,234
•Calculate the change in operating cash flow for each year using the following information: •The machine costs $1,000,000 and is depreciated using straight-line over five years.
•Calculate the change in operating cash flow for each year using the following information:•The machine costs $1,000,000 and is depreciated using straight-line over five years.•The machine will increase sales by $150,000 per year for five years.•The tax rate is 40%.•Working capital needs increase by $10,000 when the machine is placed in service and are reduced at the end of the life of the machine.•There is no salvage value at the end of the five years.
Operating cash flow​ (growing each​ year; MACRS). Miglietti Restaurants is looking at a project with the...
Operating cash flow​ (growing each​ year; MACRS). Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales quantity of 31,000​ with an annual growth rate of 4.00​% over the next ten years. The sales price per unit will start at $42 and will grow at 2.50​% per year. The production costs are expected to be 55​% of the current​ year's sales price. The manufacturing equipment to aid this project will have a total cost​ (including...
A firm is considering a project with a 5-year life and an initial cost of $1,000,000....
A firm is considering a project with a 5-year life and an initial cost of $1,000,000. The discount rate for the project is 10%. The firm expects to sell 2,500 units a year for the first 3 years. The after-tax cash flow per unit is $120. Beyond year 3, there is a 50% chance that sales will fall to 900 units a year for both years 4 and 5, and a 50% chance that sales will rise to 3,000 units...
2. If produced by Method A, a product’s initial capital cost will be $100,000, its operating...
2. If produced by Method A, a product’s initial capital cost will be $100,000, its operating cost will be $20,000 per year, and its salvage value after 3 years will be $20,000. With Method B there is a first cost of $150,000, an operating cost of $10,000 per year, and a $50,0000 salvage value after its 3-year life. Based on a present worth analysis at a 15% interest rate, which method should be used?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT