Operating Cash Flows

Daisy Inc. current products comprises of the followings:

Moon: The selling price is RM$15\mathrm{.}00$ per unit and sales volume on average is $250,000$ units per year.

River: The selling price is RM$40\mathrm{.}00$ per unit and sales volume on average is $130,000$ units per year.

The company projected the sales will increase by $3\%$ year on year for the next $5$ years, decreases by $1\%$ in the subsequent years. Whereas, the production cost will be on average $45\%$ of the sales revenues of the financial year. The fixed cost is RM$1500,000$ per year for the first four years and increases to RM$1,550,000$ in the subsequent years, and interest expenses will be RM$185,000$ per year. The disposal of the manufacturing equipment is as per Question $2.$

Prepare the Proforma Income Statement for $7$ years and calculate the Operating Cash Flows year on year.

$1)$ Net Profit After Tax in Year $1$ is RM$\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

$2)$ Sales Revenues in Year $2$ is RM$\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

$3)$ EBIT in Year $3$ is RM$\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

$4)$ Net Profit After Tax in Year $4$ is RM$\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

$5)$ Operating Cash Flow in Year $7$ is RM$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

$6)$ The total PV of the operating cash flows is RM$\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

$7)$ The terminal value of the project is RM$\_\_\_\_\_\_\_\_\_\_\_\_\_.$

$8)$ The discounted payback period is $\_\_\_\_\_\_\_\_\_.$

$9)$ The profitability index is $\_\_\_\_\_\_\_\_\_\_.$

$10)$ The IRR is $\_\_\_\_\_\_\%.$

$11)$ The MIRR is $\_\_\_\_\_\_\_\_\_\_\%.$