Question

In: Finance

The Swiss Lakes Pen Company (SLPC) has decided to start a new project manufacturing gardening tools,...

The Swiss Lakes Pen Company (SLPC) has decided to start a new project manufacturing gardening tools, an entirely new area for the company. The company is considering a 4-year project in which revenues will be €6 million per year (constant for 4 years), manufacturing costs will be 40% of revenues, SGA will be €1.2 million per year (constant for four years) and the capital investment required will be €3 million (zero value after four years). This investment can be depreciated on a straight-line basis over four years and the company’s tax rate is 35%.

  1. Calculate the incremental free cash flows (FCFs) for this project.

  2. Using NVP, the company employs a discount rate of 12.8%,should the company go ahead with the project?

Solutions

Expert Solution

Based on given data, pls find below workings on Cash Flows and NPV;

Based on the below workings, the NPV is positive $ 2443578 and hence this project is feasible and recommended for investment.

Computation:

Computation of Net Present Value (NPV) based on the Discounted Cash flows; The Discounting factor is computed based on the formula: For year 0, the discounting factor is 1; For Year 1, it is computed as = Year 0 factor /(1+discounting factor%) ; Year 2 = Year 1 factor/(1+discounting factor %) and so on;

Next, the cashflows need to be multiplied with the respective years' discounting factor, to arrive at the discounting cash flows;

The total of all the discounted cash flows is equal to its respective Project NPV of the Cash Flows;

EXCEL in $ Million:

EXCEL WITH FORMULAE:

Project ($) Year o Year 1 Year 2 Year 3 Year 4 30,00,000 Cost of New Machine Revenues Manufacturing Costs SG & A Costs Depreciation EBIT Tax @ 35% Net Income 60,00,000 24,00,000 12,00,000 7,50,000 16,50,000 5,77,500 10,72,500 60,00,000 24,00,000 12,00,000 7,50,000 16,50,000 5,77,500 10,72,500 60,00,000 24,00,000 12,00,000 7,50,000 16,50,000 5,77,500 10,72,500 60,00,000 24,00,000 12,00,000 7,50,000 16,50,000 5,77,500 10,72,500 -30,00,000 1 Cash Flows (Net Income + Depreciation) Discounting Factor Discounted Cash Flow Cumulative Discounted Cash Flow 18,22,500 0.8865 16,15,691 -13,84,309 18,22,500 0.7859 14,32,351 48,042 18,22,500 0.6967 12,69,814 13,17,856 18,22,500 0.6177 11,25,722 24,43,578 -30,00,000 -30,00,000 NPV 24,43,578 Discounting Factor 12.80%


Related Solutions

Southern Alliance Company needs to raise $27 million to start a new project. The company has...
Southern Alliance Company needs to raise $27 million to start a new project. The company has a target capital structure of 60 percent common stock, 11 percent preferred stock, and 29 percent debt. Flotation costs for issuing new common stock are 11 percent, for new preferred stock, 8 percent, and for new debt, 4 percent. What is the true initial cost figure Southern should use when evaluating its project?
The company has a new project of importing materials for The manufacturing of nondisposable respirators that...
The company has a new project of importing materials for The manufacturing of nondisposable respirators that can be washed and reused. The cost of the machines in china is 82000$. Get the total cost of the machine to reach the facility where you are willing to run operations in Beirut city knowing that all imports can be packed in one 40 feets container and it is shipped from guanzhu. Assume you need to get the facility ready including rent cost...
Kristin has decided to start a new business of baking and selling cookies to order and...
Kristin has decided to start a new business of baking and selling cookies to order and cater to the university students on campus when they study in the evenings and stay up till after midnight. She has named her business Cookie Cult. The following is the list of tasks she came up with for completing one cycle of cookie production. After a car arrives; inspector checks paper work and sets up machine Inspector collects payment for the service Inspector checks...
ASP Pharmaceuticals has decided to go ahead and start clinical trials on a new drug. The...
ASP Pharmaceuticals has decided to go ahead and start clinical trials on a new drug. The total R&D costs are estimated to reach $750,000,000 with clinical trials mounting to $120,000,000. The current market size is estimated to be 2,000,000 and is expected to grow at 3% every year. The market share ASP hopes to capture in the first year is 8%, and is projected to grow by 20% each year for the next 4 years. A monthly prescription is anticipated...
It is January 1st, 2014 and Oscar D’Souza has decided to start a new business. He...
It is January 1st, 2014 and Oscar D’Souza has decided to start a new business. He wants to forecast the first year’s Income Statement and Balance sheet. He believes the assumptions below are reasonable – and wants you to assist him by creating the forecasted statements. You agree. Please construct an Income Statement and Balance Sheet from the information provided below. (25 points) -First year sales will total $100,000 -Gross margins will be 50% -Operating margins will be 20% -Accounts...
Austec Ltd manufactures garden tools and has decided to expand operations. The new operations are expected...
Austec Ltd manufactures garden tools and has decided to expand operations. The new operations are expected to increase EBIT from the current level of $500 000 to $1 million p.a. Austec has a capital structure that utilises bonds, ordinary equity and preference shares. The $500 000 of issued bonds pay 6% p.a.. Preference shares pay an annual fixed dividend of $70 000. The company has 1 000 000 ordinary shares that are trading at $5.1 per share. The Australian corporate...
The lavish carpet manufacturing co. has decided to acquire a new machine that has an economic...
The lavish carpet manufacturing co. has decided to acquire a new machine that has an economic life of 10 years, with no residual value. The machine can be purchased for $75,000 and the supplier is willing to advance $45,000 of the purchase price at 12 percent. The loan is to be repaid in equal instalments over 10 years. Lavish Carpet pays 40 percent corporate income tax and can claim 20 percent capital cost allowances on the purchased asset. It expects...
1) The lavish carpet manufacturing co. has decided to acquire a new machine that has an...
1) The lavish carpet manufacturing co. has decided to acquire a new machine that has an economic life of 10 years, with no residual value. The machine can be purchased for $75,000 and the supplier is willing to advance $45,000 of the purchase price at 12 percent. The loan is to be repaid in equal instalments over 10 years. Lavish Carpet pays 40 percent corporate income tax and can claim 20 percent capital cost allowances on the purchased asset. It...
Tom wants to start a new project. A project requires a start up cost of $11000...
Tom wants to start a new project. A project requires a start up cost of $11000 today and 20 annual cost of $4500 starting in one year. Starting at the end of the 21th year, the project returns 10 annual payments of $Y. Find Y so that the project yields an annual effective rate of 5% over the 30 years. PLZ by hand and not excel
MF has decided to start saving for his retirement. He will start at the end of...
MF has decided to start saving for his retirement. He will start at the end of this year saving $2000 a year for 10 years and $5,000 a year for the next 15 years after that. When he has finished with this period, he will still have 10 years left until he retires. The interest rate before retirement is 9.5% interest per year. After he retires the expected interest rate is 8%. If he wants to withdraw from his account...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT