The feasibility study of a project estimates that it is possible to produce and sell $90,000$ annual units of a product at $$350$ each during the first three years and $$400$ from the fourth year onwards. Sales projections show that from the sixth onwards these could increase by $25\%.$

The following investments are required, for a volume of $100,000$ units:

Land $$20,000,000$

Buildings $$60,000,000$

Machinery $$50,000,000$

The growth of production to satisfy the increase in sales would require investing $$30,000,000$ in additional buildings and $$20,000,000$ in machines.

The unit manufacturing costs are: Labor $$30$; materials of $$40$ and indirect costs of $$10.$

Fixed manufacturing costs are estimated at $$3,000,000.$ The expansion of installed capacity will increase them by $15\%.$

Administration and sales expenses are estimated at $6\%$ of sales.

Sales commission expenses are $1\mathrm{.}5\%$ of sales.

The legislation allows buildings to be depreciated in $20$ years and machines in $10$ years, according to the Sum of the Useful Life of the Asset Digits Method.

Intangible assets are amortized on a straight$-$line basis over five years.

Start$-$up expenses amount to $$5,000,000,$ which includes the cost of the feasibility study, which is $$2,000,000.$

The investment in working capital is estimated at the equivalent of six months of the total disbursable cost.

The income tax rate is $27\%.$

To finance the project, a loan is requested for $75\%$ of the investment in fixed assets $($Land$,$ machines, facilities$)$ for a $10-$year term, with an annual interest rate of $7\%.$ Fixed fee.

The minimum rate of return required by the investor is $15\%$ per year.

YOU ARE REQUESTED TO DO THE FOLLOWING:

$1.$ Depreciation table for fixed assets.

$2.$ Credit amortization table.

$3.$ Construction of the project's cash flow, for its first $10$ years of life.

$4.$ Evaluate the project flow, according to NPV$,$ IRR, PR$,$ PRA, IR

Note: Solve all bits by numbering each bit correctly and in english