Excel spreadsheet/program to model & value various cash flows

I’ve attached a copy of the spreadsheet with the basic layout of the first output sheet which should give you some idea of where I want to go with this.

I require a program or Excel spreadsheet that will calculate:

• Valuations of cash (in) flows 1-50 years out based on variable inputs such as annual growth in cash flow and desired IRR (see my calc sheet) and ability to change Cash flow periods between Weekly, Monthly, Quarterly, Annual etc
Example: First income payment of $1,000 received on 01.04.2015 with quarterly receipts thereafter and an average annual appreciation expected of 2%. If these cash flows are discounted at 10% IRR, what are the next 80 (20 years) cash flows valued at today?

• Duplication of above to allow side by side ( 1 & 2) comparison (see my calc sheet) to also include return calculations (IRR, ROE, ROC) of profit for ‘x’ months turnaround (‘x’ to be a variable input) and to allow for inclusion of debt . This return calc is for the ‘Trading’ section only and is separate to the main (1 & 2) return calculations

• Loan calculations to allow for comparison of using debt

• Main Return calculations (IRR, MIRR, NPV, ROE) Pre & Post Tax to compare various equity/ debt combinations for a range of cash flows.
Example: Annual cash inflow of $1,000 (growing at 2% & discounted by IRR of 10%) shows a Year 20 valuation of $9,739. What is the IRR to equity if that $9,739 was paid for with a 50% loan ($4,870) borrowed at 6% for 10 years)

I imagine this spreadsheet will consist of several worksheets.

1: Inputs Page
2: Side by side comparison of 1- 50 year cash flow valuations (with the differences in the centre, as in my example)
3: Return calculation for the various equity/ debt combinations and for each year.
4: Loan calculations
5: Graphs showing gross cash flows, net cash flows,

Inputs
-Fixed (Gross Rent) Cash Flows-
-Variable (Bonus) cash flow
-Date of first Cash Flow
-Subsequent Cash Flows: Variable Period options (Monthly/ Quarterly/ Half Year/ Annual)
-Total number of cash flows
-Annual growth rates (%) of cash flows- variable periods (every 5 years?)

-Fixed Deductions & Expenses
-Annual growth rates (%) of deductions & expenses- variable periods (every 5 years)
-Variable expenses
-Tax rate

-Date of purchase (investment payment)
-Desired IRR
-Re Investment Rate (MIRR)
-Cost of Capital (MIRR)

-% of Total Investment –Equity (1-100%)
-Loan start date
-Loan Period in Months/Years
-% Loan Annual interest rate
-Loan repayment period options (Monthly/ Quarterly/ Half Year/ Annual)
-Option for interest & principal or interest only

Outputs
Dashboard
Side by side for comparison showing trading profits & return calcs

-Annual Gross cash flow projections for 1 – 50 years
-Annual Pre Tax cash flow projections for 1 – 50 years
-Annual Net cash flow projections for 1 – 50 years
-Cumulative cash flows
-Investment Cost (Purchase Price) calculated for each (1-50 year) period & based on desired IRR rate input
-Pre & Post Tax Investment Returns to project & equity (IRR, MIRR, NPV, ROE) for each year 1-50

-Equity amount
-Debt amount
-% of Total Investment –Debt (1-100%)

-Loan payment dates
-Loan starting balance
-Loan scheduled payment
-Loan principal payment
-Loan interest payment
-Loan end balance