Excel-Based Financial Analysis Report
Budget: $10 – $30 AUD
I need a complete financial analysis distilled into a single, well-structured Excel workbook. I will supply the raw financial statements; your job is to transform them into an insightful report that highlights what is really happening behind the numbers.
The workbook should open on an executive-style dashboard that summarises key findings and then flow into clearly labelled sheets where you perform the detailed calculations. Please build the logic directly into the cells—formulas, PivotTables, dynamic charts—so I can drill down or refresh the file with new data later.
I am open to the specific analytical angles you recommend, whether that is ratio work, trend comparisons, cash-flow scrutiny or a combination. The essential point is that your narrative and figures align, making it easy for stakeholders to follow your reasoning without leaving Excel.
Deliverable
• One unlocked Excel file (.xlsx) containing:
– An overview sheet with headline metrics and commentary
– Supporting worksheets with step-by-step calculations, clearly annotated
– Visual aids (charts, conditional formatting, sparklines) that reinforce the story the numbers tell
I’ll review against accuracy, transparency of calculations, and clarity of insight. Once approved, the project is complete.
The workbook should open on an executive-style dashboard that summarises key findings and then flow into clearly labelled sheets where you perform the detailed calculations. Please build the logic directly into the cells—formulas, PivotTables, dynamic charts—so I can drill down or refresh the file with new data later.
I am open to the specific analytical angles you recommend, whether that is ratio work, trend comparisons, cash-flow scrutiny or a combination. The essential point is that your narrative and figures align, making it easy for stakeholders to follow your reasoning without leaving Excel.
Deliverable
• One unlocked Excel file (.xlsx) containing:
– An overview sheet with headline metrics and commentary
– Supporting worksheets with step-by-step calculations, clearly annotated
– Visual aids (charts, conditional formatting, sparklines) that reinforce the story the numbers tell
I’ll review against accuracy, transparency of calculations, and clarity of insight. Once approved, the project is complete.