Question

In: Finance

Problem: Calculate on the difference between FCF Do – FCF Don’t Do Prepare a template of...

Problem: Calculate on the difference between FCF Do – FCF Don’t Do

Prepare a template of doing the project and then a second template of not doing the project

Assumptions change

If you don’t do the project you will sell the land in Y0

Compare the two and calculate incremental NPV

Sunk costs

Ignore, not incremental

$50 spent two years ago, we are not getting back

Given Information:

2 year project

Capital required for P&E = $2500 in Y0

WC = $550 in Y1 and $600 in Y2. Total not incremental WC & required at beginning of the year

Salvage value of P&E at end of 2 years = $900

Depreciation in each of first 2 years = $1,000

Production is 1,000 units per year.

Assume revenue & costs are all incurred at the end of each year

Price = $2 / unit in Y1 and increases at a rate of 20%

Operating costs in Y1 = $400, Y2 = $500

Company owns land on which to build a plant which has a book value of $300.   The current market value is $300 but it is expected to rise at an annual rate of 5%. The land will be sold after 2 years.

Company originally planned to start the project 2 years ago and spent $50 in planning, but shelved it.

Tax rate = 34%

Cost of capital = 15%

Tax on asset sale

Profit / loss = Sale Proceeds – Book value

Book value = Purchase price – accumulated depreciation

Suppose you bought equipment for $2,500, depreciated it for two years at $1,000 per year and sell it for $900 at the end of the second year

Purchase price = $2,500

Accumulated depreciation = $2,000

Book value = $2,500 – 2,000 = $500

Taxable profit in Y2 = $900 – 500 = $400

____________________________________________

Include in the template:

Working Capital

Year 0,1,2

Revenue

Cash Cost

Depreciation of Equiptment

Profit/loss from asset sale

Equipment

Land

Taxable operating income

Tax on Operating income

Net oper profit after tax (NOPAT)

Depreciation of Equipment

Profit/Loss from asset sale

Equipment

Land

Operating Cash Flow

Changes In Working Capital

Capital Expenditure

Equipmeent

Land

Free Cash Flow to all capital

Solutions

Expert Solution

Year Revenue Operating costs Working Capital Depriciation Profit Before Tax Tax(@34%) Profit After Tax Depreciation Cash Flow PV Factor(@15%) PV of Cash Flow
1 2000 (400) (550) (1000) 50 (17) 33 1000 1033 0.870 898.71
2 2400 (500) (50) (1000) 850 (289+136)=(425) 425 1000 1425+900=2325 0.756 1757.7
TOTAL 2656.41

Year 1 revenue = 1000*2 = $2000

Year 1 revenue = 1000*(2.4) = $2400 (20% increase in price)

Tax on profit on sale of P&E = 900(sale) - 500(Book Value)=400(profit)*(0.34)=$136

Working Capital is total, therefore , for year 2, WC=600-550= $50

$900 salvage value is added to the cash flow.

$300 value of land is an asset and it is not a determinant for the taking up of the project as the company already owns the land and has not bought it for the purpose of the project.

The $50 spent 2 years back would have been taken into account (P&L account) because it has already been shelved.

The initial investment is $2500

PV of future cash flows from the project = $2656.41

Therefore, NPV of the project is $156.41.

The incremental cash flow in year 1 is $1033 (PV=$898.71) and in year 2 it is $2325(PV=$1757.7)

If we don't do the project then we would get $300 in year 0.

If we do it then,

Year Value PV Factor @ 15% PV
1 300*(1.05)=315 0.870 274.05
2 315*(1.05)=330.75 0.756 250.047

The land will be sold at $330.75 after 2 years, which at year 0 has a value of $250.047. Adding to this the NPV of the project undertaken,i.e, $156.41. Total equals $406.457.

It is better to take up the project than selling off the land because if the project is taken there would be a benfit of $106.457(406.457-300).

Note: Brackets indicate negative number or subtraction.


Related Solutions

A. How do you calculate net profit starting with sales? What is the difference between two...
A. How do you calculate net profit starting with sales? What is the difference between two ventures if one has very low net profit margin and the other with high profit margin? Is the difference attributed to management of costs and expenses? If yes, why? B. How is ROA related to Net Profit Margin and asset turnover?
What's the difference between numerical method to calculate differential (backward, central, forward)? At what condition do...
What's the difference between numerical method to calculate differential (backward, central, forward)? At what condition do I have to use forward over central and backward, etc? If there's boundary condition that permits the complete use of central method, what will happen if I still use forward, backward, and central regardless there's boundary condition that permits the use of central method? note: I'm not used to describe pure mathematical problem in english, so I'm sorry if my question is hard to...
PDCA template and how to do it for financial. have to make a template of our...
PDCA template and how to do it for financial. have to make a template of our own thing. i was gonna do financial.
Problem 14-12 Stock Repurchase Bayani Bakery's most recent FCF was $46 million; the FCF is expected...
Problem 14-12 Stock Repurchase Bayani Bakery's most recent FCF was $46 million; the FCF is expected to grow at a constant rate of 6%. The firm's WACC is 13%, and it has 15 million shares of common stock outstanding. The firm has $30 million in short-term investments, which it plans to liquidate and distribute to common shareholders via a stock repurchase; the firm has no other nonoperating assets. It has $364 million in debt and $64 million in preferred stock....
Explain the difference between a platelet vs clotting problem
Explain the difference between a platelet vs clotting problem
Describe the difference between inferential and descriptive statistics. 2. Why don’t we just measure populations? Why...
Describe the difference between inferential and descriptive statistics. 2. Why don’t we just measure populations? Why do we use samples to infer about populations? 3. Ten people were asked how many siblings they have. Below is the data: 2, 4, 1, 2, 1, 3, 5, 0, 1, 3, 0 4. Create a frequency distribution table. 5. Add on a cumulative frequency column and compute the cumulative frequencies. 6. Add on a relative frequency column and compute the relative frequencies.
Discuss the key differences between template synthesis vs template-free synthesis
Discuss the key differences between template synthesis vs template-free synthesis
a) Explain the difference between a statistic and a parameter. b) Is it possible to calculate...
a) Explain the difference between a statistic and a parameter. b) Is it possible to calculate a parameter? Why or why not? c) Can you trust a statistic? Explain. d) Will statistics change from one sample to another? Why or why not?
When and how should resources be invested to close gaps between those who do and don’t...
When and how should resources be invested to close gaps between those who do and don’t use the Internet?
Prepare an absorption and variable income statement and prove the difference between the two statements Units...
Prepare an absorption and variable income statement and prove the difference between the two statements Units in beginning inventory 0 Units sold     35,000 Units produced                  40,000 Ending inventory        5,000 Variable cost per unit Fixed costs Direct materials 5 Fixed overhead $160,000 Direct labor 6 Fixed selling $210,000 Variable OH 1 Variable selling exp 2 Sales price $40
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT