Required stack
필요 기술
Google SheetsData EntryFinancial ModelingFinancial AnalysisSpreadsheet FormulasData Processing
Project brief
프로젝트 내용
I have a set of source documents that contain both narrative details and numeric figures, all of which must be transcribed into a Google Sheets workbook designed for ongoing financial tracking. Every row will hold mixed data—descriptive text in some columns, numbers in others—so accuracy on both fronts is critical.
Beyond clean data entry, the sheet must automatically calculate key performance indicators using the built-in IRR and NPV functions. Once the records are in place I should be able to adjust any cash-flow figure and see the updated returns instantly, so please structure the worksheet with clear cash-in, cash-out and date columns linked to those formulas.
Deliverables
• Fully populated Google Sheets file with all source data entered exactly as provided
• Correctly configured IRR() and NPV() formulas referencing dynamic cash-flow ranges
• Quick note inside the sheet (or a short Loom clip, if you prefer) explaining where to add future transactions without breaking the calculations
I’ll share the raw files and a field-by-field mapping right after kickoff. Let me know your estimated turnaround and any clarifying questions before you start typing.
Beyond clean data entry, the sheet must automatically calculate key performance indicators using the built-in IRR and NPV functions. Once the records are in place I should be able to adjust any cash-flow figure and see the updated returns instantly, so please structure the worksheet with clear cash-in, cash-out and date columns linked to those formulas.
Deliverables
• Fully populated Google Sheets file with all source data entered exactly as provided
• Correctly configured IRR() and NPV() formulas referencing dynamic cash-flow ranges
• Quick note inside the sheet (or a short Loom clip, if you prefer) explaining where to add future transactions without breaking the calculations
I’ll share the raw files and a field-by-field mapping right after kickoff. Let me know your estimated turnaround and any clarifying questions before you start typing.