Your group is starting a project to install a solar farm near Sungai Petani. The demand of energy is growing fast near the technology park because of growth in the semi$-$conductor industry in the area.

You are given a feasibility report prepare by a consultant group on a Photovoltaic Solar Power Plant.

You are required to prepare a feasibility study on the solar farm in Sungai Petani.

The report should include :

a$.$ The demand and supply analysis of energy in the area.

b$.$ The market competition analysis

c$.$ Pricing analysis

d$.$ A financial projection showing Cash inflow and cash outflow of the project for $20$ years.

e$.$ The accounting rate of return analysis

f$.$ The payback period analysis of the project

g$.$ The net present value analysis

h$.$ The Profitability index analysis

i$.$ The Internal rate of return analysis

j$.$ In your group opinion, is this project viable?

Please assist me to answer this questions :

d$.$ Financial Projection: Forecast the project's cash inflows and outflows over $20$ years to understand its financial viability.

e$.$ Accounting Rate of Return Analysis: Calculate the project's profitability based on accounting profits relative to the initial investment.

f$.$ Payback Period Analysis: Determine how long it will take for the project to recoup its Initial investment through cash flows.

Please assist me to do a table on cash in flow, cash out flow and cummulative cash flow for the above project