The project will last for 8 years, beginning in 2011 (year 0) and ending in 2019...

The project will last for 8 years, beginning in 2011 (year 0) and ending in 2019 (year 8). Depreciation is straight line to zero, and taxation (at the time) is 35% in the United States. In any year with a negative EBIT, there is no tax. The capital investment for the fibre line project is $350,000,000 (invested in year 0), including costs of amplification sites, earthmoving equipment, easements etc. Working capital is expected to be $60,000,000, returned at the end of the project. A 24 hours a day, 7 days a week maintenance team is required to ensure 99.99% operational capacity, costing $60 million per year, and increasing at 3% per year. The project success hinges on access to the fibre ports in the exchanges, they know this and charge $50,000,000 per year (combined), declining by 5% p.a. as demand declines. A team of surveyors and builders who inspected the 1400 km path cost $1.5 million. At the end of the project, the technology is obsolete for its purpose in investment banking, but it can be sold to a telecom provider (contributing to the revenue for year 8) for $127,000,000. Revenue is subscription based at $3,600,000 per year, per subscription. In year 1 there will be 200 subscriptions, year 2 is 150, year 3 is 100, year 4 is 50. In year 5, 6, 7, 8 only 20 subscriptions are taken in per year. The all-important discount rate is 14.5%.

Question: What is the NPV and IRR using excel?

Expert Solution

NPV = 317,048,172.37

IRR = 62.90%

Note: Inspection cost of $1.5 million is a sunk cost so will not be considered in free cash flow calculation.

jeff jeffy answered 1 year ago

Balance Sheets for the Years Ending Dec. 31, 2011 and 2012 2011 2012 Cash 300...

Balance Sheets for the Years Ending Dec. 31, 2011 and 2012 2011 2012 Cash 300 400 Accounts receivable 1,000 1,400 Inventories 3,200 3,000 Current assets 4,500 4,800 Net fixed assets 3,800 4,300 Total assets 8,300 9,100 Notes payable 400 300 Accounts payable 700 500 Accruals 50 80 Current portion of long-term debt 70 80 Current liabilities 1,220 960...

The accounting records of Omar Company contained the following information for last year: Beginning Ending Direct...

The accounting records of Omar Company contained the following information for last year: Beginning Ending Direct materials inventory........................ $9,000 $7,000 Work in process inventory....................... $17,000 $31,000 Finished goods inventory........................ $10,000 $15,000 Manufacturing costs incurred Direct materials used............................... $72,000 Overhead applied..................................... $24,000 Direct labor cost (10,000 hours).............. $80,000 Depreciation............................................. $10,000 Rent......................................................... $12,000 Taxes........................................................ $8,000 Cost of goods sold................................... $157,000* * Selling and administrative costs incurred Advertising.............................................. $35,000 Rent......................................................... $20,000 Clerical..................................................... $25,000 *Does not include over- or underapplied overhead. 1. The...

At the beginning of last year (2019), Richter Condos installed a mechanized elevator for its tenants....

At the beginning of last year (2019), Richter Condos installed a mechanized elevator for its tenants. The owner of the company, Ron Richter, recently returned from an industry equipment exhibition where he watched a computerized elevator demonstrated. He was impressed with the elevator's speed, comfort of ride, and cost efficiency. Upon returning from the exhibition, he asked his purchasing agent to collect price and operating cost data on the new elevator. In addition, he asked the company’s accountant to provide...

You invest 800$ per year at the beginning of each year for 8 years at an...

You invest 800$ per year at the beginning of each year for 8 years at an interest rate of 8% the future value of your koney will be equal to approximately A 9190 B 18508 C 18989 D none of the above

"The revenue for a project in year 8 is $38,000 in constant (year-0) dollars. Expenses (not...

"The revenue for a project in year 8 is $38,000 in constant (year-0) dollars. Expenses (not including depreciation) in the same year is $22,000 in constant (year-0) dollars. Depreciation in that same year is $7675. If there were no inflation, the net income for year 8 would be $5078 in constant (year-0) dollars. If the inflation rate is 3%, what is the net cash flow in year 8 in actual dollars? Assume there are no investments or salvage values in...

Assume today is the beginning of year 2011, i.e., January 1, 2011. Company ABC is a...

Assume today is the beginning of year 2011, i.e., January 1, 2011. Company ABC is a hi-tech start-up company that had total after tax earnings of $ 2 million in 2010. Of these, $500,000 were paid out as a dividend to shareholders on December 31, 2010, and the remaining dividends are invested to finance future growth. Company ABC has a total number of 1,000,000 shares outstanding so that the dividend per share is $0.5. ABC’s earnings will grow at a...

A firm’s balance sheets for the last two years are as follows: Year 2019 Assets

A firm’s balance sheets for the last two years are as follows: Year 2019 Assets Liabilities and Equity Cash $19,000 Accounts payable $12,000 Market securities 10,000 Accruals 10,000 Accounts receivable 21,000 Current bank note 10,000 Inventory 10,000 Long-term debt 30,000 Plant 40,000 Common stock 14,000 Retained earnings 24,000 $100,000 $100,000 Year 2020 Assets Liabilities and Equity Cash $12,000 Accounts payable $12,000 Market securities 8,000 Accruals 10,000 Accounts receivable 18,000 Current bank note 30,000 Inventory 20,000 Long-term debt 10,000...

A project requires initial asset investment of $1 million. The asset will last for 8 years,...

A project requires initial asset investment of $1 million. The asset will last for 8 years, and will be depreciated for tax purposes at the CCA rate of 30%. The required return on this project is 16%, and the marginal corporate tax rate is 36%. Assuming that the asset will have a salvage value of $50,000 at the end of Year 8, what is the present value of the CCA tax shields from this project?

Financial data for Guyer Corporation, for last year follow: Guyer Corporation Balance Sheet Beginning Balance Ending...

Financial data for Guyer Corporation, for last year follow: Guyer Corporation Balance Sheet Beginning Balance Ending Balance Assets Cash $ 140,000 $ 120,000 Accounts receivable 450,000 530,000 Inventory 320,000 380,000 Plant and equipment, net 680,000 660,000 Investment in ABC, Inc. 250,000 280,000 Land (undeveloped) 180,000 170,000 Total assets $ 2,020,000 $ 2,140,000 Liabilities and Stockholders' Equity Accounts payable $ 360,000 $ 310,000 Long-term debt 1,500,000 1,500,000 Stockholders' equity 160,000 330,000 Total liabilities and stockholders' equity $ 2,020,000 $ 2,140,000 Guyer...

YEAR PROJECT A PROJECT B PROJECT C 2018 ($3,000,000) ($3,000,000) ($3,200,000) 2019 $0 $975,000 $985,000 2020...

YEAR PROJECT A PROJECT B PROJECT C 2018 ($3,000,000) ($3,000,000) ($3,200,000) 2019 $0 $975,000 $985,000 2020 $600,000 $975,000 $925,000 2021 $900,000 $975,000 $1,000,000 2022 $3,000,000 $1,000,000 $950,000 PLEASE calculate the Payback method for each and show me how you got to the answer!!

Question