Detailed Financial Model for Ice Blocks Factory -- 2
Budget: $30 – $250 USD
I would like to hire a professional freelancer who can prepare a detailed well-structured financial model for our ice blocks factory project.
The project will be phased into two phases:
Phase 1 will include purchasing the land and buildings, EPC works, supplying and installing phase 1 machines, supplying and installing all other accessories and requirements for smooth production and sales.
Phase 2 will increase production capacity by doubling it. In phase 2, we will utilize the infrastructure provisions already prepared in phase 1, and will add additional machines to increase quantity and sales. Phase 2 will start after we make sure the factory has stabilized in phase 1. Phase 2, will be financed either: i) by allocating a percentage of phase 1’s profits without affecting phase 1’s realistic and impressive returns or by applying for corporate debt when we plan to start phase 2.
The interested freelancer must be professional and qualified enough to prepare a detailed MS Excel based financial model that will be presented to equity investors and debt providers to assess project viability and bankability and to raise finance for the project.
We will provide the inputs for the model.
The financial modeler must build the financial model as follows:
- Robust, user friendly and automated
- Consider the 2 phases approach explained above
- Based on annual pacing for 7 years
- Flexible enough that if any value in the inputs sheet or scenarios sheet is changed, the whole model adjusts accordingly.
- Generate all financial statements (revenue, balance sheet, cash flow, debt statement) and all findings and required graphs
- Analyzes different scenarios
- Solve any circular references
- As per the formats and branding guidelines provided to the freelancer
The final product must include the following sheets linked together:
- Cover page
- Base sheet
- Input and assumptions sheets
- Scenarios Selection Sheet
- Dates and timelines
- Income Statement
- Balance Sheet
- Cash Flow
- Revenues
- Cost of Goods Sold
- Expenses (G&A)
- Debt Analysis
- Debt Service Reserve Account, Maintenance reserve Account, Loan Life Cover Ratio….etc.
- CAPEX Analysis
- Returns calculations
- Financial ratios
- Findings and dashboards (automatically adjustable when changing inputs and scenarios):
o Net Present Value
o Equity Internal Rate of Return
o Project Internal Rate of Return
o Money Multiples
o Net Income
o Net Cost
o Net Profit
o Debt Findings
o Investment Requirements that should include CAPEX, Working capital, and debt servicing
o CAPEX Distribution
o Capital structure showing equity and debt
o Debt loan details including number of years and interest rates
o Loan movement until fully settled
o Revenue bars
o Operating expenses bars
o Gross profit bars
o EBITDA bars
o Depreciation and financing bars
o Net income bars
o Profitability
o EBITDA divided by (loan +interest) bars
o Free cash flow divided by (loan +interest) bars
o Loan life cover ratio
o Cost of Goods Sold – Phase 2
Delivery Timeline: 5 calendar days
Work Progress: in milestones to ensure quality
Milestone 1: Model Skeleton as per our formats and brandings
Milestone 2: Statements
Milestone 3: Complete findings and dashboards
The project will be phased into two phases:
Phase 1 will include purchasing the land and buildings, EPC works, supplying and installing phase 1 machines, supplying and installing all other accessories and requirements for smooth production and sales.
Phase 2 will increase production capacity by doubling it. In phase 2, we will utilize the infrastructure provisions already prepared in phase 1, and will add additional machines to increase quantity and sales. Phase 2 will start after we make sure the factory has stabilized in phase 1. Phase 2, will be financed either: i) by allocating a percentage of phase 1’s profits without affecting phase 1’s realistic and impressive returns or by applying for corporate debt when we plan to start phase 2.
The interested freelancer must be professional and qualified enough to prepare a detailed MS Excel based financial model that will be presented to equity investors and debt providers to assess project viability and bankability and to raise finance for the project.
We will provide the inputs for the model.
The financial modeler must build the financial model as follows:
- Robust, user friendly and automated
- Consider the 2 phases approach explained above
- Based on annual pacing for 7 years
- Flexible enough that if any value in the inputs sheet or scenarios sheet is changed, the whole model adjusts accordingly.
- Generate all financial statements (revenue, balance sheet, cash flow, debt statement) and all findings and required graphs
- Analyzes different scenarios
- Solve any circular references
- As per the formats and branding guidelines provided to the freelancer
The final product must include the following sheets linked together:
- Cover page
- Base sheet
- Input and assumptions sheets
- Scenarios Selection Sheet
- Dates and timelines
- Income Statement
- Balance Sheet
- Cash Flow
- Revenues
- Cost of Goods Sold
- Expenses (G&A)
- Debt Analysis
- Debt Service Reserve Account, Maintenance reserve Account, Loan Life Cover Ratio….etc.
- CAPEX Analysis
- Returns calculations
- Financial ratios
- Findings and dashboards (automatically adjustable when changing inputs and scenarios):
o Net Present Value
o Equity Internal Rate of Return
o Project Internal Rate of Return
o Money Multiples
o Net Income
o Net Cost
o Net Profit
o Debt Findings
o Investment Requirements that should include CAPEX, Working capital, and debt servicing
o CAPEX Distribution
o Capital structure showing equity and debt
o Debt loan details including number of years and interest rates
o Loan movement until fully settled
o Revenue bars
o Operating expenses bars
o Gross profit bars
o EBITDA bars
o Depreciation and financing bars
o Net income bars
o Profitability
o EBITDA divided by (loan +interest) bars
o Free cash flow divided by (loan +interest) bars
o Loan life cover ratio
o Cost of Goods Sold – Phase 2
Delivery Timeline: 5 calendar days
Work Progress: in milestones to ensure quality
Milestone 1: Model Skeleton as per our formats and brandings
Milestone 2: Statements
Milestone 3: Complete findings and dashboards