Create Financial Model Need Urgently

Project Details:

Fast-Tracked Financial Model Creation.

I am looking for an experienced financial modeler to complete a structured financial modelling assignment within 4 hours.

The task relates to a sole entrepreneur engaged in purchasing goods for resale, operating from a rented warehouse. The provided Excel file already includes most key inputs, such as salary structure, staff bonuses, operating expenses, and CAPEX assumptions, which must be used as the foundation of the model.

Scope of Work (Part 1):
Monthly Financial Projections
Build detailed monthly projections strictly based on the assumptions provided in the Excel file.
Calculate monthly revenue, cost of goods sold (COGS), operating expenses, salaries, bonuses (including 13th salary and performance-based bonuses), depreciation, and taxes.
Income Statement Construction

Develop a complete and properly structured monthly and annual Income Statement, including:
Revenue
COGS
Gross Profit
Operating Expenses
EBITDA, EBIT
Taxes
Net Profit
Ensure all calculations are linked dynamically to the assumptions sheet.
Break-Even Analysis

Model the break-even point in Year 1, clearly showing:
The volume of goods that must be purchased and sold to cover all fixed and variable costs.
Zero net profit in Year 1 while fully covering operating expenses.
Extend projections to demonstrate modest profit growth from Year 2 onward.

Dynamic Financial Model

The Excel model must be fully dynamic, such that changing a single input (e.g., sales volume, price, salary, or cost assumptions) automatically updates:
Monthly projections
Income Statement
Break-even point
Profitability metrics
Financial Analysis Metrics

Include calculations for:
NPV
Key profitability ratios (gross margin, net margin, etc.)
Clear annual summaries derived from monthly data

Required Expertise:
Advanced Excel financial modelling
Income statement structure and financial statements
Break-even analysis
NPV and profitability ratio calculations