Question

In: Finance

Jennifer is a project manager for Cyclone Fitness Inc. She is evaluating the feasibility of a...

Jennifer is a project manager for Cyclone Fitness Inc. She is evaluating the feasibility of a project to build a new plant for manufacturing a new health drink. She has the following information. · Sales of 800,000 bottles/year with a price of $5/bottle. · Variable cost per bottle is $1.5 per bottle. · Fixed costs are $500,000 per year. · Project life is 5 years. · Initial Investment (cash outlay) is $5,000,000. · Depreciation is $1,000,000/year. · Additional net working capital of $1,500,000 required. Same for all periods. · The firm’s required return is 22%. · The tax rate is 30%.

a. What is the OCF in year 1 to year 5?

b. What is the (Free) Cash Flow in year 1 to year 5?

c. What is the NPV of the project? Should Cyclone Fitness Inc. accept or reject the project?

Solutions

Expert Solution

Free Cash Flow = Operating Cash Flow - Change in working capital - Change in Fixed Assets

Therefore operating cash flow and free cash flow will be same in this question because there is no information given on increase in working capital from year 1-5, nor there is any information on change in fixed assets

Particulars Cash Flow
Sales 800000 * 5 4,000,000
Variable cost 800000 * 1.5 1,200,000
Less Fixed cost 500,000
Operating Profit 2,300,000
Less : Depreciation 1,000,000
Earning Before Tax 1,300,000
Less : Tax 390,000
Earning After Tax 910,000
Add Back : Depreciation 1,000,000
Cash flow After Tax / Operating Cash Flow 1,910,000
PV of this Cash Flow
CFAT 1,910,000
PVAF 22%, 5 Years 2.86
PV of CFAT (B) 5,469,551.94
A. Initial Investment (Year 0)
Cost of Machine 5,000,000
Increase in Working Capital 1,500,000
Total Outlow (A) 6,500,000
Recovery of Working Capital 1,500,000
Total Terminal Cash Flow 1,500,000
Present Value Factor 0.37
Present Value of Terminal Cash Flow {C} 554,998.88
Calculation Of NPV
Initial Outflow (A) -6,500,000
PV of Annual Cash Flow (B) 5,469,551.94
PV of Terminal Cash Flow "C" 554,998.88
Net Present Value -475,449

NPV is negative we should reject the project


Related Solutions

Jane is a project manager for Jackson Drinks Inc. She is evaluating the feasibility of project...
Jane is a project manager for Jackson Drinks Inc. She is evaluating the feasibility of project to construct a plant to produce a new health drink. She has the following information. ·         Sales of 500,000 bottles/year with a price of $6/bottle. ·         Variable cost per bottle is $3 per bottle. ·         Fixed costs are $500,000 per year. ·         Project life is 5 years. ·         Initial Investment (cash outlay) is $2,000,000. ·         Depreciation is $400,000/year. ·         Additional net working capital of $1,000,000 required. Same for all periods. ·         The...
A project manager is evaluating a project and initially forecasts that the project will lasts for...
A project manager is evaluating a project and initially forecasts that the project will lasts for four years and has its annual marketing and support costs of $1,000,000 and its annual revenue of $10,000,000. The project pays a 40% tax rate on its pre-tax income and its cost of capital is 15%. While analysing a situation that competitors can run their big promotion programs during the project’s life, the manager proposes one solution to the situation by increasing the marketing...
A project manager is evaluating a project and initially forecasts that the project will lasts for...
A project manager is evaluating a project and initially forecasts that the project will lasts for four years and has its annual marketing and support costs of $1,000,000 and its annual revenue of $10,000,000. The project pays a 40% tax rate on its pre-tax income and its cost of capital is 15%. While analysing a situation that competitors can run their big promotion programs during the project’s life, the manager proposes one solution to the situation by increasing the marketing...
You are a project manager evaluating the following three projects               Year                Project A &
You are a project manager evaluating the following three projects               Year                Project A                       Project B                       Project C               0                     -$150,000                      -$300,000                      -$150,000               1                     $110,000                       $200,000                       $120,000               2                     $110,000                       $200,000                       $90,000 The relevant discount rate ( r ) is 12% a year Calculate the PI for each of the three projects. Calculate the NPV for each of the three projects. If the projects were independent, and according to the PI rule, which project(s) would you...
Barbara just received the good news: She was assigned as the project manager for a project...
Barbara just received the good news: She was assigned as the project manager for a project that her company won as part of competitive bidding. Whenever a request for proposal (RFP) comes into Barbara’s company, a committee composed mainly of senior managers reviews the RFP. If the decision is made to bid on the job, the RFP is turned over to the Proposal Department. Part of the Proposal Department is an estimating group that is responsible for estimating all work....
Assume Jennifer is an office manager working at Acme LLC a local plumbing company. Jennifer has...
Assume Jennifer is an office manager working at Acme LLC a local plumbing company. Jennifer has agency authority to sign for UPS deliveries, and to cut checks up to $250 out of the petty cash account for small tools and office supplies. After hearing a couple complaints from customers about the rusty trucks used by Acme LLC's plumbing crews Jennifer decides to purchase a brand new work van from the local dealership using an Acme LLC corporate check so that...
A company is evaluating the feasibility of investing in machinery to manufacture an automotive component. It...
A company is evaluating the feasibility of investing in machinery to manufacture an automotive component. It would need to make an investment of $560,000 today, after which, it would have to spend $7,500 every year starting one year from now, for ten years. At the end of the period, the machine would have a salvage value of $11,000. The company confirmed that it can produce and sell 7,500 components every year for ten years and the net return would be...
You are part of a team that is evaluating the feasibility of building a standardized nursing...
You are part of a team that is evaluating the feasibility of building a standardized nursing language into the electronic medical record that will be used by your department. Your group is reviewing the 12 ANA recognized terminologies. The goal is to make recommendations about one or more terminologies that could be built into EMR for use by nurses. Choose one of the 12 ANA recognized terminologies to evaluate (read materials for this unit and visit the website of the...
Assume that HCA is evaluating the feasibility of building a new hospital in an area not...
Assume that HCA is evaluating the feasibility of building a new hospital in an area not currently served by the company. The company's analysts estimate a market beta for the hospital project of 1.1, which is somewhat higher than the 0.8 market beta of the company's average project. Financial forecasts for the new hospital indicate an expected rate of return on the equity portion of the investment of 20 percent. If the risk-free rate, RF, is 7 percent and the...
The engineering calculation on the telecommunication project is needed to analyze the feasibility of the project...
The engineering calculation on the telecommunication project is needed to analyze the feasibility of the project and the total value of investments. As the Project Manager, you have to do the financial analysis of your telecommunication project to get the conclusion of whether this feasible to run the project or not. You have to prove your analysis by giving the project calculation in terms of Net Present Value (NPV), Present Worth Analysis, and Break-Even Point (BEP) based on the initial...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT