Fina Final
What types of analyses do the BNSF strategic studies team conduct?
-discounted cash flow -sensitivity
Compute the payback period for a project that requires an initial outlay of $248,607 that is expected to generate $40,000 per year for 9 years.
6.22
The multiple IRR problem occurs when the signs of a project's cash flows change more than once.
True
Identify which of these are relevant cash flows when considering a capital budgeting project
-lost rent from retail facility -remodeling expenses for new store -increase in inventory -expected salvage value of manufacturing equipment
The Internal Rate of Return (IRR) is the discount rate that equates the NPV of an investment opportunity with $0
True
A company just paid $10 million for a feasibility study. If the company goes ahead with the project, it must immediately spend another $86,888,329 now, and then spend $20 million in one year. In two years it will receive $80 million, and in three years it will receive $90 million. If the cost of capital for the project is 11 percent, what is the project's NPV?
0= -91159050 1= -20000000 2= +80000000 3= +90000000 @11% (/1.11)^n -91159050 -18018018.02 +64929794.66 +65807224.32 =21559950.96 CF in calc.
List steps of the capital budgeting process
1. Proposal generation 2. review and analysis 3. decision making 4. implementation 5. follow up
Match those following concepts for first principle 1. the investment decision 2. the financing decision 3. the dividend
2. find the right kind of debt for your firm and the right mix of debt and equity to fund your operations 1. invest in assets that earn a return greater than the minimum acceptable hurdle rate 3. if you can't find investments that make your minimum acceptable rate, return the cash to owners of your business
What is the NPV of a project that costs $100,000.00 and returns $50,000.00 annually for three years if the opportunity cost of capital is 8.04%?
28,761.90
You are considering the following three mutually exclusive projects. The required rate of return for all three projects is 14%. Year: 0A: $ (1,000) 0B: $ (5,000) 0C: $ (50,000) 1A: $ 300 1B: $ 1,700 1C: $ 0 2A: $300 2B: $ 1,700 2C: $15,000 3A: $ 600 3B: $1,700 3C: $ 28,500 4A: $300 4B: $1,700 4C: $ 33,000 What is the IRR of the best project? % terms to 2 decimal places w/o % sign
A: 17.49 B: 13.54 C: 14.23 Ans: 14.23
It should not usually be clear whether we are describing independent or mutually exclusive projects in the following chapters because when we only describe one project then it can be assumed to be independent
False
NPV assumes intermediate cash flows are reinvested at the cost of equity, while IRR assumes that they are reinvested at the cost of capital
False
Net present value (NPV) is a sophisticated capital budgeting technique; found by adding a project's initial investment from the present value of its cash inflows discounted at a rate equal to the firm's cost of capital.
False
Aero Motorcycles is considering opening a new manufacturing facility in Fort Worth to meet the demand for a new line of solar-charged motorcycles (who wants to ride on a cloudy day anyway?) The proposed project has the following features; • The firm just spent $300,000 for a marketing study to determine consumer demand (@ t=0). • Aero Motorcycles purchased the land the factory will be built on 5 years ago for $2,000,000 and owns it outright (that is, it does not have a mortgage). The land has a current market value of $2,902,087. • The project has an initial cost of $20,000,000 (excluding land, hint: the land is not subject to depreciation). • If the project is undertaken, at t = 0 the company will need to increase its inventories by $3,500,000, accounts receivable by $1,500,000, and its accounts payable by $2,000,000. This net operating working capital will be recovered at the end of the project's life (t = 10). • If the project is undertaken, the company will realize an additional $8,000,000 in sales over each of the next ten years. (i.e. sales in each year are $8,000,000) • The company's operating cost (not including depreciation) will equal 50% of sales. • The company's tax rate is 35 percent. • Use a 10-year straight-line depreciation schedule. • At t = 10, the project is expected to cease being economically viable and the factory (including land) will be sold for $4,500,000 (assume land has a book value equal to the original purchase price). • The project's WACC = 10 percent • Assume the firm is profitable and able to use any tax credits (i.e. negative taxes). What is the project's NPV? Round to nearest whole dollar value.
NWC= Inv+AR-AP 3500000+1500000-2000000= 3000000 CF0: -3000000 - 20000000 - 2502793= 25502793 CO1: 3212500 F01: 9 CF2: 10712500 F02: 1 I= WACC 10 CPT NPV: -2871796.5
Aero Motorcycles is considering opening a new manufacturing facility in Fort Worth to meet the demand for a new line of solar-charged motorcycles (who wants to ride on a cloudy day anyway?) The proposed project has the following features; • The firm just spent $300,000 for a marketing study to determine consumer demand (@ t=0). • Aero Motorcycles purchased the land the factory will be built on 5 years ago for $2,000,000 and owns it outright (that is, it does not have a mortgage). The land has a current market value of $2,600,000. • The project has an initial cost of $20,000,000 (excluding land, hint: the land is not subject to depreciation). • If the project is undertaken, at t = 0 the company will need to increase its inventories by $3,500,000, accounts receivable by $1,500,000, and its accounts payable by $2,000,000. This net operating working capital will be recovered at the end of the project's life (t = 10). • If the project is undertaken, the company will realize an additional $8,000,000 in sales over each of the next ten years. (i.e. sales in each year are $8,000,000) • The company's operating cost (not including depreciation) will equal 50% of sales. • The company's tax rate is 35 percent. • Use a 10-year straight-line depreciation schedule. • At t = 10, the project is expected to cease being economically viable and the factory (including land) will be sold for $4,500,000 (assume land has a book value equal to the original purchase price). • The project's WACC = 10 percent • Assume the firm is profitable and able to use any tax credits (i.e. negative taxes). What is the operating cash flow @ t=2? Round to nearest whole dollar value.
Same as above
Which of the following statements is correct for a project with a negative NPV?
The cost of capital exceeds the IRR
Which of the following changes, if of a sufficient magnitude, could turn a negative NPV project into a positive NPV project?
a decrease in the fixed costs
A corporation is contemplating an expansion project. The CFO plans to calculate the project's NPV by discounting the relevant cash flows (which include the initial up-front costs, the operating cash flows, and the terminal cash flows) at the corporation's cost of capital (WACC). Which of the following factors should the CFO include when estimating the relevant cash flows?
any opportunity costs associated with the project
If a 20% reduction in forecast sales would not extinguish a project's profitability, then sensitivity analysis would suggest:
deemphasizing the variable as a critical factor
What types of projects does the BNSF strategic studies team evaluate?
discretionary
According to the article, "Sunk cost fallacy: Throwing good money after bad," how can banks limit losses from bad loans?
increase bank executive turnover
The primary purpose of capital budgeting is to:
maximize the shareholder's wealth
Projects that compete with one another so that the acceptance of one eliminates from further consideration all other projects that serve a similar function.
mutually exclusive
Grill Master Johnnys is thinking about purchasing a new, energy-efficient grill. The grill will cost $53,000.00 and will be depreciated according to the 3-year MACRS schedule. It will be sold for scrap metal after 3 years for $11,750.00. The grill will have no effect on revenues but will save Johnny's $23,500.00 per year in energy expenses. The tax rate is 40%. The 3-year MACRS schedule; Year 1 Dep % 33.33 Year 2 Dep % 44.45 Year 3 Dep % 14.81 Year 4 Dep % 7.41 What is the total cash flow in year 3
tax= 14.81 Initial inv: -53000 yr 1: 53000*33.33= 17664.90 yr 2: 53000*44.45= 23558.50 yr3: 53000*14.81= 7849.30 SV: 11750 Saving: 23500 Rev:23500 - dep: 7849.30 =EBIT: 15650.70 -tax: 6260.28 =NI: 9390.42 +dep: 7849.30 =OCF: 17239.72 BV: 530000-(17664.90+23558.50+7849.30) = 3927.30 ATSV= SV-tax(sv-bv) 11750-.40(11750-3927.30)= 8620.92 Total CF: 17239.72+8620.92 = 25.860.64
Capital rationing may be beneficial to a firm if it:
weeds out proposals with weaker or biased NPV's
Jon Stevens, BNSF Vice President and Controller describes the capital spending process primarily as
- a means to ensure regulatory compliance -a balancing act that requires careful evaluation of the costs and benefits of each project
Your firm has a potential project that will cost $5,000 now to begin. The project will then generate after-tax cash flows of $487 at the end of the next three years and then $1,655 per year for the three years after that. If the discount rate is 8.87% then what is the NPV?
-510.36
Aero Motorcycles is considering opening a new manufacturing facility in Fort Worth to meet demand for a new line of solar charged motorcycles (who wants to ride on a cloudy day anyway?) The proposed project has the following features; • The firm just spent $300,000 for marketing study to determine consumer demand (@ t=0). • Aero Motorcycles purchased the land the factory will be built on 5 years ago for $2,000,000 and owns it outright (that is, it does not have a mortgage). The land has a current market value of $2,600,000. • The project has an initial cost of $27,603,445 (excluding land, hint: land is not subject to depreciation). • If the project is undertaken, the company will realize an additional $8,000,000 in sales over each of the next ten years. (i.e. sales in each year are $8,000,000) • The company's operating cost (not including depreciation) will equal 50% of sales. • The company's tax rate is 35 percent. • Use a 10-year straight-line depreciation schedule. • At t = 10, the project is expected to cease being economically viable and the factory (including land) will be sold for $4,500,000 (assume land has a book value equal to the original purchase price). • The project's WACC = 10 percent • Assume the firm is profitable and able to use any tax credits (i.e. negative taxes) .0 What is the project's outflow at t=0? Answer to the nearest whole dollar value.
2600000+27603445=30203445
Aero Motorcycles is considering opening a new manufacturing facility in Fort Worth to meet the demand for a new line of solar-charged motorcycles (who wants to ride on a cloudy day anyway?) The proposed project has the following features; • The firm just spent $300,000 for a marketing study to determine consumer demand (@ t=0). • Aero Motorcycles purchased the land the factory will be built on 5 years ago for $2,000,000 and owns it outright (that is, it does not have a mortgage). The land has a current market value of $2,600,000. • The project has an initial cost of $20,000,000 (excluding land, hint: the land is not subject to depreciation). • If the project is undertaken, at t = 0 the company will need to increase its inventories by $3,500,000, accounts receivable by $1,500,000, and its accounts payable by $2,000,000. This net operating working capital will be recovered at the end of the project's life (t = 10). • If the project is undertaken, the company will realize an additional $8,000,000 in sales over each of the next ten years. (i.e. sales in each year are $8,000,000) • The company's operating cost (not including depreciation) will equal 50% of sales. • The company's tax rate is 35 percent. • Use a 10-year straight-line depreciation schedule. • At t = 10, the project is expected to cease being economically viable and the factory (including land) will be sold for $4,500,000 (assume land has a book value equal to the original purchase price). • The project's WACC = 10 percent • Assume the firm is profitable and able to use any tax credits (i.e. negative taxes). What are the after tax proceeds from the sale of the factory (i.e., ATSV)? Round to nearest whole dollar value.
4500000 ASTV= SV- tax(Sv-bv) 4500000-[.35(4500000-2000000) = 3625000
What is the internal rate of return for a project with an initial outlay of $10,000 that is expected to generate cash flows of $2,000 per year for 6 years?
5.47
Changes in Net working Capital (NWC) What is the net effect on a firm's working capital if a new project requires: $38,991 increase in inventory, $31,869 increase in accounts receivable, $35,000.00 increase in machinery, and a $41,802 increase in accounts payable? Round to nearest dollar amount.
Incr Inv = 38991 A/R= 31869 A/P= 41802 38991+31869-41802= 29058
What are advantages of payback period?
Measures Liquidity Easy to communicate Does not require all CFs Does not require discount rate Does not require complex calculations Can be used to compare mutually exclusive projects
The "gold standard" of investment criteria refers to:
NPV
A company just paid $10 million for a feasibility study. If the company goes ahead with the project, it must immediately spend another $100 million now, and then spend $20 million in one year. In two years it will receive $80 million, and in three years it will receive $90 million. If the cost of capital for the project is 11 percent, what is the project's IRR? % terms to 2 decimal places and without the % sign.
NPV= 1271900.96 CPT IRR =15.95%
Your firm has a potential project that will cost $5,000 now to begin. The project will then generate after-tax cash flows of $900 at the end of the next three years and then $1400 per year for the three years after that. If the discount rate is 8% then what is the PI? Answer in % format
NPV= 183.48 (183.48+5000) / 5000= 1.03669 = 103.67%
Revenues generated by a new fad product are forecast as follows: Year 1 Revenues $32,594 Year 2 Revenues 40,000 Year 3 Revenues 20,000 Year 4 Revenues 10,000 Thereafter 0 Expenses are expected to be 50% of revenues, and working capital required in each year is expected to be 20% of revenues in the following year. The product requires an immediate investment of $40,000 in plant and equipment that will be depreciated using the straight-line method over 5 years. The firm recently spent $2,000 on a study to estimate the revenues of the new product. The tax rate is 20%. What is the operating cash flow in year 1? Answer to nearest whole dollar amount.
OCF = EBIT - taxes + depreciation Revenue - exp - depreciation EBT -tax NI +Deprecation exp = rev/2 dep= int cost/# tax= T(EBIT) Year 1 32594 (rev) - 16297 (exp) - 8000(dep) =EBIT 8297 - 1659.4 (tax) = 6637.6 (NI) + 8000 (dep) =14637.6 (OCF)
What is the amount of the operating cash flow for a firm with $378,840 profit before tax, $100,000 depreciation expense, and a 35% marginal tax rate?
OCF= EBIT - taxes + depreciation (378840 x (1-.35) + 100000= 346246
What is the profitability index for Project A with a cost of capital of 8%? Year ProjectA Project B 0($42,000.00) ($45,000.00) 1$14,000.00 $28,000.00 2$14,000.00 $12,000.00 3$14,000.00 $10,000.00 4$14,000.00 $10,000.00 5$14,000.00 $10,000.00
Proj. A NPV= 13,897.94 (13897.94+42000) / 42000= 1.33
The disadvantages of the IRR period method is that it
Requires complex calculations Requires a lot of data (estimates of all CFs) Only works for normal cash flows Requires discount rate (for decision) Does not always work for mutually exclusive projects
Aero Motorcycles is considering opening a new manufacturing facility in Fort Worth to meet the demand for a new line of solar-charged motorcycles (who wants to ride on a cloudy day anyway?) The proposed project has the following features; • The firm just spent $300,000 for a marketing study to determine consumer demand (@ t=0). • Aero Motorcycles purchased the land the factory will be built on 5 years ago for $2,000,000 and owns it outright (that is, it does not have a mortgage). The land has a current market value of $2,600,000. • The project has an initial cost of $20,000,000 (excluding land, hint: the land is not subject to depreciation). • If the project is undertaken, at t = 0 the company will need to increase its inventories by $3,500,000, accounts receivable by $1,500,000, and its accounts payable by $2,000,000. This net operating working capital will be recovered at the end of the project's life (t = 10). • If the project is undertaken, the company will realize an additional $8,000,000 in sales over each of the next ten years. (i.e. sales in each year are $8,000,000) • The company's operating cost (not including depreciation) will equal 50% of sales. • The company's tax rate is 35 percent. • Use a 10-year straight-line depreciation schedule. • At t = 10, the project is expected to cease being economically viable and the factory (including land) will be sold for $4,500,000 (assume land has a book value equal to the original purchase price). • The project's WACC = 10 percent • Assume the firm is profitable and able to use any tax credits (i.e. negative taxes). What is the operating cash flow @ t=1? Round to nearest whole dollar value.
Rev: 8000000 -Exp: 4000000 (8mil/2) -Dep: 2000000 (init cost/n) =EBIT: 2000000 -Tax: 700000 (ebit*t) =NI: 1300000 +Dep: 2000000 =OCF: 3300000
Aero Motorcycles is considering opening a new manufacturing facility in Fort Worth to meet the demand for a new line of solar-charged motorcycles (who wants to ride on a cloudy day anyway?) The proposed project has the following features; • The firm just spent $300,000 for a marketing study to determine consumer demand (@ t=0). • Aero Motorcycles purchased the land the factory will be built on 5 years ago for $2,000,000 and owns it outright (that is, it does not have a mortgage). The land has a current market value of $2,600,000. • The project has an initial cost of $20,000,000 (excluding land, hint: the land is not subject to depreciation). • If the project is undertaken, at t = 0 the company will need to increase its inventories by $3,500,000, accounts receivable by $1,500,000, and its accounts payable by $2,000,000. This net operating working capital will be recovered at the end of the project's life (t = 10). • If the project is undertaken, the company will realize an additional $8,000,000 in sales over each of the next ten years. (i.e. sales in each year are $8,000,000) • The company's operating cost (not including depreciation) will equal 50% of sales. • The company's tax rate is 35 percent. • Use a 10-year straight-line depreciation schedule. • At t = 10, the project is expected to cease being economically viable and the factory (including land) will be sold for $4,500,000 (assume land has a book value equal to the original purchase price). • The project's WACC = 10 percent • Assume the firm is profitable and able to use any tax credits (i.e. negative taxes). What is the total cash flow at t=10? Round to nearest whole dollar value.
WACC = 10% MV= 2600000
