Case Study Financial Excel Model
Budget: $12 – $30 SGD
I have a single Excel data file for a real-estate style case study and I need a clear, easy-to-follow model built around it. The goal is straightforward: perform a basic financial analysis that returns expected equity yield, IRR, and NPV from the figures already supplied.
Key points
• Source file is ready; you just connect the existing cash-flow projections, revenue & expense lines, and investment details to your formulas.
• Please structure the workbook so all raw data stays on its own tab and results feed into a clean summary dashboard.
• Core calculations required: expected equity yield, internal rate of return, and net present value. No advanced macros—plain Excel formulas are fine.
• Keep the model transparent: clearly labeled rows/columns, no hard-coded numbers inside formulas, and brief cell notes where logic might not be obvious.
Deliverable
One Excel workbook (.xlsx) that I can open and immediately follow, with the data tab, calculation sheets, and a one-page results summary laid out logically.
This is a compact assignment focused on accuracy and clarity, so a tidy, well-annotated first draft that I can test with my data will meet the brief.
Key points
• Source file is ready; you just connect the existing cash-flow projections, revenue & expense lines, and investment details to your formulas.
• Please structure the workbook so all raw data stays on its own tab and results feed into a clean summary dashboard.
• Core calculations required: expected equity yield, internal rate of return, and net present value. No advanced macros—plain Excel formulas are fine.
• Keep the model transparent: clearly labeled rows/columns, no hard-coded numbers inside formulas, and brief cell notes where logic might not be obvious.
Deliverable
One Excel workbook (.xlsx) that I can open and immediately follow, with the data tab, calculation sheets, and a one-page results summary laid out logically.
This is a compact assignment focused on accuracy and clarity, so a tidy, well-annotated first draft that I can test with my data will meet the brief.