INTL
Freelancer
보통
외주
원격 가능
Google Sheets Financial Data Entry -- 2
예산
$600~$1,500 INR
예상 기간
1주일 이내
난이도
보통
기술 스택
Google Sheets
Data Entry
Financial Modeling
Financial Analysis
Spreadsheet Formulas
Data Processing
AI 분석 요약
이 프로젝트는 원본 문서를 기반으로 재무 데이터를 Google Sheets에 정확하게 입력하고, IRR 및 NPV 함수를 사용하여 재무 성과 지표를 자동 계산하는 스프레드시트를 구축하는 것입니다. 정확한 데이터 입력 능력과 더불어 고급 Google Sheets 수식 활용 및 재무 모델링 역량이 필요합니다.
프로젝트 원문 설명
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.
Freelancer에서 원본 확인
원본 보기