A company will conduct a Right Issue to acquire coal bulk terminal docks with the following conditions:

BOT system (Build Operation System)

Acquisition cost of coal bulk terminal wharf = $10,000,000

Concession period = 30 years

Jetty construction = 1 year (estimated cost $10,000,000)

Coal bulk terminal pier maintenance & operation = 29 years

Coal capacity per year = 7,500,000 tons/ year

Revenue Stockpiling and barge loading costs are= $1.11/ton

Estimated operational cost of coal bulk terminal jetty = $1,200,000/ year

The residual value of the wharf at the end of the concession period is estimated = $5,000,000

Depreciation = 5% per year

What is the Right Issue value that should be obtained?

if possible please explain the attached excel file

Thank u so much