Question

In: Finance

option shows the estimated increase in gross profit from the improved facility and/or automation at current...

option shows the estimated increase in gross profit from the improved facility and/or automation at current forecast production levels.  All information is Pre-Tax.  Tax rate = 40%

Option A:

  • Cost (time = 0) = $10.0 million, and takes one year to complete and bring online.
  • Yr. 1 cash flow = 0.
  • Depreciate the project cost over the 5yr allowable write-down of the facility after completion (Yr. 2-6).
  • The production line will increase pre-tax revenue by $5.0 million per year starting in yr. 2 and going for five years (Yr. 2-6).  
  • The WACC for the firm is 10% and the project risk premium is 4.0%

Termination Value: Six years from today the project is salvaged for $2.0 Million of before tax dollars.

What is the NPV of Option A, answer in dollars?

Solutions

Expert Solution

IN $ MILLION
Year 0 1 2 3 4 5 6
Increase in pre tax revenue 5 5 5 5 5 WACC 10%
Salvage value 2
Less-Depreciation 2 2 2 2 2 Risk Premium 4%
Discount rate 14% WACC+Risk Premium
Increase in Profit before tax 3 3 3 3 5
Less-Tax @40% of Profit before tax 1.2 1.2 1.2 1.2 2 Depreciation per year (in $ million) 2 Cost/5 years
Profit after tax 1.8 1.8 1.8 1.8 3
Add-Depreciation (as non cash expense) 2 2 2 2 2
Cash flow after tax 3.8 3.8 3.8 3.8 5
Present value of Inflow after tax 2.923977 2.564892 2.249905 1.973601 2.277932738
$ millions
Sum of Present value of Inflows 11.99031
Outflow 10
NPV 1.990307

Related Solutions

Gross profit margins for the year improved to 20.9% of sales compared to last year’s 18.5%....
Gross profit margins for the year improved to 20.9% of sales compared to last year’s 18.5%. All operations reported improved margins due in large part to improved operating efficiencies as a result of cost reduction measures implemented during the second and third quarters of the fiscal year and increased manufacturing throughout due to higher unit volume sales. Contributing to the improved margins was a favorable materials price variance due to competitive pricing by suppliers as a result of soft demand...
What is the firm's current year gross profit margin?
Category Prior Year Current YearAccounts payable ??? ???Accounts receivable 320,715 397,400Accruals 40,500 33,750Additional paid in capital 500,000 541,650Cash 17,500 47,500Common Stock 94,000 105,000COGS 328,500 428,048.00Current portion long-term debt 33,750 35,000Depreciation expense 54,000 54,731.00Interest expense 40,500 41,017.00Inventories 279,000 288,000Long-term debt 339,670.00 401,877.00Net fixed assets 946,535 999,000Notes payable 148,500 162,000Operating expenses (excl. depr.) 126,000 161,905.00Retained earnings 306,000 342,000Sales 639,000 850,323.00Taxes 24,750 48,686.00What is the firm's current year gross profit margin?
Your company is planning on expanding their current facility to increase the manufacturing of their products....
Your company is planning on expanding their current facility to increase the manufacturing of their products. The total cost is expected to be $100,000, and the company has decided to finance the project with short-term debt for the company an interest -bearing note or a zero-interest -bearing note. What are the key characteristics and differences between the two? Which one should the company decide to take on and why ? What effect will each bearing note have on the financial...
To find the gross profit percentage from intra-entity sales,
To find the gross profit percentage from intra-entity sales,A. divide the transfer price by the amount of the goods in the buyer's ending inventory.B. divide the transfer cost by the amount of the goods in the buyer's ending inventory.C. multiply the buyer's ending inventory by the amount of gross profit in the intra-entity sales.D. divide the transfer price by the cost of the goods.E. divide the transfer price by the gross profit on the intra-entity sales
Example Three: Use a Trial Balance to: Calculate Gross Profit (Gross Margin), Current Assets, Long-Term Assets...
Example Three: Use a Trial Balance to: Calculate Gross Profit (Gross Margin), Current Assets, Long-Term Assets (PPE), Current Liabilities, and Long-Term Liabilities Prepare Closing Entries, and Calculate ending balance in Retained Earnings. Account Name Debit Credit Cash 143,500 Accounts Receivable 23,250 Allowance for Uncollectible Accounts 465 Inventory 20,750 Prepaid Rent 3,000 Equipment 30,000 Accumulated Depreciation – Equipment 2,300 Accounts Payable 5,000 Salaries Payable 900 Unearned Revenue 3,500 Notes Payable 45,000 Common Stock 150,000 Retained Earnings 10,250 Dividends 1,500 Sales Revenue...
4.3) General Hospital, a not-for-profit acute care facility, has estimated the following costs for its inpatient...
4.3) General Hospital, a not-for-profit acute care facility, has estimated the following costs for its inpatient services: Fixed costs $10,000,000         Variable cost per inpatient day $200 The hospital expects to have 15,000 inpatient days next year. a.What is the hospital's underlying cost structure? b.What are the hospital's expected total costs? c.What are the hospital's estimated total costs at 12,500 inpatient days? At 17,500 inpatient days? d.What is the average cost per inpatient day at 12,500, 15,000, and 17,500 inpatient days?...
Google improved its operations from a net loss in 2015 to a net profit in 2016....
Google improved its operations from a net loss in 2015 to a net profit in 2016. While happy about these developments, they are concerned with trying to understand how long the firm takes to complete its cash conversion cycle in 2016. Use the following financial statements to make your calculations. Balance sheet items should reflect the averages of the 2015 and 2016 accounts. Google products PRODUCTS COMPANY INCOME STATEMENT 2015 2016 Net sales $900,000 $1,500,000 Cost of goods sold 540,000...
How is the contribution margin concept different from the gross profit concept and why is the...
How is the contribution margin concept different from the gross profit concept and why is the distinction important? Why would a company endeavor to calculate these amounts for their products?
How is the contribution margin concept different from the gross profit concept and why is the...
How is the contribution margin concept different from the gross profit concept and why is the distinction important? Why would a company endeavor to calculate these amounts for their products? While not mandatory for credit, I highly encourage you to read your classmates thoughts and comment on their reflections. You may be able to help each other! I will be reading your discussions and commenting both on the board itself and on the grading screen.
Graph the pay-off and profit from writting a European put option with option price (premium)=$10, strike...
Graph the pay-off and profit from writting a European put option with option price (premium)=$10, strike price=$50. Also calculate the intrinsic value of this option if the stock price is $45
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT